SQL Server Dba - Waterloo, Canada - Sun Life

Sun Life

Verified Company

Waterloo, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

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.

About the role

This role requires Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada] and Star Compliance.

What will you do?

Support database workload in AWS Cloud and SQL expertise as a shared resource to Agile projects
Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of difficult SQL issues
Administrative support of SQL Server versions 2012, 2014, 2016, 2019 including: Database Engine, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
Migration of database objects from development through production following documented standards, policies and procedures (Change Management Process)
Participation in afterhours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
Support of PowerShell, T-SQL stored procedures and functions to support internal processes and improve system performance (if applicable)

What you need to succeed?:

BE/B Tech/MCA/M Tech/Proven administration/analyst skills preferably with a degree in Computer Science or related technology degree/diploma, or equivalent experience
3+ years of SQL Server database administration experience handling medium to large databases
Manage medium to large projects and participate in a variety of projects through the entire project lifecycle (if applicable)
Experience with AWS Cloud technologies
Experience with the Microsoft BI stack
Strong T-SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning
Handson experience with SQL Server installations and patching
SQL Server Certification (optional)

Preferred Skills

Excellent communication skills and experience in assisting clients with various issues related to connectivity, permissions and access
Analytical and problem solving skills with a keen attention to detail and the ability to consistently produce highquality deliverables
Strong organizational skills and monitoring skills with the ability to handle several tasks efficiently and escalate to manager when issues arise
Ability to work and lead projects with mínimal direction and to successfully juggle multiple tasks and priorities simultaneously
Good judgement in knowing when to escalate issues including seeking guidance when managing competing priorities and peak workload situations
Ability to evaluate functionality and features with newer versions of the SQL Server DBMS as part of a readiness program

What's in it for you:

Joining an organization that the industry calls 'one of the best places to work
Being part of our journey in developing the next greatest digital experience
Wellness programs that support the three pillars of your health mental, physical and financial
An extensive support system for continual learning including companyrun courses, access to online learning platforms, opportunity for rotations and cross training and more
A flexible work schedule within core business working 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/ ,000/101 000

Job Category:

IT - Technology Services

Posting End Date:

12/05/2024