Job Title : Infrastructure Engineering SQL Server
Location : Montreal (Hybrid Role : 3 days onsite, 2 days remote)
Contract Duration : 1 Year
Our Team :
As a member of the SQL Server Engineering Team under the Data and Analytics Technology Organization, you will 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.
Your Role :
- 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.
Your Skills - Required :
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 .