Sr. DevOps Engineer (Data Infrastructure)

HOOPP (Healthcare of Ontario Pension Plan); Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading healthcare pension organization in Toronto is seeking a Senior DevOps Engineer to manage data pipelines and infrastructure for investment applications. The ideal candidate will have 7+ years of experience in database administration and DevOps, with strong expertise in SQL and cloud environments like AWS and Snowflake. This full-time position offers competitive benefits, a people-focused culture, and opportunities for professional growth.

Benefits

100% company-paid health and dental benefits

Defined benefit pension plan

Wellness initiatives and classes

Qualifications

• 7+ years of experience in database administration and DevOps.
• Hands-on knowledge of SQL and query optimization.
• Certifications in AWS or Oracle highly desirable.

Responsibilities

• Manage database systems for optimal performance and availability.
• Collaborate with teams to design schema changes and implement CI/CD pipelines.
• Monitor resource usage and optimize for cost efficiency.

Skills

Database administration

DevOps practices

Automation and process optimization

SQL proficiency

Cloud optimization (AWS, Snowflake)

Collaboration and communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

AWS RDS

Terraform

Snowflake

Job description

Join to apply for the Sr. DevOps Engineer (Data Infrastructure) role at HOOPP (Healthcare of Ontario Pension Plan)

2 weeks ago Be among the first 25 applicants

Join to apply for the Sr. DevOps Engineer (Data Infrastructure) role at HOOPP (Healthcare of Ontario Pension Plan)

• high-performance, people-focused culture
• our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves
• learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth
• membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security
• competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account).
• optional post-retirement health and dental benefits subsidized at 50%
• yoga classes, meditation workshops, nutritional consultations, and wellness seminars
• the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Why You’ll Love Working Here

• high-performance, people-focused culture
• our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves
• learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth
• membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security
• competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account).
• optional post-retirement health and dental benefits subsidized at 50%
• yoga classes, meditation workshops, nutritional consultations, and wellness seminars
• the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Job Summary

The Senior DevOps Engineer will play a pivotal role in ensuring seamless and reliable data pipelines, infrastructure, and operations for investment, financial, and risk applications within our Investment Service Group Data (ISG) Infrastructure team. This position blends DataOps engineering expertise with database administration (DBA) responsibilities and is responsible for designing, implementing, and maintaining scalable data solutions to meet the growing needs of the organization while ensuring compliance, performance, and security across our data platforms. The role requires a collaborative mindset to partner with enterprise architects, Cloud DevOps engineers, developers, and other stakeholders to drive operational excellence, automation, and innovation.

What You Will Do

• Manage and maintain database systems (e.g., Oracle, SQL Server, AWS RDS, Snowflake) to ensure availability, reliability, and optimal performance.
• Perform routine database tuning, including indexing, query optimization, and storage management, to meet workload demands.
• Plan and execute database backups, recovery strategies, and replication to ensure business continuity and disaster recovery alignment.
• Oversee database security, implementing role-based access control (RBAC), encryption, and compliance with corporate security policies.
• Collaborate with development teams to design and implement schema changes, migrations, and performance benchmarks.
• Design, build, and maintain ETL / ELT pipelines for investment applications, ensuring seamless integration and high-performance data workflows.
• Implement CI / CD pipelines to automate data deployment, testing, and monitoring processes.
• Develop reusable frameworks and best practices for ingesting, transforming, and integrating structured and unstructured datasets.
• Build and maintain cloud-native data platforms, with a focus on AWS services (e.g., S3, RDS, Redshift, Athena) and Snowflake.
• Implement Infrastructure as Code (IaC) practices using tools like Terraform or CloudFormation to provision and manage cloud resources.
• Monitor cloud resource utilization and optimize for performance and cost efficiency.
• Establish proactive monitoring and alerting for data workflows and databases using tools like AWS CloudWatch, Datadog, or Prometheus.
• Troubleshoot and resolve database and data pipeline issues, ensuring minimal downtime and consistent performance.
• Drive automation initiatives to streamline manual database tasks and improve operational efficiency.
• Define and enforce standards for data quality, data governance, and audit readiness.
• Work closely with IT Governance, Unified Data Platform (UDP) and Unified Data Governance (UDG) and InfoSec groups to ensure all database and data operations meet Governance and ICFR standards
• Act as a technical liaison for database and data platform-related vendor engagements.
• Interprets internal / external challenges, critically evaluates products / services / workflows, identifies areas of inefficiencies and optimization, and recommends solutions based best practices
• Acts as a mentor for junior colleagues and invests time to grow individuals in a technical capacity.
• Advocate for Agile and DevOps principles, fostering a culture of collaboration and continuous improvement.

What You Bring

• 7+ years of progressive experience in database administration, DevOps, and data operations, with a focus on automation and process optimization.
• Extensive experience managing and optimizing databases in cloud environments, particularly AWS and Snowflake using IaC (Infrastructure as Code).
• Hands-on knowledge of Snowflake for data warehousing and storage, performance tuning, and integration within DevOps workflows.
• Expertise in SQL and advanced query optimization.
• Strong proficiency in database platforms, including Oracle, SQL Server, PostgreSQL, and Snowflake.
• Experience with cloud-native database services such as AWS RDS, Redshift, DynamoDB, and Snowflake.
• Hands-on experience with ETL tools (e.g., AWS Glue, Apache Airflow,) and DevOps tools (e.g., Azure DevOps, Jenkins, GitLab CI / CD, Docker, Kubernetes).
• Advanced knowledge of backup, recovery, replication, and disaster recovery strategies.
• Hands-on experience with Infrastructure as Code (IaC) tools like Terraform or equivalent.
• Strong problem-solving and troubleshooting abilities.
• Exceptional collaboration and communication skills to interact effectively with technical and business stakeholders.
• Detail-oriented and proactive in delivering high-quality data solutions.
• Desire to improve processes and procedures to improve current workflows.
• Certifications such as AWS Certified Database - Specialty, AWS Certified Data Engineer, SnowPro Advanced Architect, or Oracle Database Administrator are highly desirable.