Infrastructure Engineering SQL Server

ALLTECH CONSULTING SVC INC; Quebec; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player seeks a skilled SQL Server Engineer to enhance secure SQL Server infrastructure both on-premise and in Azure cloud. This role involves implementing compliant Azure SQL Database deployments, developing IaC using Terraform, and supporting teams in troubleshooting and resolving issues. Ideal candidates will possess strong experience in SQL Server data engineering, cloud infrastructure automation, and agile practices. Join a dynamic team where your expertise will contribute to innovative solutions and improvements in a collaborative environment focused on excellence and security.

Qualifications

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

Responsibilities

• Implement Azure SQL Database deployments with firm-approved standards.
• Support engineering and DBA teams in troubleshooting Azure SQL Database issues.

Skills

SQL Server Data Engineering

Azure SQL Database

TSQL

Powershell

Terraform

Python

Agile Practices

Problem-solving

Communication Skills

Tools

JIRA

GitHub

GitHub Actions

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:

1. Implement hardened and controls-compliant Azure SQL Database deployments using firm-approved standards and infrastructure-as-code best practices.
2. Design, develop, test, debug and document improvements to Azure SQL Database infrastructure configuration management IaC code base using Terraform.
3. Assist in researching, assessing, setting up PoCs and analyzing new Microsoft feature enhancements to the Azure SQL PaaS offering.
4. Stay up-to-date on the latest Terraform provider releases from Hashi Corp and update the IaC provider libraries to keep them current.
5. Adhere to agile best practices to produce high-quality, secure and maintainable code in an agile environment.
6. Support the engineering and DBA teams in troubleshooting, analyzing and resolving issues related to Azure SQL Database and affiliated services.
7. Develop a good understanding of the downstream services and applications that are an integral part of the Azure SQL ecosystem.
8. Write clear and comprehensive how-to documents, guides and procedures on new and existing processes related to the Azure SQL Database offering.

Required skills:

1. Strong experience in SQL Server data engineering, including Azure SQL Database, and use of TSQL.
2. Strong experience in enterprise and cloud infrastructure engineering automation using Powershell and Terraform (Experience in Python is a plus).
3. Experience with SDLC, agile practices and related tools, particularly JIRA, GitHub and GitHub Actions.
4. Excellent problem-solving, analytical and critical thinking skills (Experience creating technical architecture documentation is a plus).
5. Strong communication, written and interpersonal skills.