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?