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

India

Key Responsibilities Performance Tuning Specifics Mandatory Skills Lead end to end database performance tuning for Oracle on AWS RDS Analyze AWR ADDM ASH Stats pack reports to identify performance bottlenecks Perform SQL tuning using execution plan analysis SQL profiles and indexing strategies Optimize wait events related to CPU IO memory and locking contention Tune Oracle parameters PGA SGA optimizer settings within RDS constraints Work with development teams to refactor inefficient SQL and PLSQL code Perform capacity planning and workload forecasting based on performance trends Optimize storage and IO performance RDS storage types IOPS tuning Lead performance testing for releases migrations and major changes Troubleshooting Incident Management Specifics Act as the primary escalation point for complex Oracle production issues Diagnose and resolve database outages slowness and replication issues Troubleshoot blocking sessions deadlocks latchmutex contention and enqueue waits Analyze logs trace files and diagnostic dumps in RDS environments Handle corruption scenarios recovery issues and restore validations Coordinate with AWS Support and Oracle Support for critical incidents Lead root cause analysis RCA and produce detailed postmortem reports Implement preventive measures and automation to reduce repeat incidents Core Responsibilities Architect operate and govern Oracle databases on AWS RDS Define HADR strategies Multi AZ backups cross region recovery Lead patching upgrades and database lifecycle management Drive database security compliance and audit readiness Provide DB related technical leadership Support cloud migrations and modernization initiatives Required Qualifications 10 years of Oracle DBA experience including lead or senior roles Proven hands on experience with Oracle on AWS RDS Expert level Oracle performance tuning and troubleshooting skills Strong knowledge of AWS RDS internals and limitations Advanced SQL PLSQL and shell scripting skills Linux Unix system administration experience Preferred Qualifications Optional Skills Experience with largescale high throughput OLTP systems Experience with AWS DMS and Oracle Data Pump Familiarity with IaC tools Terraform CloudFormation Experience in regulated or 24x7 production environments Oracle OCP certifications Leadership Soft Skills Strong ownership and accountability for production stability Ability to lead during high severity incidents Clear communication with engineering leadership and vendors Mentoring and knowledge sharing mindset

Database Administrator · Bengaluru

Job highlights

Skillset required

Job Description

Job Description for Database Administrator

More at MPHASIS