06 Sep
|
Trigent Software
|
Bengaluru
06 Sep
Trigent Software
Bengaluru
Experience: 8+ years
Maximum Budget: Up to 32 LPA
Candidate Profile:
- Must be from Tier 1 or Tier 2 organizations
- Strong leadership experience with the ability to manage and mentor a large DBA team
- Proven expertise in handling complex database environments and team delivery
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 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
- Solid 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
- 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 stakeholder
📌 Oracle DBA Lead_Litmus7 (Bengaluru)
🏢 Trigent Software
📍 Bengaluru