Oracle Database Administrator

Job Description for AWS Oracle RDS DBA

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 databas...