Infrastructure Engineer - SQL server

Compunnel Software Group; Montreal; On-site; CAD 75,000 - 95,000; Full time

Job summary

A leading company is seeking an Infrastructure Engineer to enhance SQL Server infrastructures on-premise and in Azure cloud. The ideal candidate will implement secure Azure SQL Database deployments, automate infrastructure using Terraform, and collaborate with cross-functional teams to ensure system integrity and performance.

Qualifications

• Strong experience in SQL Server data engineering and Azure SQL Database.
• Experience with enterprise and cloud infrastructure automation using PowerShell and Terraform.

Responsibilities

• Implement Azure SQL Database deployments using infrastructure-as-code best practices.
• Design and document improvements to Azure SQL Database infrastructure.

Skills

SQL Server Data Engineering

Problem Solving

Communication

Education

Microsoft Certified: Azure Solutions Architect Expert

Tools

Terraform

PowerShell

JIRA

GitHub

Job description

As a member of the SQL Server Engineering Team under the Data and Analytics Technology Organization, the candidate will assist in building and enhancing secure on-premise and Azure cloud SQL Server infrastructures. The role focuses on seamlessly integrating these systems with existing firm systems and controls. The ideal candidate will have a strong engineering background working with the Azure cloud stack and Microsoft SQL Server, especially with Azure SQL Database, and will contribute to the growth and management of critical databases.

Key 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 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 HashiCorp and update 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 engineering and DBA teams in troubleshooting, analyzing, and resolving issues related to Azure SQL Database and affiliated services.
• Develop a strong understanding of the downstream services and applications that are part of the Azure SQL ecosystem.
• Write clear and comprehensive documentation, guides, and procedures on new and existing processes related to the Azure SQL Database offering.

Required Qualifications :

• Strong experience in SQL Server data engineering, including Azure SQL Database and use of T-SQL.
• 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 to work effectively with cross-functional teams.

Preferred Qualifications (if any) :

• Experience in cloud infrastructure automation and Azure cloud stack.
• Familiarity with Python for scripting and automating infrastructure tasks.
• Experience in creating technical documentation and diagrams to communicate infrastructure changes or issues.
• Knowledge of enterprise-grade SQL Server environments and cloud database architectures.

Certifications (if any) :

Microsoft Certified : Azure Solutions Architect Expert (preferred).

Other relevant certifications related to Azure, SQL Server, and cloud infrastructure.

Create a job alert for this search

Infrastructure Engineer • Montreal, QC, United States