<p><b>Role: Senior Database Administrator</b></p> <p><b>Duration: 12+ months </b></p> <p><b>Location: </b><b>Remote </b></p> <p><b> </b></p> <p><b>In-person Interview in Idaho</b></p> <p> </p> <p><b>Short Description:</b></p> <p>Seeking senior SQL Server DBA to lead upgrade from 2017 to 2022 and support current on-prem VM environments.
Must have strong experience in high availability, clustering, and disaster recovery in virtualized infrastructure.
</p> <p> </p> <p><b>Full Description:</b></p> <p>We are seeking a <b>senior-level SQL Server DBA</b> to support a critical upgrade project from <b>SQL Server2017 to 2022</b>.
This role is focused on managing and upgrading SQL Server environments hosted on <b>on-premises virtual machines (VMs)</b>.
The ideal candidate will have deep experience with <b>high availability configurations, clustering, and disaster recovery</b> in a virtualized infrastructure.</p> <div align="center" style="text-align:center"> </div> <p> </p> <p><b>Key Responsibilities</b></p> <ul> <li>Lead the upgrade of SQL Server 2017 to 2022 in a complex, on-prem VM-based environment</li> <li>Maintain and troubleshoot <b>Always On Availability Groups</b> and <b>Windows Server Failover Clustering (WSFC)</b></li> <li>Collaborate with infrastructure teams to manage VM configurations, storage, and networking</li> <li>Support both production and disaster recovery (DR) environments</li> <li>Perform performance tuning, capacity planning, and backup/restore operations</li> <li>Create and maintain detailed documentation and procedures</li> <li>Provide on-call support as needed</li> <li>Provide direction as needed for other DBA contractors on work required to be performed</li> <li>Provide knowledge transfer to internal teams</li> </ul> <div align="center" style="text-align:center"> </div> <p> </p> <p><b>Required Qualifications</b></p> <ul> <li>7+ years of SQL Server DBA experience in enterprise environments</li> <li>Proven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructure</li> <li>Expertise in clustering, high availability, and DR strategies using VMs</li> <li>Strong understanding of <b>Hyper-V or VMware</b> environments</li> <li>Proficiency in <b>T-SQL</b> and <b>PowerShell</b> scripting</li> <li>Experience managing SQL Server on <b>Windows Server</b> in an on-premises data center</li> <li>Excellent problem-solving and communication skills</li> <li>Experience with SQL Server components such as <b>SSRS, SSIS, and Analysis Services</b></li> </ul> <div align="center" style="text-align:center"> </div> <p> </p> <p><b>Preferred Qualifications</b></p> <ul> <li>Microsoft Certified: Azure Database Administrator Associate or equivalent</li> <li>Familiarity with VM backup and snapshot strategies</li> <li>Experience with monitoring tools like <b>Redgate , SolarWinds , or Sentry One </b></li> <li>Knowledge of hybrid DR strategies involving off-site or co-located data centers</li> <li>Knowledge of current Microsoft SQL Server licensing </li> <li>Experience in using and configuring 3rd party tools such as Redgate monitoring tools</li> <li><b>Understanding of Active Directory configuration requirements</b>, including: <ul style="list-style-type:circle"> <li>Cluster Name Object (CNO) requirements for pre staged SQL Computer Objects</li> <li>Delegation of rights to service accounts for dynamic object creation within specific OUs</li> </ul> </li> <li><b>Understanding of DNS configuration requirements</b> to support dynamic updates for SQL Server listeners and CNOs in high availability scenarios</li> </ul> <p> </p> <p><i>Note: While the contractor will not directly manage AD or DNS, they will work closely with the Server Support team to facilitate necessary changes and ensure proper configuration.</i></p>