Oracle DB Admin | HA & GoldenGate Expert

PowerToFly; New Jersey; On-site; USD 113,000 - 188,000; Full time

Job summary

Deloitte is seeking an experienced Oracle Database Administrator to join our Project Delivery Talent Model in New Jersey. You will administer Oracle databases across production, development, test, and disaster-recovery environments, working as a consultant on client projects.

You'll collaborate with a team to implement GoldenGate replication, configure RAC, Data Guard, and RMAN backups, and optimize performance via SQL tuning, PL/SQL, and shell scripting.

Qualifications

• 4+ years of professional Oracle Database Administration experience.
• Experience with Oracle architecture, schemas, tablespaces, indexes, partitioning, RAC, Data Guard, ASM, and RMAN backup and recovery.
• Experience with Oracle GoldenGate replication and troubleshooting, along with database performance monitoring, PL/SQL, SQL tuning, and execution plan analysis.
• Proficiency with Linux or Unix operating systems and shell scripting.

Responsibilities

• Administer Oracle databases across production, development, test, and disaster-recovery environments.
• Manage database configurations, schemas, tablespaces, indexes, partitioning, datafiles, listeners, redo logs, and archive logs.
• Implement and optimize Oracle GoldenGate replication, including Extract, trail files, Replicat, checkpoints, replication lag, and error resolution.
• Support high-availability and disaster-recovery architectures using Oracle RAC, Active Data Guard, ASM, and RMAN.
• Monitor and optimize database performance through SQL tuning, execution plans, AWR, ASH, and alert log analysis.
• Manage database security, including users, roles, privileges, access controls, and security patching.
• Respond to incidents, perform root-cause analysis, and execute database changes, upgrades, migrations, and maintenance activities.
• Develop automation scripts and maintain technical documentation, standard operating procedures, and recovery runbooks using SQL, PL/SQL, and shell scripting.

Skills

Oracle DBA

SQL tuning

PL/SQL

Shell scripting

Linux/Unix

Tools

Oracle GoldenGate

RAC

Data Guard

RMAN

ASM

Job description

Deloitte is seeking an experienced Oracle Database Administrator to join our Project Delivery Talent Model in New Jersey. You will administer Oracle databases across production, development, test, and disaster-recovery environments, working as a consultant on client projects.

You'll collaborate with a team to implement GoldenGate replication, configure RAC, Data Guard, and RMAN backups, and optimize performance via SQL tuning, PL/SQL, and shell scripting.