Windows Infrastructure Automation Engineer - SQL Server
CMK Resources is looking for an experienced Windows & SQL Server Upgrade Automation Engineer to support one of our strategic technology partners. This engineer will design, build, and support automated upgrade workflows for Windows Server and Microsoft SQL Server environments across standalone virtual machines, clustered SQL platforms, Failover Cluster Instances, and Always On Availability Groups. The ideal candidate combines strong Windows and SQL Server infrastructure knowledge with hands-on PowerShell automation and CI/CD experience. This is not simply an upgrade execution role. We are looking for someone capable of automating the complete upgrade lifecycle, including prechecks, backup and snapshot validation, upgrades, cluster failover, post-upgrade validation, reporting, rollback, and recovery.
Key Responsibilities:
- Automate Windows Server in-place upgrade processes across virtualized environments
- Automate Microsoft SQL Server in-place upgrades
- Support standalone SQL Server environments
- Support SQL Server Failover Cluster Instances
- Support SQL Server Always On Availability Groups
- Execute and automate rolling cluster upgrades with minimal service disruption
- Develop PowerShell automation for upgrade, validation, failover, rollback, and recovery activities
- Integrate upgrade automation with GitLab CI/CD pipelines
- Configure and troubleshoot GitLab Runners used to execute infrastructure automation
- Integrate automation workflows with MCM or similar orchestration platforms
- Develop automated pre-upgrade health and readiness checks
- Validate Windows Server and SQL Server upgrade compatibility
- Coordinate and validate virtual machine snapshots and backup processesValidate SQL database and system database backups before upgrades
- Automate DBCC CHECKDB and SQL Server health checks
- Automate SQL cluster failover and failback processesValidate Windows clustering, SQL services, databases, SQL Agent jobs, listeners, Availability Groups, and application connectivity following upgrades
- Build automated post-upgrade validation and centralized reporting
- Develop repeatable rollback and recovery procedures
- Troubleshoot failed Windows upgrades, SQL upgrades, clustering events, PowerShell automation, GitLab pipelines, and orchestration workflows
- Maintain automation code, configuration, and version control within GitFollow established production change-management and deployment procedures
- Create documentation and operational runbooks for automated upgrade processes
- Required Technical SkillsStrong Windows Server administration experience, including Windows Server 2016, 2019, 2022, and/or 2025 Strong Microsoft SQL Server administration experience across SQL Server 2016, 2017, 2019, 2022, or newer
- Advanced PowerShell scripting and automation experience
- Hands-on Windows Server and SQL Server upgrade experience
- Git and source-control experienceGitLab CI/CD pipeline experienceGitLab Runner configuration and troubleshooting experience
- Windows Server Failover ClusteringSQL Server Failover Cluster InstancesSQL Server Always On Availability GroupsSQL Server backup, restore, and recovery processesVMware or comparable enterprise virtual machine environments
- Experience validating VM snapshots and backups during infrastructure changesREST API integrationJSON and YAMLProduction change-management experience
- Strong troubleshooting experience across Windows, SQL Server, clustering, and automation environments
- Preferred Experience
- Experience building large-scale automated Windows Server and SQL Server upgrade solutions
- Experience automating complete upgrade lifecycles rather than individual upgrade tasks
- Experience with centralized orchestration platforms such as MCMExperience integrating infrastructure automation with REST APIsExperience performing rolling SQL cluster upgrades with limited downtime
- Experience building automated prechecks, postchecks, rollback logic, and reporting
- Experience supporting large enterprise environments with repeatable upgrade programs across many servers