Job Title

Position OverviewWe 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 disciplinePreferred 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.