Job ID: NC-695419 (911091021)
Hybrid Oracle DBA with AWS, RDS, Golden Gate, PL/SQL, Unix/Linux, Data Guard and Cúram Experience
Location: RTP, NC DHHS
Duration: 12 months
All work must be completed on site once COVID restrictions are lifted.
Skills :
Demonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environmentRequired7Years
Modifying the database structure, creation and update to existing database objects per application needsRequired7Years
Experience in configuring, monitoring, and Cache management for Oracle database serversRequired3Years
Strong experience in allocating system storage and planning future storage requirements for the database systemRequired3Years
Experience in supporting and implementing Oracle Golden GateRequired2Years
Must have experience in implementing and supporting Oracle on AWS including RDSRequired2Years
Experience authoring code in SQL, PL/SQL on Unix/LinuxRequired5Years
Proficiency in one or more shell scripting languagesRequired2Years
Hands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host accessRequired5Years
Monitoring performance metrics, response times, and request ratesRequired5Years
Designing and implementing backup/restore service and disaster recovery (DR) solutionsRequired2Years
Installing and upgrading the database software, Patching the software that powers databaseRequired3Years
Good Analytical,Technical,TimeManagement and Communication SkillsRequired7Years
Ability to work cooperatively in a team environment to establish and maintain effective working relationshipsRequired7Years
Participate in on-call rotation and weekend workRequired5Years
Experience with advanced security and Oracle DataGaurd replicationDesired2Years
Demonstrable skills with Cúram Software and database schemaDesired
The Department of Health and Human Services (DHHS) requires a Senior Applications DBA to support the migration and development support of various applications for North Carolina Families Accessing Services through Technology (NC FAST).
The Department of Health and Human Services (DHHS) requires a Senior Applications DBA to support migration of Oracle database effort from on-prem to AWS cloud and development support of various applications for NC FAST in AWS Cloud.
Primary responsibilities include managing the application schema, design, and extensions within the database for development, test, and production environments for Oracle database on Linux platform. The responsibilities also include database technical support, performance tuning, application administration and consulting, and providing support for Oracle, Oracle Data guard, Oracle Golden Gate.
This resource will serve in a key role in the creation of database migration plans from on-Prem to AWS, participate in the development of procedures for effective database use and ensuring standards are met.
Other duties include working with developers to identify and refine data requirements, database design, database migration planning, and configuration, performing backup and recovery, monitoring database performance, and reorganizing database structures as needed, and creation and modification of test and production data, base schemas.