Senior Mainframe Administrator

• 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

• check mark Around 10+ years of experience in Mainframe DB2 Database Administration.
• check mark Strong hands-on experience in DB2 installation, maintenance, upgrades, and patches.
• check mark Strong experience with DB2 utilities such as COPY, REORG, RUNSTATS, LOAD, UNLOAD, QUIESCE, and REBIND.
• check mark Experience in DB2 performance tuning, capacity management, and space management.
• check mark Strong knowledge of DB2 objects, DDL, DML, tablespaces, partitions, and privileges.
• check mark Experience with backup, recovery, disaster recovery, and Image Copy.
• check mark Strong experience with JCL and IBM DB2 utilities.
• check mark Experience providing 24x7 Production DB2 support.
• check mark Experience with DB2 housekeeping and maintenance jobs.
• check mark Experience implementing and scheduling production DB2 jobs.
• check mark Experience supporting TEST-to-PROD DB2 object migration.
• check mark Strong troubleshooting and analytical skills with the ability to independently research and resolve problems.
• check mark Experience working with application teams on SQL errors and database performance issues.
• check mark 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:

• Bachelors 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