SQL Database Administrator

SQL Database Administrator

Location: Boise, ID (Hybrid 3 days onsite)

Contract Duration: 12+ Months

*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.

Physical Demands:

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor