Role Overview
Tata Consultancy Services is hiring a mid-level Mainframe DB2 DBA. This is a full-time role in Hyderabad. Part of Tata Consultancy Services's Qa hiring. Full responsibilities, required qualifications, and the apply link are listed in the description below.
Resume Keywords to Include
Make sure these keywords appear in your resume to improve ATS scoring
Job Description
Mainframe DB2 DBA
Mainframe DB2 DBA
Location: Hyderabad/Delhi
Experience: 5 to 10
Interview Mode: Online Interview
Interview Date:30th April 2025 (Thursday)
Interview Time: 2: 00 PM to 6: 00 PM
Mandatory skills:
- Database Object Design
- JCL utilities and Db2 utilities
- IBM Db2 suite (admin tool, log analyzer, QM, SDSF and ISPF)
- IIDR replication, Encryption key rotation and Conversion (UTS/RPN)
- Troubleshoot and RCA
Must 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 LPARs
- Good understanding of IBM DB2 utilities
- Analyze SQL access paths and identify under-performing SQL queries
- DB2 plan/package maintenance in all regions
- Design efficient indexes to influence Optimizer’s choice of access path
- Analyze bind errors and assist developers in troubleshooting database issues
- Version migration activities and RSU checkouts
- Good 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 CA7
- Service Now (Ticketing tool) experience in Incident management, request management and Change management
Key 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 analysis
- Need good hands-on experience on Db2 tools and utilities.
15 years of Continuous Education
Frequently Asked Questions
How do I apply for the Mainframe DB2 DBA position at Tata Consultancy Services?
Use the Apply button above to submit your application directly to Tata Consultancy Services. Most applications take less than 5 minutes if your resume and contact details are ready, and you'll be routed to the employer's official application system to finish.
Where is the Mainframe DB2 DBA position at Tata Consultancy Services located?
This position is based in Hyderabad. Tata Consultancy Services has not indicated remote or hybrid options for this role, so candidates should plan for on-site work.
What does a Mainframe DB2 DBA at Tata Consultancy Services earn?
Tata Consultancy Services has not disclosed a salary range in this posting. Many employers share specifics later in the interview process; you can also ask during a recruiter screen if compensation transparency is important to you.
When was the Mainframe DB2 DBA role at Tata Consultancy Services posted?
This role was posted on April 28, 2026 (53 days ago). It's still listed as actively hiring; we re-confirm openings against the source system multiple times per day and remove closed roles.
AI-powered job search
Get every job scored to your resume
Upload your resume and get jobs ranked, your resume tailored, and employee contacts found automatically.
Get Started FreeNo credit card to start