PostgreSQL DBA – Cloud, HA & Performance

AAR; Chicago (IL); On-site; USD 110,000 - 130,000; Full time

Benefits offered by this job

Health benefits

401(k) match

Paid time off

Professional development

Job summary

AAR is seeking an experienced PostgreSQL Database Administrator to manage enterprise PostgreSQL environments at our Wood Dale HQ, with planned move to Chicago. You will handle architecture, performance tuning, HA/DR, security, automation, and cross‑functional collaboration.

The role demands 5+ years of PostgreSQL experience, strong migration knowledge, and cloud platform expertise (Azure/AWS). Relocation to Chicago is planned for 2027.

Qualifications

• 5+ years’ work experience in PostgreSQL database administration and other related database technologies
• Bachelor’s degree in related field
• Strong interpersonal skills; the ability to work well with people from many disciplines and with varying degrees of business and technical experience
• Strong, recent database administration technical skills, knowledge and background
• Excellent knowledge of best practices around management, control, and monitoring of database infrastructure
• Excellent written and oral communication skills; ability to describe complex, highly technical issues using simple, clear, and precise language
• Great at organizing, prioritizing, and multitasking
• Strong troubleshooting skills
• Technical writing skills are required for database management documentation and procedures

Responsibilities

• Install, configure, upgrade, clone and maintain PostgreSQL database environments.
• Monitor database health, performance, and availability across production, staging, and development environments.
• Manage database objects including schemas, tables, indexes, partitions, views, functions, and stored procedures.
• Perform regular database maintenance activities such as VACUUM, ANALYZE, REINDEX, Statistics management, Storage optimization.
• Ensure database uptime and operational excellence through proactive monitoring and issue resolution.
• Analyze slow‑running queries and optimize SQL performance.
• Design and maintain effective indexing strategies.
• Perform query execution plan analysis using EXPLAIN, EXPLAIN ANALYZE, pg_stat_statements
• Optimize PostgreSQL configuration parameters such as shared_buffers, work_mem, maintenance_work_mem, effective_cache_size, wal_buffers.
• Identify and eliminate performance bottlenecks related to CPU, memory, storage, and network resources.
• Develop, test, and maintain backup & disaster recovery procedures.
• Execute database refreshes, restores during incidents and recovery operations.
• Implement database security standards and best practices.
• Manage PostgreSQL environments on cloud platforms. Azure Database for PostgreSQL (preferred), AWS RDS for PostgreSQL.
• Implement cloud‑native monitoring and automation.
• Optimize cloud database performance and costs.
• Support hybrid and multi‑cloud database architectures.
• Supports the AAR development staff in the areas of database design as it relates to reliability, resource utilization, practical operations, database environment, bug fixes, and interaction with vendor support

Skills

PostgreSQL

Performance tuning

Backup & DR

Automation scripting

SQL optimization

Cloud databases

Collaboration

Problem solving

Education

Bachelor's degree in related field

Tools

Azure Database for PostgreSQL

AWS RDS for PostgreSQL

Oracle

SQL Server

MySQL

Job description

AAR is seeking an experienced PostgreSQL Database Administrator to manage enterprise PostgreSQL environments at our Wood Dale HQ, with planned move to Chicago. You will handle architecture, performance tuning, HA/DR, security, automation, and cross‑functional collaboration.

The role demands 5+ years of PostgreSQL experience, strong migration knowledge, and cloud platform expertise (Azure/AWS). Relocation to Chicago is planned for 2027.