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 [Confidential Information]
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
