The Department of Health and Human Services (DHHS) requires a Senior Oracle DBA to provide development and optimization support to various applications using Oracle database on AWS.
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 Exadata.
This resource will serve in a key role in the managing Oracle database on AWS cloud platform Lead the development of procedures and best practices for effective database for high volume application system and providing database solution for application modernization.
This position is responsible for performing tasks associated with the Leading the management of the application schema design and extensions within the database in development test and production environments.
Some of the key duties:
Provision and manage Oracle database instances on AWS/Linux
Set up replication and high availability for Oracle databases using tools like Golden gate
Monitor Oracle database performance and 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
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| Demonstrable skills in designing schema access patterns locking strategy 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 |
| Must have experience in implementing and supporting Oracle on AWS/Linux platform | Required | 2 | Years |
| Strong experience in allocating system storage and planning future storage requirements for the database system | Required | 3 | Years |
| Understanding of Exadatas hardware and software components including storage cells InfiniBand networking and Smart Scan technology. | Required | 2 | Years |
| Experience with managing storage using Oracle Automatic Storage Management (ASM) | Required | 2 | Years |
| Proficiency in one or more shell scripting languages | Required | 2 | Years |
| Experience authoring code in SQL PL/SQL | 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 AnalyticalTechnicalTimeManagement and Communication Skills | Required | 7 | Years |
| Participate in on-call rotation and weekend work | Required | 5 | Years |
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 candidates 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 candidates 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 list cloud platform (example: Azure GCP AWS etc.) technologies along with duration of experience on which the candidate has hands-on experience. |
| Question11 | Please describe briefly a key achievement in Oracle database area as senior Oracle DBA. |
| Question12 | Final hourly pay will be between $$$0 and $$$$$0 based on the candidate s level of experience and interview performance. |
The Department of Health and Human Services (DHHS) requires a Senior Oracle DBA to provide development and optimization support to various applications using Oracle database on AWS. Primary responsibilities include managing the application schema design and extensions within the database for develop...
The Department of Health and Human Services (DHHS) requires a Senior Oracle DBA to provide development and optimization support to various applications using Oracle database on AWS.
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 Exadata.
This resource will serve in a key role in the managing Oracle database on AWS cloud platform Lead the development of procedures and best practices for effective database for high volume application system and providing database solution for application modernization.
This position is responsible for performing tasks associated with the Leading the management of the application schema design and extensions within the database in development test and production environments.
Some of the key duties:
Provision and manage Oracle database instances on AWS/Linux
Set up replication and high availability for Oracle databases using tools like Golden gate
Monitor Oracle database performance and 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
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| Demonstrable skills in designing schema access patterns locking strategy 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 |
| Must have experience in implementing and supporting Oracle on AWS/Linux platform | Required | 2 | Years |
| Strong experience in allocating system storage and planning future storage requirements for the database system | Required | 3 | Years |
| Understanding of Exadatas hardware and software components including storage cells InfiniBand networking and Smart Scan technology. | Required | 2 | Years |
| Experience with managing storage using Oracle Automatic Storage Management (ASM) | Required | 2 | Years |
| Proficiency in one or more shell scripting languages | Required | 2 | Years |
| Experience authoring code in SQL PL/SQL | 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 AnalyticalTechnicalTimeManagement and Communication Skills | Required | 7 | Years |
| Participate in on-call rotation and weekend work | Required | 5 | Years |
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 candidates 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 candidates 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 list cloud platform (example: Azure GCP AWS etc.) technologies along with duration of experience on which the candidate has hands-on experience. |
| Question11 | Please describe briefly a key achievement in Oracle database area as senior Oracle DBA. |
| Question12 | Final hourly pay will be between $$$0 and $$$$$0 based on the candidate s level of experience and interview performance. |
View more
View less