PostgreSQL DBA: Cloud, HA & Performance Expert

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

Benefits offered by this job

Medical/dental/vision insurance

401(k) with employer match

Paid time off & holidays

Job summary

AAR is seeking a seasoned PostgreSQL Database Administrator to manage and optimize enterprise PostgreSQL environments. This role covers on-prem and cloud deployments with a focus on performance, security, and high availability.

You will collaborate with development, infrastructure, cloud, and security teams to ensure reliability and efficiency. The position starts at our Wood Dale HQ with relocation planned to the Merchandise Mart in Chicago in early 2027.

Qualifications

• 5 years’ work experience in PostgreSQL and related databases.
• Bachelor’s degree in a related field.
• Strong interpersonal and communication skills.
• Experience migrating Oracle/MSSQL to PostgreSQL.
• Experience with Linux (RHEL) and Windows.

Responsibilities

• Install, configure, upgrade, clone and maintain PostgreSQL environments.
• Monitor health, performance, and availability across environments.
• Manage schemas, tables, indexes, and other objects.
• Perform VACUUM, ANALYZE, REINDEX and statistics maintenance.
• Analyze slow queries and optimize SQL performance.
• Design indexing strategies and use EXPLAIN ANALYZE.
• Ensure uptime and DR procedures; backups.
• Manage cloud PostgreSQL environments (Azure, AWS RDS).

Skills

PostgreSQL

Database administration

Performance tuning

SQL optimization

Cloud databases

Education

Bachelor’s degree

Tools

Azure Database for PostgreSQL

AWS RDS for PostgreSQL

pg_stat_statements

EXPLAIN ANALYZE

Job description

AAR is seeking a seasoned PostgreSQL Database Administrator to manage and optimize enterprise PostgreSQL environments. This role covers on-prem and cloud deployments with a focus on performance, security, and high availability.

You will collaborate with development, infrastructure, cloud, and security teams to ensure reliability and efficiency. The position starts at our Wood Dale HQ with relocation planned to the Merchandise Mart in Chicago in early 2027.