AWS Cloud DBA

1.Primary Skillset: AWS RDS, Aurora PostGreSQL and DynamoDB

2. Secondary Skillet: Scripting (Python/Bash), AWS Monitoring tools (CloudWatch, ELK Logs and Datadog) and CI/CD DevOps (GitLab)

3. An RDS Aurora PostGreSQL DBA is responsible for managing and maintaining the performance, security and availability of a PostGreSQL Database hosted on Amazon RDS (Aurora), which includes tasks like database design, monitoring performance, implementing backups, managing user access, troubleshooting issues, optimizing, and ensuring the data integrity across dev, test and production environments.

Roles & Responsibilities

1. Database Administration

a. Creating and managing the clusters and performing the regular DR Exercises

b. Creating user accounts and permissions to control data access

c. Scaling clusters

d. Performing database upgrades and Patching

2. Performance Optimization

a. Monitoring Database performance Metrics like CPU Usage, Memory consumption and Disk I/O

b. Identify Performance Bottlenecks using AWS Monitoring tools (CloudWatch, ELK Logs and Datadog)

3. Backup, Recovery, Import/Export

a. Implementing Robust backup strategies

b. Knowledge of AWS_S3 Extension

4. Creating and Managing IAM Roles to control user access to RDS Instances

5. AWS Management Console: Utilization to manage RDS Instances

6. High Availability and DR

7. Monitoring and Alerting