Database Operations Engineer

1 month ago

Toronto, Ontario, Canada Company 1 - The Manufacturers Life Insurance Company Full time
Job Title: Database Operations Engineer

About the Role:

We are seeking a highly skilled Database Operations Engineer to join our team at Manulife. As a key member of our database operations team, you will be responsible for ensuring the smooth operation of our SQL Server databases on Azure cloud platforms.

Key Responsibilities:

  • Coordinate and plan database migration activities from on-prem to Azure (PaaS & IaaS) and across Azure subscriptions
  • Lead complex troubleshooting or escalated technical issues over a significant population of affected software or equipment
  • Manage backups, recovery procedures, DBCC utilities, index maintenance jobs, database & disk space management
  • Manage database refresh jobs
  • Recommend on stored procedure optimization, performance tuning & index tuning
  • Develop monitoring strategy / implementation pattern for monitoring of SQL server in Azure cloud using New Relic
  • Build and maintain customized dashboard and alerts
  • Improve on operational efficiency by designing and adopting automated tools/utilities to reduce toil
  • Works closely with IT project managers, programmers, architects on currency initiatives
  • Planning, developing, testing and execution of Disaster recovery processes
  • Champion the culture of reliability mindset by embarking on opportunities to implement self-healing database solutions
  • Maintain security, compliance, database hardening, encryption standards, audit, and access control frameworks
  • Oversee implementation and maintenance of database setup, installation, configuration & monitoring
  • Consult, guide & mentor team members
  • Participate in on-call support rotation including after-hours/weekend duties

Requirements:

  • Total 4 - 7/8 years experience
  • SQL server 2019, 2017 & 2016 Azure (IaaS & PaaS) cloud platforms
  • Data Migration tools such as Data Migration Assistant, Data Migration Services, Azure Data Studio
  • Azure Geo Replication for High Availability
  • High Availability Solution-Clustering & Always On
  • Database backup/restore and disaster recovery
  • SQL server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance
  • 24 x7 dedicated support for SQL server production server
  • Database alerts and monitoring for Azure cloud platform
  • Azure Active Directory (Entra) & SQL authentication
  • Database migration from on-prem to Azure cloud
  • Performance tuning and Query Optimization
  • Database hardening and security standards like TDE, SSL/TLS and auditing
  • Azure provisioning through automation tools such as IAC (Terraform), CI/CD i.e. Jenkins, Flyway, GitHub Actions
  • Cryptographic key management using Azure Key Vault (AKV)
  • Database health check, reports, and metrics

Preferred Qualifications:

  • Database: PostgreSQL
  • Platform: AWS
  • AIOps tool: Moogsoft
  • SQL Server: Resource Governor & SSRS
  • Analytics: Utilizing Azure Databricks, ADF, ADLS, and Synapse to design and develop end-to-end data pipelines supporting data ingestion, curation, visualization, and delivery
  • Certification: Microsoft DP-300

About Manulife:

Manulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States. We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions. At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers. At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as 'MFC' on the Toronto, New York, and the Philippine stock exchanges, and under '945' in Hong Kong.

Manulife is an Equal Opportunity Employer

Salary & Benefits:

The annual base salary for this role is listed below.

Primary Location

Waterloo, Ontario

Salary range is expected to be between

$74,270.00 CAD - $137,930.00 CAD

