Oracle database administrator quick overview and apply

Job Title: Senior Oracle Applications DBA

Location: Raleigh, NC (Hybrid)

Duration: 12 Months Contract

Note: *** Hybrid: Local candidates strongly preferred, or non-local candidates who are willing to relocate at their own expense from acceptance with no delays. NO REMOTE ONLY OPTION.

Responsibilities and Skills:

Job ID: NC-719344

Location: Raleigh, NC (NCDHHS-NCFAST)

Duration: 12 Months

Skills:

Demonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environment Required 7 Years
Modifying the database structure, creation, and update to existing database objects per application needs Required 7 Years
Experience in configuring, monitoring, and Cache management for Oracle database servers Required 3 Years
Strong experience in allocating system storage and planning future storage requirements for the database system Required 3 Years
Experience in Install, configuring, and troubleshooting/maintaining Golden Gate Required 2 Years
Must have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3 Required 2 Years
Experience authoring code in SQL, PL/SQL on Unix/Linux Required 5 Years
Proficiency in one or more shell scripting languages Required 2 Years
Hands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host access Required 5 Years
Monitoring performance metrics, response times, and request rates Required 5 Years
Designing and implementing backup/restore service and disaster recovery (DR) solutions Required 2 Years
Installing and upgrading the database software, Patching the software that powers database Required 3 Years
Good Analytical, Technical, Time Management and Communication Skills Required 7 Years
Participate in on-call rotation and weekend work Required 5 Years
Experience with advanced security and Oracle Data Guard replication Required 2 Years
Experience in Oracle Data Masking and Subsetting Highly desired
Demonstrable skills with Cúram Software and database schema Desired

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 managing Oracle database on cloud platforms like AWS, Lead the development of procedures and best practices for effective database for high volume application system and providing database solution for application modernization for this C2c job.

Provision and manage Oracle database instances on AWS/Linux
Install, configure, and troubleshoot Golden Gate for batch and online process synchronization for high volume database
Set up replication and high availability for Oracle databases using tools like Golden gate
Monitor Oracle database performance
Troubleshoot Oracle database problems
Perform backups and restores of Oracle databases
Work with application developers to identify and refine data requirements, table/database design, assist in SQL writing

Kind Regards.