[ZPH2AC29] Senior Mainframe Administrator

ZettaMine Labs Pvt. Ltd.

Telangana

In loco

INR 4.000.000 - 7.000.000

Tempo pieno

3 giorni fa

Candidati tra i primi

Aumenta le possibilità di ricevere una risposta da questo datore di lavoro

Il tuo curriculum e una lettera di presentazione personalizzati, che corrispondono esattamente a ciò che sta cercando.

Supera i filtri ATS

Descrizione del lavoro

ZettaMine Labs Pvt. Ltd. in Telangana, India, invites an experienced Senior Mainframe DB2 DBA to join our production-critical environments.

You will own end-to-end DB2 database administration across TEST, QA, and PROD, manage utilities, security, and space, and drive performance tuning and capacity management. The role requires 12+ years in Mainframe DB2, strong hands-on DB2 utilities, JCL, and 24x7 production support on a rotation. Bachelor0s degree preferred.

Competenze

End-to-end DB2 database administration 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.

Mansioni

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.
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.

Conoscenze

Mainframe DB2

Production Support

Performance Tuning

JCL

SQL Troubleshooting

Formazione

Bachelor's degree in Computer Science or related field

Strumenti

IBM DB2 Utilities

IBM Administration Tool Suite

Query Monitor

BMC Database Tools

COPY

REORG

RUNSTATS

LOAD / UNLOAD

QUIESCE

REBIND

Image Copy

Backup & Recovery Utilities

Descrizione del lavoro

We are looking for Senior Mainframe DB2 DBA with project opportunities.

Job Role: Senior Mainframe DB2 DBA

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 with DB2 housekeeping and maintenance jobs.
Experience implementing and scheduling production DB2 jobs.
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.