Aurora PostgreSQL Database Administrator (DBA)

Job Title: Aurora PostgreSQL Database Administrator (DBA)Experience Level: Senior-levelExperience Required: 5-10+ yearsPrimary Database: PostgreSQL / Amazon Aurora PostgreSQLPosition OverviewExperienced Aurora PostgreSQL DBA responsible for designing, administering, optimizing, and supporting highly available PostgreSQL databases on Amazon Aurora PostgreSQL. Responsible for:Database reliabilityPerformanceSecurityBackup and recoveryMonitoringProduction supportSupport database environments across:DevelopmentTestProductionStrong hands-on PostgreSQL and AWS/Amazon Aurora experience required. Strong understanding of:Database performanceHigh availabilityAutomationTroubleshootingKey ResponsibilitiesAdminister and support Amazon Aurora PostgreSQL database environments. Install, configure, upgrade, patch, and maintain PostgreSQL/Aurora systems. Manage:Aurora clustersRead replicasFailoverParameter groupsSubnet groupsEndpointsPerform database performance tuning, including:Query optimizationExecution plan analysisIndex optimizationConnection and memory tuningLock and wait-event analysisVacuum/autovacuum optimizationMonitor database:HealthCapacityPerformanceAvailabilityUse AWS and PostgreSQL monitoring tools. Implement and maintain:Backup and restore strategiesDisaster recovery (DR)Business continuity strategiesPerform Point-in-Time Recovery (PITR). Support database recovery exercises. Troubleshoot production issues, including:Database incidentsPerformance problemsConnectivity issuesReplication issuesDatabase failuresManage database security:UsersRolesPermissionsEncryptionAuditingAccess controlsWork with application and development teams on:SQL queriesSchema designIndexesDatabase-related application issuesSupport migrations to Aurora PostgreSQL from:On-premises DB2Other database platformsDevelop automation and operational scripts using:PythonAWS LambdaAWS CLIEstablish and maintain:Database standardsOperational proceduresDocumentationRunbooksParticipate in on-call rotations. Provide production support for critical database environments. Assist with:Capacity planningCloud cost optimizationDatabase modernization initiativesRequired Qualifications5+ years of database administration experience with PostgreSQL. 2+ years of hands-on experience with Amazon Aurora PostgreSQL. Strong understanding of:PostgreSQL architecturePostgreSQL administrationPostgreSQL internalsStrong experience with:SQLPL/pgSQLIndexesTransactionsLockingQuery execution plansExperience with:PostgreSQL backup and recoveryReplicationHigh-availability strategiesStrong AWS knowledge, particularly:Amazon AuroraAmazon RDSEC2IAMCloudWatchS3AirflowLambdaExperience troubleshooting database performance using:EXPLAINEXPLAIN ANALYZEPostgreSQL statistics viewsAWS Performance InsightsCloudWatchExperience with database monitoring and alerting. Strong scripting and automation skills using Python or similar languages. Experience working with:Production-critical databasesIncident management processesPreferred QualificationsAWS 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:DatadogGrafanaSimilar platformsExperience with:PostgreSQL version upgradesAurora major-version upgradesTechnical SkillsDatabases:PostgreSQLAmazon Aurora PostgreSQLAmazon RDSAWS:AuroraRDSEC2VPCIAMCloudWatchS3KMSDMSLambdaAirflowPerformance Tuning:EXPLAIN / EXPLAIN ANALYZEQuery tuningIndexingWait-event analysisLock analysisVacuum/autovacuumConnection managementHigh Availability & Disaster Recovery:Aurora replicationRead replicasFailoverBackup/restorePoint-in-Time RecoveryDisaster recoveryAutomation:PythonAWS CLILambdaAirflowMonitoring & Observability:AWS Performance InsightsCloudWatchPostgreSQL monitoringGrafanaPrometheusDatadogSoft SkillsStrong analytical and problem-solving skills. Excellent troubleshooting skills. Strong incident-management capabilities. Ability to work effectively with:DevelopersArchitectsInfrastructure teamsStrong communication skills. Strong documentation skills. Ability to work independently in a fast-paced production environment. Strong ownership and attention to:ReliabilitySecurityOperational excellenceSuccess CriteriaMaintain highly available and secure Aurora PostgreSQL environments. Proactively improve database:PerformanceReliabilityAutomate routine DBA activities. Minimize production downtime. Partner effectively with engineering teams. Deliver scalable and reliable database solutions. Key Resume KeywordsPostgreSQL DBAAurora PostgreSQLAmazon AuroraAWS RDSPostgreSQL AdministrationDatabase AdministrationSQLPL/pgSQLQuery OptimizationPerformance TuningEXPLAIN ANALYZEIndex OptimizationReplicationHigh AvailabilityFailoverBackup & RecoveryPoint-in-Time RecoveryDisaster RecoveryAWSCloudWatchPerformance InsightsIAMS3LambdaAWS CLIPythonAirflowAWS DMSDB2 MigrationDatabase MigrationDatadogGrafanaPrometheusCI/CD