SQL Server DBA Job at Resource Consultings Services Inc, Boise, ID

ZzN1WFVNMGxZWStkUXpFZTU3ZzZHMmFOeGc9PQ==
  • Resource Consultings Services Inc
  • Boise, ID

Job Description

Role: Senior Database Administrator

Duration: 12+ months

Location: Remote

In-person Interview in Idaho

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.

Full 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

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

Job Tags

For contractors, Remote work,

Similar Jobs

Maxion Corp

Virtual Data Entry Clerk Job at Maxion Corp

 ...Love This Job: Flexibility at Its Best: Work part-time or full-time, from anywhere, and on a schedule that fits your...  ...job for Stay at home moms, retired folks, disabled people and anyone looking to learn how to make income online.... 

ExecutivePlacements.com

Junior Data Analyst (Remote) Job at ExecutivePlacements.com

 ...partnering experts with top AI labs to provide the high quality data for LLMs. We believe AI can only perform as well as the data its...  ...Problem-Solving Skills : Ability to develop complex, professional-level prompts and evaluate nuanced AI reasoning. Strong Writing :... 

Beech Valley Solutions

SALT Property Tax Consultant Remote Job at Beech Valley Solutions

 ...Specialty Tax team is seeking a SALT Sr. Manager experienced with property tax compliance to backfill a role until they hire due to an upcoming retirement. Scope of work is a reviewer of personal business property tax filings by team of 2 senior associates. Also provide... 

GreatAuPair LLC

Au Pair Job at GreatAuPair LLC

We are looking for an au pair to join our family. We have a 10 year old daughter and a rabbit. We live in the heart of Orlando near all the theme parks. Would love someone who can care for our daughter like their own. Duties: Assist in sending daughter to school. Pick daughter...

Blockchain & Climate Institute/ BCI America Inc.

UNPAID VOLUNTEER - Principal / Senior / Legal Advisors / Assistants (US-based) Job at Blockchain & Climate Institute/ BCI America Inc.

 ...THIS IS AN UNPAID VOLUNTEERING ROLE. Role Title: Principal Legal Advisor / Senior Legal Advisor / Legal Advisor / Legal Assistant...  ...Proven ability to effectively multitask and prioritize work; Foreign language skills (e.g. Spanish) would be preferred Some knowledge...