Logo
JobsFor employers
Get matched

Aurora PostgreSQL Database Administrator (DBA)

L5

talent software servicesDenver, COyesterday

Occupations

Database AdministratorsDatabase ArchitectsData Warehousing Specialists

Industries

Computer Systems Design ServicesComputing Infrastructure Providers, Data Processing, Web Hosting, and Related ServicesCustom Computer Programming Services
Aurora PostgreSQL Database Administrator (DBA) 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, Grafana, or similar 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 Recovery Disaster 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
Apply now
Apply now

Level

SeniorL5

Location

Denver, CO

Occupation

Database Administrators

Industry

Computer Systems Design Services

Posted

yesterday

To get sharper similar jobs, create your profile using the link below.

Create profile