Senior DB2 DBA

BMO; Toronto; Hybrid; CAD 70,000 - 150,000; Full time

Benefits offered by this job

Hybrid work model

Health insurance

Tuition reimbursement

Retirement savings plans

Job summary

BMO is seeking a Senior Database Administrator (Db2 z/OS) to join the Mainframe Platform & Application Services team. You will design, optimize, and support enterprise Db2 environments powering critical applications across the bank.

We value collaboration with engineers, developers, and partners to ensure secure, resilient, and high-performing platforms. The role offers a hybrid work model and comprehensive benefits.

Qualifications

• 7+ years of hands-on Db2 for z/OS experience.
• Experience with Db2 z/OS Version 12+.
• Strong design, administration, and maintenance of Db2 environments.
• Proficiency in z/OS, JCL, TSO/ISPF and mainframe tech.

Responsibilities

• Administer and support enterprise Db2 z/OS environments.
• Design and deploy secure, scalable database solutions.
• Coordinate changes through change management for production deployments.
• Collaborate with development teams to deliver performant DB solutions.
• Troubleshoot complex database, application, and connectivity issues.

Skills

Db2 z/OS experience

Mainframe

SQL tuning

JCL/TSO/ISPF

Education

Bachelor's degree in CS/IT

Tools

Db2 Connect

ISPW

QMF

Job description

Application Deadline

10/30/2026

Location

4100 Gordon Baker Road

Job Family Group

Technology Senior DB2 DBA

Senior Database Administrator (Db2 z/OS)

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. We are looking for a Senior Database Administrator (Db2 z/OS) to join our Mainframe Platform & Application Services team. In this role, you'll help design, optimize, and support the mission‑critical database environments that power enterprise applications across the bank. You'll collaborate with talented engineers, developers, architects, and business partners to ensure our platforms remain secure, resilient, and high performing. If you're passionate about database technology, enjoy solving complex technical challenges, and want to make a meaningful impact within a large‑scale enterprise environment, we'd love to hear from you.

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.

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.

Salary

Salary: $70,000.00 - $150,000.00 Pay Type: Salaried The above represents BMO Financial Group’s pay range and type. Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part‑time roles will be pro‑rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position. BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance‑based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world. As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in‑depth training and coaching, to manager support and network‑building opportunities, we’ll help you gain valuable experience, and broaden your skillset. To find out more visit us at https://jobs.bmo.com/ca/en.

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Who we are We’re proud to be fueling growth and expanding possibilities for individuals, families and businesses. More than 12 million customers count on us for personal and commercial banking, wealth management and investment services. As the 8th largest bank in North America by assets, we provide personal and commercial banking, wealth management and investment services to more than 12 million customers. In Canada, the United States and across the globe, we’ll continue to build, invest and transform to drive performance that serves the good that grows.