Infrastructure Engineering SQL Server

9 hours ago

Québec, Quebec, Canada ALLTECH CONSULTING SVC INC Full-time

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.