Senior PostgreSQL DBA / AWS Database Architect

IDR is seeking a Senior PostgreSQL DBA / AWS Database Architect to join one of our top clients for a remote opportunity. This role involves supporting and optimizing enterprise-level PostgreSQL databases in AWS environments, with a focus on high availability, performance tuning, and seamless database operations. The client operates within a technology-driven industry and is looking for a highly experienced professional to support their critical infrastructure.Position Overview for the Senior PostgreSQL DBA / AWS Database Architect:Administer, monitor, and optimize PostgreSQL databases in AWS RDS and Aurora environmentsIndependently troubleshoot and resolve production database incidents and client-reported issuesAnalyze database performance using PostgreSQL-native tools such as pg_stat_activity, EXPLAIN / EXPLAIN ANALYZE query execution plans, and connection/session monitoring toolsManage and optimize connection pooling strategies utilizing tools like PgBouncerDesign and implement scalable, highly available database architectures and support deployment, migration, upgrades, and patching activitiesRequirements for the Senior PostgreSQL DBA / AWS Database Architect:7+ years of DBA experience with strong focus on PostgreSQLHands-on experience supporting PostgreSQL databases in AWS environmentsStrong experience with Amazon RDS and Aurora PostgreSQLDeep understanding of PostgreSQL performance tuning and query optimizationExperience managing connection pooling and concurrency strategiesWhat's in it for you?Competitive compensation packageFull Benefits; Medical, Vision, Dental, and more!Opportunity to get in with an industry leading organization.Why IDR?25+ Years of Proven Industry Experience in 4 major marketsEmployee Stock Ownership ProgramDedicated Engagement Manager who is committed to you and your success.Medical, Dental, Vision, and Life InsuranceClearlyRated's Best of Staffing® Client and Talent Award winner 12 years in a row.