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 robust 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, perfor

📌 Senior Mainframe Administrator (Mahbubnagar)
🏢 ZettaMine Labs
📍 Mahbubnagar