Intermediate Snowflake and Redshift 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.

Job Description:

The candidate will be a member of a team within Data Management Services (DMS) called Alternative Database Technologies. Alternative Database Technologies is responsible for database infrastructure architecture and operation support to teams using various cloud based and on-premises database platforms.

The successful candidate will have a passion for database related technologies and is a proven fast learner. This is an opportunity for someone who is expert in data warehouse technologies, preferably in Snowflake and Redshift.

What will you do:

• Maintain and optimize Snowflake and Redshift environments across dev, test, stage and production Participate in projects throughout the entire project lifecycle
• Manage infrastructure, permissions, resource monitors, warehouses, and network setting in Snowflake
• Collaborate with stakeholders to implement best practices
• Monitor usage and performance; troubleshoot issues and optimize queries
• Monitor Snowflake usage and spending trends, provide recommendations for cost optimization and efficient resource utilizations.
• Ensure compliance with internal and external data governance policies
• Refine existing data pipelines by improving query efficiency, indexing strategies, and automating repetitive tasks to reduce processing times and optimize resource utilization.
• Proactively monitors database and data pipeline performance, identifying and addressing inefficiencies, query bottlenecks, and latency issues. Use advanced diagnostic tools to analyze execution plans, optimize SQL queries, and ensure high database availability.
• Troubleshoot complex connectivity, replication, and system performance issues, working closely with infrastructure and DevOps teams to maintain database health and stability.
• Enforce database security best practices by managing user roles, permissions, and encryption protocols to protect sensitive data.
• automate reporting processes and build scalable data visualization tools that improve accessibility and decision-making across teams.

What you need to succeed:

• University degree in Computer Science or related information technology degree/diploma
• 2+ years of hands-on Snowflake administration/development experience
• 2+ years of experience in cloud native database technologies, i.e. AWS Redshift,  Oracle ADW etc.
• 2+ years of experience working with multiple platforms and types of data repositories (Relational, NOSQL, Datawarehouse, OLAP, OLTP etc.)

Preferred skills: 

• Understanding of schema design (relational and data warehouse), index design, operation optimization, query (or explain) plans
• Proficient in writing and optimizing SQL queries, stored procedures, and indexing strategies to improve efficiency.
• Direct experience with cloud-based database environments such as AWS RDS, Azure SQL, or Snowflake. Understand cloud-native database services, storage solutions, and cost optimization strategies.
• Proactive professional who thrives on the fast-paced release cycles of Snowflake and Redshift, transforming new features into operational value

Individual Skills:

• Developed strong problem-solving skills and actively works to diagnose and resolve complex database performance and system issues.
• A collaborative and flexible style, with a strong service mentality. Need to be seen as a team player. Comfortable working works closely with cross-functional teams,
• Excellent interpersonal and communication skills

What’s in it for you:

• We’re 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 top-level certification, the Canada Order of Excellence for Mental Health at Work®,  for prioritizing employee well-being, fostering a positive work culture, and achieving excellence in mental health.
• 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 need 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

Must be able to satisfactorily complete applicable background checks prior to the start date and during employment, in accordance with Sun Life’s 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 e-mail a request to [email protected].

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you! Several work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

Job Category:

Posting End Date: