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, and newly extended maternity/parental leave top of 26 weeks) optional post-retirement health and dental benefits subsidized at 50% yoga classes, meditation workshops, nutritional consultations, and wellness seminars access to an annual wellness reimbursement program for health and wellness-related expenses for permanent and temporary employees 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 experience in data operations, database administration, or related roles. Experience with automation is an asset. Proven experience managing databases across cloud (AWS, Snowflake) and on-premises environments. 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, DBT, 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. About HOOPP The Healthcare of Ontario Pension Plan (HOOPP) is one of the strongest and most stable defined benefit (DB) pension plans in Canada. Since 1960, HOOPP has been helping Ontario's healthcare workers build the foundation for a financially secure retirement. We take pride in being the pension plan for Ontario’s healthcare community and serve more than 460,000 members at more than 670 employers across the province. At HOOPP, we are committed to providing our members with a stable and reliable pension that starts in retirement and is paid for life. With offices in Toronto and London, we manage a global, multi-asset class investment portfolio. At the end of 2023 our net assets reached $112.6 billion and our funded status remained strong and stable at 115%. HOOPP's core values - professional, accountable, collaborative, compassionate and trustworthy - guide every interaction with our members, employers and employees. We've become one of Canada's leading pension plans by consistently challenging ourselves and embracing innovation. From our unique investment management approach to our innovative technology and thought-provoking research, we constantly seek to push the boundaries, and we do this by hiring passionate, forward-thinking people. Our high-performance culture is founded on collaboration, respect and belonging. HOOPP is an equal opportunity employer and we're proud of our diversity. We select applicants for employment solely on the basis of their qualifications. Should you require accommodation because of a disability during the recruitment and selection process, please contact our Human Resources team. We will be happy to consult with you so that arrangements can be made for reasonable accommodation.
