IND Senior Engineer, Infrastructure

• IND Senior Engineer, Infrastructure
• GCC034

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.

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 HIG onshore 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.

What We Offer

• Collaborative and innovative work environment.

• Competitive compensation and comprehensive benefits.

• Continuous learning and professional development opportunities.

About Us | Our Culture | What It’s Like to Work Here