JOBSEARCHER

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