The Department of Health and Human Services (DHHS) requires a Senior Oracle Exadata DBA to provide development and optimization support to various applications using Oracle database on AWS.
We are seeking an experienced Oracle Exadata DBA for managing and optimizing Oracle databases hosted on Exadata and Linux platforms within the AWS cloud environment. This role includes ownership of application schemas, database design, extensions, and ongoing support across development, test, and production environments. The position requires strong expertise in database performance tuning, administration, replication, and high availability solutions such as Oracle Data Guard.
This individual will play a key role in leading database strategy and implementing best practices for large scale, high volume application systems. They will collaborate with development teams to support application modernization initiatives and ensure database components are designed for scalability, reliability, and optimal performance in AWS.
Primary Responsibilities:
Manage and maintain Oracle database environments (development, test, production) running on Exadata and Linux in AWS.
Collaborate with application developers to define data requirements, design tables and schemas, and assist with SQL development and optimization.
Support application modernization efforts by providing robust, scalable database solutions.
Lead the design, implementation, and management of application schemas, database structures, and extensions.
Provide technical support for Oracle databases, including diagnosis and resolution of performance, configuration, and availability issues.
Develop and maintain procedures, standards, and best practices for database operations in cloud environments.
Administer high availability and disaster recovery configurations using Oracle Data Guard.
Implement and manage replication solutions such as Oracle GoldenGate.
Perform database performance tuning, query optimization, and resource management for high volume workloads.
Conduct regular database backups, restores, patching, and upgrades.
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 | 5 | Years |
| Experience managing storage using Oracle Automatic Storage Management (ASM) and monitoring ASM disk groups | Required | 5 | Years |
| Hands-on experience installing, patching, and upgrading Oracle Database software and related components (Exadata patches, PSU/DBRU/Release Updates) | Required | 3 | Years |
| Experience with performance tuning at both database and Exadata storage layer | Required | 2 | Years |
| Demonstrable expertise in designing database schemas, access patterns, indexing, locking strategies, and tuning Oracle databases | Required | 7 | Years |
| Ability to troubleshoot complex issues across database, OS, and Exadata storage components | Required | 7 | Years |
| Experience with OEM (Oracle Enterprise Manager) or Cloud Control for monitoring and diagnostics | Required | 2 | Years |
| Strong experience in SQL writing skills | Required | 7 | Years |
| Participate in on-call rotation and weekend work | Required | 0 | |
Questions
| No. | Question |
|---|
| Question1 | 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? |
| Question2 | All work must be completed on site once COVID restrictions are lifted. Do you accept this requirement? |
| Question3 | Please list candidate's email address HERE that will be used when submitting E-RTR. |
| Question4 | 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. |
| Question5 | Will the candidate be subcontracted at the time of submission? |
| Question6 | 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? |
| Question7 | 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? |
| Question8 | Please provide candidate's current location (City and state), NOT a Yes or No response. |
| Question9 | Please describe briefly experience in Oracle Exadata and Automatic storage management (ASM). |
| Question10 | Please describe a key achievement on Oracle database area as senior Oracle DBA |
| Question11 | Please describe briefly a key achievement in resource/cost optimization on AWS or Azure cloud platform. |
| Question12 | Final hourly pay will be between $$.$$0 and $$.$$$.$$$.$$ based on the candidate s level of experience and interview performance. |