Senior PostgreSQL DBA / AWS Database Architect

IDR, Inc.

Des Moines, IA, United States

3 months ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Compensation

$114,400.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Amazon Web Services Databases Continuous Integration PostgreSQL Microsoft SQL Server Performance Tuning Query Optimization Database Performance Amazon Relational Database Service

Job description

Administer, monitor, and optimize PostgreSQL in AWS (RDS & Aurora PostgreSQL)
Own production support/triage, troubleshooting incidents through resolution
Perform performance tuning and query optimization (EXPLAIN/EXPLAIN ANALYZE, execution plans, pg_stat_activity)
Manage/optimize connection pooling & concurrency (e.g., PgBouncer)
Design and improve scalable, highly available database architectures
Support deployments, migrations, upgrades, and patching
Partner with engineering teams to improve application/database performance
Ensure best practices around security, backups, recovery, and DR

Requirements

Do you have experience in RDS database?, * 7+ years DBA experience with strong focus on PostgreSQL

Hands-on experience running PostgreSQL in AWS
Strong experience with Amazon RDS and Aurora PostgreSQL
Demonstrated ability to troubleshoot independently in production environments
Strong communication / client-facing skills, * Migration experience (e.g., SQL Server ? PostgreSQL)
Automation and CI/CD exposure
Familiarity with AWS monitoring/observability tools
High-volume / enterprise production experience

Location note: This role is fully remote, but the team strongly prefers candidates in/near Des Moines, IA.