Job ID: JOB_ID_7772
Role Overview:
We are seeking an experienced Database Lead with strong expertise in Microsoft SQL Server and PostgreSQL, and a solid working knowledge of Red Hat Enterprise Linux (RHEL). This is a long-term contract role with potential for extensions, located in West Des Moines, IA, offering a hybrid work model.
Key Responsibilities:
- Database Administration:
- Install, configure, upgrade, and manage MS SQL Server and PostgreSQL databases across various environments.
- Perform query tuning, index optimization, vacuuming, execution plan analysis, and overall performance tuning.
- Implement and maintain High Availability/Disaster Recovery (HA/DR) solutions including AlwaysOn, Log Shipping, Replication, Streaming Replication, Patroni, and pgBackRest.
- Manage database security, roles, permissions, auditing, capacity planning, and storage optimization.
- Perform backup and restore operations for both SQL Server and PostgreSQL using appropriate strategies and tools.
- Monitor, troubleshoot, and resolve database issues related to performance, locks, replication, connectivity, and system-level components.
- Datacenter Operations:
- Coordinate with vendors for rack & stack, maintenance, and new service builds.
- Red Hat Enterprise Linux (RHEL) Administration:
- Monitor system performance, resource utilization, and availability to ensure optimal operations.
- Troubleshoot and resolve OS-level issues related to CPU, memory, storage, network, and system services.
- Manage user accounts, groups, file permissions, sudo access, and system hardening.
- Configure and maintain system security, including firewall settings, SELinux policies, and patch compliance.
- Configure and troubleshoot core network services such as SSH, NTP, DNS, FTP, and HTTP.
- Develop and maintain Bash shell scripts and Ansible playbooks for automation.
- Support Linux systems running in VMware, AWS, or Azure cloud environments.
- Collaborate with application teams for deployments and OS-level incident resolution.
- Document system builds, configurations, troubleshooting procedures, and runbooks.
- Participate in on-call rotation and respond to critical production incidents.
Requirements:
- 8+ years of hands-on MS SQL / PGSQL DBA experience.
- Strong proficiency with SQL Server versions.
- Solid understanding of RHEL administration and Linux troubleshooting.
- Experience with Bash scripting and automation (Ansible preferred).
- Knowledge of virtualization (VMware) and cloud platforms (AWS/Azure).
- Strong analytical, troubleshooting, and documentation skills.
About Empower Professionals Inc.:
Empower Professionals Inc. is a certified NJ and NY Minority Business Enterprise (NMSDC) specializing in providing top-tier IT staffing solutions. We are committed to connecting talented professionals with leading companies.
Location:
West Des Moines, IA (Hybrid)
Employment Type:
Contract
Duration:
12+ Months
Compensation & Location
Salary: $30 – $45 per year
Location: West Des Moines, IA
Recruiter / Company – Contact Information
Recruiter / Employer: Empower Professionals Inc.
Email: hash@empowerprofessionals.com
Recruiter Notice:
To remove this job posting, please send an email from
hash@empowerprofessionals.com with the subject:
DELETE_JOB_ID_7772