Database Administrator

Alrek Business Solutions Inc; Wood Dale (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Alrek Business Solutions Inc. is seeking an experienced PostgreSQL Database Administrator (DBA) to manage enterprise PostgreSQL environments on-premises and in cloud platforms. The role emphasizes performance tuning, high availability, security, automation, and DR for mission-critical applications.

Strong collaboration with development, infrastructure, cloud, and security teams is essential. The ideal candidate will have advanced PostgreSQL administration skills, migration experience (Oracle/SQL

Qualifications

• Advanced PostgreSQL administration in on-premises and cloud environments.
• Database migration experience (Oracle to PostgreSQL, SQL Server to PostgreSQL, on-prem to Azure).
• Recent technical background in database administration.
• Excellent knowledge of best practices for managing database infrastructure.

Responsibilities

• Install, configure, upgrade, clone, and maintain PostgreSQL environments on-prem and in the cloud.
• Monitor health, performance, and availability across environments.
• Manage schemas, tables, indexes, partitions, views, functions, and procedures.
• Design and maintain backup and disaster recovery procedures.
• Implement security standards and cloud-native monitoring and automation.
• Support hybrid and multi-cloud database architectures.

Skills

PostgreSQL admin

Performance tuning

SQL optimization

Backup & DR

Migration experience

Cloud databases

Troubleshooting

Team collaboration

Technical writing

On-prem & cloud

Education

Bachelor's degree or 5+ years PostgreSQL experience

Tools

Azure

AWS

Linux

Windows

Job description

Work Authorization: Candidates must be authorized to work in the U.S. without current or future employer sponsorship.

This is a Contract-to-Hire opportunity with potential conversion to a full-time position.

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

Responsibilities:

• Install, configure, upgrade, clone, and maintain PostgreSQL database environments on-premises and in cloud platforms.
• 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.
• 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.
• Identify and eliminate performance bottlenecks related to CPU, memory, storage, and network resources.
• Develop, test, and maintain backup and disaster recovery procedures.
• Execute database refreshes and restores during incidents and recovery operations.
• Implement database security standards and best practices.
• Implement cloud-native monitoring and automation.
• Optimize cloud database performance and costs.
• Support hybrid and multi-cloud database architectures.
• Support AAR development staff with database design related to reliability, resource utilization, operational efficiency, database environments, bug fixes, and vendor support coordination.

Requirements:

• Advanced knowledge of PostgreSQL administration in on-premises and cloud environments.
• Database migration experience, including Oracle to PostgreSQL, SQL Server to PostgreSQL, and on-premises to Azure migrations.
• Recent technical background in database administration.
• Excellent knowledge of best practices for managing, controlling, and monitoring database infrastructure.
• Strong interpersonal skills
• Excellent written and oral communication skills
• Organizational, prioritization, and multitasking skills.
• Strong troubleshooting skills
• Technical writing skills for database management documentation and procedures.
• Bachelor’s degree in a related field or 5+ years of experience in PostgreSQL database administration and related database technologies.

Additional Positives for the Position:

• Credentials that demonstrate the ability to perform database administration tasks at a defined level.
• Ability to evaluate and recommend software and hardware needed to meet organizational requirements.
• Train users on the proper use of company computer technology.
• Troubleshoot database operational errors and performance issues.
• Experience working with RHEL and Windows environments