Role Name: Senior DevOps Engineer for Data warehouse & .NET Modernization
Location: Montreal
Start date: 09/01/2025
JOB DESCRIPTION:
We are seeking a highly skilled and motivated Senior DevOps Engineer to lead the modernization of our data and application delivery processes. The ideal candidate will have extensive experience in designing implementing and managing CI/CD pipelines for complex multi-technology environments. This role will be pivotal in our transition to modern DevOps practices focusing on automating the build test and deployment of both legacy data warehouse procedures (SQL PL/SQL Shell Scripting Control-M) framework applications using GitLab.
Responsibilities
Pipeline Design and Implementation: Architect design and implement end-to-end CI/CD pipelines using GitLab for both the data warehouse application stacks.
Data Warehouse Modernization: Develop automation strategies for existing data warehouse components including:
o Implementing version control for SQL and PL/SQL code.
o Automating the compilation testing and deployment of PL/SQL packages functions and procedures.
o Integrating Control-M job scheduling with GitLab pipelines for automated job promotion and management.
o Automating the execution and monitoring of data warehouse processes triggered by CI/CD.
.NET Application Modernization: Implement CI/CD framework projects including:
o Automating builds testing and artifact generation.
o Configuring deployments to various environments (e.g. development QA production).
o Working with developers to integrate best practices for continuous integration and delivery.
Scripting and Automation: Write and maintain advanced automation scripts using Shell Scripting to orchestrate processes across different systems.
Infrastructure and Tooling: Work with infrastructure teams to ensure environments are configured to support the new CI/CD processes. Manage and configure GitLab Runners and integrate other necessary DevOps tools.
Collaboration and Mentoring: Work closely with data warehouse developers and operations teams to embed a DevOps culture and foster shared responsibility. Mentor team members on CI/CD principles and best practices.
Troubleshooting and Support: Provide expertise in diagnosing and resolving pipeline failures deployment issues and other automation-related problems.
Documentation: Create and maintain detailed documentation for all CI/CD pipelines automation scripts and deployment processes.
Skills and Qualifications
Minimum of 7 years of experience in DevOps or a related software engineering role.
Mandatory Skills:
o CI/CD Pipeline Expertise: Extensive hands-on experience designing and building CI/CD pipelines with GitLab for complex multi-language/multi-platform projects.
o SQL and PL/SQL: Strong proficiency in SQL and PL/SQL development with a solid understanding of database deployments and migrations.
o Shell Scripting: Expert-level skills in Shell Scripting (Bash) for automating tasks in a Linux/Unix environment.
o Control-M: Hands-on experience with Control-M or similar enterprise job scheduling tools with a focus on automation and integration.
o .NET Framework: Experience with building and deploying applications using framework.
Preferred (Optional) Skills:
o Perl/Python: Experience with Perl or Python for scripting and automation.
o Containers: Experience with Docker or other containerization technologies.
o Infrastructure as Code (IaC): Knowledge of IaC concepts and tools like Terraform or Ansible.
Excellent communication and interpersonal skills with a proven ability to lead and mentor.
Strong problem-solving abilities and a strategic approach to automation.