Senior Software Developer - SQL/Python

RBC; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading bank in Canada is seeking a Senior Database/Python Developer to design and develop large-scale data projects in Wealth Management Global IT Data Services. The ideal applicant will have extensive experience in database technologies and programming with a focus on quality and performance optimization. This position offers competitive compensation and a comprehensive Total Rewards Program.

Benefits

Comprehensive Total Rewards Program

World-class training program

Flexible benefits and bonuses

Qualifications

• 5 years of experience in database and SQL Server technologies including Python.
• Solid SQL experience - querying, indexing, and performance optimization.
• Ability to analyze and improve database performance.

Responsibilities

• Design and develop applications and programs ensuring timely completion.
• Collaborate with teams to improve overall system performance.
• Provide technical guidance and mentorship to junior members.

Skills

Database and SQL Server technologies

Python

Snowflake

Active Learning

Agile Methodology

Tools

SQL Server

Python

Docker

Job description

Overview

We are seeking an experienced Senior Database/Python Developer to join our dynamic team in Wealth Management Global IT Data Services. The successful candidate will be responsible for designing and developing large-scale projects and programs, leveraging database technologies such as SQL Server, Snowflake, and Python. Provide information on the detailed technical design and development of applications using existing and emerging technology platforms. Apply experience and seasoned knowledge, skills, and practices to perform a variety of assignments.

What will you do

• Design and develop small to large applications and programs, ensuring design, reusability, defect-free, and timely completion.
• Develop high-quality, scalable, and maintainable code that meets the requirements and standards.
• Identify, track, and resolve technical issues, and develop/recommend mitigation strategies to ensure successful solution development and delivery.
• Collaborate with other teams to resolve technical issues and improve overall system performance.
• Collaborate with other teams to create new and modify existing database or infrastructure objects based on required functionality.
• Participate in walkthrough reviews of technical design, specifications, programs, and unit test plans.
• Assist DevOps/support teams in troubleshooting high-priority implementation issues, production investigations, and other activities.
• Provide technical guidance and mentorship to junior team members on database and Python development.

What you need to succeed

• 5 years of experience in database and SQL Server technologies, including Python and Snowflake.
• Solid experience in Microsoft SQL Server, including its various versions and editions, database design, implementation and maintenance.
• Solid SQL experience - including querying, indexing, and performance optimization.
• Solid experience with Transact-SQL (T-SQL) for stored procedures, functions and triggers.
• Knowledge of security best practices, including user management, roles, and permissions.
• Understanding of backup strategies and recovery models to ensure data integrity and availability.
• Ability to analyze and improve database performance, including query optimization and index management.

Nice to have

• Java: Experience with Java programming language
• Cloud: Experience with cloud platforms such as AWS, Azure, Google Cloud
• Database: SQL Server, Snowflake
• Programming Language: Python
• DevOps: Experience with DevOps tools and methodologies
• Containerization: Experience with containerization tools such as Docker

What’s in it for you?

• We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.
• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• A world-class training program in financial services

#LI-POST
#TECHPJ

Job Skills

Active Learning, Agile Methodology, Application Integrations, Detail-Oriented, Enterprise Application Delivery, Group Problem Solving, Programming Languages, Software Development Life Cycle (SDLC)

Additional Job Details

Address: RBC Centre, 155 Wellington St W, Toronto

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2025-09-13

Application Deadline: 2025-11-03

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

Join our Talent Community Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you. Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at RBC jobs.