10 Sep
|
ZettaMine Labs
|
India
10 Sep
ZettaMine Labs
India
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 robust 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
📌 Senior Mainframe Administrator (India)
🏢 ZettaMine Labs
📍 India