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.