Talent.com
ID - DHW - Database Administrator
ID - DHW - Database AdministratorMahantech Corporation • Boise, ID, US
serp_jobs.error_messages.no_longer_accepting
ID - DHW - Database Administrator

ID - DHW - Database Administrator

Mahantech Corporation • Boise, ID, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Overview

Engagement Type : Contract

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.

Complete Description

We are seeking a senior-level SQL Server DBA to support a critical upgrade project from SQL Server 2017 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

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

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

    Skills

  • MS SQL Server DBA experience — Required
  • Proven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructure — Required
  • Experience upgrading SQL Server 2017 to 2022 — Required
  • Experience maintaining and setup of High Availability and Clustering — Required
  • Hyper-V or VMware virtualization knowledge — Required
  • Proficient writing T-SQL and PowerShell scripts — Required
  • Windows Server 2022 experience — Required
  • Experience with setup and maintenance of SQL Server components such as SSRS, SSIS and Analysis Services — Required
  • Strong problem-solving and communication skills — Required
  • Microsoft DBA Certification — Required
  • VM backup / snapshot strategy experience — Highly desired
  • Experience with Hybrid disaster recovery strategies — Highly desired
  • Active Directory knowledge – CNO in HA setups — Highly desired
  • Familiarity with SQL Server licensing options / strategies — Highly desired
  • Familiarity with VM backup and snapshot strategies — Highly desired
  • Monitoring tools such as Redgate, SolarWinds or Sentry One — Desired
  • DNS configuration for SQL listeners and CNOs in HA setup — Nice to have
  • Delegation of rights to service accounts for dynamic object creation within specific OUs — Nice to have

    • J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Database Administrator • Boise, ID, US