Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Join Sun Life's Data Management Services team as a SQL Server Infrastructure Database Administrator. You will modernize our database infrastructure across distributed systems supporting Canada and the US, focusing on database automation and cloud integration.

Responsibilities

• Lead SQL Server initiatives from concept to deployment, including software releases, security upgrades, feature optimization, and infrastructure scaling.
• Design and implement automated database deployment pipelines, integrating DevOps practices.
• Architect and deploy robust SQL Server environments, including standalone instances, failover clusters, and AlwaysOn Availability Groups.
• Create and maintain operational best practices and documentation.
• Architect comprehensive backup/restore strategies and validate recoverability.
• Proactively monitor database stability, performance, and availability using diagnostic tools and AI-powered tuning.
• Partner with technical leads, IT teams, and application support to deliver seamless database services.
• Champion process innovations and contribute forward-thinking solutions.

Requirements

• University level degree in Computer Science or related information technology degree/diploma.
• 2-3+ years of experience with database concepts, business requirements, data-mapping, and logical/physical data modeling.
• 2-3+ years of experience with SQL Server database resiliency strategies (AlwaysOn, replication, log shipping, maintenance plans, DR recovery strategies).
• Hands-on experience provisioning, configuring, and scaling SQL Server Environments (including Availability Groups and FCI) using Terraform or Ansible.
• Advanced PowerShell proficiency for automation scripting, environment validation, and configuration management.
• Familiarity with leveraging AI-powered performance tools (SQL Automatic tuning, Intelligent Query processing).
• Strong engineering capabilities in bridging on-premises with cloud capabilities (e.g., AWS EC2/RDS).
• Reliability Security Clearance required.
• Must be able to satisfactorily complete applicable background checks.

Skills

• SQL Server
• Database Administration
• Infrastructure Modernization
• Database Automation
• Cloud Integration
• DevOps
• Terraform
• Ansible
• PowerShell
• AI-Driven Performance Tuning
• AWS EC2
• AWS RDS

Location

• Canada
• US

Work Type

• Hybrid
• Remote
• 24/7 rotational on-call responsibilities
• after-hours change management

Experience Level

• 2-3+ years

Education Level

• University level degree in Computer Science or related information technology degree/diploma

Salary/Compensations

• 65,000 - 105,000

Benefits

• Wellness programs supporting mental, physical, and financial health.
• Opportunity for career path variety and networking.

About the Company

• Sun Life is driven by its Purpose: helping Clients achieve lifetime financial security and live healthier lives.
• Values: caring, authentic, bold, inspiring, and impactful.
• Recognized as a 2026 Best Workplaces in Canada by Great Place to Work® Canada.
• Recognized by Excellence Canada with their top-level certification, the Canada Order of Excellence for Mental Health at Work®.

Equal Opportunity

• Diversity and inclusion are at the core of our values.
• A diverse workforce with wide perspectives and creative ideas benefits our Clients, communities, and colleagues.
• Applications are welcomed 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.