Amazon Aurora PostgreSQL Database Administrator (DBA)

Amazon Aurora PostgreSQL Database Administrator (DBA), * Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.

• Perform database installation, upgrades, patching and lifecycle management.

• Monitor database health, capacity and performance metrics. Performance Optimization

• Analyze and optimize SQL queries and database workloads.
• Implement indexing strategies and query tuning best practices.
• Manage connection pooling and resolve infrastructure bottlenecks.

• Troubleshoot and resolve database performance issues. High Availability & Disaster Recovery

• Design and implement Multi-AZ deployments and cross-region replication.
• Develop, test, and maintain backup and disaster recovery processes.

• Ensure database availability and business continuity objectives are met. Cloud Migration & Modernization

• Lead or support database migration initiatives to Aurora PostgreSQL.
• Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects.

• Perform migration assessments, validations and post-migration optimization. Automation & Infrastructure as Code (IaC)

• Develop automation scripts for routine database administration activities.
• Manage infrastructure using Terraform, Ansible or AWS CloudFormation.

• Support CI/CD pipeline integration for database deployments and schema changes. Security & Compliance

• Implement security controls, database encryption and access management.
• Apply database patches and vulnerability remediation activities.
• Ensure compliance with organizational and regulatory security standards.
• Perform periodic security reviews and audit support activities.

Must Have Technical/Functional Skills Technical Skills

• Strong expertise in PostgreSQL architecture, replication, backup and recovery.

• Deep knowledge of AWS database services, including: o Amazon Aurora PostgreSQL o Amazon RDS o AWS DMS o AWS SCT o CloudWatch o IAM o KMS

• Experience with database performance tuning and troubleshooting.
• Proficiency in scripting languages such as Python, Bash, or PowerShell.
• Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation.
• Familiarity with CI/CD tools and DevOps practices.

Experience

• Minimum 5+ years of hands-on database administration experience.
• Strong experience administering PostgreSQL databases in AWS environments.
• Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services., Bachelor’s degree Regards