Database Operations Engineer at Manulife

Waterloo, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

20 Jun, 26

Salary

136100.0

Posted On

22 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Azure PaaS, Azure IaaS, Database Migration, Backup and Recovery, Performance Tuning, Index Tuning, SQL Database Monitoring, New Relic, Automation Tools, Generative AI, Disaster Recovery, Database Hardening, T-SQL, PowerShell, Terraform

Industry

Insurance

Description

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. Enhance operational efficiency through the design and adoption of automated tools and Generative AI solutions. 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. SSRS reporting server. Programming language: T- SQL for SQL server, PowerShell, Terraform & AZ CLI Database monitoring: Foglight & NewRelic (or an equivalent motoring tool) 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: MongoDB & 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: We’ll empower you to learn and grow the career you want. We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words. As part of our global team, we’ll 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 https://www.manulife.com/en/about/our-story.html. Manulife 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 hr@manulife.com. Referenced Salary Location Waterloo, Ontario Working Arrangement Hybrid Salary range is expected to be between $86,100.00 CAD - $136,100.00 CAD 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 hr@manulife.com 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 hr@manulife.com for more information about U.S.-specific paid time off provisions. We're Manulife. And we’re on a mission to make decisions easier and lives better. Better is what drives us. It’s what inspires us to find new ways to support customers and colleagues in living longer and healthier lives. It’s the reason we’re dedicated to investing in digital innovation and accelerating a sustainable and economically inclusive future. Joining us means you’ll be empowered to learn and grow your career. We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words. And as part of our global team, you’ll help shape the future you want to see – and discover that better can take you anywhere you want to go. We’re proud of our accomplishments and recognitions. Recent awards include: 2024 Gallup Exceptional Workplace Award Winner Manulife Named one of Forbes World’s Best Employers 2023 Best Companies to Work for in Asia 2023 We’ve been recognized as one of Canada’s Top 100 Employers (2024) Manulife included in Bloomberg’s 2023 Gender-Equality Index To receive our latest job opportunities directly to your inbox, create an account or sign in and navigate to the ‘Job Alerts’ section located in the top right corner of the page. From there, you can sign up to receive job alerts. Our ambition is to be the most digital, customer-centric global company in our industry. Learn more at https://www.manulife.com/.

Responsibilities

The role involves analyzing, building, and maintaining complex backend databases, including coordinating database migrations from on-premises to Azure cloud environments. Responsibilities also cover managing backups, performance tuning, developing monitoring strategies, and implementing automation and self-healing solutions.