Mainframe Infra-DB2 LUW Gemsource It Consulting

6.0 - 11.0 years

7 - 17 Lacs

pune, chennai, bengaluru

Work from Office

We are seeking a highly experienced Chief Mainframe Infra DB2 LUW professional to lead and manage support and operations of DB2 LUW, QREP, and CDC solutions in a banking environment. The role demands strong technical expertise in database administration, performance tuning, disaster recovery, and ITIL-compliant incident, change, and problem management. The successful candidate will drive operational excellence and adopt best practices to optimize performance and reduce technical debt. Key Responsibilities: Manage support and operations of DB2 LUW, QREP, and CDC database solutions implemented within the bank. Handle Incident, Change, and Problem Management for DB2 LUW, QREP, and CDC environments as per ITIL framework. Proactively monitor database performance and capacity trends, initiating improvements as needed. Apply and automate fix packs, cumulative updates, and hotfixes to ensure systems remain up-to-date. Perform regular health checks, monitoring, backup, space management, and maintenance activities. Follow up on CIRATS (Compliance, Issue, Risk) related to database systems. Manage user access and BAU (Business As Usual) database activities. Setup and maintain data replication services (QREP, CDC) ensuring data consistency and availability. Plan and execute disaster recovery and business continuity processes, including backup and point-in-time recovery. Perform database performance tuning and troubleshooting to optimize system responsiveness. Participate in a 24x7 on-call support rotation for DB2 LUW, QREP, and CDC portfolios and related applications. Provide best-in-class solutions to meet evolving business needs. Identify opportunities and lead initiatives to implement best technical practices to reduce technical debt and operational costs. Manage physical database infrastructure including storage management, access procedures, security, monitoring, and tuning. Analyze system storage capacity and recommend improvements for efficiency and scalability. Assist in designing and implementing the physical framework of databases. Support Operational DBAs with database tuning and performance optimization when required. Required Skills and Experience: Extensive experience managing DB2 LUW environments with strong operational and support background. Proven expertise with QREP (Query Replication) and CDC (Change Data Capture) technologies. Strong knowledge of ITIL processes for Incident, Change, and Problem Management. Experience in database performance tuning, capacity planning, and disaster recovery . Hands-on experience applying patches, fix packs, and automating update processes. Familiarity with backup/recovery strategies , including point-in-time recovery. Knowledge of data replication setup and maintenance . Excellent troubleshooting and root cause analysis skills. Ability to work in a 24x7 on-call rotation environment. Strong leadership and collaboration skills to work with multiple stakeholders and teams. Preferred Qualifications: Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field. Certifications in DB2, ITIL, or relevant database technologies. Experience in banking or financial services domain is a plus.

Posted 17 hours ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.