Database Operations Engineer

Join our Enterprise Technology Services team!

Our team is responsible for analyzing resolving building and maintaining complex backend databases in support of multiple business applications.

Position Responsibilities:

• Coordinate plan and perform database migration activities transitioning from on-premises environments to Azure (PaaS & IaaS) and across Azure subscriptions.

• Lead complex fix or raised technical issues.

• Manage backups recovery procedures DBCC utilities index maintenance job/database refresh.

• Recommend on procedure optimization performance tuning & index tuning.

• Develop monitoring strategy / implementation pattern focused on SQL database instances in Azure cloud using New Relic.

• Build and maintain customized dashboard and alerts.

• Improve operational efficiency by designing and adopting automated tools.

• Works closely with IT project managers programmers architects on initiatives.

• Planning developing testing and execution of Disaster recovery processes.

• Foster the culture of reliability approach 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 junior team members.

• Participate in on-call support rotation including after-hours/weekend duties every 4 weeks.

Required Qualifications:

• Minimum 5 years of relevant technical experience.

• SQL server Azure (IaaS & PaaS) cloud platforms.

• Data Migration tools.

• Azure Geo Replication for High Availability.

• High Availability Solution-Clustering.

• Database backup/restore and disaster recovery.

• SQL server Profiler Extended Events Query Store and Database Engine Tuning Advisor (DTA) for performance.

• Azure Active Directory & SQL authentication.

• 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

AI Ops tool: Moogsoft

SQL Server: Resource Governor & SSRS

Analytics: Using 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

When you join our team:

Well empower you to learn and grow the career you want.

Well recognize and support you in a flexible environment where well-being and inclusion are more than just words.

As part of our global team well support you in shaping the future you want to see.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider helping people make their decisions easier and lives better. To learn more about us visit is an Equal Opportunity Employer

At Manulife/John Hancock we embrace our diversity. We strive to attract develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment retention advancement and compensation and we administer all of our practices and programs without discrimination on the basis of race ancestry place of origin colour ethnic origin citizenship religion or religious beliefs creed sex (including pregnancy and pregnancy-related conditions) sexual orientation genetic characteristics veteran status gender identity gender expression age marital status family status disability or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process contact .

Referenced Salary Location

Salary range is expected to be between

Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. 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. If you are applying for this role outside of the primary location please contact for the salary range for your location.

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.