Senior DB2 DBA

Bank N.A.; Toronto; Hybrid; CAD 110,000 - 140,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

BMO in Toronto is seeking a Senior DB2 DBA to optimize and lead Db2 for z/OS environments, ensuring secure, reliable, and high-performing database platforms for enterprise workloads. You will design and deploy robust database solutions, perform tuning, implement backup/recovery strategies, and collaborate with development teams for resilient data services.

The role supports a hybrid work model with two onsite days weekly.

Qualifications

• 7+ years hands-on experience supporting Db2 for z/OS environments.
• Proven experience with Db2 z/OS Version 12 or higher.
• Strong expertise in database design, implementation, administration, and maintenance.
• Solid experience with z/OS, JCL, TSO/ISPF, and mainframe technologies.

Responsibilities

• Administer, monitor, and support enterprise-scale Db2 for z/OS environments.
• Design, implement, and maintain secure, scalable, and highly available database solutions in non-production environments.
• Prepare and deploy database changes through established change management processes into production environments.
• Partner with application development teams to deliver high-quality, performant, and resilient database solutions.
• Perform logical and physical database design while ensuring adherence to enterprise standards for data integrity, security, and performance.
• Provide expert guidance on SQL design, SQL optimization, performance tuning, backup and recovery strategies, stored procedures, and database architecture.
• Troubleshoot and resolve complex database, application, and connectivity issues, including distributed applications utilizing JDBC and ODBC/CLI connectivity.
• Analyze and optimize database performance to support business-critical workloads.
• Develop and maintain database security standards, governance practices, and operational procedures.
• Contribute to continuous improvement initiatives, automation opportunities, and modernization efforts across the database ecosystem.
• Collaborate with cross-functional technology teams to support strategic projects and enterprise transformation initiatives.

Skills

Db2 for z/OS expertise

SQL performance tuning

Data security practices

Disaster recovery planning

Education

Bachelor's degree in Computer Science or related field

Tools

Db2 Connect

CICS

ISPW

PowerDesigner

QMF

Job description

Application Deadline:

10/30/2026

Address:

4100 Gordon Baker Road

Job Family Group:

Technology

Senior DB2 DBA

Drive the Data Platforms Powering One of Canada's Leading Financial Institutions

At BMO , we're driven by a shared Purpose: Boldly Grow the Good in business and life . Our technology teams play a critical role in delivering secure, reliable, and innovative banking solutions that millions of customers depend on every day.

What You'll Do

• Administer, monitor, and support enterprise-scale Db2 for z/OS environments.
• Design, implement, and maintain secure, scalable, and highly available database solutions in non-production environments.
• Prepare and deploy database changes through established change management processes into production environments.
• Partner with application development teams to deliver high-quality, performant, and resilient database solutions.
• Perform logical and physical database design while ensuring adherence to enterprise standards for data integrity, security, and performance.
• Provide expert guidance on SQL design, SQL optimization, performance tuning, backup and recovery strategies, stored procedures, and database architecture.
• Troubleshoot and resolve complex database, application, and connectivity issues, including distributed applications utilizing JDBC and ODBC/CLI connectivity.
• Analyze and optimize database performance to support business-critical workloads.
• Develop and maintain database security standards, governance practices, and operational procedures.
• Contribute to continuous improvement initiatives, automation opportunities, and modernization efforts across the database ecosystem.
• Collaborate with cross-functional technology teams to support strategic projects and enterprise transformation initiatives.

What You'll Bring

Required Experience & Qualifications

• 7+ years of hands-on experience supporting Db2 for z/OS environments.
• Proven experience with Db2 z/OS Version 12 or higher .
• Strong expertise in database design, implementation, administration, and maintenance.
• Solid experience with z/OS, JCL, TSO/ISPF , and mainframe technologies.
• Experience supporting distributed Db2 applications and connectivity solutions.
• Strong SQL performance tuning and query optimization capabilities.
• Deep understanding of Db2 security architecture and controls.
• Experience with Db2 utilities, plans, packages, access paths, Explain, LOBs, triggers, stored procedures, and user-defined functions.
• Experience with Db2 data sharing environments and high-availability solutions.
• Practical expertise in backup, recovery, and disaster recovery processes.
• Strong analytical, troubleshooting, and problem-solving abilities.
• Understanding of the Software Development Life Cycle (SDLC) and change management practices.
• Excellent collaboration, communication, and relationship management skills.
• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.

Preferred Qualifications

• Experience with one or more of the following technologies and tools:
• Db2 Connect configuration and implementation utilizing AT-TLS
• RACF, ACF2, or other enterprise security products
• Db2 Explain
• ISPW
• GitHub
• Visual Studio Code with Db2 extensions
• ESP
• CICS
• Data replication technologies
• NDM
• IBM Change Management Tool Catalog Manager
• IBM Query Monitor
• IBM Log Analysis Tool
• Omegamon
• AQT
• QMF
• ServiceNow
• Additional assets:
• Knowledge of COBOL, PL/I, Assembler, REXX, or CLIST
• Experience with data modelling and tools such as PowerDesigner
• Db2 for z/OS certification
• Experience working within large, regulated enterprise environments

Why Join BMO?

At BMO, you'll have the opportunity to work on large-scale platforms that support millions of customers while collaborating with some of the industry's most talented technology professionals.

You’ll benefit from:

• Meaningful work with enterprise-wide impact
• A culture that values inclusion, collaboration, and continuous learning
• Access to leading technologies and modernization initiatives
• Career growth and development opportunities across a global organization
• Flexible hybrid work arrangements
• A supportive environment where your ideas and expertise help shape the future of banking technology

Hybrid Work Model: This role requires in-office presence two days per week .

Ready to make