An application made for this job — a tailored resume and cover letter that speak straight to the posting.
A-Line Staffing Solutions is seeking an SQL Automation Engineer in Dallas, TX to design, build, and maintain automation for patching SQL Server Always On clusters. The role emphasizes zero unplanned downtime, coordinated patch waves, and robust rollback verification.
On-site only, standard shift with maintenance windows. Bachelor's degree required; Red Hat Ansible Automation and ITIL Foundations preferred to support vulnerability remediation and compliance processes.
Job Description Design, build, and maintain automation for patching production SQL Server Always On Availability Group clusters without unplanned service loss. Automate availability group discovery based on the live estate state. Automate pre-patch procedures, including replica role changes and service stops. Orchestrate patch wave order, failover, and failback to ensure continuous availability. Automate suppression and restoration of monitoring alerts during patch cycles. Integrate patching automation with scheduled jobs and existing maintenance workflows. Provide verification and rollback steps at each automation stage for safety and reusability. Critical Information No remote work; on-site in Dallas, TX. Standard shift, with planned maintenance windows and adherence to change management practices. Partner with teams for window planning, vulnerability remediation, and compliance processes. Education/Licenses Needed Bachelor's degree in Computer Science, Engineering, or related field. Red Hat Certified Specialist in Ansible Automation, ITIL Foundations preferred.