What is the opportunity?

As DB2 Database Developer you will lead DB2 LUW projects and initiatives in multiple Agile Labs.  We are looking for a passionate DBA with strong database architecture skills and leadership, effective written and verbal communication skills, a strong work ethic and a demonstrated capability to multi-task effectively.  This role requires a positive attitude and a willingness to take accountability for results achieved.

What will you do?

• Create and maintain DB2 database & transaction processing environments for application testing, pre-production verification and production operation.

• Work closely with agile teams and other stakeholders to understand their database requirements and assist in building database solutions that cater to their needs.

• Provide DBA technical support to a list of critical Insurance applications that use DB2 LUW.

• Ensure DB2 databases are optimally designed so that applications meet their defined SLAs, maximize reuse of existing database structures, and minimize operational costs.

• Assist RBC infrastructure teams with DB2 LUW version upgrades, maintenance, and enhancement of database products.

• Ensure enterprise database standards are followed and aligned to overall RBC guidelines.

Must Have:

• 5+ years’ experience as DBA supporting critical applications that use DB2 LUW in standalone and HADR/Cluster environments. 

• Strong technical knowledge of IBM DB2 database including data modeling, stored procedures, views and optimization.

• High level of proven competence with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning

• Good knowledge on Unix shell scripting and database backup tools such as Networker

• Good knowledge on mainframe JCL, Jira, Service Now, GITHub, OnDemand and Zeke

• Excellent collaboration skills and proven ability to adapt to challenges, coaching and mentoring.

• Strong communication, analytical and negotiation skills, including conceptual, requirements interpretation, solution creation and problem-solving abilities.

• Quick learner on areas you never worked on.

Nice to have:

• Bachelor’s degree in Computer Science, Engineering or equivalent.

• Knowledge/experience administering IBM Integrated Analytics System appliance.

• Knowledge/experience with Microsoft SQL Server, MongoDB, MySQL.

• Knowledge/experience using database backup tools and managing data retention policies.

• Insurance and/or Financial Industry experience.

What’s In 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.

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGAMississaugaCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2026-04-142026-05-04

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

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.