Oracle PL/SQL Developer

𝐉𝐨𝐛 𝐓𝐢𝐭𝐥𝐞: 𝐎𝐫𝐚𝐜𝐥𝐞 𝐏𝐋/𝐒𝐐𝐋 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐫 𝐋𝐨𝐜𝐚𝐭𝐢𝐨𝐧: 𝐀𝐥𝐛𝐚𝐧𝐲, 𝐍𝐘 – 𝐎𝐧𝐬𝐢𝐭𝐞 𝐉𝐨𝐛 𝐃𝐮𝐫𝐚𝐭𝐢𝐨𝐧: 30 𝐌𝐨𝐧𝐭𝐡𝐬 𝐂𝐨𝐧𝐭𝐫𝐚𝐜𝐭 𝐕𝐢𝐬𝐚: 𝐍𝐨 𝐆𝐂, 𝐔𝐒𝐂 𝐄𝐱𝐩𝐞𝐫𝐢𝐞𝐧𝐜𝐞: 8+ 𝐲𝐞𝐚𝐫𝐬 𝐉𝐨𝐛 𝐃𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧: 36 months experience upgrading legacy Oracle databases to current supported versions and splitting up Oracle database instances that contain schemas for multiple applications into separate Oracle instances, one per application, while also preserving user accounts and roles and maintaining any access that was present between database schemas, using data facades or links. 84 months experience doing Oracle performance tuning by reviewing slow performing SQL and creating partitions, indexes, new table structures or SQL rewrites to ensure fast data retrieval. This includes regular checks of application databases for any SQL that is performing full table scans when accessing data and the implementation of indexes to avoid full table scans. All of this includes measuring the performance, before and after. 84 months experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc. 84 months experience building and maintaining Oracle tables that contain Protected Health Information (PHI) within a health care environment. 84 months experience creating and maintaining Oracle database tables containing complex government financial data, specifically budgets, encumbrances, and payments within a government organization with an affected budget of 2 billion dollars or more. 84 months experience maintaining/supporting a Medicare D billing system including the creation and maintenance of NCPDP transactions such as B1, B2, B3, & E1. 60 months experience designing, building and maintaining data interfaces to Peoplesoft financial systems. 60 months experience working on a cost reporting application that supplies data for Medicare/Medicaid Cost Reports.