| AWS Cloud Database Administrator (Oracle/PostgreSQL RDS) | Competencies: 4-6 years experience Digital : Amazon Web Service(AWS) Cloud Computing PostgreSQL Oracle DBA Role Description: Provisioned and configured Amazon RDS instances across Oracle PostgreSQL Redshift Dynamodb 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 CloudWatch 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 CloudWatch 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 shellPython 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 refreshtable level refresh from production to non-prod. |
AWS Cloud Database Administrator (Oracle/PostgreSQL RDS) Competencies: 4-6 years experience Digital : Amazon Web Service(AWS) Cloud Computing PostgreSQL Oracle DBA Role Description: Provisioned and configured Amazon RDS instances across Oracle PostgreSQL Redshift Dynamodb Managed RDS storage ...
| AWS Cloud Database Administrator (Oracle/PostgreSQL RDS) | Competencies: 4-6 years experience Digital : Amazon Web Service(AWS) Cloud Computing PostgreSQL Oracle DBA Role Description: Provisioned and configured Amazon RDS instances across Oracle PostgreSQL Redshift Dynamodb 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 CloudWatch 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 CloudWatch 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 shellPython 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 refreshtable level refresh from production to non-prod. |
View more
View less