AWS Cloud Database Administrator

AWS Cloud Database Administrator (Oracle/Postgre

SQL RDS)

Competencies:

4-6+ years experience

Digital:
Amazon Web Service(AWS) Cloud Computing Postgre

SQL Oracle DBA

• Provisioned and configured Amazon RDS instances across Oracle, Postgre
  
  SQL, Redshift, Dynamo
  
  DB. Managed RDS storage, instance classes, parameter groups, option groups, and maintenance windows.
• Performed automated backup validation, manual snapshots, cross-region snapshot copy, and PITR restores.
• Monitored performance using Cloud Watch, Enhanced Monitoring, and Performance Insights.
• Diagnosed and resolved bottlenecks including CPU spikes, slow queries, blocking sessions, and IOPS issues.
• Implemented HA and DR solutions using multi-AZ, read replicas, and cross-region failover strategies.
• Created Cloud Watch alarms and alerts for CPU, storage, connections, replication lag, and backup failures.
• Executed minor version upgrades, patching, and capacity scaling during scheduled maintenance windows.
• Tuned SQL queries, indexes, and database parameters to optimize performance and resource usage.
• Developed automation using AWS CLI and shell/Python scripts for monitoring and reporting.
• Performed database migrations from on-prem to AWS using DMS and native export/import tools.
• Conducted performance benchmarking, load testing, and configuration optimization.
• Optimized cost by rightsizing RDS instances, enabling storage auto-scaling, and cleaning unused snapshots.
• Database refresh table level refresh from production to non-prod.