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 prospect 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. - 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. - 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.

📌 Database Administrator REMOTE (Canada)
🏢 Jobgether
📍 Canada