Senior DevOps Data warehouse & .NET Modernization

Job Summary

We are seeking a highly skilled and motivated Senior Dev Ops 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 Dev Ops 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 Git Lab.

• Pipeline Design and Implementation: design, and implement end-to-end CI/CD pipelines using Git Lab 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 Git Lab 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 Git Lab Runners and integrate other necessary Dev Ops tools.
• Collaboration and Mentoring:
  Work closely with data warehouse engineers, .NET developers, and operations teams to embed a Dev Ops 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.

• 5 years of experience in Dev Ops or a related software engineering role.
• Mandatory
  
  Skills:
• CI/CD Pipeline Expertise: hands-on experience designing and building CI/CD pipelines with Git Lab
• 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.