Oracle DBA Architect with migration, archival, ETL, PL/SQL, tuning, Curam and state/federal auditors experience

Job ID: NC-627272 (911090406)

Oracle DBA Architect with migration, archival, ETL, PL/SQL, tuning, Curam and state/federal auditors experience

Location: Durham NC (DHHS)
Duration: 12 months
Interview: In-person or webcam

Skill Required / Desired Amount of Experience
Extensive experience with Oracle Database architecture and design Required 7 Years
Extensive experience in planning and executing Oracle database migration and archival process for large scale applications Required 7 Years
Extensive experience in developing ETL frameworks using PL/SQL Required 7 Years
Extensive experience in fine tuning complex queries and resolving of performance issues Required 7 Years
Extensive experience in leading and mentoring large teams with group of report developers and database architects Required 7 Years
Experience in working with State and Federal auditors in meeting their requirements Highly desired 3 Years
Familiarity with Cúram application schema Highly desired 3 Years

The Department of Health and Human Services (DHHS) requires an Oracle Data Engineer to provide technical oversight and development of the redesign of the Data Warehouse Reporting environment based on the Cúram application schema. This position will provide Oracle database development, technical support such as resolving performance issues and serve as a mentor. This role will identify and refine data requirements, database design, database migration and archival planning and implementation, construct configurable ETL frameworks, and ensure adherence to defined development standards. In addition to reporting duties, this position will work closely with the NC FAST Quality Control (QC) team to assist in all data related matters when audits and evaluations requiring reports are needed. This QC assignment will require face to face meetings with State and Federal auditors where requirements are gathered, and reporting data is explained. Business requirements must be interpreted into logical queries and written to provide the data for reports that are provided for the audits. Requirements and design documentation must be created and maintained as part of this reporting and QC work..

E-RTR-627272.docx

NC_Resume_Template-627272.doc

Leave a Reply