Aurora PostgreSQL Database Administrator (DBA)
Job Description
Job Title: Aurora PostgreSQL Database Administrator (DBA)
Experience Level: Senior-level
Experience Required:
5–10+ years
Primary Database: PostgreSQL / Amazon Aurora PostgreSQLPosition Overview
Experienced Aurora PostgreSQL DBA responsible for designing, administering, optimizing, and supporting highly available PostgreSQL databases on Amazon Aurora PostgreSQL.Responsible for:
- Database reliability
- PerformanceSecurityBackup and recovery
- MonitoringProduction support
- Support database environments across:
- Development
TestProductionStrong hands-on PostgreSQL and AWS/Amazon Aurora experience required.
Strong understanding of:
Database performance
High availability
AutomationTroubleshootingKey Responsibilities
Administer and support Amazon Aurora PostgreSQL database environments.
Install, configure, upgrade, patch, and maintain PostgreSQL/Aurora systems.
Manage:
Aurora clusters
Read replicas
FailoverParameter groups
Subnet groups
EndpointsPerform database performance tuning, including:
Query optimization
Execution plan analysis
Index optimization
Connection and memory tuning
Lock and wait-event analysisVacuum/autovacuum optimization
Monitor database:
Health
CapacityPerformanceAvailabilityUse AWS and PostgreSQL monitoring tools.
Implement and maintain:
Backup and restore strategies
Disaster recovery (DR)
Business continuity strategies
Perform Point-in-Time Recovery (PITR).Support database recovery exercises.
Troubleshoot production issues, including:
Database incidents
Performance problems
Connectivity issues
Replication issues
Database failures
Manage database security:
UsersRolesPermissionsEncryptionAuditingAccess controls
Work with application and development teams on:
SQL queries
Schema design
IndexesDatabase-related application issues
Support migrations to Aurora PostgreSQL from:
On-premises DB2Other database platforms
Develop automation and operational scripts using:
PythonAWS LambdaAWS CLIEstablish and maintain:
Database standards
Operational procedures
DocumentationRunbooksParticipate in on-call rotations.
Provide production support for critical database environments.
Assist with:
Capacity planning
Cloud cost optimization
Database modernization initiatives
Required Qualifications:
5+ years of database administration experience with PostgreSQL.2+ years of hands-on experience with Amazon Aurora PostgreSQL.Strong understanding of:
- PostgreSQL architecture
- PostgreSQL administration
- PostgreSQL internals
- Strong experience with:
- SQLPL/pgSQLIndexesTransactionsLockingQuery execution plans
- Experience with:
- PostgreSQL backup and recovery
- ReplicationHigh-availability strategies
- Strong AWS knowledge, particularly:
- Amazon AuroraAmazon RDSEC2IAMCloudWatchS3Airflow
- LambdaExperience troubleshooting database performance using:
- EXPLAINEXPLAIN ANALYZEPostgreSQL statistics viewsAWS Performance Insights
- CloudWatchExperience with database monitoring and alerting.
- Strong scripting and automation skills using Python or similar languages.
- Experience working with:
- Production-critical databases
- Incident management processes
Preferred Qualifications:
AWS Certified Database – Specialty or comparable AWS certification.
PostgreSQL certification or equivalent professional experience.
Experience migrating databases to Aurora PostgreSQL using AWS Database Migration Service (DMS).Experience with CI/CD pipelines.
Experience with database observability tools such as:
Datadog
GrafanaSimilar platforms
Experience with:
PostgreSQL version upgrades
Aurora major-version upgrades
Technical Skills
Databases:
PostgreSQLAmazon Aurora PostgreSQLAmazon RDSAWS:AuroraRDSEC2VPCIAMCloudWatchS3KMSDMSLambdaAirflowPerformance Tuning:
EXPLAIN / EXPLAIN ANALYZEQuery tuning
IndexingWait-event analysis
Lock analysisVacuum/autovacuum
Connection management
High Availability & Disaster Recovery:
Aurora replication
Read replicas
FailoverBackup/restore
Point-in-Time RecoveryDisaster recovery
Automation:
PythonAWS CLILambdaAirflowMonitoring & Observability:
AWS Performance Insights
CloudWatchPostgreSQL monitoring
GrafanaPrometheusDatadogSoft SkillsStrong analytical and problem-solving skills.
Excellent troubleshooting skills.
Strong incident-management capabilities.
Ability to work effectively with:
Developers
ArchitectsInfrastructure teams
Strong communication skills.
Strong documentation skills.
Ability to work independently in a fast-paced production environment.
Strong ownership and attention to:
Reliability
SecurityOperational excellence
Success Criteria
Maintain highly available and secure Aurora PostgreSQL environments.
Proactively improve database:
Performance:
- ReliabilityAutomate routine DBA activities.
- Minimize production downtime.
- Partner effectively with engineering teams.
- Deliver scalable and reliable database solutions.
- Key Resume Keywords
- PostgreSQL DBAAurora PostgreSQLAmazon AuroraAWS RDSPostgreSQL Administration
- Database AdministrationSQLPL/pgSQLQuery Optimization
- Performance TuningEXPLAIN ANALYZEIndex Optimization
- ReplicationHigh Availability
- FailoverBackup & Recovery
- Point-in-Time RecoveryDisaster RecoveryAWSCloudWatchPerformance InsightsIAMS3LambdaAWS CLIPythonAirflowAWS DMSDB2 Migration
- Database Migration
DatadogGrafanaPrometheusCI/CD