Search jobs > Waterloo, ON > Database engineer

Database Operations Engineer

Company 1 - The Manufacturers Life Insurance Company
Waterloo, Ontario
$74.3K-$137.9K a year
Full-time

Description

The Opportunity

Manulife is seeking a results-oriented SQL Database Operational Engineer committed and self-motivated with exceptional technical skills in SQL Server on Azure cloud (i.

e., IaaS & PaaS) to join our team. The team is responsible for analyzing, troubleshooting, building, and maintaining complex backend databases in support of multiple business applications.

Work location : Waterloo - ON, Canada Or Toronto - ON, Canada

Work arrangement : Hybrid (3 days in Office, 2 days from Home); Working remotely is not available.

Role requires to be on-Call production support rotation including after-hours / weekend duties.

Roles & Responsibilities :

Coordinate, plan and perform 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 job, database & disk space management

Manage database refresh jobs

Recommend on stored procedure optimization, performance tuning & index tuning

Developmonitoring 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

Must have knowledge and experience in :

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

Proficiency in :

Database Management : MS SQL, MongoDB Atlas, Azure SQL, SQL MI & Cosmos

Programing Languages : Java script, Python, PowerShell, Terraform & AZ CLI

Database Programing : XML, MySQL and T-SQL

CI / CD Pipelines : Jenkins & GitHub

Network & Access : NSG, VNet and Subnets, AD Roles and Responsibilities

Database Monitoring : Foglight & NewRelic

Standard Operating Systems : Unix, Linux & Windows

SQL Server : SQL Server Management Studio, Profiler, Replication,

Patching & Database Tuning Wizard

Experience in :

Agile and DevOps principles, test-driven development, continuous integration, and other approaches to accelerate the delivery of new features

Lead and have the ability to consult on high profile incident calls comprising of cross functional teams and senior leaders

Skilled to collaborate and build relationships with Manulife business and risk partners

Data driven decision making skills

Having the ability to quickly learn and pivot to newer technologies as required

Ability to adopt and change with Manulife corporate culture

Good organizational and problem-solving abilities that enable you to manage through creative abrasion

Excellent verbal and written communication; able to effectively articulate technical vision, possibilities, and outcomes

Able to achieve most tasks using own judgement

Can lead smaller groups when required

Good analytical skills, copes with complex situations through deliberate analysis and planning

Qualifications

BSC Information Systems / Computer Science, or equivalent

4 - 7 / 8 years’ experience managing production SQL Server environments Azure (70%) On prem (30%)

Nice to have :

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 and John Hancock

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.

30+ days ago
Related jobs
Manulife
Waterloo, Ontario

Manulife is seeking a results-oriented SQL Database Operational Engineer committed and self-motivated with exceptional technical skills in SQL Server on Azure cloud (i. The team is responsible for analyzing, troubleshooting, building, and maintaining complex backend databases in support of multiple ...

Company 1 - The Manufacturers Life Insurance Company
Waterloo, Ontario

Manulife is seeking a results-oriented SQL Database Operational Engineer committed and self-motivated with exceptional technical skills in SQL Server on Azure cloud (i. The team is responsible for analyzing, troubleshooting, building, and maintaining complex backend databases in support of multiple ...

Promoted
Intellex Systems Group
Canada

OnBase Administrator– our client requires an OnBase Administrator to develop, configure, and maintain the client’s OnBase solution. ...

Promoted
Procom
Guelph, Ontario

On behalf of our client in the Government Services Sector, Procom is looking for a Systems Administrator/Operations Support Specialist Systems Administrator/Operations Support Specialist – Job Description. Systems Administrator/Operations Support Specialist. ...

Promoted
Alignerr
Norfolk County, Ontario, Canada
Remote

As an AI Tutor - Coding, you'll play a critical role in shaping the future of AI.You'll leverage your subject-matter expertise to train and evaluate AI models, ensuring the information they generate is reliable and relevant across various domains.This position offers a unique path for professional g...

Ethnos360
Canada

Computer Network and Systems Administrator. ...

Peroptyx
Kitchener, Ontario

At Peroptyx, we are looking for Data Analysts who will review mapping data for digital mapping applications. ...

Mucci Farms
Canada

Perform daily system monitoring, verifying the availability of all hardware and applications, reviewing system and application logs, and verifying completion of scheduled backups. Implementation of software upgrades; including operating systems, production software upgrades and other enhancements as...

Foilcon
La Gran YajaToronto, Ontario, Canada

Develop project documentation including charter, integrated project plan, project schedule, status reports, meeting notes, and other project artifacts as required. Mentor and coach junior project management resources including Project Managers and Project Coordinators. The Senior Project Manager/Lea...

hays-gcj-v4-pd-online
CANADA

Our client is a leading national bank looking to hire Solaris System Administrator for a remote long-term contract. Solaris Clustering OVM and OpsCenter Unix System administration and hardware support Build automation (Scripting, Packaging, Ansible, OpsCenter). ...