Oracle DBA Lead

Ample Success HR; Bengaluru; On-site; INR 4,200,000 - 5,200,000; Full time

Job summary

Ample Success HR in Bengaluru, India seeks an experienced Oracle Database Administrator to own day-to-day DB administration in a multi-platform enterprise. You will drive maintenance tasks, tune performance, troubleshoot incidents, and optimize queries across large-scale environments.

The ideal candidate has 8+ years of Oracle DBA experience, hands-on with RAC/Dataguard, RMAN, and advanced SQL/PLSQL tuning.

Qualifications

• 8+ years of hands-on Oracle DBA experience in enterprise environments.
• Experience supporting large-scale organizations (> $10B revenue) is a plus.
• Strong SQL/PLSQL tuning and performance analysis.
• Experience with RAC, ASM, and Data Guard.
• Linux server administration knowledge.
• Proven incident management and effective communication with stakeholders.

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 production incident resolution including RCA and permanent fixes.
• Manage Oracle RAC / ASM and Data Guard 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.

Skills

Oracle DBA

SQL tuning

PL/SQL tuning

RAC/Dataguard

RMAN

AWR/ASH/ADDM

Linux admin

Incident management

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 plansAnalyze AWR/ASH/ADDM reports and implement tuning recommendationsLead critical production incident resolution including triage, RCA, and permanent fixesManage Oracle RAC / ASM and Data guard environmentsImplement and test backup and recovery strategies using RMANPerform database upgrades, patching, and capacity planningEnsure database security, auditing, and complianceAutomate repeatable DBA tasks and maintain documentationAnalyze and investigate reason for job failures, long-running queries, and provide recommendations to improve overall system performanceRequired Experience:8+ years of hands-on Oracle DBA experience in enterprise environmentsExperience supporting organizations with >$10B revenue or large-scale operational workloadsHands-on experience with Oracle 11g/12c/19cStrong expertise in:SQL tuningPL/SQL tuningQuery execution plans and explain plan interpretationOracle Optimizer behaviorWait events & performance diagnosticsHands-on with SQL Developer, ToadStrong knowledge of RAC, ASM, DataguardGood Linux admin exposureNice to Have experience:Hands-on experience with handling SQL Server and/or Postgres SQL Database administrationSoft Skills:Ability to operate during high-severity outagesStrong problem-solving and troubleshooting mindsetExcellent communication with technical and business teamsShould have expertise in leading critical priority incidents with all Client stakeholdersCoach and mentor team members on performance tuning and best practicesPlan day-to-day tasks for the team, ensure 100% completion of tasks, provide clear and timely updates to clients and stakeholdersDemonstrate the conviction and ability to steer pro-active, improvement ideas through different levels of stakeholders