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.
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)
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.
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)
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)
HCLTech is a global technology company, home to more than 226,600 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 September 2025 totaled $14.2 billion. To learn how we can supercharge progress for you, visit hcltech.com.
