What are the responsibilities and job description for the ID - DHW - Database Administrator position at Brains Technology Solutions, Inc.?
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.
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
Required Qualifications
Preferred Qualifications
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
SkillRequired /DesiredAmountof ExperienceMS SQL Server DBA experienceRequired7YearsProven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructureRequired3YearsExperiencing upgrading SQL server 2017 to 2022Required2YearsExperience maintaining and setup of High Availability and ClusteringRequired5YearsHyper-V or VMware virtualization knowledgeRequired2YearsProficient writing T-SQL and PowerShell scriptsRequired7YearsWindows Server 2022 experienceRequired2YearsExperience with setup and maintiance of SQL server components such as SSRS, SSIS and Analysis ServicesRequired7YearsStrong problem-solving and communication skillsRequired7YearsMicrosoft DBA CertificationRequired5YearsVM backup/snapshot strategy experienceHighly desired4YearsExperience with Hybrid disaster recovery strategiesHighly desired4YearsActive directory Knowledge - Cluster Name Objects(CNO) in HA setupsHighly desired5YearsFamiliarity and experience with Microsoft SQL Server licensing options/strategiesHighly desired2YearsFamiliarity with VM backup and snapshot strategiesHighly desired2YearsMonitoring Tools such as Redgate, Solar Winds or Sentry OneDesired3YearsDNS configuration for SQL listeners and CNO's in HA setupNice to have3YearsDelegation of rights to service accounts for dynamic object creation within specific OUsNice to have2Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement?Question2What is your candidate's email address?Question3Have you completed and submitted the Right to Represent form, making sure to do so exactly as instructed? The form is located at https://www.cai.io/media/documents/msp/id/idaho_e-rtr_template.doc.Question4Candidates submitted above the hourly Vendor Rate of $99.88 will not be considered. Do you agree to this requirement?Question5The candidate MUST have experience in leading/performing a SQL Server 2016/2017 to 2022 migration in a HA Always up Clustered environment with DR using replication.Question6Respond to this question with a link to your candidate's LinkedIn ProfileQuestion7Please SPECIFY the CITY and STATE in which your candidate is CURRENTLY located (if not specified or if location specified is determined to be untrue at any point during the screening/interview/onboarding process - INCLUDING DURING BACKGROUND CHECK WHICH WILL CONFIRM TRUE ADDRESS - your candidate will not be considered/will be removed from consideration for the position).Question8If selected to interview, All candidates submitted MUST be able to attend either: (1) an IN-PERSON interview at the client location OR (2) a webcam/virtual interview with their camera on . Please confirm you have discussed this with your candidate and they are able to make an in-person interview OR attend the interview virtually with their camera on if selected. Question9Please prepare your candidate that they may receive a screening call from someone at CAI at any point between the time of submittal through close of business, Thursday, 10/9/25, to discuss their qualifications for this position. Please MAKE SURE THEY ARE PREPARED FOR THIS CALL and are PREPARED TO GIVE US YOUR COMPANY's NAME as the vendor that submitted them for this position. Please confirm you have discussed this with them and they will be prepared for a potential screening call from CAI.
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.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceMS SQL Server DBA experienceRequired7YearsProven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructureRequired3YearsExperiencing upgrading SQL server 2017 to 2022Required2YearsExperience maintaining and setup of High Availability and ClusteringRequired5YearsHyper-V or VMware virtualization knowledgeRequired2YearsProficient writing T-SQL and PowerShell scriptsRequired7YearsWindows Server 2022 experienceRequired2YearsExperience with setup and maintiance of SQL server components such as SSRS, SSIS and Analysis ServicesRequired7YearsStrong problem-solving and communication skillsRequired7YearsMicrosoft DBA CertificationRequired5YearsVM backup/snapshot strategy experienceHighly desired4YearsExperience with Hybrid disaster recovery strategiesHighly desired4YearsActive directory Knowledge - Cluster Name Objects(CNO) in HA setupsHighly desired5YearsFamiliarity and experience with Microsoft SQL Server licensing options/strategiesHighly desired2YearsFamiliarity with VM backup and snapshot strategiesHighly desired2YearsMonitoring Tools such as Redgate, Solar Winds or Sentry OneDesired3YearsDNS configuration for SQL listeners and CNO's in HA setupNice to have3YearsDelegation of rights to service accounts for dynamic object creation within specific OUsNice to have2Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement?Question2What is your candidate's email address?Question3Have you completed and submitted the Right to Represent form, making sure to do so exactly as instructed? The form is located at https://www.cai.io/media/documents/msp/id/idaho_e-rtr_template.doc.Question4Candidates submitted above the hourly Vendor Rate of $99.88 will not be considered. Do you agree to this requirement?Question5The candidate MUST have experience in leading/performing a SQL Server 2016/2017 to 2022 migration in a HA Always up Clustered environment with DR using replication.Question6Respond to this question with a link to your candidate's LinkedIn ProfileQuestion7Please SPECIFY the CITY and STATE in which your candidate is CURRENTLY located (if not specified or if location specified is determined to be untrue at any point during the screening/interview/onboarding process - INCLUDING DURING BACKGROUND CHECK WHICH WILL CONFIRM TRUE ADDRESS - your candidate will not be considered/will be removed from consideration for the position).Question8If selected to interview, All candidates submitted MUST be able to attend either: (1) an IN-PERSON interview at the client location OR (2) a webcam/virtual interview with their camera on . Please confirm you have discussed this with your candidate and they are able to make an in-person interview OR attend the interview virtually with their camera on if selected. Question9Please prepare your candidate that they may receive a screening call from someone at CAI at any point between the time of submittal through close of business, Thursday, 10/9/25, to discuss their qualifications for this position. Please MAKE SURE THEY ARE PREPARED FOR THIS CALL and are PREPARED TO GIVE US YOUR COMPANY's NAME as the vendor that submitted them for this position. Please confirm you have discussed this with them and they will be prepared for a potential screening call from CAI.
Salary : $100