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. ✔️ Solid 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 [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 & Regards TAG Team

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