Role : Senior Database Administrator
Duration : 12+ months
Location : Remote
In-person Interview in Idaho
Short Description :
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.
Full Description :
We are seeking a senior-level SQL Server DBA to support a critical upgrade project from SQL Server2017 to 2022 . This role is focused on managing and upgrading SQL Server environments hosted on on-premises virtual machines (VMs) . The ideal candidate will have deep experience with high availability configurations, clustering, and disaster recovery in a virtualized infrastructure.
Key Responsibilities
- Lead the upgrade of SQL Server 2017 to 2022 in a complex, on-prem VM-based environment
- Maintain and troubleshoot Always On Availability Groups and Windows Server Failover Clustering (WSFC)
- Collaborate with infrastructure teams to manage VM configurations, storage, and networking
- Support both production and disaster recovery (DR) environments
- Perform performance tuning, capacity planning, and backup / restore operations
- Create and maintain detailed documentation and procedures
- Provide on-call support as needed
- Provide direction as needed for other DBA contractors on work required to be performed
- Provide knowledge transfer to internal teams
Required Qualifications
7+ years of SQL Server DBA experience in enterprise environmentsProven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructureExpertise in clustering, high availability, and DR strategies using VMsStrong understanding of Hyper-V or VMware environmentsProficiency in T-SQL and PowerShell scriptingExperience managing SQL Server on Windows Server in an on-premises data centerExcellent problem-solving and communication skillsExperience with SQL Server components such as SSRS, SSIS, and Analysis ServicesPreferred Qualifications
Microsoft Certified : Azure Database Administrator Associate or equivalentFamiliarity with VM backup and snapshot strategiesExperience with monitoring tools like Redgate , SolarWinds , or Sentry OneKnowledge of hybrid DR strategies involving off-site or co-located data centersKnowledge of current Microsoft SQL Server licensingExperience in using and configuring 3rd party tools such as Redgate monitoring toolsUnderstanding of Active Directory configuration requirements , including :Cluster Name Object (CNO) requirements for pre staged SQL Computer Objects
Delegation of rights to service accounts for dynamic object creation within specific OUsUnderstanding of DNS configuration requirements to support dynamic updates for SQL Server listeners and CNOs in high availability scenariosNote : 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.