Oracle Exadata DBA (Hybrid - Onsite interviews)

Short Description:

• The Department of Health and Human Services (DHHS) requires a Senior Exadata Applications DBA to support the migration and development support of various applications for North Carolina Families Accessing Services through Technology (NC FAST).
• Job Description:
• The Department of Health and Human Services (DHHS) is seeking an experienced Oracle Exadata DBA to lead the migration of large Oracle 19c databases (100+ TB) from standard AWS environments to Oracle Exadata in AWS. This role is responsible for optimizing, administering, and supporting Exadata platforms across development, test, and production environments, ensuring high performance, scalability, and reliability for a large portfolio of applications.
• The DBA will work closely with engineering and application teams to modernize database architecture, streamline data models, and implement best practices for operating mission‑critical systems on Exadata within AWS.

Key responsibilities:

• Lead end‑to‑end migration of large 19c databases to Oracle Exadata in AWS, including planning, execution, cutover, and validation.
• Design and implement Exadata‑optimized database configurations, storage features, and performance strategies.
• Manage Oracle Exadata environments (dev/test/prod), including schema design, data modeling, and SQL optimization.
• Perform advanced performance tuning using AWR/ASH analysis, indexing, partitioning, and resource management.
• Administer high‑availability and DR configurations using Oracle Data Guard.
• Implement and manage replication solutions such as Oracle Golden Gate.
• Troubleshoot performance, configuration, and availability issues across Exadata and Linux platforms.
• Execute backups, restores, patching, and upgrades for Exadata environments.

Required / Desired Skills

     

Skill

Required / Desired

Amount

of Experience

Deep understanding of Oracle Exadata architecture, including storage cells, InfiniBand networking, Smart Scan and Hybrid Columnar Compression (HCC)

Required

7

Years

Experience managing storage using Oracle Automatic Storage Management (ASM) and monitoring ASM disk groups

Required

7

Years

Proficiency in applying Exadata storage cell, compute node, and firmware patches, along with database-level PSU/DBRU/Release Updates

Required

3

Years

Experience with performance tuning at both database and Exadata storage layer

Required

3

Years

Ability to troubleshoot complex issues across database, OS, and Exadata storage components

Required

5

Years

Demonstrable expertise in designing database schemas, access patterns, indexing, locking strategies, and tuning Oracle databases

Required

2

Years

Experience with OEM (Oracle Enterprise Manager) or Cloud Control for monitoring and diagnostics

Required

2

Years

Experience in Install, configure, and troubleshoot/maintain Golden Gate

Required

2

Years

Strong experience in SQL writing skills

Required

5

Years

Participate in on-call rotation and weekend work

Required

5

Years

Experience with advanced security and Oracle DataGuard replication

Required

2

Years

Questions

     

 

Description

   

Question 1

Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?

   

Question 2

All work must be completed on site once COVID restrictions are lifted. Do you accept this requirement?

   

Question 3

Please list candidate's email address HERE that will be used when submitting E-RTR.

   

Question 4

Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.

   

Question 5

Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?

   

Question 6

Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?

   

Question 7

Please describe briefly experience in Oracle Exadata and Automatic storage management (ASM).

   

Question 8

Please describe two key achievements as senior Oracle Exadata DBA

   

Question 9

Please provide candidate's current location (City and state), NOT a Yes or No response.

   

Question 10

Will the candidate be subcontracted at the time of submission?

   

Question 11

Candidates submitted over bill rate will not be considered. Do you accept this requirement?

   

Question 12

Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate’s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?