Job ID: NC-655143 (911090716)
Location: Durham,NC (NCDHHS)
Duration: 12 months
Interview: Either Webcam Interview or In Person
Skills:
Extensive experience with Oracle Database technologies. 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
Experience in fine tuning complex queries and resolving of performance issues. Required 7 Years
Experience in implementing improvements based on Oracle AWR report. Required 7 Years
Extensive experience in collaborating and mentoring large teams with group of report developers and database architects. Required 7 Years
Experience with enterprise level cloud-based development, deployment, and auditing, with PAAS, IAAS, and SAAS models. Highly desired 3 Years
Experience in using or supporting data interfaces via Dell Boomi, Amazon RedShift, AWS Glue Highly desired 2 Years
Experience in working with State and Federal auditors in meeting their requirements. Desired
Familiarity with Cúram application schema Desired
The Department of Health and Human Services (DHHS) requires an Oracle Data Engineer to identify and refine data requirements, database migration and archival planning and implementation including out of the box schema’s such as Cúram application schema. This position will also provide Oracle database development, technical support such as resolving performance issues. 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..