Infrastructure Engineering SQL Server
Job Description
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:
• Implement hardened and controls-compliant Azure SQL Database deployments using firm-approved standards and infrastructure-as-code best practices
• Design, develop, test, debug and document improvements to Azure SQL Database infrastructure configuration management IaC code base using Terraform
• Assist in researching, assessing, setting up PoCs and analyzing new Microsoft feature enhancements to the Azure SQL PaaS offering
• Stay up-to-date on the latest Terraform provider releases from Hashi Corp and update the IaC provider libraries to keep them current
• Adhere to agile best practices to produce high-quality, secure and maintainable code in an agile environment
• Support the engineering and DBA teams in troubleshooting, analyzing and resolving issues related to Azure SQL Database and affiliated services
• Develop a good understanding of the downstream services and applications that are an integral part of the Azure SQL ecosystem
• Write clear and comprehensive how-to documents, guides and procedures on new and existing processes related to the Azure SQL Database offering
• Design, develop, test, debug and document improvements to Azure SQL Database infrastructure configuration management IaC code base using Terraform
• Assist in researching, assessing, setting up PoCs and analyzing new Microsoft feature enhancements to the Azure SQL PaaS offering
• Stay up-to-date on the latest Terraform provider releases from Hashi Corp and update the IaC provider libraries to keep them current
• Adhere to agile best practices to produce high-quality, secure and maintainable code in an agile environment
• Support the engineering and DBA teams in troubleshooting, analyzing and resolving issues related to Azure SQL Database and affiliated services
• Develop a good understanding of the downstream services and applications that are an integral part of the Azure SQL ecosystem
• Write clear and comprehensive how-to documents, guides and procedures on new and existing processes related to the Azure SQL Database offering
Required skills:
• Strong experience in SQL Server data engineering, including Azure SQL Database, and use of TSQL
• Strong experience in enterprise and cloud infrastructure engineering automation using Powershell and Terraform (Experience in Python is a plus)
• Experience with SDLC, agile practices and related tools, particularly JIRA, GitHub and GitHub Actions
• Excellent problem-solving, analytical and critical thinking skills (Experience creating technical architecture documentation is a plus)
• Strong communication, written and interpersonal skills
