Infrastructure Engineering SQL Server

As a member of the SQL Server Engineering Team under the Data and Analytics Technology Organization, the candidate is expected to assist in building and enhancing a secure on-premise and Azure cloud SQL Server infrastructure, while seamlessly integrating them with existing firm systems and controls.

The candidate must have a strong engineering background working with the Azure cloud stack and Microsoft SQL Server, especially with Azure SQL Database, and will have the following core responsibilities:

1. Implement hardened and controls-compliant Azure SQL Database deployments using firm-approved standards and infrastructure-as-code best practices.
2. Design, develop, test, debug and document improvements to Azure SQL Database infrastructure configuration management IaC code base using Terraform.
3. Assist in researching, assessing, setting up PoCs and analyzing new Microsoft feature enhancements to the Azure SQL PaaS offering.
4. Stay up-to-date on the latest Terraform provider releases from Hashi Corp and update the IaC provider libraries to keep them current.
5. Adhere to agile best practices to produce high-quality, secure and maintainable code in an agile environment.
6. Support the engineering and DBA teams in troubleshooting, analyzing and resolving issues related to Azure SQL Database and affiliated services.
7. Develop a good understanding of the downstream services and applications that are an integral part of the Azure SQL ecosystem.
8. Write clear and comprehensive how-to documents, guides and procedures on new and existing processes related to the Azure SQL Database offering.

Required skills:

1. Strong experience in SQL Server data engineering, including Azure SQL Database, and use of TSQL.
2. Strong experience in enterprise and cloud infrastructure engineering automation using Powershell and Terraform (Experience in Python is a plus).
3. Experience with SDLC, agile practices and related tools, particularly JIRA, GitHub and GitHub Actions.
4. Excellent problem-solving, analytical and critical thinking skills (Experience creating technical architecture documentation is a plus).
5. Strong communication, written and interpersonal skills.