DB2 Admin Friday Drive

Tata Consultancy Services; Hyderabad, Chennai District, Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced DB2 Admin in India. The role requires 5–8 years of hands-on experience with IBM DB2 and related administration tasks across multiple listed locations.

You will install, configure, upgrade, patch DB2 databases, perform backups and DR, configure Q-Replication, monitor performance, and automate routine admin tasks using shell scripting. Collaboration with application and infra teams is essential to maintain availability and security.

Qualifications

• 5–8 years of experience in DB2 administration.
• Strong Linux/AIX administration skills.
• Experience with Q-Replication and Disaster Recovery.

Responsibilities

• Install, configure, upgrade, and patch DB2 databases.
• Monitor database performance and apply tuning recommendations.
• Backup, recovery, and disaster recovery activities.
• Configure replication, including Q-Replication.
• Health checks and capacity planning.
• Troubleshoot SQL and system level issues.
• Support production incidents and ensure availability.
• Automate routine admin tasks with shell scripts.
• Collaborate with application and infra teams for DB support.
• Maintain database security and operational documentation.

Skills

DB2 Admin

Performance Tuning

Backup & Recovery

Install & Patch

SQL Troubleshooting

Linux/AIX

Monitoring & Health

Q-Replication

Shell Scripting

Incident Mgmt

Security & User Mgmt

Education

15 years education

50% in 10th/12th/UG/PG

Job description

What we are looking for

Role: DB2 Admin

Experience Range: 5 to 8 Years

Location: Chennai, Kolkata, Hyderabad, Bangalore, Pune, Delhi

Interview Date: Friday Online

Must Have:

• IBM DB2 Database Administration
• DB2 Performance Tuning and Optimization
• DB2 Backup, Restore & Recovery
• DB2 Installation, Configuration, Upgrades & Patching
• SQL Performance Analysis and Troubleshooting
• Linux/AIX Administration
• Database Monitoring and Health Checks
• Q-Replication Setup and Management
• Shell Scripting for Automation and Monitoring
• Incident and Problem Management
• Database Security and User Management

Good to Have:

• Banking / Financial Services Domain Experience
• ServiceNow
• Change and Release Management
• High Availability (HA) and Disaster Recovery (DR)
• Database Capacity Planning
• Automation and Monitoring Tools

Essential:

• Install, configure, upgrade, and patch DB2 databases.
• Monitor database performance and implement tuning recommendations.
• Perform database backup, recovery, and disaster recovery activities.
• Configure and support DB2 replication solutions, including Q-Replication.
• Conduct regular health checks and capacity planning.
• Troubleshoot database issues at SQL and system levels.
• Support production incidents and ensure database availability.
• Automate routine administration activities using shell scripts.
• Work closely with application and infrastructure teams for database support.
• Maintain database security, compliance, and operational documentation.

Minimum Qualification:

• 15 years of full-time education
• Minimum percentile of 50% in 10th, 12th, UG & PG (if applicable)