Hello,Greetings from ZettaMine Labs Pvt Ltd!!We are looking for

Senior Mainframe DB2 DBA

with project opportunities.Job Role:

Senior Mainframe DB2 DBALocation:

BangaloreExperience:

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 UtilitiesIBM Administration Tool SuiteQuery MonitorBMC Database ToolsCOPYREORGRUNSTATSLOAD / UNLOADQUIESCEREBINDImage CopyBackup & Recovery Utilities

Mainframe Technologies:JCLVSAMCLISTREXXSASDFSMS SuiteIDCAMSCA1ICF CatalogISMFTDMFFlashCopyGlobal MirrorCopy Services ManagerOAMFDR/ABREOSPRODJSF

Valuable 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:

We look forward to connecting with you!

Thanks & RegardsTAG Team

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