Amazon Aurora PostgreSQL Database Administrator (DBA)

Position: Amazon Aurora PostgreSQL Database Administrator (DBA)

Position Type: Fulltime

Location: Costa Mesa, CA/ Remote

6 - 10 Years exp.

Desired Skills : PostgreSQL DBA

Salary Range: $110000 - $125000 a year

Job Description

Amazon Aurora PostgreSQL Database Administrator (DBA)

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.

Roles & Responsibilities
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.

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.

Education
Bachelor's degree

Regards,          
Sajith Nair                        
Ztek Consulting Inc