Senior Mainframe DB2 Support Specialist (z/OS)

Canada Mortgage and Housing Corporation

Montreal, QC
$104,180-130,225 per year
Permanent
Full-time

1 day ago

Job Requisition ID: 11968Position Status: Permanent Full TimePosition Type: HybridOffice Location: Ottawa (ON); Calgary (AB); Halifax (NS); Montreal (QC); Toronto (ON); Vancouver (BC)Travel Requirement: LimitedLanguage Designation: English EssentialLanguage Skill Levels (Read/Write/Speak): ZZZSecurity Requirement: SecretSalary: Our salaries generally range from $ 104,180.28 to $ 130,225.36 and are based on qualifications and experience.About CMHCThe work you do and the work we do together matters. We come to work every day with a common purpose: to contribute to a well-functioning housing system.At CMHC, we hold ourselves accountable for our results and support our colleagues in their achievements. We thrive on collaboration, connecting across CMHC and involving the right people to get our work done. Our leadership style is guided by trust, where our leaders favour an adaptive approach based on the needs of their teams.Join us and be part of a team that's committed to making a real difference and be part of something meaningful.What's in it for youWe've got the purpose, the people and the perks you need for a fulfilling career. Here's the comprehensive and generous benefits you get when you're a permanent employee:

Annual Paid vacation.
Annual individual performance incentive.
Defined benefit pension plan.
Comprehensive group insurance plan to support your well-being from day one.
Support towards your personal and professional growth with training, mentorship and more.
An inclusive workplace culture and environment.
While positions at CMHC require some in-office presence, alternative work arrangements may be considered for Indigenous candidates.

About the role
Join the Infrastructure and Operations Team, in the Senior Mainframe DB2 Support Specialist (z/OS) position. The successful candidate will play a key role in ensuring database availability, performance, security, and recoverability for enterprise mainframe applications. This is a hands on role requiring deep technical expertise, strong problem solving skills, and the ability to collaborate with infrastructure, application, and operations teams.What you'll do:

Provide Level 3 support for IBM DB2 on z/OS, including incident management, root-cause analysis, and production issue resolution.
Install, configure, upgrade, and maintain DB2 subsystems and support z/OS components.
Monitor and tune DB2 performance, including SQL, buffer pools, storage, and system parameters.
Manage and optimize DB2 objects (tablespaces, indexes, plans, packages).
Design, implement, and test backup, recovery, disaster recovery, and high-availability solutions, including data sharing environments.
Ensure compliance with security, audit, and regulatory requirements, managing access controls and privileges.
Analyze complex performance problems and partner with application teams on SQL optimization and schema changes.
Act as a DB2 subject-matter expert, mentoring staff and collaborating across development, systems, and operations teams.

What you should have:

A bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
7+ years of hands on experience supporting IBM DB2 on z/OS (Mainframe).
.Strong knowledge of:

DB2 subsystem architecture and internals.
z/OS operating system concepts.
SQL performance tuning and access path analysis.
Proven experience with:

Backup, recovery, and disaster recovery procedures.
DB2 utilities and common third party tools (e.g., BMC, Broadcom, IBM tools).
The ability to troubleshoot complex, high impact production issues.
Excellent analytical, documentation, and communication skills.

It would be great if you also had:

Experience with DB2 Data Sharing Environments.
Exposure to CICS, IMS, or batch processing workloads.
Familiarity with automation, scripting, or DevOps practices on the mainframe.
Knowledge of capacity planning and performance engineering.
IBM DB2 or z/OS certifications.

Posting closing date: Note, the competition will remain active until filled.Standby and Call Back duties are a requirement of this position and will be subject to CMHC policies, including the Standby and Call Back Pay Procedure.Our commitment to diversity, equity, and inclusionWe're committed to employment equity and encourage women, Indigenous Peoples, persons with disabilities, veterans and persons of all races, ethnicities, religions, abilities, sexual orientations, and gender identities and expressions to apply. We also welcome applications from non-Canadians who are eligible to work in Canada.CMHC is an inclusive workplace where diversity of thought - and of people - are recognized, valued, and considered essential to achieving our mission.What happens after you applyWe know that applying for a new job can be both exciting and daunting, and we appreciate your effort. . If you are selected for an interview or testing, please advise us if you require an accommodation.If you applied before and you were not successful don't worry - we're always posting new positions, so don't hesitate to give it another shot. We're excited to see what you bring to the table this time around!

Canada Mortgage and Housing Corporation

Apply Now