SME - Mainframe Automation Tools
Technology, Data & Digital · IT Infrastructure & Security · Database Administration
In short
We are looking for a Subject Matter Expert (SME) in Mainframe Automation Tools with strong experience in IBM DB2 Database Administration. This full-time, on-site role based in Bengaluru, India, involves managing database operations, performance, security, and providing support to application teams.
Responsibilities
- Strong experience in IBM DB2 Database Administration on Mainframe and/or Distributed platforms.
- Expertise in database creation, modification, and schema management.
- Support application teams with database design and structural changes.
- Database storage allocation and space management.
- Capacity planning and forecasting future database growth.
- Performance optimization of tablespaces, indexes, and storage resources.
- Database backup, restore, and recovery management.
- Disaster recovery planning and implementation.
- Archive management and data retention administration.
- Monitoring database health, availability, and performance.
- SQL tuning, query optimization, and resource utilization analysis.
- Identifying and resolving performance bottlenecks.
- User provisioning and access management.
- Database security administration and auditing.
- Ensuring compliance with organizational policies and vendor licensing requirements.
- Managing and monitoring data replication environments.
- Performing database refresh activities across development, test, and production environments.
- Ensuring data consistency and synchronization.
- Troubleshooting database issues and performing root cause analysis (RCA).
- Supporting critical incidents and production outages.
- Engaging with IBM/vendor support for complex technical issues.
- Generating operational and management reports through database queries.
- Supporting business and application teams with data extraction and analysis requests.
Requirements
- 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.
- Database storage allocation and space management.
- Capacity planning and forecasting future database growth.
- Performance optimization of tablespaces, indexes, and storage resources.
- Database backup, restore, and recovery management.
- Disaster recovery planning and implementation.
- Archive management and data retention administration.
- Monitoring database health, availability, and performance.
- SQL tuning, query optimization, and resource utilization analysis.
- Identifying and resolving performance bottlenecks.
- User provisioning and access management.
- Database security administration and auditing.
- Ensuring compliance with organizational policies and vendor licensing requirements.
- Managing and monitoring data replication environments.
- Performing database refresh activities across development, test, and production environments.
- Ensuring data consistency and synchronization.
- Troubleshooting database issues and performing root cause analysis (RCA).
- Supporting critical incidents and production outages.
- Engaging with IBM/vendor support for complex technical issues.
- 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
- z/OS, JCL, TSO/ISPF (for Mainframe DB2 environments)
Benefits
- Supercharge your potential.
- Find your career.
- Find your spark.
#DB2#Database Administration#Mainframe#Automation
Company
HCLTech
Job Posted
1 month ago
Employment Type
Full Time
WorkMode
On Site
Experience Level
Senior
Locations
Bengaluru, India
Applicants
Be an early applicant