DB2 / IMS Database Administrator

Jobgether; Canada; A distancia; CAD 92.000 - 142.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health coverage

Remote work within Canada

Wellbeing programs

Life and disability insurance

Retirement savings plan

Paid time off

Flexible benefits

Descripción de la vacante

Jobgether is partnering with a client in Canada to hire a Senior Db2/IMS Database Administrator. The role focuses on maintaining IBM Db2 for z/OS and IMS databases in large-scale production environments, with emphasis on performance, security, and recoverability.

You will collaborate across application, infrastructure, and operations teams, participate in on-call rotations, and drive operational excellence through documentation, runbooks, and best practices. Remote within Canada.

Formación

• At least 10 years hands-on IBM Db2 for z/OS and IMS DB/DC administration experience.
• Strong knowledge of Db2 backup/recovery utilities and IMS recovery/reorganization tools.
• Proficient with z/OS, JCL, and TSO/ISPF for daily operations.
• Ability to document procedures and maintain operational runbooks.
• Familiar with ITIL-based incident, change, and problem processes.

Responsabilidades

• Administer, maintain, monitor, and optimize IBM Db2 for z/OS and IMS databases.
• Create, modify, and maintain database objects; support related teams.
• Monitor health, availability, performance, and storage; address bottlenecks.
• Execute backup, recovery, DR procedures; participate in DR exercises.
• Resolve production incidents and coordinate with teams during critical events.
• Support IMS DBRC/RECON, DBD/PSB/ACB management, and IMS utilities.
• Maintain technical docs and operational runbooks; follow ITIL practices.
• Provide database design guidance to development teams for stability.

Conocimientos

IBM Db2 for z/OS

IMS DB/DC administration

Db2 performance monitoring

Db2 backup/recovery utilities

JCL/TSO/ISPF

On-call rotation experience

Documentation and runbooks

Herramientas

Db2 Platinum utilities

IMS DBRC/RECON

DB2 BIND/REBIND

IDCAMS

SMP/E

Omegamon

CA/BMC tools

Descripción del empleo

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a DB2 / IMS Database Administrator based in Canada.

We are seeking an experienced database professional to support and optimize mission-critical IBM Db2 for z/OS and IMS environments. In this role, you will help maintain the performance, availability, security, and recoverability of large-scale mainframe databases. You will collaborate with application development, infrastructure, and operations teams to resolve complex technical challenges and ensure reliable production services. Your expertise will contribute to database modernization, performance optimization, disaster recovery readiness, and operational excellence. This is a remote opportunity for a highly skilled administrator comfortable working in business-critical environments and participating in a formal on-call rotation. The ideal candidate combines deep technical knowledge with strong troubleshooting, documentation, and cross-functional collaboration skills

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.

How Jobgether works:

We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.

We appreciate your interest and wish you the best!

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.