If you are applying for this role outside of the primary location, please contact for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact for more information about U.S.-specific paid time off provisions.

  • Database Operations Engineer

    1 week ago

    Toronto, Ontario, Canada Company 1 - The Manufacturers Life Insurance Company Full time

    Job Title: Database Operations EngineerJob Summary:We are seeking a highly skilled Database Operations Engineer to join our team. The successful candidate will be responsible for designing, implementing, and maintaining complex database systems on Azure cloud platforms.Key Responsibilities:Design and implement database migration strategies from on-prem to...

  • Database Operations Engineer

    3 weeks ago

    Toronto, Ontario, Canada Company 1 - The Manufacturers Life Insurance Company Full time

    Job Title: Database Operations EngineerAbout the Role:We are seeking a highly skilled Database Operations Engineer to join our team. As a key member of our database operations team, you will be responsible for designing, implementing, and maintaining complex database systems on Azure cloud platforms.Key Responsibilities:Coordinate and plan database migration...

  • Senior Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team. As a Senior Data Engineer, you will be responsible for designing, building, and maintaining large-scale data systems that support our business operations.Key ResponsibilitiesDesign and implement data models, data warehouses, and data pipelines to support business...

  • Senior Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team. As a Senior Data Engineer, you will be responsible for designing, building, and maintaining large-scale data systems that support our business operations.Key ResponsibilitiesDesign and implement data models, data warehouses, and data pipelines to support business...

  • Database Engineer

    3 weeks ago

    Toronto, Ontario, Canada Rakuten Kobo Inc. Full time

    Database Platform Engineer Job DescriptionRakuten International is a global e-commerce company that operates 7 businesses with over 4,000 employees worldwide. Our mission is to deliver innovative, automated, and self-service infrastructure using cost-effective technologies to empower autonomous product development teams.Key Responsibilities:Design, install,...

  • Cloud Database Engineer

    3 weeks ago

    Toronto, Ontario, Canada Questrade Financial Group Full time

    Cloud Database EngineerQuestrade Financial Group is seeking a skilled Cloud Database Engineer to join our team. As a Cloud Database Engineer, you will be responsible for designing, implementing, and maintaining cloud-based database infrastructure for our cloud-native applications.Key Responsibilities:Design and implement cloud database infrastructure using...

  • Senior Database Engineer

    2 months ago

    Toronto, Ontario, Canada 0076 eBay Canada Full time

    eBay is seeking a Senior Member of Technical Staff (Database Engineering) for their Data Infrastructure organization, that builds and runs petabyte scale core data platform that powers large scale database, storage, caching and media infrastructure.This position will have the opportunity to architect, build and operate the next generation distributed...

  • Senior Database Engineer

    2 months ago

    Toronto, Ontario, Canada 0076 eBay Canada Full time

    eBay is seeking a Senior Member of Technical Staff (Database Engineering) for their Data Infrastructure organization, that builds and runs petabyte scale core data platform that powers large scale database, storage, caching and media infrastructure.This position will have the opportunity to architect, build and operate the next generation distributed...

  • Senior Database Engineer

    2 weeks ago

    Toronto, Ontario, Canada 0076 eBay Canada Full time

    eBay is seeking a Senior Member of Technical Staff (Database Engineering) for their Data Infrastructure organization, that builds and runs petabyte scale core data platform that powers large scale database, storage, caching and media infrastructure.This position will have the opportunity to architect, build and operate the next generation distributed...

  • Senior Database Engineer

    4 weeks ago

    Toronto, Ontario, Canada 0076 eBay Canada Full time

    eBay is seeking a highly skilled Senior Member of Technical Staff (Database Engineering) for their Data Infrastructure organization. This position will have the opportunity to architect, build and operate the next generation distributed database and storage platform that powers some of the most critical systems powering eBay's global ecommerce business.Key...

  • Senior Database Engineer

    4 weeks ago

    Toronto, Ontario, Canada 0076 eBay Canada Full time

    eBay is seeking a highly skilled Senior Member of Technical Staff (Database Engineering) for their Data Infrastructure organization. This position will have the opportunity to architect, build and operate the next generation distributed database and storage platform that powers some of the most critical systems powering eBay's global ecommerce business.Key...

  • Database Systems Engineer

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    At Broadridge, we empower our associates to accomplish more by fostering a culture of collaboration and innovation. If you're passionate about developing your career in database administration, we invite you to explore this exciting opportunity.Job SummaryWe're seeking a highly skilled Database Systems Engineer to join our team. As a key member of our...

  • Database Systems Engineer

    2 months ago

    Toronto, Ontario, Canada Amazon Full time

    {"h1": "Cloud Database Engineer - Amazon Aurora PostgreSQL Engine", "p": "We are seeking an experienced Cloud Database Engineer to join our Amazon Aurora PostgreSQL Engine team. As a key member of our team, you will be responsible for designing, developing, and deploying highly scalable distributed database systems that provide availability, reliability, and...

  • Database Systems Engineer

    2 months ago

    Toronto, Ontario, Canada Amazon Full time

    {"h1": "Cloud Database Engineer - Amazon Aurora PostgreSQL Engine", "p": "We are seeking an experienced Cloud Database Engineer to join our Amazon Aurora PostgreSQL Engine team. As a key member of our team, you will be responsible for designing, developing, and deploying highly scalable distributed database systems that provide availability, reliability, and...

  • Cloud Database Engineer

    2 months ago

    Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking an experienced Cloud Database Engineer to join our Amazon Aurora PostgreSQL Engine team. As a key member of our team, you will be responsible for designing, developing, and implementing highly scalable distributed database systems that provide availability, reliability, and performance guarantees.Key ResponsibilitiesDesign and...

  • Cloud Database Engineer

    2 months ago

    Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking an experienced Cloud Database Engineer to join our Amazon Aurora PostgreSQL Engine team. As a key member of our team, you will be responsible for designing, developing, and implementing highly scalable distributed database systems that provide availability, reliability, and performance guarantees.Key ResponsibilitiesDesign and...

  • Staff Database Engineer

    1 month ago

    Toronto, Ontario, Canada CLIO Full time

    About the Role:Clio is seeking a highly skilled Staff Database Engineer to join our team. As a key member of our engineering organization, you will be responsible for designing, building, and maintaining our MySQL database infrastructure.Key Responsibilities:Design and implement scalable and reliable database systemsInvestigate and resolve performance issues...

  • Staff Database Engineer

    1 month ago

    Toronto, Ontario, Canada CLIO Full time

    About the Role:Clio is seeking a highly skilled Staff Database Engineer to join our team. As a key member of our engineering organization, you will be responsible for designing, building, and maintaining our MySQL database infrastructure.Key Responsibilities:Design and implement scalable and reliable database systemsInvestigate and resolve performance issues...

  • Senior Cloud Database Engineer

    4 weeks ago

    Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    Join Our Team of Cloud Database ExpertsWe are seeking a highly skilled and experienced Cloud Database Engineer to join our team at Amazon Development Centre Canada ULC. As a Cloud Database Engineer, you will play a key role in designing, developing, and deploying highly scalable and available cloud database services.About the RoleThis is a hands-on position...

  • Senior Cloud Database Engineer

    4 weeks ago

    Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    Join Our Team of Cloud Database ExpertsWe are seeking a highly skilled and experienced Cloud Database Engineer to join our team at Amazon Development Centre Canada ULC. As a Cloud Database Engineer, you will play a key role in designing, developing, and deploying highly scalable and available cloud database services.About the RoleThis is a hands-on position...