Senior SQL DBA (Remote)
Senior SQL DBA (Remote)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Title:
Senior SQL DBA (Remote)
Location:
Boise ID
Duration:
12 months
Pay Rate:
$75/hr on C2C / 1099 all inclusive (OR) $70/hr on W2
Note
Interview: Either Webcam or In Person
Job 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.
Client is 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
Top Skills & Years of Experience
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 centre
- 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 canters
- 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.
Required/Desired Skills
Skill
Required /Desired
Amount
of Experience
MS SQL Server DBA experience
Required
7
Years
Proven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructure
Required
3
Years
Experiencing upgrading SQL server 2017 to 2022
Required
2
Years
Experience maintaining and setup of High Availability and Clustering
Required
5
Years
Hyper-V or VMware virtualization knowledge
Required
2
Years
Proficient writing T-SQL and PowerShell scripts
Required
7
Years
Windows Server 2022 experience
Required
2
Years
Experience with setup and maintenance of SQL server components such as SSRS SSIS and Analysis Services
Required
7
Years
Strong problem-solving and communication skills
Required
7
Years
Microsoft DBA Certification
Required
5
Years
VM backup/snapshot strategy experience
Highly desired
4
Years
Experience with Hybrid disaster recovery strategies
Highly desired
4
Years
Active directory Knowledge - Cluster Name Objects (CNO) in HA setups
Highly desired
5
Years
Familiarity and experience with Microsoft SQL Server licensing options/strategies
Highly desired
2
Years
Familiarity with VM backup and snapshot strategies
Highly desired
2
Years
Monitoring Tools such as Redgate Solar Winds or Sentry One
Desired
3
Years
DNS configuration for SQL listeners and CNOs in HA setup
Nice to have
3
Years
Delegation of rights to service accounts for dynamic object creation within specific OUs
Nice to have
2
Years
Recruiter Details:
Sravani
Sarvani at
Two Eight One Seven Six Nine - One Two Six Four
About US:
GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality timeliness and budgetary considerations we consistently strive to exceed client expectations building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development covering information security software development consulting and IT audits. We excel in managing critical time-sensitive projects for Fortune 500 clients nationwide ensuring their success is always at the forefront of our mission.
Employment Type
Full Time
