Staff Engineer Infrastructure Engineer SQL/Cloud

About The Company

Our client is a leader in property and casualty insurance, employee benefits and mutual funds. One of the largest insurers in the United States with many decades of expertise, this company is widely recognized for its service excellence, sustainability practices, trust and integrity.

Position Overview

We are seeking a highly skilled and experienced Senior Windows/SQL Platform Engineer to join our team. The preferred candidate for this position will have an extensive history working with the full stack of products offered by Microsoft with a core focus on SQL Server database infrastructure deployment experience and a proven ability to develop with Powershell and WinRM to automate infrastructure deployments and configurations. A history of experience using configuration management tools such as Ansible in conjunction with Powershell to manage Windows servers is highly desirable for this position.

In this role, you will:

Require a deep understanding of Microsoft SQL Server internals and have experience working with the full suite of services offered (Ex. SSIS, SSRS, SSAS)

Work closely with a team of database product specialists and help enhance our product portfolio of SQL Server products on the AWS platform with a core focus on SQL Server products deployed on Windows virtual machines.

Collaborate with application teams to build scalable, secure, and high-performing database solutions aligned with enterprise standards.

Partner with the Cloud Engineering team to lead database migrations to AWS, ensuring seamless transitions and minimal disruption.

Leverage automation and IAC tools such as Ansible and Terraform to automate and streamline infrastructure provisioning and database operations.

Key Responsibilities

• Drive design, creation, and management of SQL Server databases running on Windows on VMWare and Windows on AWS EC2


• Participate in design, development, and implementation of database architecture and database solutions for Speed-to-Market Agile projects underway.


• Perform tuning with expertise using SQL Server DMVs and Execution Plans.


• Master the latest DB features and apply them to provide a measurable value on applications.


• Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions, and upgrades.


• Work to reduce complexity and cost in database environments through analysis, simplification, and automation using Ansible, Powershell, terraform or other tools.


• Conduct SQL Server database configuration reviews, audits, and troubleshooting for all platforms supported by SQL Server.


• Control and monitor user access to databases and maintain database security.


• Manage capacity planning and forecasting for various platforms.


• Facilitate databases migration from an on-prem system to the Cloud.


• Maintain documentation of systems and standard operating policies and procedures


• Collaborate and participate in application release planning and implementation.


• Work with clientonshore and offshore database partners to ensure availability, performance, quality, and Service Level Agreement specifications.


• Educate and influence stakeholders to promote an understanding of the environments, increase simplification, risk management, and promote reuse and innovation.

Required Skills & Experience

• Requires at least 6-9 years of experience with implementations, upgrades, migration and consolidation projects with SQL Server databases.


• Solid knowledge and experience of SQL Server and technical database concepts, including database and query tuning, database cloning, migrations, and backup/recovery techniques.


• Knowledge and experience in AWS


• Proficiency in Windows server management


• Strong organizational and communication skills with the ability to handle multiple priorities.


• The ability to learn fast on the job by partnering with senior resources


• A passion for engineering excellence and continuous improvement.


• Strong communication and collaboration skills to work across cross-functional teams.


• A proactive mindset with the ability to troubleshoot complex issues and drive resolution.


• Bachelor s degree in computer science or a related discipline

Preferred Qualifications

• 3+ years working in an Enterprise environment that uses Microsoft Active Directory services to manage users and groups, and have a strong understanding of security best practices using Windows Auth and Kerberos.


• 3+ years of experience working on cloud platforms such as AWS or Azure, with preference on AWS.


• 3+ years of highly technical experience of Microsoft SQL Server, Availability Groups and Failover Clusters.


• 3+ years of development/automation experience using Powershell and Powershell remoting via WinRM.


• 2+ years of experience using Ansible to configure Windows systems using WinRM (Chef, Puppet experience will also be considered)


• 2+ years of experience with Terraform.


• 2+ years of experience using 3rd Party database backup tools such as Rubrik, Idera, Redgate, etc. and a firm understanding of native SQL Server backup and recovery strategies.


• AWS certifications are highly recommended for this position.


• Familiarity with programming languages such as TSQL, .Net, Powershell, Python, GO.


• Strong understanding of backup and recovery, security configuration, license management, reporting, integration, monitoring, audit, and performance troubleshooting skills.


• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.


• Experience working in an Agile development environment is a plus.


• Experience with other database platforms such as Oracle, PostgreSQL, etc is a plus.