Hello,

Greetings from ZettaMine Labs Pvt Ltd!!

We are looking for Senior Mainframe DB2 DBA with project opportunities.

Job Role: Senior Mainframe DB2 DBA

Location: Bangalore

Experience: 12+ Years

Relevant Experience: Minimum 12 Years of hands-on experience in Mainframe DB2 Database Administration with strong production support and DB2 utility experience.

Mandatory: Mainframe DB2 DBA + DB2 Administration + DB2 Utilities + JCL + Performance Tuning + Backup/Recovery + Reorg + Runstats + COPY + LOAD/UNLOAD + Space Management + DB2 Security + Production Support + DB2 Objects + IBM/BMC Tools

REQUIREMENT FOR SENIOR MAINFRAME DB2 DBA:

Key Responsibilities:

- Perform end-to-end DB2 database administration activities across TEST, QA, and PROD environments.
- Install, configure, maintain, upgrade, and patch Mainframe DB2 databases/subsystems.
- Create, modify, and maintain DB2 objects, DDL, and database privileges.
- Manage DB2 security, user permissions, access controls, and compliance.
- Perform database backup, recovery, disaster recovery, and restore activities.
- Execute and schedule DB2 maintenance utilities including COPY, REORG, RUNSTATS, QUIESCE, LOAD, and UNLOAD.
- Perform ad-hoc REORGs, RUNSTATS, and REBINDs in production environments.
- Monitor and manage DB2 database health, performance, capacity, and space utilization.
- Perform partition rebalancing and tablespace migration activities.
- Monitor housekeeping jobs including Image Copy, RUNSTATS, DDL/DML reports, and other DB2 maintenance processes.
- Create and schedule production DB2 utility and maintenance jobs.
- Implement and monitor production DB2 batch jobs across daily, weekly, and monthly cycles.
- Perform major data refreshes from Production to Test environments.
- Support refreshing, copying, recovering, reorganizing, and maintaining test and production databases.
- Perform database and DB parameter tuning to improve system performance.
- Assist application teams with SQL error diagnosis, performance tuning, and database-related technical issues.




- Support migration of DDL and DB2 objects across environments through Production.
- Implement DB2 objects across various environments, from TEST through PROD.
- Handle high-volume Production DB2 subsystems and provide 24x7 production support on a rotational basis.
- Participate in end-to-end release activities, production deployments, and implementation activities.
- Handle backup, recovery, and disaster recovery responsibilities for primary and secondary production environments.
- Work with application teams to provide technical guidance and resolve database-related issues.
- Participate in on-call and off-hours support as required.
- Act as a Technical Lead/ISME and provide technical guidance and knowledge sharing across Mainframe platforms.
- Independently investigate complex technical problems and provide effective solutions.

Who Can Apply? ✔️ Around 10+ years of experience in Mainframe DB2 Database Administration.

✔️ Solid hands-on experience in DB2 installation, maintenance, upgrades, and patches.

✔️ Strong experience with DB2 utilities such as COPY, REORG, RUNSTATS, LOAD, UNLOAD, QUIESCE, and REBIND.

✔️ Experience in DB2 performance tuning, capacity management, and space management.

✔️ Strong knowledge of DB2 objects, DDL, DML, tablespaces, partitions, and privileges.

✔️ Experience with backup, recovery, disaster recovery, and Image Copy.

✔️ Strong experience with JCL and IBM DB2 utilities.

✔️ Experience providing 24x7 Production DB2 support.

✔️ Experience with DB2 housekeeping and maintenance jobs.

✔️ Experience implementing and scheduling production DB2 jobs.





✔️ Experience supporting TEST-to-PROD DB2 object migration.

✔️ Strong troubleshooting and analytical skills with the ability to independently research and resolve problems.

✔️ Experience working with application teams on SQL errors and database performance issues.

✔️ Experience in Technical Lead / ISME responsibilities is preferred.

DB2 Tools & Utilities:

- IBM DB2 Utilities
- IBM Administration Tool Suite
- Query Monitor
- BMC Database Tools
- COPY
- REORG
- RUNSTATS
- LOAD / UNLOAD
- QUIESCE
- REBIND
- Image Copy
- Backup & Recovery Utilities

Mainframe Technologies:

- JCL
- VSAM
- CLIST
- REXX
- SAS
- DFSMS Suite
- IDCAMS
- CA1
- ICF Catalog
- ISMF
- TDMF
- FlashCopy
- Global Mirror
- Copy Services Manager
- OAM
- FDR/ABR
- EOSPROD
- JSF

Good to Have:

- Bachelor's degree in Computer Science or related field.
- Strong knowledge of Mainframe Storage and DB2 infrastructure.
- Experience with Tablespace Migration and Partition Management.
- Experience with performance and DB parameter tuning.
- Experience handling primary and secondary Production environments.
- Experience in Technical Lead / ISME roles.
- Strong customer-facing and stakeholder management skills.
- Experience transitioning knowledge from vendor teams to in-house teams.

Please share the following details along with your updated resume to [email protected]

Full Name:

Contact Number:

Current Location:

Total Experience:

Relevant Experience in Mainframe DB2:

DB2 DBA Experience:

Mainframe Experience:

DB2 Utilities Experience:

JCL Experience:

DB2 Performance Tuning Experience:

Backup & Recovery Experience:

Production Support Experience:

DB2 Upgrade/Patching Experience:

IBM/BMC Tools Experience:

Mainframe Storage Experience:

Technical Lead/ISME Experience:

Current Company:

Notice Period:

Current CTC:

Expected CTC:

For any further clarification, feel free to reach out at [email protected]

We look forward to connecting with you!

Thanks & Regards

TAG Team

📌 Senior MainframeDBA (Bengaluru)
🏢 ZettaMine Labs
📍 Bengaluru