Job Specifications
Database Administrator
Req number:R6349
Employment type:Full time
Worksite flexibility:Hybrid Who we are
CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Job SummaryWe are looking for a motivated SQL Database Administrator ready to take us to the next level! If you have deep experience with high availability configurations, clustering, and disaster recovery in a virtualized infrastructure and are looking for your next career move, apply now.
Job Description
We are looking for a SQL Database Administrator to support a critical upgrade project from SQL Server 2017 to 2022. This position will be full-timeand hybrid in Boise, ID.
What You'll Do
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
What You'll Need
Required:
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:
Microsoft Certified: Azure Database Administrator Associate or equivalent
Familiarity with VM backup and snapshot strategies
Experience with monitoring tools like Redgate(r), SolarWinds(r), or Sentry One(r)
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(r) 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.
Physical Demands
Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
The pay range for this position is $60 - $70 per hour (USD). Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages for this role includes medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave as provided by applicable law. ?
Reasonable accommodation statement
If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to (see below) or (888) 824 - 8111.
The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role receive paid time off and may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.
About the Company
CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what's right--whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Know more