SQL Server DBA - Jobs in North York, ON

Job 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. 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.Role Summary:The candidate will be a member of the SQL Server Client team within Data Management Services (DMS). The primary role on the team will be as a SQL Server Database Administrator supporting various client applications, but the individual may be asked to take on additional duties including infrastructure support and training on various emerging technologies related to Business Intelligence and Big Data solutions.The team has members in Canada, the US and India supporting a wide range of distributed and mainframe applications across many continents. The core hours for this position are 08:00 – 16:30 but are flexible within a range as long as there is proper coverage within the team. All team members must have the ability to handle 7X24 rotational on-call duties, after hour change support and disaster recovery support (will require cell phone, laptop and guaranteed coverage from home).What will you do

• Administrative support of SQL Server versions 2005, 2008, 2012, 2014 and 2016 including: Database Engine, Integration Services (DTS, SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Infrastructure support of SQL Server versions 2005, 2008, 2012, 2014 and 2016 including: server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development (as needed by Infrastructure manager)
• Support of application and database upgrades from existing SQL versions to, SQL2012, SQL2014, SQL2016 and future supported releases
• Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues
• Migration of database objects from development through production following documented standards, policies and procedures (Change Management Process)
• Monitoring and support of nightly production batch cycles
• Organizing and monitoring personal workload and escalating to manager when issues arise
• Regular review of database maintenance and performance improvement procedures
• Ensuring the proper setup and validation of backup and restore processes
• Participation in a rotational on-call schedule
• Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
• Regular database capacity planning related to database growth and system utilization; trend analysis
• Working 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
• Helping define, document and implement consistent standards and procedures across the team
• Support of PowerShell, Ansible, T-SQL stored procedures and functions to support internal processes and improve system performance
• Maintaining up-to-date documentation and procedures for all supported applications and environments
• Managing medium to large projects and participating in a variety of projects through the entire project lifecycle
• Maintaining 99.99% availability for all production environments
• Assisting clients with various issues related to connectivity, permissions, access
• Evaluation of functionality and features with newer versions of the SQL Server DBMS
• Sharing ideas for process improvement and innovative solutions to known problems

What will 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 to 5 years of SQL Server database administration experience handling medium to large databases
• Excellent verbal and written communication skills
• Experience with the Microsoft BI stack
• Experience with on-call support and trouble-shooting
• Strong T-SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning
• SQL Server 2008, 2012, 2014 or 2016 certification (optional)
• Hands-on experience with SQL Server installations and patching
• Strong knowledge of SQL Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools
• Strong knowledge of SQL Server Management Studio and Business Intelligence Development Studio
• Strong knowledge of SQL Server database backup and recovery strategies
• Strong knowledge of SQL Server replication, mirroring, log shipping, maintenance plans and DR recovery strategies
• Experience with Sybase Power Designer
• Experience with Redgate SQL Backup tools
• Knowledge of data-mapping and logical and physical data modeling
• Strong organizational skills with the ability to handle several tasks efficiently

Whats in it for you

• Being part of our journey in developing the next greatest digital experience
• Flexible Benefits from the day you join to meet the needs of you and your family
• Pension, stock and savings programs to help build and enhance your future financial security
• A ‘dress for the day’ dress code, where you dictate how you dress based on your day
• Great Place to Work® Certified in Canada and the US.
• Named 2021 “Best Places to Work” by Glassdoor
• Canada Award for Excellence for Mental Health at Work - 2021
• Flexible hybrid work model including in-country work-from-home if you prefer.
• Pension, stock and savings programs to help build and enhance your future financial security
• Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
• A friendly, collaborative, and inclusive culture
• Be part of our continuous improvement journey in developing the next greatest digital enterprise experience.

Unique RequirementsThe candidate selected for this role is required to have special clearance from the Royal Canadian Mounted Police. To see if you are eligible for this clearance, please review the section 201 on the Federal Government site (https://www.tpsgc-pwgsc.gc.ca/esc-src/personnel/pdcf-rsrp-eng.html)#LI-RemoteThe 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 thebrightside@sunlife.com.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.Sun Life is committed to the health and safety of all those in our workplaces and our communities. In accordance with Sun Life’s Vaccination Policy (Canada):

• Employees permitted to work remotely are required to be fully vaccinated against COVID-19 in order to attend a Sun Life office, Financial Centre or offsite location where activity related to Sun Life business occurs.
• Employees whose job duties require them to attend a Sun Life office, Financial Centre or offsite location for Sun Life business must be fully vaccinated against COVID-19 effective May 1st.
• Employees whose regular workplace is a Financial Centre and SLFD field leaders must be fully vaccinated against COVID-19 or participate in Sun Life’s Rapid Screening Program to attend a Financial Centre or an offsite event.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.Salary Range:56,300/56 300 - 92,900/92 900Job Category:IT - Technology ServicesPosting End Date:05/05/2022Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected