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
- ExperiencedAurora PostgreSQL DBAresponsible for designing, administering, optimizing, and supporting highly available PostgreSQL databases onAmazon 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 PostgreSQLdatabase 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
PerformPoint-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 Qualifications5+ yearsof database administration experience with PostgreSQL.2+ yearsof 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 usingAWS 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