SME - Mainframe Automation Tools (IN)
HCLTech
HCLTech
This role focuses on **Mainframe Automation Tools**, specifically as a **DB2 L3 Database Administrator (DBA)**. You will be instrumental in ensuring the smooth operation of database systems through comprehensive management of incidents, problems, changes, and root cause analysis. A strong emphasis is placed on maintaining system availability, capacity, and adherence to audit and compliance standards.
Key responsibilities include detailed database administration, covering creation, modification, and maintenance of DB2 databases and schemas, alongside supporting application teams with database design. You will manage storage, perform capacity planning, and optimize resources. Crucial duties involve configuring and executing backup and recovery processes, ensuring disaster recovery readiness, and maintaining business continuity. Performance monitoring, tuning, and optimization of SQL queries and database resources are essential. Furthermore, you will handle security and compliance, manage user access, and implement security controls. Replication technologies, environment refreshes, and robust incident and problem management are core functions. Finally, you will generate reports, support data extraction, and provide valuable database insights.
Essential technical skills encompass core DB2 administration, database design, schema management, tablespace and index management, SQL development and optimization, security administration, and comprehensive backup/recovery procedures. Expertise in performance management, capacity planning, resource utilization analysis, and replication technologies is required. Familiarity with DB2 replication, data synchronization, and environment refresh activities, along with replication monitoring, is also necessary. Mainframe skills, including JCL, TSO/ISPF, and general mainframe operations, are critical. A strong foundation in service management is expected. Preferred soft skills include excellent analytical and troubleshooting abilities, effective communication, the capacity to support critical production environments, and a collaborative, customer-focused approach.
HCLTech
IT Consulting