IND Senior Engineer, Infrastructure

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.