SQL Database Administrator - Hybrid - W2 only

  • Boise, ID
  • Posted 10 hours ago | Updated 10 hours ago

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

Database Administration
Microsoft SQL Server DBA
Microsoft SSIS
Microsoft SSRS
Microsoft SSAS
Microsoft SQL Server
Hyper-V
VMware
SQL Azure
Transact-SQL
Red Gate
Active Directory
DNS
Microsoft Windows Server

Job Details

Job Title: SQL Database Administrator

Location: Hybrid in Boise, ID (3 days onsite)

Client address: 450 W. State Street Boise, Idaho 83702

*7+ years of SQL Server DBA experience in enterprise environments

*MUST have previous experience migrating from SQL Server 2016 to SQL Server 2022 in a HA clustered always up environment.

*Expertise in clustering, high availability, and DR strategies using VMs

*Strong understanding of Hyper-V or VMware environments

Job Description

We are looking for a SQL Database Administrator to support a critical upgrade project from SQL Server 2017 to 2022. This position will be full-time and hybrid in Boise, ID.

What You'll Do

  • 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

What You'll Need Required:

  • 7+ years of SQL Server DBA experience in enterprise environments
  • MUST have previous experience migrating from SQL Server 2016 to SQL Server 2022 in a HA clustered always up environment
  • 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

Preferred:

  • 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
  • Knowledge of current Microsoft SQL Server licensing
  • 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

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.

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.