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 solid 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 technic

📌 Senior MainframeDBA (Bengaluru)
🏢 ZettaMine Labs
📍 Bengaluru