Database Administrator

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 1 Year(s)

Skills

Active Directory
Backup
Capacity Management
Clustering
Collaboration
Communication
Conflict Resolution
DNS
Database Administration
Disaster Recovery
Documentation
Dragon NaturallySpeaking
Failover
High Availability
Hyper-V
Knowledge Transfer
Licensing
Management
Microsoft
Microsoft Operating Systems
Microsoft SQL Server
Microsoft SQL Server DBA
Microsoft SSIS
Microsoft SSRS
Microsoft Windows Server
Performance Tuning
Problem Solving
Recovery
Red Gate
SQL
SQL Azure
Storage
Transact-SQL
VMware
Virtual Machines
Windows PowerShell

Job Details

Job 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.
  • 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 environments
  • Proven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructure
  • Expertise in clustering, high availability, and DR strategies using VMs
  • Strong understanding of Hyper-V or VMware environments
  • Proficiency in T-SQL and PowerShell scripting
  • Experience managing SQL Server on Windows Server in an on-premises data center
  • Excellent problem-solving and communication skills
  • Experience with SQL Server components such as SSRS, SSIS, and Analysis Services
  • Experiencing upgrading SQL server 2017 to 2022
  • Experience maintaining and setup of High Availability and Clustering
  • Experiencing upgrading SQL server 2017 to 2022
  • Microsoft DBA Certification
  • VM backup/snapshot strategy experience Highly desired
  • Experience with Hybrid disaster recovery strategies Highly desired
  • Active directory Knowledge - Cluster Name Objects(CNO) in HA setups Highly desired

Preferred Qualifications

  • Microsoft Certified: Azure Database Administrator Associate or equivalent
  • Familiarity with VM backup and snapshot strategies
  • Experience with monitoring tools like Redgate , SolarWinds , or Sentry One
  • Knowledge of hybrid DR strategies involving off-site or co-located data centers
  • Familiarity and experience with Microsoft SQL Server licensing options/strategies
  • Experience in using and configuring 3rd party tools such as Redgate monitoring tools
  • Understanding 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 OUs
  • Understanding of DNS configuration requirements to support dynamic updates for SQL Server listeners and CNOs in high availability scenarios

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.