SQL Database Administrator

Job Description

We are looking for aSQL Database Administratorto support a critical upgrade project from SQL Server 2017 to 2022. This position will behybrid in Boise ID.

What Youll 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 Youll 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

Required Skills:

SQL ServerDatabase AdministrationPowerShellT-SQL