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
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 skills
Technical 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
