Mainframe DB2 Manager / Associate Manager

Mindteck (India) Limited

India

Remote

INR 1,200,000 - 2,400,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Mindteck (India) Limited in India seeks an experienced IBM DB2 on z/OS System Administrator/DBA to manage DB2 subsystems, migrations, performance, backup, and production support ensuring data availability and integrity.

The ideal candidate will drive CA to IBM DB2 Utilities migrations, perform SQL tuning, handle upgrades, and collaborate with app and infrastructure teams to maintain reliable, scalable database operations.

Qualifications

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

Responsibilities

  • 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, Fast Index, Fast Load, Fast Recover to IBM DB2 Utilities Suite for z/OS.
  • Ensure data integrity, compatibility, and minimal disruption during migration.
  • Install, configure, upgrade, and maintain DB2 subsystems on z/OS.
  • Manage DB2 databases, tablespaces, tables, indexes, and subsystem configurations.
  • Support DB2 version upgrades, migrations, and maintenance activities.
  • Monitor DB2 performance and optimise SQL queries, access paths, and resource utilisation.
  • Perform performance tuning using DB2 tools and utilities.
  • Identify and resolve database performance bottlenecks.
  • Execute DB2 utilities, including REORG, RUNSTATS, LOAD, COPY, and RECOVER.
  • Manage backup and recovery strategies to ensure data availability and integrity.
  • Troubleshoot database recovery and utility‑related issues.
  • Provide L2/L3 support for DB2 incidents and resolve issues within SLAs.
  • Perform root cause analysis and implement permanent corrective actions.
  • Manage database changes, releases, and migrations through CAB processes.
  • Maintain technical documentation and change records.
  • Manage DB2 security, access controls, and audit compliance.
  • Monitor storage, buffer pools, and resource utilisation; support capacity planning.
  • Collaborate with application, z/OS, and infrastructure teams on releases, integrations, and data migrations.

Skills

IBM DB2 on z/OS
CA to IBM DB2 Utilities migration
DB2 utilities: REORG RUNSTATS LOAD REC
SQL tuning & performance optimization
DB2 subsystem administration
z/OS, JCL, SDSF
DB2 tools: SPUFI QMF DB2 Admin Tool
Incident & Change management

Tools

SPUFI
QMF
DB2 Administration Tool

Job description

Position Summary
  • We are seeking an experienced IBM DB2 on z/OS System Administrator / DBA with hands‑on experience migrating CA DB2 utilities to IBM DB2 Utilities Suite for z/OS. The successful candidate will manage DB2 subsystem administration, database performance, backup and recovery, software migration, and production support to 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.
  • Ensure data integrity, compatibility, and minimal disruption during migration.
  • 2. DB2 System Administration
  • Install, configure, upgrade, and maintain DB2 subsystems on z/OS.
  • Manage DB2 databases, tablespaces, tables, indexes, and subsystem configurations.
  • Support DB2 version upgrades, migrations, and maintenance activities.
  • 3. Database Performance & Tuning
  • Monitor DB2 performance and optimise SQL queries, access paths, and resource utilisation.
  • Perform performance tuning using DB2 tools and utilities.
  • Identify and resolve database performance bottlenecks.
  • 4. Backup, Recovery & Utilities
  • Execute DB2 utilities, including REORG, RUNSTATS, LOAD, COPY, and RECOVER.
  • Manage backup and recovery strategies to ensure data availability and integrity.
  • Troubleshoot database recovery 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 change records.
  • 6. Security, Monitoring & Collaboration
  • Manage DB2 security, access controls, and audit compliance.
  • Monitor storage, buffer pools, and resource utilisation; support capacity planning.
  • Collaborate with application, z/OS, and infrastructure teams on releases, integrations, and data migrations.
Required Skills & Qualifications
  • Strong hands‑on experience with IBM DB2 on z/OS at both system administration and DBA levels.
  • Proven experience migrating CA DB2 utilities to IBM DB2 Utilities Suite for z/OS.
  • Strong knowledge of DB2 utilities, including REORG, RUNSTATS, LOAD, COPY, and RECOVER.
  • Expertise in SQL tuning, database performance optimisation, and troubleshooting.
  • Experience in DB2 subsystem administration, upgrades, backup, and recovery.
  • Familiarity with z/OS, JCL, and SDSF.
  • Experience with DB2 tools such as SPUFI, QMF, and DB2 Administration Tool.
  • Strong incident management, change management, analytical, and problem‑solving skills.
Ideal Candidate
  • The ideal candidate is a technically strong DB2 professional with expertise in z/OS database administration, performance tuning, and CA‑to‑IBM utility migration. The candidate should be capable of managing complex migration activities, maintaining reliable database operations, and collaborating effectively 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 will be a strong advantage.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Z/OS Manager / Associate Manager
Z/OS Manager / Associate Manager

Mindteck (India) Limited • India

Remote
INR 1,400,000 - 2,100,000
[ZPH2AC29] Senior Mainframe Administrator
[ZPH2AC29] Senior Mainframe Administrator

ZettaMine Labs Pvt. Ltd. • Telangana

On-site
INR 4,000,000 - 7,000,000
Mainframe DB2 DBA
Mainframe DB2 DBA

AagatiServe Pvt Ltd • Bengaluru

On-site
INR 3,500,000 - 6,000,000
SeniorAdministrator - IBM DB2 for z/OS
SeniorAdministrator - IBM DB2 for z/OS

HCL Technologies Limited • Pandhurna

On-site
INR 1,200,000 - 1,800,000
Mainframe DB2 DBA
Mainframe DB2 DBA

BetaNXT Inc. • Bengaluru

On-site
INR 3,500,000 - 5,500,000
Mainframe Storage Manager / Associate Manager
Mainframe Storage Manager / Associate Manager

Mindteck (India) Limited • India

Remote
INR 3,500,000 - 6,500,000
IBM DB2 Database Engineer (Migration & Production Engg)
IBM DB2 Database Engineer (Migration & Production Engg)

Crisil • Chennai

On-site
INR 1,800,000 - 3,200,000
Senior DB2 z/OS Database Administrator
Senior DB2 z/OS Database Administrator

HCL Technologies Limited • Pune District

On-site
INR 1,500,000 - 2,700,000
Database Administrator - z/OS
Database Administrator - z/OS

SourcingXPress • Maharashtra

On-site
INR 1,200,000 - 2,400,000
Senior Mainframe Systems Programmer - DB2 Engineer
Senior Mainframe Systems Programmer - DB2 Engineer

ensono • Hyderabad

On-site
INR 1,800,000 - 3,200,000