DHS - Senior Oracle Database Administrator

This role will be extended on through the next fiscal year

Description:

Coordinates, manage, and designs database structures across multiple database platforms. Monitor and tune the application databases and establish communication links across Database Management Systems. Assists technical support and staff/vendors with installations, upgrades, or troubleshooting problems relating to the database environment.

Responsibilities

• Install and upgrade Oracle database-related software

• Create, review, and quality check new databases, database storage structures, database replication, and database security like Database Vault, Redaction, and Fine Grain Auditing.

• Monitor and optimize the performance of the database

• Tune instance components, including SQL and PL/SQL statements

• Maintain migrations and Overlays of Oracle databases across the enterprise.

• Supporting Database instance running in AWS (EC2 & RDS) Environment

• Maintain and support High available environment

• Develops and maintains database documentation

• Performs root cause analysis of infrastructure problems; identifies solutions and makes recommendations; takes appropriate remedial steps towards resolution

• Provide plan and support of database backup and recovery strategies

• Participates in implementation and maintenance of disaster recovery plans

• Maintains established service level agreements to meet customer expectations and quality standards.

Qualifications

• Must-Have

• Five years of Information Technology experience working in the generation, installation, and maintenance of resident software packages, at least three years has been administering server-based Oracle databases

• Must have experience creating and working with different database backup and recovery strategies.

• Must have extensive experience working with SQL analysis, performance, debugging, and recommendations

• Must have Oracle migration experience from one version to another

• Strong Oracle troubleshooting and analytical skills

• Experience with Oracle 12c, 19c database software and features

• Experience with Oracle 12c, 19c RAC, and Cluster ware

• Experience with OEM and management packs

• Experience with vendor products used to support the database, such as Oracle Enterprise Manager, Oracle Security, RMAN, and Active Directory

• Experience with ASM and Dataguard

• Experience working on various systems on a Microsoft platform and Linux Experience developing

• documenting, and enforcing DBA standards

• Experience with Oracle Database Vault, Data Redaction, and Fine Grain Auditing. Unix/Linus shell scripting experience

• Experience with RMAN backup and recovery Experience with AWR, Statspack, and Tkprof

• Experience collaborating and managing database in AWS environment

• Soft Skills:

• Excellent communications (verbal and written) skills

• Strong teamwork skills are essential

• Mentor team members

• Worked in 24X7 production support although not required in this environment

• Required/Desired Skills

Skill

• Required/Desired Amount of Experience

• Experience creating and working with different database backup and recovery strategies Required 7 Years

• Extensive experience working with SQL analysis, performance, debugging, and recommendations. Required 7 Years

• Strong Oracle troubleshooting and analytical skills. Required 7 Years

• Experience with Oracle 12c, 19c database software and features Required 7 Years

• Experience with Oracle 12c, 19c RAC, and Cluster ware Required 7 Years

• Experience with OEM and management packs Required 7 Years

• Experience with vendor products used to support the database, such as Oracle Enterprise Manager, Oracle Security, RMAN, and Active Directory. Required 7 Years

• Experience working on various systems on a Microsoft platform and Linux Experience developing, documenting, and enforcing DBA standards Required 7 Years

• Experience collaborating and managing database in AWS environment Required 7 Years

• Experience with Oracle Database Vault, Data Redaction, and Fine Grain Auditing. Unix/Linus shell scripting experience Required 7 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 Please list candidate's email address that will be used when submitting E-RTR.

• Question 3 Candidate must be paid the rate of $53.76 if selected for engagement therefore the SRP rate cannot exceed $72.57. Do you accept this requirement?

• Question 4 The maximum mark-up for this engagement’s SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%?

• Question 5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement?

• Question 6 The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client’s selection date. Do you accept this requirement?

• Question 7 Remote Work Permitted: Due to COVID-19, the client has agreed to allow the selected candidate to work remotely for the time being. However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement?