Enterprise Solutions, Inc.
https://www.enterprisesolutioninc.com/wp-content/uploads/2020/07/Enterprise-Logo-web.png
https://www.enterprisesolutioninc.com
https://www.enterprisesolutioninc.com
USD
65
80
HOUR
true
NC FAST- Senior Applications DBA
NC, NC United States
Posted: 09/05/2023
2023-09-05
2024-03-23
Job Number: z5G7h3l6a1kMvyS65NP3c4yK-I9tiXNLCoAqnTfQW38=
Pay Rate: 65-80 Hourly USD
Job Description
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
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceDemonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environmentRequired7YearsModifying the database structure, creation, and update to existing database objects per application needsRequired7YearsExperience in configuring, monitoring, and Cache management for Oracle database servers Required3YearsStrong experience in allocating system storage and planning future storage requirements for the database system Required3YearsExperience in Install, configure, and troubleshoot/maintain Golden GateRequired2YearsMust have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3 Required2YearsExperience authoring code in SQL, PL/SQL on Unix/LinuxRequired5YearsProficiency in one or more shell scripting languagesRequired2YearsHands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host accessRequired5YearsMonitoring performance metrics, response times, and request ratesRequired5YearsDesigning and implementing backup/restore service and disaster recovery (DR) solutionsRequired2YearsInstalling and upgrading the database software, Patching the software that powers databaseRequired3YearsGood Analytical,Technical,TimeManagement and Communication SkillsRequired7YearsParticipate in on-call rotation and weekend workRequired5YearsExperience with advanced security and Oracle DataGuard replicationRequired2YearsExperience in Oracle Data Masking and Subsetting Highly desired0Demonstrable skills with Cúram Software and database schemaDesired0
Questions
No.QuestionQuestion1Absences 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?Question2All work must be completed on site once COVID restrictions are lifted. Do you accept this requirement? Question3Please list candidate's email address HERE that will be used when submitting E-RTR. Question4Please 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. Question5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement? Question6Vendor 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? Question7Please list number of years of experience in setting up and configuring Oracle Golden gateQuestion8Please 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? Question9Please provide candidate's current location (City and state), NOT a Yes or No response. Question10Will the candidate be subcontracted at the time of submission? Question11 Please list databases (including version) apart from Oracle in which candidate has hand-on experience as DBA. Question12Please list cloud platform (example: Azure, GCP, AWS etc.) along with duration of experience on which the candidate has hands-on experience.Question13Candidates submitted over xxxx10/hr will not be considered. Do you accept this requirement?
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
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceDemonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environmentRequired7YearsModifying the database structure, creation, and update to existing database objects per application needsRequired7YearsExperience in configuring, monitoring, and Cache management for Oracle database servers Required3YearsStrong experience in allocating system storage and planning future storage requirements for the database system Required3YearsExperience in Install, configure, and troubleshoot/maintain Golden GateRequired2YearsMust have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3 Required2YearsExperience authoring code in SQL, PL/SQL on Unix/LinuxRequired5YearsProficiency in one or more shell scripting languagesRequired2YearsHands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host accessRequired5YearsMonitoring performance metrics, response times, and request ratesRequired5YearsDesigning and implementing backup/restore service and disaster recovery (DR) solutionsRequired2YearsInstalling and upgrading the database software, Patching the software that powers databaseRequired3YearsGood Analytical,Technical,TimeManagement and Communication SkillsRequired7YearsParticipate in on-call rotation and weekend workRequired5YearsExperience with advanced security and Oracle DataGuard replicationRequired2YearsExperience in Oracle Data Masking and Subsetting Highly desired0Demonstrable skills with Cúram Software and database schemaDesired0
Questions
No.QuestionQuestion1Absences 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?Question2All work must be completed on site once COVID restrictions are lifted. Do you accept this requirement? Question3Please list candidate's email address HERE that will be used when submitting E-RTR. Question4Please 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. Question5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement? Question6Vendor 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? Question7Please list number of years of experience in setting up and configuring Oracle Golden gateQuestion8Please 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? Question9Please provide candidate's current location (City and state), NOT a Yes or No response. Question10Will the candidate be subcontracted at the time of submission? Question11 Please list databases (including version) apart from Oracle in which candidate has hand-on experience as DBA. Question12Please list cloud platform (example: Azure, GCP, AWS etc.) along with duration of experience on which the candidate has hands-on experience.Question13Candidates submitted over xxxx10/hr will not be considered. Do you accept this requirement?