Job Specifications
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, SQ