SME - Mainframe Automation Tools (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

DB2 L3 Database AdministrationIncident ManagementProblem ManagementChange ManagementRoot Cause Analysis (RCA)Availability ManagementCapacity ManagementAudit & ComplianceDB2 Database AdministrationDatabase Design & Schema ManagementTablespace and Index ManagementSQL Development and OptimizationDatabase Security AdministrationBackup & RecoveryDB2 UtilitiesBackup / Restore ManagementRecovery PlanningArchive ManagementDisaster Recovery ProceduresPerformance ManagementSQL Performance TuningQuery OptimizationCapacity PlanningPerformance MonitoringResource Utilization AnalysisReplication TechnologiesDB2 ReplicationData SynchronizationEnvironment Refresh ActivitiesReplication MonitoringJCLTSO/ISPFMainframe OperationsDB2 Utilities on Mainframe

Good to Have

Strong analytical and troubleshooting skillsEffective stakeholder communicationAbility to support critical production environmentsTeam collaboration with application and infrastructure teamsCustomer-focused approachDocumentation and reporting skills

Highlights

  • Actively hiring

More Details

RoleSME - Mainframe Automation Tools (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting

SME - Mainframe Automation Tools (IN) at HCLTech | SkillMX | SkillMX