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

📌 Senior MainframeDBA (Bengaluru)
🏢 ZettaMine Labs
📍 Bengaluru