SQL Automation Engineer

Yoh Services LLC; United States; Remote; USD 77,000 - 110,000; Full time

Benefits offered by this job

Medical, Prescription, Dental & Vision

Health Savings Account (HSA)

401K Retirement Savings Plan

Direct Deposit & weekly epayroll

Job summary

Yoh Services LLC seeks a skilled SQL Automation Engineer to design and sustain automated patching for SQL Server Always On clusters. The role focuses on safe patch sequencing, health validation, and minimizing downtime in a 100% remote contract environment.

The candidate will implement Ansible playbooks, PowerShell scripts, and ServiceNow integrations, while leveraging Azure DevOps for source control and CI/CD. Strong collaboration with DBA, Security, and Infrastructure teams is required.

Qualifications

• Bachelor’s degree or equivalent experience required.
• 6+ years enterprise Windows Server infrastructure engineering.
• 4+ years SQL Server Always On Availability Groups in production HA environments.
• 3+ years infrastructure automation using Ansible and/or PowerShell.
• Experience with change-management and documentation standards.

Responsibilities

• Design, build, and maintain automation to patch production SQL Server Always On Availability Group clusters with no unplanned interruption.
• Automate discovery of availability group topology and health metrics.
• Automate pre-patch steps and safe patch sequencing across replicas.
• Integrate patch execution with change workflows in ServiceNow and with JAMS schedules.
• Build reusable Ansible playbooks and roles; replace legacy runbooks with automation.
• Maintain automation in Azure DevOps and participate in code reviews and documentation.
• Produce post-patch evidence and enable remediation of vulnerabilities.

Skills

SQL Server Always On

Windows Server

Infrastructure automation

Ansible

PowerShell

T-SQL

Azure DevOps

Git workflows

Vulnerability remediation

Troubleshooting

Communication

Education

Bachelor’s degree in CS/Engineering

Azure Database Administrator Associate

Red Hat Certified Specialist in Ansible Automation

ServiceNow certifications

ITIL Foundation

Windows Server certifications

Tools

JAMS

Control‑M

SentryOne

dbatools

Ansible Automation Platform

Azure DevOps

ServiceNow

Job description

SQL Automation Engineer (SQL Server Always On / Patch Automation)

12+ month contract (W2 ONLY, NO C-C)

100% Remote

What You’ll Do

• Design, build, and maintain automation to patch production SQL Server Always On Availability Group clusters with no unplanned interruption.
• Automate discovery of availability group topology (replicas, roles, synchronization health, routing, current state).
• Automate pre-patch steps, including:
  • Removing secondary replicas from read-only routing
  • Placing nodes into monitoring maintenance mode
  • Stopping services on DR availability group instances in a controlled manner
• Orchestrate safe patch sequencing across secondary, DR, and primary replicas, including failover/failback activities.
• Keep availability groups online throughout the patch cycle and validate health at each stage.
• Automate suppression and restoration of monitoring alerts (SQL Sentry / SentryOne; equivalents considered).
• Integrate patch execution with JAMS scheduled jobs and maintenance-mode workflows.
• Build reusable, parameterized Ansible Automation Platform playbooks/roles/job templates.
• Replace manual scripts and legacy SCORCH runbooks with standardized automation.
• Integrate automation with ServiceNow for change workflows:
  • Change creation
  • Approval gating
  • Execution status updates
  • Automated closure
• Implement verification steps, halt conditions, rollback logic, and restartability at each stage.
• Produce post-patch evidence (replica health, sync status, patch level, audit/vulnerability evidence).
• Support emergency and out-of-cycle database patching for high‑severity vulnerabilities and CISA KEV items.
• Partner with DBA, Security, Infrastructure Ops, and App teams on maintenance windows and cutover planning.
• Support remediation of database‑tier vulnerabilities identified through Tenable (or similar).
• Maintain automation in source control (Azure DevOps) and participate in code reviews and documentation (runbooks/SOPs).

Required Skills & Experience

• Strong hands‑on SQL Server Always On Availability Groups expertise, including:
  • Replica roles and synchronization modes
  • Read‑only routing, listeners
  • Failover/failback
  • Quorum behavior
• 6+ years enterprise Windows Server infrastructure engineering.
• 4+ years SQL Server Always On Availability Groups in production HA environments.
• 3+ years infrastructure automation using Ansible and/or PowerShell.
• Demonstrated success automating patching/maintenance for clustered or HA database environments.
• Experience operating in formal change‑management and documentation standards.
• Regulated environment experience (HIPAA, PCI, SOX) preferred.
• Strong Windows Server Failover Clustering (WSFC) administration/troubleshooting.
• Experience patching and maintaining highly available SQL Server infrastructure in production.
• Advanced PowerShell scripting.
• Experience with SQL Server PowerShell module, dbatools, or similar tooling.
• Strong T‑SQL skills for querying AG state and DMVs.
• Strong Ansible experience; Ansible Automation Platform (AAP) preferred.
• Experience building Ansible playbooks, roles, inventories, credentials, and job templates.
• Enterprise Windows patch management experience (MECM/SCCM, rings, maintenance windows).
• ServiceNow API integration experience (change records, approvals, automation status).
• Experience with enterprise scheduling tools (JAMS, Control‑M, or similar).
• Monitoring platform integration experience (SQL Sentry/SentryOne, SCOM, or equivalent).
• Git‑based workflows; Azure DevOps Repos and Pipelines experience.
• Ability to build idempotent, restartable automation with validation and rollback controls.
• Solid understanding of vulnerability remediation and severity‑based SLAs.
• Strong troubleshooting, risk management, and communication skills.

• Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience).

• Microsoft certifications (e.g., Azure Database Administrator Associate; Windows Server‑related)
• Red Hat Certified Specialist in Ansible Automation
• ServiceNow certifications
• ITIL Foundation

Estimated Min Rate: $56.00

Estimated Max Rate: $80.00

What’s In It for You?

We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice: https://www.yoh.com/privacy-notice Stay Safe During Your Job Search.

Fraudulent recruiting communications have become increasingly common. Emails from Yoh recruiters will only come from an @yoh.com email address. Yoh will never ask candidates to pay fees, purchase equipment, send gift cards, or transfer funds as part of the recruiting or hiring process. If you receive a communication that appears suspicious or requests payment, contact Yoh directly before responding or sharing personal information.