Senior DevOps for Data warehouse & .NET Modernization.

Job Summary

We are seeking a highly skilled and motivated Senior DevOps 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: , 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:
• Implementing version control for SQL and PL/SQL code.
• Automating the compilation, testing, and deployment of PL/SQL packages, functions, and procedures.
• Integrating Control-M job scheduling with GitLab pipelines for automated job promotion and management.
• Automating the execution and monitoring of data warehouse processes triggered by CI/CD.
• .NET Application Modernization: Implement CI/CD for .NET framework projects, including:
• Automating builds, testing, and artifact generation.
• Configuring deployments to various environments (e.g., development, QA, production).
• Working with developers to integrate best practices for continuous integration and delivery.
• Scripting and Automation: Write and maintain 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 / Qualifications

• 5 years of experience in DevOps or a related software engineering role.
• Mandatory Skills:
• CI/CD Pipeline Expertise: hands-on experience designing and building CI/CD pipelines with GitLab
• SQL and PL/SQL: Strong proficiency in SQL and PL/SQL development, with a solid understanding of database deployments.
• Shell Scripting: Expert-level skills in Shell Scripting (Bash) for automating tasks in a Linux/Unix environment.
• Control-M: Hands-on experience with Control-M or similar enterprise job scheduling tools, with a focus on automation and integration.
• .NET Framework: Experience with building and deploying applications using the .NET framework.
• Preferred (Optional) Skills:
• Perl/Python: Experience with Perl or Python for scripting and automation.
• Containers: Experience with Docker or other containerization technologies.
• 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.