Senior DevOps Engineer for Data warehouse & .NET Modernization

Job Description

Job Description

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) and .NET 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 and .NET 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 for .NET 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 engineers, .NET 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 the .NET 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."