Junior Database Analyst

Our student and new graduate programs offer a chance to explore Sun Life from the inside. You’ll make a difference in the lives of our customers and communities, while building the skills and experience that allow you to grow in a meaningful and rewarding way.

Job Description:

As part of Digital, Business and Technology Solutions [DBTS], Data Management Services works with all areas of Sun Life Financial, supporting our business partners by providing technology solutions needed to achieve business excellence. This position offers great career growth opportunities using technologies including Ansible, AWS RDS, RDBMS, Linux, and others. There are a lot of opportunities if you are willing to learn. The ideal candidate should have a relentless desire for continuous improvement through the learning of new things, embracing emerging technologies and be a champion of new ideas, continually explore new perspectives, and embrace going beyond their comfort zone even at the risk of failure or embarrassment.

Term Length: 4-months (May - August 2025)

What will you do?

• Become familiar and follow existing SLF operation and security standard
• Monitor database alerts and ticket queue
• Participate in projects and understand user requirements
• Build new AWS RDS DB instances by using existing procedures and participate in AWS RDS instances miner version patching
• Assist Senior Database Analyst on project/application related database management tasks
• Review and Implementing DB scripts provided by clients
• Control access permissions and privileges
• Communicate regularly with colleagues on the health, integrity and security of database
• Perform other duties as assigned

What do you need to succeed?

• Enrolled in undergraduate degree majoring in technology programs, such as Computer Science, Engineering, Information Technology Management, Financial Analysis and Risk Management, Computing, etc.
• Some knowledge of RDBMS internals and any type of relational databases, such as MySQL, Oracle, PostgreSQL etc.
• Knowledge of database query languages such as SQL, PSQL and using AWS RDS would be considered an asset
• Knowledge of Basic Linux commands
• Great communication skills and ability to work independently and/or in teams
• Quick learner, share ideas, participate in small to medium size projects and take initiative to ask for more work as workload permits
• Organizational skills with the ability to multi-task

What's in it for you?

• A friendly, collaborative, and inclusive culture where you’re an innovator and trusted partner
• An environment of continuous learning and improvement
• We’re honoured to be recognized as a 2022 Best Workplaces in Canada by Great Place to Work Canada
• Enhance your technical, analytical and problem-solving skills, Relationship database management skills (PostgreSQL, Oracle, MySQL)
• AWS services skills such as RDS, CloudFormation, CloudWatch, KMS, stacks, secret manager etc.
• Gain leadership skills with taking in accountability of tasks and gain knowledge of business transactions, services and methodologies used in the global insurance industry

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.