SQL Server Client Manager

You are as unique as your background experience and point of view. Here youll be encouraged empowered and challenged to be your best self. Youll 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 youll 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.

Job Description:

The Manager of SQL Server Client reporting to the Director SQL Server Databases of Data Management Services DMS will provide support and the management of SQL Server and Sybase databases as well as lead/manage a team of SQL Server DBAs. The incumbent will colead a dynamic multiplatform and multi technology environment with heavy and tight target dates provide support/guidance of the overall strategic design and delivery of enterprise wide distributed database platforms supporting technologies and processes.

The position requires the ability to provide management support to a SQL Server Team and support some of the work initiatives. It also includes the ability to identify emerging technology trends that make sense to the enterprise retirement of aging technologies inclusion of regulatory requirements as well as maintaining vendor and industry relations.

*Ability to receive Security clearance is required for this role minimum of 5 consecutive years of residency in Canada and compliance with investment trading disclosure.

What will you do

• Mentor and manage a team of SQL Server database administrators who support the suite of client applications and projects.
• Knowledge of the SQL Server Engine Data Management and Business Intelligence tools (SSIS SSMS SSRS SSAS) for SQL2016 version or greater
• Mentor staff with varying proficiencies in diverse technologies and in a multiplatform environment.
• Participate in yearly employee performance reviews.
• Guide employees withy career paths training and growth opportunities.
• Some experience in the management and support of all databases and related software for SLFs mission critical SQL Server and Sybase applications. This includes performance and capacity monitoring query tuning and optimization.
• Engage with architects and infrastructure team to refine the ongoing strategy for the SQL Server and Sybase databases and possibly participate in architectural change projects.
• Provide team with leadership and direction in support of crisis management business continuity disaster recovery and incident response in a worldwide business environment.
• Ensure adherence to company policies for audit and security requirements.
• Collaborate and work closely with several different functional areas to provide all the necessary support for every database requirement.
• Participate in the Data Management Services budget process with respect to anticipated client application demand.
• Work closely with application owners to deliver database solutions.
• May work with Business Unit leaders at all levels in proactive advancement of database technology order to leverage new technologies for business advancement.
• Support technology solutions and approaches that position Data Management Services for improved database activities including reporting without impact to application performance or data integrity.

What do you need to succeed

• Expert knowledge of SQL Server database technologies and knowledge of other DBMS in particular Microsoft SQL Server and Sybase.
• Excellent/strong leadership people management presentation consulting negotiation interpersonal communication motivational organizational and planning skills to mentor a team of systems specialists who are serving a variety of business units.
• Experience with Employee performance evaluations.
• Knowledge of Dev/Ops and automation tools such as Ansible Jenkins etc.
• Strong business acumen and knowledge/appreciation for a wide variety of application and infrastructure technologies and processes.
• Ability to develop strong relationships with all levels of management and staff.
• Capable of summarizing concepts clearly concisely and accurately.
• Selfstarter strategic thinker and intellectually innovative.
• Values differences of opinion and works to achieve consensus.
• Experience of Agile and Waterfall methodologies.

Whats in it for you:

• Were honoured to be recognized as a 2024 Best Workplaces in Ontario by Great Place to Work Canada.
• We are thrilled to be recognized by Excellence Canada with their toplevel certification the Canada Order of Excellence for Mental Health at Work for prioritizing employee wellbeing fostering a positive work culture and achieving excellence in mental health.
• Were proud to be recognized as a company with a 2023 Most Trusted Executive team by Great Place to Work Canada.
• Wellness programs that support the three pillars of your health 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 date and the role will also require Star Compliance.

Must be able to satisfactorily complete applicable background checks prior to the start date and during employment in accordance with Sun Lifes policies and practices.

The 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 email 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: