Senior DevOps for Data warehouse

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.

#J-18808-Ljbffr