Key Responsibilities

<ul>
<li style="text-align:start;">Performance Tuning Specifics Mandatory Skills</li>
</ul>

<ul>
<li style="text-align:start;">Lead end to end database performance tuning for Oracle on AWS RDS</li>
</ul>

<ul>
<li style="text-align:start;">Analyze AWR ADDM ASH Stats pack reports to identify performance bottlenecks</li>
</ul>

<ul>
<li style="text-align:start;">Perform SQL tuning using execution plan analysis SQL profiles and indexing strategies</li>
</ul>

<ul>
<li style="text-align:start;">Optimize wait events related to CPU IO memory and locking contention</li>
</ul>

<ul>
<li style="text-align:start;">Tune Oracle parameters PGA SGA optimizer settings within RDS constraints</li>
</ul>

<ul>
<li style="text-align:start;">Work with development teams to refactor inefficient SQL and PLSQL code</li>
</ul>

<ul>
<li style="text-align:start;">Perform capacity planning and workload forecasting based on performance trends</li>
</ul>

<ul>
<li style="text-align:start;">Optimize storage and IO performance RDS storage types IOPS tuning</li>
</ul>

<ul>
<li style="text-align:start;">Lead performance testing for releases migrations and major changes</li>
</ul>

Troubleshooting Incident Management Specifics

<ul>
<li style="text-align:start;">Act as the primary escalation point for complex Oracle production issues</li>
</ul>

<ul>
<li style="text-align:start;">Diagnose and resolve database outages slowness and replication issues</li>
</ul>

<ul>
<li style="text-align:start;">Troubleshoot blocking sessions deadlocks latchmutex contention and enqueue waits</li>
</ul>

<ul>
<li style="text-align:start;">Analyze logs trace files and diagnostic dumps in RDS environments</li>
</ul>

<ul>
<li style="text-align:start;">Handle corruption scenarios recovery issues and restore validations</li>
</ul>

<ul>
<li style="text-align:start;">Coordinate with AWS Support and Oracle Support for critical incidents</li>
</ul>

<ul>
<li style="text-align:start;">Lead root cause analysis RCA and produce detailed postmortem reports</li>
</ul>

<ul>
<li style="text-align:start;">Implement preventive measures and automation to reduce repeat incidents</li>
</ul>

Core Responsibilities

<ul>
<li style="text-align:start;">Architect operate and govern Oracle databases on AWS RDS</li>
</ul>

<ul>
<li style="text-align:start;">Define HADR strategies Multi AZ backups cross region recovery</li>
</ul>

<ul>
<li style="text-align:start;">Lead patching upgrades and database lifecycle management</li>
</ul>

<ul>
<li style="text-align:start;">Drive database security compliance and audit readiness</li>
</ul>

<ul>
<li style="text-align:start;">Provide DB related technical leadership</li>
</ul>

<ul>
<li style="text-align:start;">Support cloud migrations and modernization initiatives</li>
</ul>

Required Qualifications

<ul>
<li style="text-align:start;">10 years of Oracle DBA experience including lead or senior roles</li>
</ul>

<ul>
<li style="text-align:start;">Proven hands on experience with Oracle on AWS RDS</li>
</ul>

<ul>
<li style="text-align:start;">Expert level Oracle performance tuning and troubleshooting skills</li>
</ul>

<ul>
<li style="text-align:start;">Strong knowledge of AWS RDS internals and limitations</li>
</ul>

<ul>
<li style="text-align:start;">Advanced SQL PLSQL and shell scripting skills</li>
</ul>

<ul>
<li>Linux Unix system administration experience</li>
</ul>

Preferred Qualifications Optional Skills

<ul>
<li style="text-align:start;">Experience with largescale high throughput OLTP systems</li>
</ul>

<ul>
<li style="text-align:start;">Experience with AWS DMS and Oracle Data Pump</li>
</ul>

<ul>
<li style="text-align:start;">Familiarity with IaC tools Terraform CloudFormation</li>
</ul>

<ul>
<li style="text-align:start;">Experience in regulated or 24x7 production environments</li>
</ul>

<ul>
<li style="text-align:start;">Oracle OCP certifications</li>
</ul>

Leadership Soft Skills

<ul>
<li style="text-align:start;">Strong ownership and accountability for production stability</li>
</ul>

<ul>
<li style="text-align:start;">Ability to lead during high severity incidents</li>
</ul>

<ul>
<li style="text-align:start;">Clear communication with engineering leadership and vendors</li>
</ul>

<ul>
<li style="text-align:start;">Mentoring and knowledge sharing mindset </li>
</ul>

Database Administrator in Bengaluru (UID-16126)

Job Description

Job Details

Skills Required for Database Administrator

Job Description for Database Administrator

Explore More Opportunities