Database Lead/ Lead DBA/ Senior Database Administrator/ SQL Server / PostgreSQL DBA Lead (SQL Server + PostgreSQL + Linux)
Not Disclosed
Location: West Des Moines, IA
Job Type: Hybrid
Salary: Competitive
Duration: 12+ Months
Experience: 8+ years, SQL Server & PostgreSQL
Job Description & Details
"The demand for experts who can bridge both Microsoft SQL Server and PostgreSQL on Linux environments has surged as companies modernize their data platforms. This hybrid DBA role offers a chance to lead critical database initiatives while working with cutting\u2011edge automation tools. If you thrive on performance tuning, high\u2011availability design, and cloud\u2011native infrastructure, this opportunity is worth your attention.\n\n# Job Summary\nWe are seeking a seasoned Database Lead to own the design, implementation, and maintenance of high\u2011performance SQL Server and PostgreSQL environments on Red Hat Enterprise Linux. The role involves performance tuning, HA/DR configuration, automation via Bash/Ansible, and collaboration with cloud (AWS/Azure) and virtualization (VMware) teams.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|---|---|---|\n| SQL Server Administration | Core relational platform; ensures performance, security, and high\u2011availability | Senior |\n| PostgreSQL Administration | Handles open\u2011source workloads, replication, and disaster recovery | Senior |\n| Linux & Automation (Bash/Ansible) | Underpins environment stability and repeatable deployments | Senior |\n\n# Interview Preparation\n1. **How do you configure and monitor AlwaysOn Availability Groups in SQL Server?**\n *What the interviewer is looking for:* Depth of HA knowledge, understanding of quorum, replica roles, and monitoring tools.\n2. **Explain the process of setting up Patroni with etcd for PostgreSQL HA.**\n *What the interviewer is looking for:* Hands\u2011on experience with PostgreSQL clustering, failover mechanisms, and configuration nuances.\n3. **Describe a performance tuning scenario where you identified a bottleneck and resolved it on both SQL Server and PostgreSQL.**\n *What the interviewer is looking for:* Ability to use DMVs, pg_stat_statements, indexing strategies, and query plan analysis across platforms.\n4. **What are the key differences between pgBackRest and native PostgreSQL backup methods, and when would you choose each?**\n *What the interviewer is looking for:* Knowledge of backup strategies, reliability, and restoration procedures.\n5. **Walk me through an Ansible playbook you wrote to automate database patching on RHEL.**\n *What the interviewer is looking for:* Proficiency in scripting, idempotent automation, and Linux system administration.\n\n# Resume Optimization\n- SQL Server Administration\n- PostgreSQL Administration\n- Red Hat Enterprise Linux (RHEL)\n- HA/DR (AlwaysOn, Replication, Patroni, pgBackRest)\n- Performance Tuning & Optimization\n- Bash Scripting\n- Ansible Automation\n- VMware Virtualization\n- AWS Cloud Services\n- Azure Cloud Services\n\n# Application Strategy\nWhen reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your updated resume, and clearly highlights your top relevant skills. Make sure to mention related skills you possess, such as SQL Server high\u2011availability design, PostgreSQL clustering with Patroni, and Linux/Ansible automation. Reference specific projects where you delivered performance improvements or successful migrations, and map each to the key requirements listed in the job description.\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|---|---|---|---|\n| Senior Database Lead (DBA) | 8+ years managing SQL Server & PostgreSQL on Linux, cloud, automation | Multi\u2011platform database architecture, HA/DR, scripting | DB Architecture Manager / Data Platform Director |\n"