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