AWS RDS (Oracle DBA)

Role: AWS RDS (Oracle DBA) Location: Bangalore/Chennai Exp: 5-7 yrs Mode of interview : Virtual Must Have Skills: 1. Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM. 2. Expert-level performance tuning (SQL & instance), AWR/ASH analysis, wait events. 3. Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups). 4. Govern backup/restore (automated backups, snapshots), encryption (KMS), patching, and minor/major version upgrades. 5. Implement monitoring/alerting via CloudWatch, Performance Insights, Enhanced Monitoring; tune connections/queries. 6. Cost management: right-sizing, storage management, Reserved/Compute Savings Plans advisory. 7. Design and operate Redshift clusters; configure WLM, concurrency scaling, queue management. 8. Optimize schema (distribution/sort keys), VACUUM/ANALYZE, query tuning; workload isolation. Good to have: 1. 4–7 years as a Oracle DBA with 3 years on AWS data services. 2. Hands-o...