SME - Mainframe Automation Tools
Technology, Data & Digital · IT Infrastructure & Security · Database Administration
In short
We are seeking an experienced DB2 DBA for Mainframe Automation Tools. Responsibilities include database administration, storage management, backup/recovery, performance tuning, security, and replication across development, test, and production environments. The role requires strong technical skills in IBM DB2, SQL, and Mainframe utilities.
Responsibilities
- Perform IBM DB2 Database Administration on Mainframe and/or Distributed platforms.
- Manage database creation, modification, and schema management.
- Support application teams with database design and structural changes.
- Allocate database storage and manage space.
- Plan capacity and forecast future database growth.
- Optimize performance of tablespaces, indexes, and storage resources.
- Manage database backup, restore, and recovery.
- Plan and implement disaster recovery.
- Administer archive management and data retention.
- Monitor database health, availability, and performance.
- Tune SQL, optimize queries, and analyze resource utilization.
- Identify and resolve performance bottlenecks.
- Manage user provisioning and access.
- Perform database security administration and auditing.
- Ensure compliance with policies and licensing.
- Manage and monitor data replication environments.
- Perform database refresh activities.
- Ensure data consistency and synchronization.
- Troubleshoot database issues and perform root cause analysis.
- Support critical incidents and production outages.
- Engage with IBM/vendor support for complex issues.
- Generate operational and management reports.
- Support business and application teams with data extraction and analysis.
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.
- Experience with database storage allocation and space management.
- Experience with capacity planning and forecasting future database growth.
- Experience with performance optimization of tablespaces, indexes, and storage resources.
- Experience with database backup, restore, and recovery management.
- Experience with disaster recovery planning and implementation.
- Experience with archive management and data retention administration.
- Experience monitoring database health, availability, and performance.
- Experience with SQL tuning, query optimization, and resource utilization analysis.
- Experience identifying and resolving performance bottlenecks.
- Experience with user provisioning and access management.
- Experience with database security administration and auditing.
- Experience ensuring compliance with organizational policies and vendor licensing requirements.
- Experience managing and monitoring data replication environments.
- Experience performing database refresh activities across development, test, and production environments.
- Experience ensuring data consistency and synchronization.
- Experience troubleshooting database issues and performing root cause analysis (RCA).
- Experience supporting critical incidents and production outages.
- Experience engaging with IBM/vendor support for complex technical issues.
- Experience generating operational and management reports through database queries.
- Experience 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.
- A place that knows that helping its customers stay on top starts by putting its people first.
#DB2#Database Administration#Mainframe#Automation Tools
Company
HCLTech
Job Posted
1 month ago
Employment Type
Full Time
WorkMode
On Site
Experience Level
Mid-Senior
Locations
Bengaluru, India
Applicants
Be an early applicant