DB2 / IMS Database Administrator.

Accountabilities

• Administer, maintain, monitor, and optimize IBM Db2 for z/OS and IMS databases in large-scale production environments.

• Create, modify, and maintain database objects, implement database changes, and support application and infrastructure teams with database-related requirements.

• Monitor database health, availability, performance, and storage capacity; investigate performance bottlenecks and recommend corrective actions.

• Execute and manage database maintenance utilities, including REORG, RUNSTATS, LOAD, and UNLOAD, as well as Db2 BIND/REBIND and access-path analysis.

• Manage backup, recovery, and disaster recovery procedures, troubleshoot restoration issues, and participate in scheduled disaster recovery exercises and business continuity testing.

• Resolve production incidents, service requests, and change activities, conducting root-cause analysis and coordinating with technical teams during critical situations.

• Support IMS DBRC/RECON administration, DBD/PSB/ACB management, IMS recovery and reorganization utilities, and Db2 utility restart and recovery processes.

• Maintain technical documentation, develop operational runbooks, support planned maintenance and production implementations, and follow established ITIL incident, problem, and change management practices.

• Provide database design guidance and technical recommendations to application development teams to help ensure stable, efficient, and recoverable database services.

Requirements:

• At least 10 years of hands-on experience with IBM Db2 for z/OS and IMS DB/DC administration in enterprise production environments.

• Strong expertise in Db2 and IMS database performance monitoring, troubleshooting, tuning, backup, recovery, and disaster recovery.

• Practical experience with Db2 backup and recovery utilities, DB2 Platinum utilities, IMS DBRC/RECON, DBD/PSB/ACB management, and IMS recovery and reorganization utilities.

• Knowledge of Db2 BIND/REBIND, access-path analysis, SQL performance tuning, and IBM utility restart and recovery behavior.

• Strong understanding of IBM z/OS mainframe environments, JCL, and TSO/ISPF.

• Experience supporting business-critical production systems, including data-sharing environments, and familiarity with ITIL-based operational processes.

• Strong written communication skills, with the ability to produce clear technical documentation and operational runbooks.

• Ability to collaborate effectively across application, infrastructure, and operations teams, manage complex incidents, and participate in a formal on-call rotation.

• Additional experience with IMS/DC, IMS/TM, VSAM/OSAM, REXX, COBOL, DFSORT, IDCAMS, SMP/E, OMEGAMON, BMC MainView for Db2/IMS, CA/BMC database tools, or Db2 Query Monitor is an asset.

• Must be legally authorized to work in Canada and hold Canadian citizenship or permanent resident status, as required by the Controlled Goods Program.

Benefits:

• Annual salary range: CAD $92,100–$142,100, depending on experience, relevant skills, qualifications, and organizational requirements.

• Remote work: Opportunity to work remotely from within Canada.

• Health coverage: Health, dental, and vision insurance.

• Wellbeing support: Employee wellness programs.

• Financial protection: Life and disability insurance.

• Retirement planning: Access to a retirement savings plan.

• Paid time off: Paid holidays and vacation or other paid leave.

• Flexible benefits: A comprehensive benefits program designed to support employee wellbeing and individual needs.