Must Have Technical/Functional Skills
Technical Skills
- Strong expertise in PostgreSQL architecture, replication, backup and recovery.
- Deep knowledge of AWS database services, including:
- Amazon RDS
- AWS DMS
- AWS SCT
- CloudWatch
- IAM
- 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.
Database Administration
- 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.
- 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.
- 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.