SQL Database Administrator

SQL Database Administrator

Posted 1 day ago by 1759830539

Apply
Negotiable
Outside
Remote
USA
Apply
Active Directory Business Continuity And Disaster Recovery Computer Network Operations Database Administration Disaster Recovery Domain Name System (DNS) Servers Failover Failover Clustering File Servers Hyper-V Microsoft 365 Microsoft SQL Servers Microsoft Windows Oracle Database Administration (DBA) Performance Tuning Service Accounts SQL (Programming Language) Virtual Machines VM (Operating System) VMware Certified Associate Windows PowerShell Windows Servers Windows Server Virtualisation

Summary: The role of Database Administrator involves leading the upgrade of SQL Server from 2017 to 2022 within a complex on-premises virtual machine environment. The position requires extensive experience in high availability configurations, clustering, and disaster recovery strategies. The ideal candidate will also provide support for production and disaster recovery environments while collaborating with infrastructure teams. This is a senior-level position focused on managing SQL Server environments effectively.

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

Key Skills:

  • 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

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:
Title: Database Administrator (777672)
Duration: 12 Months
Client: Idaho Department of Health and Welfare
Location: 450 W State Street, Boise, ID 83702
Note: Remote role
Job Description:
  • 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
Preferred Qualifications
  • 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
Certification:
  • Microsoft Certified:Azure Database Administrator Associate or equivalent
Apply
Similar Jobs
Loading data...