Oracle Database Admin

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

Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Oracle Database Admin, you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel. The Project Delivery Talent Model is designed for professionals with specialized skills that align to a current client need. Team members focus on delivering services to clients, without additional expectations related to business development or promotion. Their employment is tied to their role on a project, and they are eligible for a benefits package that is competitive for project delivery-focused professionals.

Work you'll do/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.

The Team

Join our AI & Engineering team in transforming technology platforms, driving innovation, and helping make a significant impact on our clients' success. You'll work alongside talented professionals reimagining and re-engineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

AI & Engineering leverages cutting-edge engineering capabilities to build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions are powered by engineering for business advantage, transforming mission-critical operations. We enable clients to stay ahead with the latest advancements by transforming engineering teams and modernizing technology & data platforms. Our delivery models are tailored to meet each client's unique requirements.

Our AI & Data practice offers comprehensive solutions for designing, developing, and operating advanced Data and AI platforms, products, insights, and services. We help clients innovate, enhance, and manage their data, AI, and analytics capabilities, ensuring they can grow and scale effectively.

Qualifications

Required

• 4+ years of professional Oracle Database Administration experience, with a proven track record of supporting production of Oracle databases and business-critical applications in a client-facing or enterprise capacity.
• 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.

Preferred

• Professional Certifications: Active Oracle Database or related cloud infrastructure certifications.
• Strong analytical, troubleshooting, documentation, and communication skills.
• Experience with FSI organizations, Exadata, OEM, advanced GoldenGate tooling, database upgrades and migrations, AI/GenAI and RPA automation, and hybrid-cloud platforms such as OCI, AWS, or Azure.
• Ability to operate in controlled financial-services environments, including scheduled, on-call, and after-hours support; knowledge of SOX, PCI-DSS, GLBA, access reviews, and data privacy controls is preferred.

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $113,000 to $188,400.

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.