SME - Mainframe Automation Tools
India
Apply now
Job Description
SME - Mainframe Automation Tools
Bengaluru, Karnataka

Job Summary

DB2 DBA – Database Administration

DB2 DBA – Key Skills Required

Database Administration

Strong experience in IBM DB2 Database Administration on Mainframe and/or Distributed platforms.

Expertise in database creation, modification, and schema management.

Ability to support application teams with database design and structural changes.

Storage & Capacity Management

Database storage allocation and space management.

Capacity planning and forecasting future database growth.

Performance optimization of tablespaces, indexes, and storage resources.

Backup, Recovery & Data Protection

Database backup, restore, and recovery management.

Disaster recovery planning and implementation.

Archive management and data retention administration.

Performance Monitoring & Tuning

Monitoring database health, availability, and performance.

SQL tuning, query optimization, and resource utilization analysis.

Identifying and resolving performance bottlenecks.

Security & Compliance

User provisioning and access management.

Database security administration and auditing.

Ensuring compliance with organizational policies and vendor licensing requirements.

Replication & Database Refresh

Managing and monitoring data replication environments.

Performing database refresh activities across development, test, and production environments.

Ensuring data consistency and synchronization.

Incident & Problem Management

Troubleshooting database issues and performing root cause analysis (RCA).

Supporting critical incidents and production outages.

Engaging with IBM/vendor support for complex technical issues.

Reporting & Data Analysis

Generating operational and management reports through database queries.

Supporting business and application teams with data extraction and analysis requests.

Technical Skills

IBM DB2 Administration

SQL and Query Performance Tuning

Data Replication Technologies

Backup & Recovery Utilities

Database Security Administration

Capacity Planning

Performance Monitoring Tools

OS, JCL, TSO/ISPF (for Mainframe DB2 environments)

Key Responsibilities

Database Administration Strong experience in IBM DB2 Database Administration on Mainframe and/or Distributed platforms. Expertise in database creation, modification, and schema management. Ability to support application teams with database design and structural changes.

Skill Requirements

Technical Skills IBM DB2 Administration SQL and Query Performance Tuning Data Replication Technologies Backup & Recovery Utilities Database Security Administration Capacity Planning Performance Monitoring Tools z/OS, JCL, TSO/ISPF (for Mainframe DB2 environments)

Other Requirements

Technical Skills IBM DB2 Administration SQL and Query Performance Tuning Data Replication Technologies Backup & Recovery Utilities Database Security Administration Capacity Planning Performance Monitoring Tools z/OS, JCL, TSO/ISPF (for Mainframe DB2 environments)
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.