SeniorAdministrator - Mainframe Automation Tools (IN)

HCLTech

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

Job description

Seeking a seasoned DB2 Database Administrator (DBA) proficient in managing the complete database lifecycle. This role focuses on ensuring optimal database performance, availability, and operational stability for critical environments. You will be instrumental in supporting application teams and maintaining mission-critical systems on IBM DB2 platforms (Mainframe OS and/or distributed).

Key responsibilities span database administration, performance tuning, robust backup and recovery strategies, security implementation, replication management, capacity planning, and comprehensive production support. This position demands a deep understanding of DB2 functionalities and a proactive approach to system maintenance and enhancement.

Responsibilities

Administer DB2 databases, including creation, modification, and maintenance of schemas, objects, and tablespaces. Support application teams with database design and structural adjustments, ensuring adherence to best practices.

Manage database storage, monitor usage trends, and conduct capacity planning for future needs. Optimize storage resources and database configurations for peak efficiency.

Configure and execute backup, recovery, and disaster recovery processes to ensure business continuity and data protection. Maintain archive and retention policies effectively.

Monitor database health and performance, conducting SQL tuning and query optimization to resolve bottlenecks. Enhance application database performance through detailed analysis of resource consumption.

Implement and manage database security controls, including user access and permissions. Support compliance and audit requirements, ensuring adherence to licensing and governance policies.

Oversee data replication technologies, monitor their health, and ensure data consistency across environments. Perform database refreshes for development, test, UAT, and production instances.

Troubleshoot and manage database-related incidents and production outages. Conduct Root Cause Analysis (RCA) and collaborate with vendor support for complex issues, implementing preventive measures.

Generate operational reports and support data extraction requests using SQL. Provide valuable database insights for informed decision-making.

Qualifications

A strong background in IBM DB2 database administration is essential, encompassing database design, schema management, and expertise in tablespace and index management. Proficiency in SQL development, optimization, and database security administration is required.

Experience with backup and recovery procedures, DB2 utilities, and disaster recovery planning is crucial. Demonstrated ability in performance tuning, query optimization, capacity planning, and performance monitoring tools is expected.

Familiarity with replication technologies, data synchronization, and environment refresh activities is necessary. For Mainframe OS environments, knowledge of JCL, TSO/ISPF, and mainframe operations is required.

Essential service management skills include incident management, problem management, change management, Root Cause Analysis (RCA), availability management, and capacity management.

Ideal candidates possess strong analytical and troubleshooting skills, effective communication abilities, and can support critical production environments. Team collaboration and a customer-focused approach are highly valued, along with solid documentation and reporting capabilities.

Essential Skills

IBM DB2 Database AdministrationDatabase DesignSchema ManagementTablespace ManagementIndex ManagementSQL DevelopmentSQL OptimizationDatabase SecurityBackup and RecoveryDB2 UtilitiesRestore ManagementRecovery PlanningArchive ManagementDisaster RecoveryPerformance TuningQuery OptimizationCapacity PlanningPerformance MonitoringResource Utilization AnalysisDB2 ReplicationData SynchronizationEnvironment RefreshReplication MonitoringJCLTSO/ISPFMainframe OperationsIncident ManagementProblem ManagementChange ManagementRoot Cause Analysis (RCA)Availability ManagementCapacity ManagementAudit and Compliance

Good to Have

OSDB2 Utilities on Mainframe

Highlights

  • Actively hiring

More Details

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

About the Company

HCLTech logo

HCLTech

IT Consulting

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