Database Administrator

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

Job summary

Alrek Business Solutions Inc seeks an experienced PostgreSQL DBA to manage on‑prem and cloud PostgreSQL environments, with performance tuning, high availability, and security. This contract‑to‑hire role may convert to full‑time, requiring collaboration with development, infrastructure, cloud and security teams.

Responsibilities include installation, monitoring, optimization of queries, indexing, backups/DR, and incident recovery.

Qualifications

• 5+ years of PostgreSQL administration experience.
• Experience migrating Oracle/SQL Server to PostgreSQL.
• Experience with on-premise and cloud deployments.
• Strong troubleshooting and optimization skills.
• Excellent communication and documentation skills.

Responsibilities

• Install, configure, and maintain PostgreSQL environments on‑prem and in the cloud.
• Monitor health, performance, and availability.
• Manage schemas, tables, indexes, and procedures.
• Design indexing strategies and optimize slow queries.
• Develop backup and disaster recovery procedures.
• Implement security standards and cloud-native monitoring.
• Support hybrid/multi-cloud database architectures.
• Collaborate with development, infra, and security teams.

Skills

PostgreSQL DBA

Performance tuning

Backup & DR

Security best practices

Cloud/on-prem hybrid

Cross-functional teamwork

Technical writing

Migration experience

Education

Bachelor's degree

Tools

Oracle

SQL Server

Azure

PostgreSQL

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