SQL Server Cloud Specialist

2 months ago

Toronto, Ontario, Canada Manulife Full time
Job Description

The Opportunity

Manulife is seeking a results-driven SQL Database Operations Engineer with exceptional technical skills in SQL Server on Azure cloud (IaaS & PaaS) to join our team.

Key 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 jobs, database & disk space management.
  • Manage database refresh jobs.
  • Recommend on stored procedure optimization, performance tuning & index tuning.
  • Develop monitoring 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 current 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.

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

Preferred Qualifications:

  • 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

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

At Manulife/JohnHancock, 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, color, 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

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.

  • SQL Server Developer

    1 month ago

    Old Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the RoleTata Consultancy Services is an equal opportunity employer, committed to fostering a diverse and inclusive work environment. We strive to create a workplace that reflects the communities we serve, and we welcome applications from individuals with diverse backgrounds and experiences.As a SQL Server Analyst at TCS, you will play a key role in...

  • SQL Server Developer

    1 month ago

    Old Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the RoleTata Consultancy Services is an equal opportunity employer, committed to fostering a diverse and inclusive work environment. We strive to create a workplace that reflects the communities we serve, and we welcome applications from individuals with diverse backgrounds and experiences.As a SQL Server Analyst at TCS, you will play a key role in...

  • Cloud Systems Administrator

    4 weeks ago

    Old Toronto, Ontario, Canada Hypertec Cloud Inc. Full time

    Cloud Systems AdministratorWe are seeking a highly skilled Cloud Systems Administrator to join our team at Hypertec Cloud Inc. in Montreal. As a key member of our cloud infrastructure team, you will be responsible for ensuring the efficient day-to-day operations of all systems and infrastructure.Key Responsibilities:Manage incidents and service requests in a...

  • Cloud Systems Administrator

    4 weeks ago

    Old Toronto, Ontario, Canada Hypertec Cloud Inc. Full time

    Cloud Systems AdministratorWe are seeking a highly skilled Cloud Systems Administrator to join our team at Hypertec Cloud Inc. in Montreal. As a key member of our cloud infrastructure team, you will be responsible for ensuring the efficient day-to-day operations of all systems and infrastructure.Key Responsibilities:Manage incidents and service requests in a...

  • Senior Cloud Migration Specialist

    3 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    Job Title: Cloud Migration SpecialistAs a Cloud Migration Specialist at Prodigy Labs, you will be responsible for migrating on-prem applications to the cloud. Your primary focus will be on developing clean and effective code based on requirements, performing unit testing and integration testing, optimizing current ETL code, and assisting the support team...

  • Senior Cloud Migration Specialist

    3 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    Job Title: Cloud Migration SpecialistAs a Cloud Migration Specialist at Prodigy Labs, you will be responsible for migrating on-prem applications to the cloud. Your primary focus will be on developing clean and effective code based on requirements, performing unit testing and integration testing, optimizing current ETL code, and assisting the support team...

  • Senior Cloud Migration Specialist

    4 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    Job Title: Cloud Migration SpecialistAs a Cloud Migration Specialist at Prodigy Labs, you will be responsible for migrating on-prem applications to the cloud. Your primary focus will be on developing clean and effective code based on requirements, performing unit testing and integration testing, optimizing current ETL code, and assisting the support team...

  • Senior Cloud Migration Specialist

    4 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    Job Title: Cloud Migration SpecialistAs a Cloud Migration Specialist at Prodigy Labs, you will be responsible for migrating on-prem applications to the cloud. Your primary focus will be on developing clean and effective code based on requirements, performing unit testing and integration testing, optimizing current ETL code, and assisting the support team...

  • Senior Cloud Migration Specialist

    3 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    Job Title: Cloud Migration SpecialistAs a Cloud Migration Specialist at Prodigy Labs, you will be responsible for migrating on-prem applications to the cloud. Your primary focus will be on developing clean and effective code based on requirements, performing unit testing and integration testing, optimizing current ETL code, and assisting the support team...

  • Senior Cloud Migration Specialist

    2 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    Job Title: Cloud Migration SpecialistAs a Cloud Migration Specialist at Prodigy Labs, you will be responsible for migrating on-prem applications to the cloud. Your primary focus will be on developing clean and effective code based on requirements, performing unit testing and integration testing, optimizing current ETL code, and assisting the support team...

  • SQL Server Database Administrator

    3 weeks ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Job Title: SQL Server Database AdministratorWe are seeking an experienced SQL Server Database Administrator to join our team at Uncharted Talent Inc. The ideal candidate will have a proven track record of optimizing database performance in a high-concurrency transaction environment and will play a critical role in ensuring the reliability and efficiency of...

  • SQL Server Database Administrator

    3 weeks ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Job Title: SQL Server Database AdministratorWe are seeking an experienced SQL Server Database Administrator to join our team at Uncharted Talent Inc. The ideal candidate will have a proven track record of optimizing database performance in a high-concurrency transaction environment and will play a critical role in ensuring the reliability and efficiency of...

  • SQL Server Database Administrator

    1 week ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    We are seeking an experienced SQL Server Database Administrator to manage and maintain our production SQL Server Platform as a Service (PaaS) databases. The ideal candidate will have a proven track record of optimizing database performance in a high-concurrency transaction environment and will play a critical role in ensuring the reliability and efficiency...

  • SQL Database Administrator

    1 month ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: SQL Database AdministratorWe are seeking a highly skilled SQL Database Administrator to join our team at Nexus Systems Group Inc. in Toronto. As a key member of our IT department, you will be responsible for ensuring the smooth operation of our database systems, providing top-notch support to our development teams, and collaborating with...

  • SQL Database Administrator

    1 month ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: SQL Database AdministratorWe are seeking a highly skilled SQL Database Administrator to join our team at Nexus Systems Group Inc. in Toronto. As a key member of our IT department, you will be responsible for ensuring the smooth operation of our database systems, providing top-notch support to our development teams, and collaborating with...

  • SQL Database Administrator

    1 month ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: SQL Database AdministratorWe are seeking a highly skilled SQL Database Administrator to join our team at Nexus Systems Group Inc. in Toronto. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database infrastructure to ensure high performance, security, and reliability.Key...

  • SQL Database Administrator

    1 month ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: SQL Database AdministratorWe are seeking a highly skilled SQL Database Administrator to join our team at Nexus Systems Group Inc. in Toronto. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database infrastructure to ensure high performance, security, and reliability.Key...

  • SQL Developer

    4 weeks ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Description**Database Developer - SQL, ETL****About the Role**CB Canada is seeking a skilled Database Developer - SQL, ETL to join our team. As a Database Developer - SQL, ETL, you will be responsible for designing, developing, and maintaining databases to support our business operations.**Key Responsibilities**Design and develop databases to meet...

  • SQL Developer

    2 months ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Description**Database Developer - SQL, ETL****About the Role**CB Canada is seeking a skilled Database Developer - SQL, ETL to join our team. As a Database Developer - SQL, ETL, you will be responsible for designing, developing, and maintaining databases to support our business operations.**Key Responsibilities**Design and develop databases to meet...

  • Cloud Application Support Specialist

    4 weeks ago

    Toronto, Ontario, Canada Bond Brand Loyalty Full time

    Cloud Application Support SpecialistBond Brand Loyalty is seeking a skilled Cloud Application Support Specialist to join our team. As a key member of our technical support team, you will be responsible for providing level 2 and level 3 support to our existing business solutions.Key Responsibilities:Investigate and troubleshoot technical issues and suggest...