Oracle Database Administrator

Litmus7 Systems Consulting; Bengaluru; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Litmus7 Systems Consulting is seeking an experienced Oracle DBA to join our Bengaluru team. The role involves administering large enterprise databases, performing deep-dive performance tuning, and leading critical incident resolution.

You will analyze AWR/ASH/ADDM reports, manage RAC/ASM/Dataguard, and ensure security and compliance while driving automation and documentation. The ideal candidate has 8+ years of hands-on Oracle DBA experience, strong tuning skills, and solid Linux administration.

Qualifications

• 8+ years of hands-on Oracle DBA experience in enterprise environments.
• Experience supporting organizations with >$10B revenue or large-scale operational workloads.
• Hands-on experience with Oracle 11g/12c/19c.
• Strong expertise in: SQL tuning, PL/SQL tuning, Query execution plans and explain plan interpretation, Oracle Optimizer behavior, Wait events & performance diagnostics.
• Hands-on with SQL Developer, Toad.
• Strong knowledge of RAC, ASM, Dataguard.
• Good Linux admin exposure.

Responsibilities

• Administer Oracle databases in large enterprise environments (clients >$10B revenue).
• Perform deep-dive performance tuning across SQL, PL/SQL, indexes, and query execution plans.
• Analyze AWR/ASH/ADDM reports and implement tuning recommendations.
• Lead production incident resolution including triage, RCA, and permanent fixes.
• Manage Oracle RAC / ASM and Dataguard environments.
• Implement and test backup and recovery strategies using RMAN.
• Perform database upgrades, patching, and capacity planning.
• Ensure database security, auditing, and compliance.
• Automate repeatable DBA tasks and maintain documentation.
• Analyze and investigate reasons for job failures, long-running queries, and provide recommendations to improve overall system performance.

Skills

SQL tuning

PL/SQL tuning

Query execution plans

Oracle Optimizer

Wait events

RAC

ASM

Dataguard

Linux admin

SQL Developer

Toad

Tools

SQL Developer

Toad

Job description

Role & responsibilities

Key Responsibilities

• Administer Oracle databases in large enterprise environments (clients >$10B revenue)
• Perform deep-dive performance tuning across SQL, PL/SQL, indexes, and query execution plans
• Analyze AWR/ASH/ADDM reports and implement tuning recommendations
• Lead critical production incident resolution including triage, RCA, and permanent fixes
• Manage Oracle RAC / ASM and Dataguard environments
• Implement and test backup and recovery strategies using RMAN
• Perform database upgrades, patching, and capacity planning
• Ensure database security, auditing, and compliance
• Automate repeatable DBA tasks and maintain documentation
• Analyze and investigate reason for job failures, long-running queries, and provide recommendations to improve overall system performance

Required Experience

• 8+ years of hands-on Oracle DBA experience in enterprise environments
• Experience supporting organizations with >$10B revenue or large-scale operational workloads
• Hands-on experience with Oracle 11g/12c/19c
• Strong expertise in:
• SQL tuning
• PL/SQL tuning
• Query execution plans and explain plan interpretation
• Oracle Optimizer behavior
• Wait events & performance diagnostics
• Hands-on with SQL Developer, Toad
• Strong knowledge of RAC, ASM, Dataguard
• Good Linux admin exposure

Nice to Have experience

• Hands-on experience with handling SQL Server and/or Postgres SQL Database administration

Soft Skills

• Ability to operate during high-severity outages
• Strong problem-solving and troubleshooting mindset