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.

Strong 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 [HIDDEN TEXT]

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:

We look forward to connecting with you!

Thanks & Regards

TAG Team

Senior Mainframe Administrator