Madurai · Mid Level
Applicants who checked fit first are 3.1× more likely to hear back
Your score for this role already exists
ASAI compared this JD against 41 signals - skills, seniority, domain, stack overlap etc. Add a resume and it unlocks in about 30 seconds.
Always free · no credit card · 1 tap with Google
HIGH
Our tracked job listings for HCLTech show strong recent activity.
First 72 hours
Still inside it - posted 2d agoEarly applicants get seen before the pile builds.
Not a repost
The first time we've seen this listing - it hasn't been closed and reopened.
You almost certainly match several of these already. Unlock your skill map to see the matches, the gaps, and what to fix first.
Executive Summary
Role: DB2 Database Administrator (DBA)
Platform: IBM DB2 (Mainframe OS and/or distributed)
Focus Areas: Database Administration, Performance Tuning, Backup & Recovery, Security, Replication, Capacity Planning, and Production Support
This role requires a strong DB2 DBA who can manage the complete database lifecycle, ensure database performance and availability, support application teams, and provide operational stability for mission-critical environments.
Key Responsibilities
1. Database Administration
Create, modify, and maintain DB2 databases and schemas.
Support application teams with database design and structural changes.
Manage database objects including tables, indexes, views, and tablespaces.
Ensure database standards and best practices are followed.
2. Storage & Capacity Management
Manage database storage allocation and utilization.
Monitor space usage and growth trends.
Perform capacity planning and forecasting.
Optimize tablespaces, indexes, and storage resources.
3. Backup, Recovery & Disaster Recovery
Configure and manage backup and recovery processes.
Execute database restore and recovery activities.
Maintain archive and retention processes.
Support disaster recovery planning and testing.
Ensure business continuity and data protection requirements are met.
4. Performance Monitoring & Tuning
Monitor database health, availability, and performance.
Perform SQL tuning and query optimization.
Analyze resource consumption and system utilization.
Identify and resolve database bottlenecks.
Improve application database performance.
5. Security & Compliance
Manage user access and database permissions.
Implement database security controls.
Support compliance and audit requirements.
Ensure adherence to licensing and governance policies.
6. Replication & Environment Refresh
Support data replication technologies and processes.
Monitor replication health and data consistency.
Perform database refreshes across Development, Test, UAT, and Production environments.
Ensure synchronization and integrity of replicated databases.
7. Incident & Problem Management
Troubleshoot database-related incidents.
Support production outages and critical issues.
Conduct Root Cause Analysis (RCA).
Work with IBM/vendor support teams for complex problems.
Implement preventive measures to reduce recurring issues.
8. Reporting & Data Analysis
Generate operational and management reports.
Support business teams with data extraction requests.
Develop SQL queries for reporting and analysis.
Provide database insights for operational decision-making.
Technical Skills Required
Core DB2 Skills
IBM DB2 Database Administration
Database Design & Schema Management
Tablespace and Index Management
SQL Development and Optimization
Database Security Administration
Backup & Recovery
DB2 Utilities
Backup / Restore Management
Recovery Planning
Archive Management
Disaster Recovery Procedures
Performance Management
SQL Performance Tuning
Query Optimization
Capacity Planning
Performance Monitoring Tools
Resource Utilization Analysis
Replication Technologies
DB2 Replication
Data Synchronization
Environment Refresh Activities
Replication Monitoring
Mainframe Skills (For OS Environments)
OS
JCL
TSO/ISPF
Mainframe Operations
DB2 Utilities on Mainframe
Service Management Skills
Knowledge of:
Incident Management
Problem Management
Change Management
Root Cause Analysis (RCA)
Availability Management
Capacity Management
Audit & Compliance
Preferred Soft Skills
Strong analytical and troubleshooting skills
Effective stakeholder communication
Ability to support critical production environments
Team collaboration with application and infrastructure teams
Customer-focused approach
Documentation and reporting skills
Your match score, skill map and tracker stay free.
Skip jobs with hidden dealbreakers. See what they actually need, what's easy to miss, and how they describe the team.
Ground Reality on every job, plus Insider Path, practice interviews and resume tailoring.
We help you find people there who worked or studied where you did, and draft your first message and follow-up.
Free · no signup
Daily job drops, skill trends and free resources - posted straight to the group. Leave any time.
No spam. Just jobs and resources.
Why people use ASAI
Scored, not searched. Every role ranked against your actual profile.
Alerts as often as hourly. Reach new roles while the pile is still small.
Skill gaps, spelled out. See exactly which requirements you don't meet yet.
Verified jobs, only. Say no to ghost jobs. Your time deserves respect.
Keep browsing