Job Description

You are as unique as your background, experience and point of view. Here, youxe2x80x99ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.::As a SQL Server DBA within Data Management Services (DMS), your primary role will be as a Database Engineer providing technical leadership in all facets SQL Serverxe2x80x99s use at Sunlife, both on prem and in cloud. The role consists of occasional participation in on-call, after-hours and weekend support of projects, infrastructure activities, as well as various disaster recovery exercises as may be required.As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life in advance of the start date and the role will also require Star Compliance.What will you do:

• Support technical leadership and direction for SQL Server. Designing new patterns of deployment, evaluating new tools to improve DMSxe2x80x99 service to their clients
• Assist with defining and documenting best practices for the global deployments of SQL Server
• Grow knowledge of various emerging technologies, cloud technologies, DevOps tools and processes, and vendor applications
• Progress in the role to becoming a point of contact for application architects or cloud teams for various engineering project initiatives requiring non-standard deployment patterns
• Constantly research better ways of implementing SQL Server and related technologies to improve stability, reduce cost, and improve security

What do you need to succeed?

• 1- 2+ years of SQL Server database experience supporting both infrastructure and development teams.
• 1+ years of administrative support of SQL Server versions including Database Engine, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• 1+ years of experience and support with AWS Cloud technologies and database workload
• Manage small complexity projects/deliverables and participate in a variety of projects through the entire project lifecycle
• Insatiable desire to learn new technologies or platforms
• Possess exceptional creativity on how to use different technologies or patterns to address business challenges.
• Be able to express difficult technical concepts to a variety of audiences (executive, technical and business) both written and verbally
• Organize and monitor personal workload and escalate to manager when issues arise
• Work closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services
• Support functionality and features with newer versions of the SQL Server DBMS as part of a readiness program
• Some SQL Server knowledge that includes a thorough understanding of SQL internals, system tables, stored procedures, functions, triggers, and SQL tuning

Whatxe2x80x99s in it for you:

• Wexe2x80x99re honoured to be recognized as a 2024 Best Workplaces in Ontario by Great Place to Workxc2xae Canada.
• We are thrilled to be recognized by Excellence Canada with their top-level certification, the Canada Order of Excellence for Mental Health at Workxc2xae, for prioritizing employee well-being, fostering a positive work culture, and achieving excellence in mental health.
• Wexe2x80x99re proud to be recognized as a company with a 2023 Most Trusted Executive team by Great Place to Workxc2xae Canada.
• Wellness programs that support the three pillars of your health xe2x80x93 mental, physical, and financial
• The opportunity to move along a variety of career paths with amazing networking potential.
• As a hybrid organization, you and your leader use business and Client needs to choose where you work, at home or in the office

As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life in advance of the start dateThe Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to .At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.Salary Range: 63,000/63 000 - 104,000/104 000Job Category: IT - Technology ServicesPosting End Date: 25/03/2025

Sun Life Financial