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 designRequired7Years
Extensive experience in planning and executing Oracle database migration and archival process for large scale applicationsRequired7Years
Extensive experience in developing ETL frameworks using PL/SQLRequired7Years
Extensive experience in fine tuning complex queries and resolving of performance issuesRequired7Years
Extensive experience in leading and mentoring large teams with group of report developers and database architectsRequired7Years
Experience in working with State and Federal auditors in meeting their requirementsHighly desired3Years
Familiarity with Cúram application schemaHighly desired3Years
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..