Senior DevOps Engineer for Data warehouse & .NET Modernization

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.

Disclaimer

“Capgemini is an Equal Opportunity Employer committed to diversity, equity, and inclusion in the workplace. We promote fairness, accessibility, inclusion, and respect through our Partnership Accreditation in Indigenous Relations (PAIR) Committee, which supports meaningful engagement with Indigenous communities across Canada. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment. 
All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status, or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law
Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.”