Job Title

Mainframe DB2 DBAMainframe DB2 DBALocation: Hyderabad/DelhiExperience: 5 to 10Interview Mode: Online InterviewInterview Date:30th April 2025 (Thursday)Interview Time: 2: 00 PM to 6: 00 PMMandatory skills:Database Object DesignJCL utilities and Db2 utilitiesIBM Db2 suite (admin tool, log analyzer, QM, SDSF and ISPF)IIDR replication, Encryption key rotation and Conversion (UTS/RPN)Troubleshoot and RCAMust Have:Design, implement and customize database objects according to business needs.Good knowledge of IIDR replication process.Monitor and manage production/test databases across multiple LPARsGood understanding of IBM DB2 utilitiesAnalyze SQL access paths and identify under-performing SQL queriesDB2 plan/package maintenance in all regionsDesign efficient indexes to influence Optimizer’s choice of access pathAnalyze bind errors and assist developers in troubleshooting database issuesVersion migration activities and RSU checkoutsGood experience in UTS conversion, Encryption key rotation and RPN conversion activities.Mainframe environment management and legacy database decommissioning.Need to have hands-on experience working on Admin tool Omegamon, QMF , SDSF, ISPF panel, Platinum tool and Log analyzer tools.Good troubleshooting skills to support business critical applications in Production.Need to have hands on experience to work on batch job scheduling and execution using CA7Service Now (Ticketing tool) experience in Incident management, request management and Change managementKey Responsibilities:Design, implement and customize database objects according to business needs.Good experience in UTS conversion, Encryption key rotation and RPN conversion activities.Run Pre and Post checkouts for validation of LPARs.Analyze the batch job failure and provide root cause analysisNeed good hands-on experience on Db2 tools and utilities.15 years of Continuous Education