Database Operations Specialist

2 months ago

Kitchener, 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 designing, implementing, and maintaining complex database systems 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 Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job Title: Database SpecialistAbout the Role:We are seeking a skilled Database Specialist to join our team at Belief Tech Development. As a Database Specialist, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure.Key Responsibilities:Develop and implement a strategic blueprint to follow...

  • Database Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job Title: Database SpecialistWe are seeking a skilled Database Specialist to join our team at Belief Tech Development. As a Database Specialist, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure. You will develop and implement a strategic blueprint to follow when deploying databases...

  • Database Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job Title: Database SpecialistAbout the Role:We are seeking a skilled Database Specialist to join our team at Belief Tech Development. As a Database Specialist, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure.Key Responsibilities:Collect data to identify areas for improvement within...

  • Database Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a skilled Database Specialist to join our team at Belief Tech Development. The successful candidate will be responsible for collecting and analyzing data to identify areas for improvement within our IT infrastructure.Key ResponsibilitiesDevelop and implement a strategic blueprint for database deploymentLiaise with staff on data...

  • Database Specialist

    1 week ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    We are seeking a skilled Database Specialist to join our team at Belief Tech Development. As a key member of our organization, you will be responsible for collecting data to identify areas for improvement within our IT infrastructure. Your expertise in database management systems will enable you to develop and implement a strategic blueprint for deploying...

  • Database Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a skilled Database Specialist to join our team at Belief Tech Development.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT infrastructure.Develop and implement a strategic blueprint for database deployment.Liaise with staff on data requirements, collection, and availability.Test data...

  • Database Systems Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job Title: Database Systems SpecialistAbout the Role:We are seeking a skilled Database Systems Specialist to join our team at Belief Tech Development. As a key member of our data infrastructure team, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure.Key Responsibilities:Collect data to...

  • Database Systems Specialist

    2 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job Title: Database Systems SpecialistAbout the Role:We are seeking a skilled Database Systems Specialist to join our team at Belief Tech Development. As a key member of our IT department, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure.Key Responsibilities:Collect data to identify...

  • Senior Technology Specialist, Database Administration

    1 month ago

    Kitchener, Ontario, Canada Equitable Life of Canada Full time

    Job Title: Senior Technology Specialist, Database AdministrationWe are seeking a highly skilled Senior Technology Specialist, Database Administration to join our team at Equitable Life of Canada. As a key member of our IT Infrastructure department, you will be responsible for designing, implementing, and managing our enterprise database server...

  • Senior Technology Specialist, Database Administration

    1 month ago

    Kitchener, Ontario, Canada Equitable Life of Canada Full time

    Job Title: Senior Technology Specialist, Database AdministrationWe are seeking a highly skilled Senior Technology Specialist, Database Administration to join our team at Equitable Life of Canada. As a key member of our IT Infrastructure department, you will be responsible for designing, implementing, and managing our enterprise database server...

  • Database and Mailing Specialist

    2 weeks ago

    Kitchener, Ontario, Canada beBee Professionals Full time

    About the Role:We are looking for a skilled Database and Mailing Specialist to join our team at BeBee Professionals. The successful candidate will be responsible for managing and coordinating all mailings and lists for the company. The ideal candidate will have a minimum of two years of experience in a similar role, excellent organizational and communication...

  • Database Specialist

    3 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development. As a key member of our IT department, you will play a crucial role in analyzing and improving our organization's IT infrastructure.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT infrastructureDevelop and...

  • Database Specialist

    3 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development. As a key member of our IT department, you will play a crucial role in analyzing and improving our organization's IT infrastructure.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT infrastructureDevelop and...

  • Spreadsheets and Database Specialist

    2 weeks ago

    Kitchener, Ontario, Canada beBee Professionals Full time

    We are seeking a highly skilled Spreadsheets and Database Specialist to join our team at beBee Professionals in Kitchener. The successful candidate will be responsible for creating and maintaining spreadsheets and databases, analyzing data, and providing reports and insights to support our organization's decision-making process.Key Responsibilities:Develop...

  • Database Specialist

    4 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development. As a key member of our IT department, you will be responsible for collecting and analyzing data to identify areas for improvement within our organization's IT infrastructure.Key ResponsibilitiesCollect and analyze data to identify trends and areas for...

  • Database Specialist

    4 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development. As a key member of our IT department, you will be responsible for collecting and analyzing data to identify areas for improvement within our organization's IT infrastructure.Key ResponsibilitiesCollect and analyze data to identify trends and areas for...

  • Database Specialist

    3 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development. As a key member of our IT department, you will be responsible for collecting and analyzing data to identify areas for improvement within our organization's IT infrastructure.Key ResponsibilitiesCollect and analyze data to identify trends and areas for...

  • Database Specialist

    3 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development. As a key member of our IT department, you will be responsible for collecting and analyzing data to identify areas for improvement within our organization's IT infrastructure.Key ResponsibilitiesCollect and analyze data to identify trends and areas for...

  • Database Specialist

    4 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT infrastructure.Develop and implement a strategic blueprint for database deployment.Liaise with staff to understand data requirements and ensure data...

  • Database Specialist

    4 weeks ago

    Kitchener, Ontario, Canada Belief Tech Development Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Belief Tech Development.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT infrastructure.Develop and implement a strategic blueprint for database deployment.Liaise with staff to understand data requirements and ensure data...