Infrastructure Dba

You are as unique as your background, experience and point of view. Here, you’ll 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 Server’s use at Sunlife, both on prem and in cloud. The role consists of occasional participation in after-hours and weekend support of projects, infrastructure activities, as well as various disaster recovery exercises as may be required.
- **Ability to receive Security clearance is required for this role [minimum of 5 consecutive years of residency in Canada] and the role will also require Star Compliance.**

**What will you do**:

- Provide technical leadership and direction for SQL Server. Designing new patterns of deployment, evaluating new tools to improve DMS’ service to their clients
- Define and document best practices for the global deployments of SQL Server
- 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?**
- 5+ years of SQL Server database experience supporting both infrastructure and development teams.
- 3+ years of administrative support of SQL Server versions including: Database Engine, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
- 3+ years of experience and support with AWS Cloud technologies and database workload
- Manage large and complex projects 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
- Evaluation of functionality and features with newer versions of the SQL Server DBMS as part of a readiness program
- Deep SQL Server knowledge that includes a thorough understanding of SQL internals, system tables, stored procedures, functions, triggers, and SQL tuning

**What’s in it for you?**
- Challenged by a role that is non repetitive, constantly changing, working on complex problems and results that concretely improve the Sun life organization
- Being part of our journey in developing the next greatest digital experience
- Flexible Benefits from the day you join to meet your and your family’s needs
- Wellness programs that support the three pillars of your health - mental, physical and financial
- An extensive support system for continual learning including company-run courses, access to online learning platforms and vendor led technical sessions.
- A flexible work schedule, that supports core business hours

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**:
61,000/61 000 - 101,000/101 000

**Job Category**:
IT - Technology Services

**Posting End Date**:
12/05/2024