Senior DB2 DBA

MainframeMaster; Toronto; On-site; CAD 98,000 - 210,000; Full time

Job summary

MainframeMaster in Toronto is seeking a Senior DB2 DBA (z/OS) to design, optimize, and support enterprise Db2 environments powering critical financial applications.

You will administer Db2, ensure high availability, implement security, tune SQL, manage backups, and collaborate with developers and architects across the platform to deliver reliable data services.

Qualifications

• 7+ years of hands-on Db2 for z/OS experience.
• Experience with Db2 z/OS Version 12 or higher.
• Strong understanding of security, backups, recovery, and HA for Db2 environments.

Responsibilities

• Administer, monitor, and support Db2 for z/OS environments in production and non-production settings.
• Design and implement secure, scalable Db2 solutions and optimize performance.
• Lead change management and coordinate deployments of database changes to production.
• Troubleshoot complex database and connectivity issues and provide guidance on SQL tuning and access paths.

Skills

SQL performance tuning

Database design

Problem solving

Education

Bachelor's degree in Computer Science or related field

Tools

Db2 for z/OS

JCL

TSO/ISPF

DB2 Utilities

Job description

# Senior DB2 DBABMOFull-timeToronto, ON, CANUSD 70,000 - 150,0000 viewsPosted October 21, 2026## Job DescriptionDrive the Data Platforms Powering One of Canada's Leading Financial InstitutionsAt 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 DoAs a key member of our Db2 DBA Dev team, you will: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.## Requirements & SkillsWhat You'll BringRequired Experience & Qualifications7+ 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 QualificationsExperience 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 certificationExperience working within large, regulated enterprise environments## How to ApplyApply directly through the application link above