Job description:

General Description Responsibilities : - DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning, physical database definition (DDL) and understanding of logical database design - Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades - Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades - Implement DBDC (CICS, DB2, or IMS) security compliance corrections - Mentoring / Training Team Members - Perform root cause analysis - Understanding of Multi-geo support environment - Responsible for strategizing a backup plan for failure scenario - Improves and maintains customer satisfaction - Suggests new technologies and design changes - Testing / Auditing/processes as required from time to time Skill set Requirements - CICS Installation, building CICS regions, Worked with tools like Fault Analyzer, Debugger, CAFC etc - DB2 System programming for z/OS, IBM DB2 products and CA Platinum tools - Planning & Implementing System software upgrades and change in configuration etc. - Evaluate the Database Server Hardware. - Define/Recommend/Maintain database Standards and Architecture. - Expert in Database Design of table spaces, buffer pool and table - Future Release management for database/instance and Impact Analysis. - Research/Recommend Migration/Up gradation - Planning Database Migration and Upgrade. Desirable to have experience in IBM MKT kit for migration from other DBMS like Oracle to UDB - 3rd Party Vendor Support and Interactsion(including TAR and OS) and can handle Client Independently - Technical Consultation. - Should be able to mentor L1 and L2 DBAs - Should be able to Lead the Team of DBAs - Should be able to diagnose clustered environment - Advance Database Performance Tuning Tuning Applications, Instance/Kernel Parameters and Tuning Memory. - Should be able to perform database reorganization - Usage of db2 registry variable, DBM and DB cfg. Recommend changes for performance improvement. - Recommend and Review Backup and Recovery Strategies for DB2. Knowledge of TSM essential - Knowledge of Advanced Replication, Queuing and Streams. - Hands on experience of configuration & administration of HADR. - Good Working experience of DPF and Table Partitioning. Desirable to have experience in BCU. - Table space Level Backup and recovery - Having experience of DR setup through various synch methods. - Designing strategy towards Capacity Management(Growth) for DB tracks. - Designing/Recommending Database Security Policy. - Designing/Recommending database alerts for monitoring database availability and performance. - Good working experience of configuration/troubleshooting federated database environment. - Should have good experience with shell scripts. Good to Have: - Worked on Production systems - Datacenter understanding - Experience with Database Migration, Installation, Upgrades and Patching - Knowledge of Data warehousing and Other Technologies(RDBMS) - Desirable to have experience in Federation set up - Storage Management Techniques Soft Skills/Other skills - Excellent communication and conversation skills (Verbal and Written) - Good documentation skills - Good working knowledge of MS OFFICE - Should have a great customer handling skills - Able to handle unforeseen situations - High level of acceptance - Can drive HCL s value and its methodology

• - Coordinate with LoBs, external consultants to get relevant inputs/data like employee engagement scores, attrition analysis, employee feedback on policies, other HR scorecards, etc. from respective teams (COEs, LoB HR, business) and market (C&B benchmarking report, etc.) at the beginning of financial year</br>
  - Analyse the data gathered and propose gaps and areas of improvement to the respective Prac