Analyste au support applicatif senior / Senior Application Support Analyst

NÖORD TECHNOLOGIES; Montreal; Presencial; CAD 85 000 - 130 000; Tempo integral

Resumo da oferta

NÖORD TECHNOLOGIES is seeking a skilled SQL/Cloud Engineer to help build and optimize secure on-premises and Azure SQL environments. You will integrate these with existing firm systems and controls, leveraging Terraform IaC and PowerShell automation.

You'll work within an Azure-focused team to enhance SQL Server deployments, PoCs, and ongoing improvements, while aligning with agile practices and documentation standards.

Qualificações

• Strong experience in SQL Server data engineering with Azure SQL Database.
• Automation using PowerShell and Terraform.
• Experience with SDLC, agile practices and tools such as JIRA, GitHub and GitHub Actions.
• Excellent problem-solving, analytical and communication skills.
• Experience documenting technical architecture and procedures.

Responsabilidades

• Implement hardened and controls-compliant Azure SQL Database deployments using firm-approved standards and IaC practices.
• Design, develop, test and document improvements to Azure SQL Database infrastructure configuration management IaC using Terraform.
• Assist in PoCs, research and analysis of new Microsoft Azure SQL PaaS enhancements.
• Stay up-to-date on Terraform provider releases and update IaC libraries.
• Adhere to agile practices to produce high-quality, secure, and maintainable code.
• Support engineering and DBA teams in troubleshooting Azure SQL Database issues.
• Develop understanding of downstream services and applications in the Azure SQL ecosystem.
• Write clear how-to guides and procedures for Azure SQL processes.

Conhecimentos

Azure SQL Database

SQL Server data engineering

Terraform

PowerShell

GitHub Actions

GitHub

JIRA

Python

SDLC / Agile

Communication

Ferramentas

Terraform

PowerShell

GitHub

GitHub Actions

JIRA

Descrição da oferta de emprego

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