Oracle Database Administration

Role - Oracle Database Administration

Location :- Onsite (Columbus, Ohio

Max Rate $50/hr

Job Summary

A candidate with 10+ years of experience in Oracle Database Administration. Knowledge of Goldengate and Real Application Testing (RAT) highly preferred.

The candidate should possess strong expertise and Hands-on experience in

1. DB Migration (Oracle to Oracle DB)

2. Oracle GoldenGate Replication

3. Oracle Multitenant Architecture (CDB/PDB)

4. Oracle DB Performance Tuning (SQL Tuning)(AWR / ADDM / ASH Report Analysis)

5. Oracle RAC/ASM Administration

6. Oracle Data Guard (Active Data Guard)

7. Cloud platforms such as AWS PostgreSQL on AWS (Experience or good understanding of AWS Aurora PostgreSQL/RDS PostgreSQL is an added advantage)

Note : Candidate should be capable of independently handling above mentioned task.

Years of experience needed

10+ years

Technical Skills:

Strong experience administering various multi-Terabyte, 24x7 uptime Oracle databases as a Systems/Infrastructure Database Administrator required

Solid experience working with Oracle versions 11gR1/2, 12c, 19C in a Linux environment

Experience with Zero Data Loss Recovery Appliance is a plus

Strong, proven Oracle Database Performance Diagnostic skills (at both the SQL and system levels)

Experience with features such as Oracle Real Application Clusters (RAC), CDB/PDB, Automatic Storage Management (ASM), Active Data Guard, Oracle Enterprise Manager (OEM), Golden Gate replication an Real Application Testing (RAT).

Experience with Backup and Recovery using Oracle Recovery Manager (RMAN)

Proficiency in installing and configuring complex database management system environments, creating and maintaining databases as well as backup and recovery

Certifications Needed:

OCI will be plus

AND/OR

AWS certified