Talent.com
Infrastructure Engineering SQL Server

Infrastructure Engineering SQL Server

Alltech Consulting ServicesMontreal Quebec, Canada
19 days ago
Job description

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

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