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