Job ID: NC-655143 (911090921)
Oracle Data Engineer with migration/archiving, ETL, PL/SQL, tuning, AWR report, cloud, Dell Boomi, AWS Glue, RedShift, Curam and government experience
Location: Raleigh, NC (NCDHHS)
Duration: 12 months
Interview: Either Webcam Interview or In Person
Skills:
Extensive experience with Oracle Database technologies.Required7Years
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
Experience in fine tuning complex queries and resolving of performance issues.Required7Years
Experience in implementing improvements based on Oracle AWR report.Required7Years
Extensive experience in collaborating and mentoring large teams with group of report developers and database architects.Required7Years
Experience with enterprise level cloud-based development, deployment, and auditing, with PAAS, IAAS, and SAAS models.Highly desired3Years
Experience in using or supporting data interfaces via Dell Boomi, Amazon RedShift, AWS GlueHighly desired2Years
Experience in working with State and Federal auditors in meeting their requirements.Desired
Familiarity with Cúram application schemaDesired
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..