MI

Mainframe DB2 Manager / Associate Manager

Mindteck (India) Limited
Remote ₹20-30 LPA Posted 11 Nov 2026
FULL TIME
CA DB2 Utilities Migration
DB2 Database Administration (DBA)
DB2 System Administration
IBM DB2 for z/OS
IBM DB2 Utilities Suite for z/OS

Job Description

Position Summary

  • We are looking for an experienced IBM DB2 on z/OS System Administrator / DBA who has hands-on experience migrating CA DB2 utilities to the IBM DB2 Utilities Suite for z/OS. This role focuses on DB2 subsystem administration, database performance management, backup and recovery, software migration, and production support to help ensure database availability, integrity, and optimal performance.

Key Responsibilities

1. Product Migration

  • Lead or support migration from CA DB2 utilities to IBM DB2 Utilities Suite for z/OS.
  • Plan and execute migration, configuration, testing, validation, and post-migration support.
  • Relevant migration experience includes:
  • CA Fast Check for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS.
  • CA Fast Index for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS.
  • CA Fast Load for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS.
  • CA Fast Recover for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS.
  • Maintain data integrity, compatibility, and minimal disruption throughout the migration process.
  • 2. DB2 System Administration
  • Install, configure, upgrade, and maintain DB2 subsystems on z/OS.
  • Manage DB2 databases, tablespaces, tables, indexes, and overall subsystem configurations.
  • Support DB2 version upgrades, migrations, and ongoing maintenance activities.
  • 3. Database Performance & Tuning
  • Monitor DB2 performance and optimise SQL queries, access paths, and resource utilisation.
  • Conduct performance tuning using DB2 tools and utilities.
  • Detect and resolve database performance bottlenecks.
  • 4. Backup, Recovery & Utilities
  • Run and manage DB2 utilities, including REORG, RUNSTATS, LOAD, COPY, and RECOVER.
  • Own backup and recovery strategies to ensure data availability and integrity.
  • Troubleshoot database recovery processes and utility-related issues.
  • 5. Production Support & Change Management
  • Provide L2/L3 support for DB2 incidents and resolve issues within agreed SLAs.
  • Perform root cause analysis and implement permanent corrective actions.
  • Manage database changes, releases, and migrations through established CAB processes.
  • Maintain technical documentation and update change records.
  • 6. Security, Monitoring & Collaboration
  • Manage DB2 security, access controls, and audit compliance requirements.
  • Monitor storage, buffer pools, and resource utilisation; support capacity planning activities.
  • Coordinate with application, z/OS, and infrastructure teams for releases, integrations, and data migrations.

Required Skills & Qualifications

  • Strong hands-on experience with IBM DB2 on z/OS in both system administration and DBA responsibilities.
  • Demonstrated experience migrating CA DB2 utilities to IBM DB2 Utilities Suite for z/OS.
  • Thorough knowledge of DB2 utilities, including REORG, RUNSTATS, LOAD, COPY, and RECOVER.
  • Ability to deliver SQL tuning, database performance optimisation, and troubleshooting expertise.
  • Experience with DB2 subsystem administration, including upgrades, backup, and recovery.
  • Familiarity with z/OS, JCL, and SDSF.
  • Experience with DB2 tools including SPUFI, QMF, and DB2 Administration Tool.
  • Strong incident management, change management, analytical, and problem-solving skills.

Ideal Candidate

  • The ideal candidate is a highly capable DB2 professional with deep expertise in z/OS database administration, performance tuning, and CA-to-IBM utility migration. The candidate must be able to handle complex migration efforts, support dependable database operations, and collaborate closely with application and infrastructure teams.
  • Hands-on experience migrating CA Fast Check, Fast Index, Fast Load, and Fast Recover to IBM DB2 Utilities Suite for z/OS is a strong advantage.

foundit: Fast. Faster. foundit. 10 lakh+ jobs, top recruiters hiring. Register nowSponsored
Join WhatsApp Channel