NC FAST- Senior Applications DBA

NC FAST- Senior Applications DBA

[Research Triangle Park, NC, 27711] |   2023-09-05 08:44:16

Apply Now

Share Job 

Job Code : NC010

Hello,

Hope you are doing good.

Position: Senior Applications DBA

Location: Research Triangle Park, NC (Hybrid)

Duration: Long Term

Job ID: 719344

Client: State of NC

Job Description:

Q1 Please list number of years of experience in setting up and configuring Oracle Golden gate

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.

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

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, configure, and troubleshoot/maintain 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 DataGuard replication

Required

2

Years

Experience in Oracle Data Masking and Subsetting

Highly desired

Demonstrable skills with Cúram Software and database schema