Database Administrator
Mphasis - Chennai, Tamil Nadu
Apply NowJob Description
Job Description Role: DB2/IMS Lead Database Administrator Location: Onshore/US Who are we looking for? We are seeking for 10+ years of administrator experienced and detail-oriented DB2 and IMS Database Administrator (DBA) to join our production support team. In this role, you will be responsible for maintaining the stability, availability, and performance of DB2 and IMS databases on IBM mainframe (z/OS) environments. The role requires strong problem-solving skills, a solid understanding of mainframe database internals, and a proactive approach to system health monitoring, incident response, and database maintenance.You will provide 24/7 production support, troubleshoot issues, monitor system health, optimize performance. Technical Skills: Proven experience as a DB2/IMS Databases Administrator or similar role in production support environments. 10+ years of hands-on experience supporting DB2 for z/OS and IMS (Information Management System) in a production environment. Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities. Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities. Proficient in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance. Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting Experience with modern mainframe automation tools and schedulers (e.g., Control-M, CA-7). Knowledge of COBOL, CICS, and batch job data flows. Understanding of DB2 Data Sharing and IMS Sysplex environments. Experience with backup and recovery solutions Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar). Proficiency in troubleshooting performance tuning, and capacity planning. In-depth understanding of data management (e.g. permissions, recovery, security and monitoring) Strong troubleshooting and problem-solving skills. Excellent communication and collaboration abilities. Ability to work in a 24/7 support rotation and handle urgent production issues. Familiarity with data security is the best practice and backup procedures.
Created: 2025-08-06