Mainframe Database Administrator

Job Title : Mainframe DBA. Location : Bangalore / Gurgaon. Experience : 5 - 9 Years. Job Description : We are looking for an experienced Mainframe DBA with strong expertise in DB2 z/OS and IMS to support mission-critical databases across development, testing, pre-production, and production data-sharing environments. The role involves database design, optimization, break-fix support, security administration, automation, and implementation of new database features. Key Responsibilities : - Design, administer, optimize, and support DB2 z/OS v12 and IMS v15 databases. - Work with IMS FF/FP databases and DB2 z/OS data-sharing environments. - Convert logical database models into physical database designs. - Perform access path re-engineering and optimization for large-scale databases. - Administer database security in accordance with zDBMS standards. - Perform backups, reorganizations, database analysis, and troubleshooting. - Diagnose and resolve database errors and performance issues. - Use BMC Admin tools, including Change Manager, for database administration. - Work with IBM Data Studio, IBM utilities, and BMC utilities for DB2 and IMS. - Support database feature implementations, automation, and break-fix activities. - Drive/support application migration initiatives from z/OS to PostgreSQL. - Support conversion of VSAM tablespaces to Universal Table Spaces (UTS) in preparation for DB2 z/OS v13 and large-scale database growth. - Support mission-critical applications and large database environments. - Collaborate with application, infrastructure, and development teams. - Mentor junior DBAs and provide technical guidance. Required Skills : - DB2 z/OS - IMS / IMS DB - IMS FF/FP - Mainframe Database Administration - Database Design & Modeling - Access Path Optimization - DB2 Performance Tuning - DB Security Administration - Backup & Recovery - Reorg & Database Utilities - BMC Admin Toolset / Change Manager - IBM Data Studio - IBM/BMC DB2 & IMS Utilities - VSAM / Universal Table Spaces - PostgreSQL migration exposure Preferred Qualification : - Bachelor's degree in Computer Science, Information Management, or a related field.