We are looking for a skilled Mainframe DB2 Administrator with 4 to 5 years of hands-on experience in managing and supporting DB2 databases in a z / OS environment. The ideal candidate will have a strong understanding of DB2 internals, backup and recovery, performance tuning, and security, along with experience working in enterprise-level environments.
Key Responsibilities :
- Install, configure, and maintain IBM DB2 databases on mainframe (z / OS) systems
- Perform regular database maintenance tasks such as reorgs, backups, and updates
- Monitor database performance and implement tuning measures to optimize efficiency
- Plan and execute DB2 database upgrades and patch management
- Manage database security, roles, and access controls
- Support application development teams by providing DB2-related guidance and resolving database-related issues
- Perform capacity planning and storage management
- Participate in Disaster Recovery (DR) planning and execution
- Maintain documentation for DB2 database architecture, standards, and procedures
- Collaborate with cross-functional teams for change and incident management
Required Skills :
4 to 5 years of experience as a DB2 Database Administrator on mainframe (z / OS) platformsStrong knowledge of DB2 utilities (REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER, etc.)Experience with performance tuning and troubleshooting of DB2 databasesProficient in JCL, REXX, and TSO / ISPFExperience with backup and recovery strategiesFamiliarity with database monitoring tools and automationUnderstanding of DB2 catalog, indexing, and locking mechanismsKnowledge of RACF and mainframe security practicesGood to Have :
Experience with COBOL and DB2 application supportExposure to change management tools (e.g., Endevor, BMC, CA Tools)Knowledge of DB2 Connect and integrations with distributed systemsITIL foundation or knowledge of service management practicesSoft Skills :
Strong analytical and problem-solving abilitiesGood verbal and written communication skillsAbility to work independently and as part of a teamWillingness to support on-call rotations and weekend maintenance activities as requiredSkills Required
Performance Tuning, Troubleshooting