Engineering Lead, Database

Ontario Teachers' Pension Plan; Toronto; Hybrid; CAD 80,000 - 130,000; Full time

Job summary

An established industry player is seeking an Engineering Lead for Database to spearhead the management and optimization of database technologies. This senior role involves developing infrastructure strategies, leading implementation projects, and ensuring optimal performance across cloud and hybrid environments. The ideal candidate will leverage their extensive experience in database internals and cloud platforms, while also mentoring junior staff and collaborating with various teams. Join a dynamic organization that values diversity and offers a flexible work environment, competitive salary, and opportunities for professional growth.

Benefits

Competitive salary and incentive

Professional growth opportunities

Employer paid benefits coverage

Defined benefit pension plan

Flexible/hybrid work environment

Competitive time off

Flexible Travel Program

Employee discount programs

Qualifications

• 10+ years in IT with expert knowledge of database technologies.
• Experience in managing cloud and hybrid data platforms.
• Strong technical troubleshooting and problem-solving skills.

Responsibilities

• Develop and manage database infrastructure services and strategies.
• Coordinate with teams to optimize database technology stack.
• Conduct market research and evaluate new technologies.

Skills

Database Internals

SQL Server

Azure SQL

Snowflake

Oracle

PostgreSQL

Cloud Platforms (Azure)

DevOps

Technical Troubleshooting

Problem Solving

Education

Bachelor's degree in Computer Science

ITIL Foundations Certification

TOGAF Certification

Tools

Ansible

Terraform

Jenkins

Spacelift

Job description

The Opportunity

The Engineering Lead, Database is a senior technical role responsible for supporting the introduction and management of database technologies. In this role, the Lead will develop database infrastructure strategy, plans, designs and continuous improvement initiatives, and alongside service providers lead all aspects of implementation.

A key responsibility for the Lead will be gathering and translating technical requirements into infrastructure solution designs, developing and optimizing database infrastructure services in a hybrid environment, leveraging infrastructure-as-code to build database services, manage capacity, usage, performance and availability.

This role is additionally responsible for relationship management with key vendors and internal partners, managing services, processes and important metrics related to system design efficiency, requirements traceability, customer and partner satisfaction, system design quality and system availability to take proactive actions and deliver expected levels of system capability.

Who you’ll work with

Working under the direction of the Sr. Manager, Database Engineering, the Engineering Lead will mentor and coach other technical staff and our managed services staff. You will partner with architects, application developers, QA, product teams and internal technology groups to provide end to end technical oversight for project solutions.

What you’ll do

1. Apply your existing knowledge of database technologies to deploy, optimize and manage database infrastructure services.
2. Analyze existing database ecosystems to ensure they are effectively meeting the needs of the organization.
3. Coordinate with all areas of the organization to see that the database technology stack is performing optimally. They will also analyze business requirements to identify where they can integrate new compute, storage, operating systems and data platform solutions.
4. Perform market research and evaluations including Proof of Concepts (POC) of new technologies and may recommend alternative data platforms or improvements.
5. Develop and detail the proposed technical design for the integration and implementation of any new system/service and will work with service providers / teams to ensure accurate understanding of the IT system design(s).
6. Define TI Standards and Strategies, including configurations and settings (hardening, security, logging, backup/recovery, patching and platform standard methodologies).
7. Be responsible for artifact management relating to design standards, templates, patterns, reference architectures and other design documentation standards.
8. Participate in evaluating the success of the project, identifying best practices and lessons learned and provide feedback to leadership and incorporates this information into future integration plans.
9. Develop and document standard operating procedures, improvements to design, build, configuration or operational functions based on measurement of reliability or efficiency of the service.
10. Manage technology licenses, asset management, prioritizing and assigning work to vendor staff, and the evaluation of OTPP and vendor operations performance.

What you’ll need

1. Minimum of 10 years in IT.
2. Expert level knowledge of database internals with one or more of SQL Server, Azure SQL, Snowflake, Oracle, PostgreSQL.
3. Minimum 5 years implementing, managing, and supporting cloud (Azure) and hybrid data platforms.
4. Minimum 5 years designing, developing and implementing automations to deploy databases and to manage day-to-day operational activities.
5. Experience with DevOps, Infrastructure-as-Code, Ansible, Terraform, Jenkins, Spacelift are definite assets.
6. Strong technical troubleshooting and problem-solving abilities.
7. Experience planning and implementing large-scale data migrations.
8. Knowledge of Enterprise Infrastructure Services including Compute, Network & Storage ecosystems are assets.
9. Demonstrated ability to generate and maintain technical documentation.
10. Experience in contributing to a complete Project Life Cycle process including but not limited to project Request-Discovery-Planning-Delivery and Closure landmarks.
11. Bachelor’s degree in Computer Science, Engineering, or equivalent.
12. ITIL Foundations and TOGAF certification are assets.

What we’re offering

1. Pay-for-performance environment that offers competitive salary and incentive.
2. Numerous opportunities for professional growth and development.
3. Comprehensive employer paid benefits coverage.
4. Retirement income through a defined benefit pension plan.
5. The opportunity to invest back into the fund through our Deferred Incentive Program.
6. A flexible/hybrid work environment combining in office collaboration and remote working.
7. Competitive time off.
8. Our Flexible Travel Program gives you the option to work abroad in another region/country for up to a month each year.
9. Employee discount programs including Edvantage and Perkopolis.

At Ontario Teachers', diversity is one of our core strengths. We take pride in ensuring that the people we hire and the culture we create, reflect and embrace diversity of thought, background and experience. Through our Diversity, Equity and Inclusion strategy and our Employee Resource Groups (ERGs), we celebrate diversity and foster inclusion through events for colleagues to connect for professional development, networking & mentoring. We are building an inclusive and equitable workplace where our talent is respected, accepted and empowered to be themselves. To learn more about our commitment to Diversity, Equity and Inclusion, check out Life at Teachers'.

How to apply

Are you ready to pursue new challenges and take your career to the next level? Apply today! You may be invited to complete a pre-recorded digital interview as part of your application.

Accommodations are available upon request ([e-mail]) for candidates with a disability taking part in the recruitment process and once hired.

Candidates must be legally entitled to work in the country where this role is located.

The privacy of your personal information is important to us. Please visit our Privacy Centre to learn how we handle your personal information.

Functional Areas:

Information Technology

Requisition ID:

6347