Database architect Offres d'emploi - Waterloo, ON

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.

The role being advertised is an existing vacancy.

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 .

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 .

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 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.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our .