DBA Lead

Litmus7 Systems Consulting Ltd; India; On-site; INR 3,200,000 - 4,500,000; Full time

Job summary

Litmus7 Systems Consulting Ltd. is seeking an experienced Oracle Database Administrator to handle day-to-day DB administration in a multi-platform enterprise environment.

You will own maintenance tasks, perform performance analysis, tuning, and incident resolution while ensuring security and compliance. The ideal candidate has 8+ years of hands-on Oracle DBA experience, with Oracle 11g/12c/19c, and expertise in RAC, ASM, Dataguard, RMAN, and AWR/ASH/ADDM analysis.

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 in Oracle 11g/12c/19c.

Responsibilities

• Administer Oracle databases in large enterprise environments.
• 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 reasons for job failures, long-running queries, and provide recommendations to improve overall system performance.

Skills

Oracle DBA

Performance tuning

RAC/ASM/Dataguard

RMAN backups

AWR/ASH/ADDM analysis

Incident resolution

Query optimization

Tools

SQL Developer

Toad

Job description

We are looking for an experienced Oracle Database Administrator with strong expertise in handling day‑to‑day DB Administration activities in a multi‑platform enterprise environment, owning and driving scheduled and ad‑hoc maintenance tasks, strong performance analysis, tuning, troubleshooting, production incident resolution, and query optimization. The ideal candidate has supported large‑scale global enterprises (>$10B annual revenue) and can quickly analyze and resolve performance‑related issues in mission‑critical environments.

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 reasons 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 in Oracle 11g/12c/19c.

Strong Expertise In

• Query execution plans and explain plan interpretation
• Hands‑on with SQL Developer, Toad
• Strong knowledge of RAC, ASM, Dataguard

Nice to Have Experience

Hands‑on experience in handling SQL Server and/or Postgres SQL Database administration

Soft Skills

• Ability to operate during high‑severity outages
• Strong problem‑solving and troubleshooting mindset
• Excellent communication with technical and business teams
• Should have expertise in leading critical priority incidents with all Client stakeholders
• Coach and mentor team members on performance tuning and best practices
• Plan day‑to‑day tasks for the team, ensure 100% completion of tasks, provide clear and timely updates to clients and stakeholders
• Demonstrate the conviction and ability to steer pro‑active, improvement ideas through different levels of stakeholders