SQL Dba with LifePro

ESRhealthcare and EXEC STAFF RECRUITERS•Madison, WI

1d•Onsite

About The Position

ESR Healthcare is seeking an SQL DBA with LifePro to administer Microsoft SQL Server environments. The role involves installation, configuration, troubleshooting, upgrades, migrations, maintenance, security auditing, performance tuning, and backup and recovery across SQL Server versions from 2008R2 through 2022. The position is onsite in Madison, Wisconsin. The DBA will support high availability and disaster recovery solutions, including Always On Availability Groups, replication, log shipping, mirroring, and clustering. The role also requires scripting and automation, incident troubleshooting, and communicating with customers about technical questions and issues.

Requirements

10+ years of Microsoft SQL Server database administration experience, including SQL Server 2008R2, 2008, 2012, 2014, 2016, 2017, 2019, and 2022.
Experience installing, configuring, and troubleshooting SQL Server 2012 through 2022.
Experience migrating from SQL Server 2012 or earlier to SQL Server 2014, 2016, 2017, 2019, or 2022.
Experience upgrading SQL Server and applying service packs and patches.
Proficiency with SQL Management Studio, Enterprise Manager, Query Analyzer, and SQL Server job scheduling.
Experience creating database maintenance plans, rebuilding or reorganizing indexes, and performing integrity checks.
Strong knowledge of database backup, restore, recovery, linked servers, and database maintenance plans.
Experience with high availability and disaster recovery, including Always On Availability Groups, replication, log shipping, mirroring, and clustering.
Experience implementing SQL Server Always On across versions 2012, 2014, 2016, 2017, 2019, and 2022.
Experience implementing snapshot, transactional, and merge replication.
Experience installing, configuring, and maintaining WSFC with Windows Server and SQL Server 2012 or later.
Experience auditing database configuration and security configurations.
Experience troubleshooting incidents and performance using SQL query and stored procedure tuning, Query Store, SQL Profiler, Database Engine Tuning Advisor, Windows Performance Monitor, DMVs, Resource Governor, Data Collection Reports, DBCC, custom scripts, built-in performance reports, and Activity Monitor.
Experience with database backup and restore.
Experience with various encryption types.
Knowledge of PowerShell and SQL scripting for automation.
Strong customer management and teamwork skills.
Logical and critical thinking skills, deep technical and troubleshooting skills, and enthusiasm for technology and learning.
Effective written and verbal communication with a wide variety of customers.

Nice To Haves

Windows Server administration skills.
SCCM knowledge.
Dynatrace knowledge.
Crystal Reports experience.

Responsibilities

Install, configure, and troubleshoot SQL Server.
Migrate databases from SQL Server 2012 or earlier versions to newer versions, and upgrade SQL Server environments.
Apply SQL Server service packs and patches.
Schedule and manage SQL Server jobs; create database maintenance plans; rebuild or reorganize indexes; and perform integrity checks.
Manage database backup, restore, and recovery.
Implement and support high availability and disaster recovery solutions, including Always On Availability Groups, replication, log shipping, mirroring, and clustering.
Implement snapshot, transactional, and merge replication models.
Install, configure, and maintain Windows Server Failover Clustering (WSFC) for supported Windows Server and SQL Server environments.
Audit database and security configurations.
Troubleshoot incidents and system performance, including tuning SQL queries and stored procedures.
Use performance and diagnostic tools, reports, and scripts to investigate database performance.
Use PowerShell and SQL scripting to automate tasks.
Support customers by phone and written correspondence regarding technical questions and issues.