Summary
Overview
Work History
Education
Skills
Websites
Certification
Key Achievements
Languages
Timeline
Generic

Vimal Gomathy Sankar

Chennai

Summary

A highly motivated and skilled IT professional with over 3 years of experience in Mainframe Application Support and DB2 Database Administration. Currently working at Tata Consultancy Services, with expertise in Mainframe DB2 management, troubleshooting, and batch job monitoring. Adept at problem-solving and maintaining the stability of production environments through proactive issue resolution, upgrades, and routine database management tasks. Excellent communication skills and a demonstrated ability to collaborate with senior DBAs and other teams to drive system efficiency.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Mainframe Database Administration

Tata Consultancy Services
Chennai
02.2022 - Current
  • Managed production abends, performed root cause analysis, and implemented effective resolutions to minimize downtime and system disruptions
  • Administered DB2 environments including creation and management of databases, tablespaces, and tables in both test and production environments
  • Conducted Data Refresh Activities across environments, ensuring data accuracy and availability
  • Utilized BMC Remedy for issue tracking and timely resolution of incidents
  • Experienced in batch job processing, particularly with CA7 and JOBTRAC, improving operational efficiency
  • Conducted IPL (Initial Program Load) processes in both test and production environments for system maintenance
  • Skilled in SPUFI for updating tables and performing data unload/load tasks between test and production environments
  • Led function level upgrades of DB2 to version 12, ensuring compatibility and improved functionality
  • Handled DB2 admin tools and Platinum tool for database management and optimization
  • Generated image copy jobs for databases to ensure data safety and recovery capabilities
  • Proficient in the use of utilities such as LOAD, UNLOAD, REORG, REBUILD, RUNSTATS, and REPAIR for maintaining database health
  • Collaborated with senior DBAs and z/OS support team during IBM DB2 installation, ensuring smooth integration
  • Basic knowledge and experience with IMS, IDMS, and CICS
  • English, Fluent, Tamil, Native, Open to relocation and willing to work in different time zones

Education

Bachelor of Engineering - Computer Science

Sri Ramakrishna Institute of Technology
Coimbatore, India
05.2020

Skills

  • DB2 Administration
  • Database management
  • Batch Job Processing
  • TSO/ISPF
  • SPUFI
  • CA7,JOBTRAC
  • SAR,MOBIUS
  • JCL
  • SQL Programming
  • JES,SDSF
  • LOAD,UNLOAD,REORG,REPAIR,RUNSTATS,REBUILD
  • IBM DB2 Installation & Configuration
  • IPL
  • Data Refresh Activities
  • Basic IMS,IDMS,CICS Operations

Certification

  • CCNA (Cisco Certified Network Associate)
  • Introduction to IBM z/OS

Key Achievements

DB2 Installation

Installing Db2 involves running the installation jobs, connecting the facilities that allow TSO, batch, IMS, and CICS® to access Db2 resources, and preparing Db2 for use

DB2 version upgrade

Successfully led upgrades of DB2 to enhance system functionality, and ensure production stability

Languages

Tamil
First Language
English
Proficient (C2)
C2

Timeline

Mainframe Database Administration

Tata Consultancy Services
02.2022 - Current

Bachelor of Engineering - Computer Science

Sri Ramakrishna Institute of Technology
Vimal Gomathy Sankar