Database Operations Engineer

1 month ago

Toronto, 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. 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 and implement monitoring strategies for SQL Server in Azure cloud using New Relic
  • Build and maintain customized dashboards and alerts
  • Improve operational efficiency by designing and adopting automated tools/utilities to reduce toil
  • Work closely with IT project managers, programmers, architects on current initiatives
  • Plan, develop, test, and execute disaster recovery processes
  • Champion a culture of reliability by implementing 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, and 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
  • 24x7 dedicated support for SQL Server production servers
  • Database alerts and monitoring for Azure cloud platforms
  • 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:

  • Database Management: MS SQL, MongoDB Atlas, Azure SQL, SQL MI & Cosmos
  • Programming Languages: JavaScript, Python, PowerShell, Terraform & AZ CLI
  • Database Programming: 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, and Windows
  • SQL Server: SQL Server Management Studio, Profiler, Replication, Patching & Database Tuning Wizard

Experience:

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

  • Database Operations Engineer

    3 weeks ago

    Toronto, Ontario, Canada Company 1 - The Manufacturers Life Insurance Company Full time

    Job Title: Database Operations EngineerJob Summary:We are seeking a highly skilled Database Operations Engineer to join our team. The successful candidate will be responsible for designing, implementing, and maintaining complex database systems on Azure cloud platforms.Key Responsibilities:Design and implement database migration strategies from on-prem to...

  • Senior Database Engineer

    4 weeks ago

    Toronto, Ontario, Canada 0076 eBay Canada Full time

    eBay is seeking a Senior Member of Technical Staff (Database Engineering) for their Data Infrastructure organization, that builds and runs petabyte scale core data platform that powers large scale database, storage, caching and media infrastructure.This position will have the opportunity to architect, build and operate the next generation distributed...

  • Database Solutions Engineer

    13 hours ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    Job SummaryWe are seeking a highly skilled Database Solutions Engineer to join our team at Tata Consultancy Services. In this role, you will be responsible for designing, building, testing, and deploying quality database solutions that meet project objectives and client requirements.About the RoleThis is an exciting opportunity to work with a leading IT...

  • Database Engineer

    1 month ago

    Old Toronto, Ontario, Canada Amazon Full time

    Unlock the Power of Cloud Database ServicesAre you passionate about building scalable and reliable database systems in the cloud? Do you want to be part of a team that revolutionizes the way databases are designed and developed for the cloud? We are seeking experienced technical experts in relational databases and large-scale storage system technologies to...

  • Database Architect and Engineer

    2 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job SummaryWe are seeking a highly skilled Database Architect and Engineer to join our team at Randstad Canada.About the RoleThis is a 12-month contract opportunity for a Database Developer/Architect to work with a leading employer in the local market. The successful candidate will have the opportunity to work on various application development teams,...

  • Database Platform Engineer

    1 month ago

    Old Toronto, Ontario, Canada Rakuten Kobo Inc. Full time

    Database Platform EngineerJob Summary:Rakuten Kobo Inc. is seeking a skilled Database Platform Engineer to join our Productivity Engineering team. As a key member of our team, you will be responsible for designing, installing, configuring, and maintaining database systems to ensure high availability and performance.Key Responsibilities:Database Management:...

  • Database Engineer

    3 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job OverviewThis is a permanent position that requires strong technical expertise in database management and IT infrastructure.The ideal candidate will have a solid understanding of database development, deployment, and maintenance.As a key member of the team, you will be responsible for designing, implementing, and managing databases to meet business...

  • Database Systems Engineer

    2 weeks ago

    Toronto, Ontario, Canada Interac Corp. Full time

    Job Description:We are seeking a highly skilled Database Administrator to join our team at Interac Corp.About Us:At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. Whether we're leading real-time money movement, driving innovative commerce solutions like open payments for...

  • Database Operations Specialist

    4 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    At Broadridge, we empower our associates to accomplish more by fostering a culture of collaboration and innovation. If you're passionate about developing your career, come explore opportunities with us.Position Overview:We're seeking a highly skilled and detail-oriented SQL Server and related DB technologies Operations specialist to join our team. The...

  • Senior Cloud Database Engineer – GCP

    4 weeks ago

    Toronto, Ontario, Canada Highbrow LLC Full time

    Job Responsibilities:As a Senior Cloud Database Engineer at Highbrow LLC, you will be responsible for the solution engineering, design, optimization, integration, automation, and maintenance of popular Google Cloud Platform (GCP) and Microsoft Azure (AZ) database PaaS services, such as Microsoft SQL Server, PostgreSQL, No-SQL and Redis.Key...

  • Database Systems Engineer

    1 week ago

    Toronto, Ontario, Canada KDigitalLabs INC Full time

    About the RoleKDigitalLabs INC is seeking an experienced Database Systems Engineer to join our team. As a key member of our technical staff, you will be responsible for designing and developing databases to meet the needs of our clients.ResponsibilitiesDesign and develop databases using industry-leading tools and technologiesCollaborate with cross-functional...

  • Software Engineering Specialist, Database Services

    3 weeks ago

    Toronto, Ontario, Canada Amazon Full time

    We are seeking a talented Software Development Engineer to join our Amazon Aurora PostgreSQL Engine team. If you have a passion for building large-scale database systems and are excited about the opportunity to work on a highly scalable distributed system that provides availability, reliability, and performance guarantees, this could be the perfect role for...

  • Cloud Database Engineer for Scalable Systems

    2 weeks ago

    Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    As a Cloud Database Engineer at Amazon Development Centre Canada ULC, you will play a key role in designing and implementing major database components to enable Amazon Aurora to scale and perform for the growing customer demands under the project of Aurora Global Database.The ideal candidate has built a lot of software – shipped products and created...

  • Senior Database Architect and Engineer

    4 days ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job OverviewWe are seeking an experienced Senior Database Architect and Engineer to join our team in Toronto. As a key member of our technology team, you will be responsible for designing and developing complex database solutions that meet the needs of our clients.

  • Software Development Engineer, Cloud Database Services

    4 weeks ago

    Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    We are seeking a highly skilled Software Development Engineer to join our team in building hyper-scale database services in the cloud. As a key member of our team, you will design and implement major database components to allow Amazon Aurora to scale and perform for the growing customer demands under the project of Aurora Global Database.Aurora is a...

  • Database Infrastructure Engineer

    3 weeks ago

    Toronto, Ontario, Canada CI Financial Full time

    At CI Financial, we're looking for a highly skilled Database Infrastructure Engineer to join our Infrastructure team. Key Responsibilities:Provide day-to-day operational and emergency support of core Database DB infrastructure systems.Design and implement hybrid DB infrastructure systems that are scalable, stable, and efficient.Migrate and transform data...

  • Cloud Database Engineer for Highbrow LLC

    2 weeks ago

    Toronto, Ontario, Canada Highbrow LLC Full time

    At Highbrow LLC, we're seeking an experienced Cloud Database Engineer to join our team. This is a fantastic opportunity for individuals passionate about designing and implementing scalable, secure, and high-performance database solutions on Google Cloud Platform (GCP) and Microsoft Azure.About the RoleWe're looking for a skilled engineer with extensive...

  • Cloud Engineering Leader

    2 weeks ago

    Toronto, Ontario, Canada Highbrow LLC Full time

    At Highbrow LLC, we are seeking a seasoned Cloud Engineering Leader to spearhead the development and optimization of our database solutions. As a key member of our team, you will be responsible for driving innovation in cloud-based technologies, specifically focusing on Google Cloud Platform (GCP) and Microsoft Azure (AZ).Job ResponsibilitiesSolution...

  • Database Systems Engineer

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Role at BroadridgeWe are seeking a skilled Database Administrator to join our team at Broadridge. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.The successful candidate will have experience with commercial...

  • Senior Cloud Database Engineer

    4 weeks ago

    Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    About the RoleWe are seeking a highly skilled Senior Cloud Database Engineer to join our team at Amazon Development Centre Canada ULC. As a key member of our team, you will be responsible for designing, developing, and implementing highly scalable distributed database systems that provide availability, reliability, and performance guarantees.Key...