PostgreSQL Database Administrator

AAR

Wood Dale (IL)

On-site

USD 110,000 - 130,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

AAR is seeking an experienced PostgreSQL Database Administrator to manage and optimize our enterprise PostgreSQL environments. You will architect, tune performance, ensure high availability, implement security, and automate common tasks across on-prem and cloud deployments.

Based at our Wood Dale headquarters with a planned move to the Merchandise Mart in Chicago, this role partners with development, infrastructure, cloud, and security teams to deliver reliable database services and scalable

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 DBA
Problem solving
Communication

Education

Bachelor’s degree

Tools

Oracle
MSSQL Server
MySQL
Azure Database for PostgreSQL
AWS RDS for PostgreSQL

Job description

Title: PostgreSQL Database Administrator

Location: United States-Illinois-Wood Dale

Job Number: 18114

We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, optimize, and secure enterprise PostgreSQL database environments. The ideal candidate will be responsible for database architecture, performance tuning, high availability, disaster recovery, security compliance, automation, and supporting mission-critical applications. This role requires strong technical expertise, proactive problem-solving skills, and the ability to collaborate with development, infrastructure, cloud, and security teams.

This position is based at our Corporate Headquarters in Wood Dale, IL, with a planned relocation to the Merchandise Mart (Chicago) in early 2027.

What you will be responsible for:
  • 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
Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. A Database Administrator should have advanced knowledge of administration of PostgreSQL on on-prem and cloud. Strong migration experience in Oracle to PostgreSQL, MSSQL Server to PostgreSQL, On-prem to Azure migration experience preferred. Strong working experience with other database technologies such as Oracle, MSSQL Server, MySQL preferred.

Requirements:
  • 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 skillsTechnical writing skills are required for database management documentation and procedures
Additional Positives for the Position:
  • Holding credentials that demonstrates ability to perform a specific level of tasks related to database administration
  • Able to review and make decisions regarding the software and hardware required to meet the organization's needs
  • Training users in the proper use of company computer technology
  • Troubleshoot database operation errors and slowness
  • Experience working with RHEL and Windows environments
Compensation:

The anticipated salary range for this position is $110,000 to $130,000 annually. This range reflects the base salary for candidates who meet the requirements of the role, including experience, education, and location. [In addition to base pay, this role is eligible for a 10% bonus.] AAR offers a competitive benefits package, including medical/dental/vision/life/and AD&D insurance, 401(k) savings plan with employer match, paid time off and holiday pay, as well as opportunities for professional development and growth.

#LI-ONSITE #LI-RV1

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PostgreSQL Database Administrator
PostgreSQL Database Administrator

AAR • Chicago (IL)

On-site
USD 110,000 - 130,000
Health benefits
401(k) match
Paid time off
+1
Database Administrator
Database Administrator

Alrek Business Solutions Inc • Wood Dale (IL)

On-site
USD 120,000 - 160,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Dataquest • Harrisburg

On-site
USD 100,000 - 130,000
Medical insurance
Vision insurance
401(k)
+1
Senior PostgreSQL Database Engineer
Senior PostgreSQL Database Engineer

D2 Technical Services • St. Louis (MO)

On-site
USD 140,000 - 150,000
Health/Dental/Vision
401(k) match
Accrued PTO
+3
Senior PostgreSQL Database Engineer
Senior PostgreSQL Database Engineer

D2 Technical Services • Springfield (VA)

On-site
USD 145,000 - 155,000
Senior PostgreSQL Database Engineer
Senior PostgreSQL Database Engineer

D2 Consulting • Springfield (VA)

On-site
USD 145,000 - 155,000
Health/Dental/Vision Insurance
401(k) match
PTO accrual
Senior PostgreSQL Database Engineer
Senior PostgreSQL Database Engineer

D2 Consulting • St. Louis (MO)

On-site
USD 140,000 - 150,000
Health insurance
401(k) match
Paid time off
+1
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Compunnel Inc. • Des Moines (IA)

On-site
USD 120,000 - 180,000
Senior PostgreSQL DBA: AWS RDS, Performance & Reliability
Senior PostgreSQL DBA: AWS RDS, Performance & Reliability

Compunnel Inc. • Des Moines (IA)

Hybrid
USD 120,000 - 180,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Drillo.AI • St. Louis (MO)

On-site
USD 90,000 - 115,000