Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
SUMAN DASGUPTA

SUMAN DASGUPTA

Mainframe DB2 Systems And Applications DBA
Kolkata

Summary

DB2 for z/OS Database Administrator experienced in managing high-availability, high-volume production environments and driving upgrades and migrations. Achieved optimal database performance through performance tuning, data integrity, and security measures while adopting new DB2 V13 features. Delivered impactful results using a variety of IBM, CA, and BMC utilities, alongside scripting and automation skills in JCL, REXX, and ISPF.

Overview

26
26
years of professional experience

Work History

Senior Specialist / Senior Database Engineer

BetaNXT
10.2008 - Current
  • Ensured data security, integrity, and high availability while providing 24/7 support and automating routine processes.
  • Functioned as a dual Systems and Application DBA for DB2 on z/OS, providing comprehensive support for critical enterprise systems.
  • Monitored and maintained DB2 databases, upholding stringent security measures and ensuring data integrity and high availability.
  • Provided expert-level 24/7 on-call support, swiftly troubleshooting intricate database issues to minimize downtime.
  • Conducted thorough SQL review and tuning to optimize application performance and maximize resource utilization.
  • Managed version upgrades and maintenance for core DB2 and associated CA and BMC tools, ensuring smooth operations.
  • Orchestrated data migration and environment refresh activities for development and testing to facilitate efficient software development lifecycles.
  • Implemented automation solutions for routine tasks using REXX, and developed custom in-house tools with REXX, ISPF, and macros.
  • Achievements:
  • Successfully executed DB2 upgrades to V12 and V13, including all intermediate function levels, improving database functionality.
  • Spearheaded the transition from CA to BMC tools, enabling a seamless migration with minimal operational impact.
  • Engineered the implementation of Universal Table Space (UTS) conversion and adoption of DB2 V13 features like Statement-Level Dependency for Packages, enhancing database flexibility.

Application DB2 DBA

Electronic Data Systems
09.2005 - 09.2008
  • Administered DB2 databases on z/OS, supporting both development and production environments to maintain operational stability.
  • Contributed to performance tuning initiatives, optimizing SQL queries to enhance database efficiency.
  • Conducted database maintenance, implementing backup and recovery procedures to ensure data integrity.
  • Optimized SQL queries during performance tuning initiatives, improving database efficiency.
  • Managed DB2 object creation and change implementations for application teams, enhancing collaboration.
  • Performing database maintenance, backups, and recovery; providing support for performance tuning, SQL optimization, and change management.
  • Assisted application teams with DB2 object creation and managed change implementations, fostering effective collaboration.
  • Supported application development lifecycle by efficiently managing DB2 object creation and changes.
  • Achievements:

IBM Mainframe Developer

Infosys
05.2004 - 08.2005
  • Developed and maintained mainframe application code, participated in system development, and collaborated with stakeholders to gather requirements and deliver enhancements efficiently.
  • Contributed to the successful development and maintenance of mainframe applications, supporting key business operations.
  • Developing and maintaining mainframe application code, participating in system development, and collaborating with stakeholders for requirements gathering and efficient enhancements delivery.
  • Collaborated with clients to gather requirements and deliver system enhancements, ensuring alignment with business needs.
  • Collaborated closely with clients to thoroughly gather requirements and effectively deliver system enhancements.
  • Participated in system analysis, coding, rigorous testing, and seamless implementation to ensure project success.
  • Improved system reliability and performance through participation in system analysis, coding, and testing phases.
  • Enhanced system reliability and performance through active involvement in system analysis, coding, and rigorous testing.

IBM Mainframe Developer

Cognizant
08.2000 - 04.2004
  • Developed and supported mainframe applications, enhancing batch and online processing and providing production support to ensure timely, efficient operations.
  • Developed and supported mainframe-based applications using COBOL, JCL, and IMS DB/DC, contributing to system reliability.
  • Ensured efficient data handling and system uptime through effective management of batch and online processing systems.
  • Provided critical production support, efficiently resolving incidents under strict time constraints to maintain system operations.
  • Contributed to the reliability of mainframe-based applications through effective development and support activities.
  • Maintained data processing efficiency through diligent work on both batch and online systems.
  • Resolved urgent production issues promptly, ensuring smooth system operations and minimizing downtime.
  • Achievements:

Education

BACHELOR DEGREE - BE in Metallurgical Engineering

NIT Jamshedpur/Ranchi University
01.2000

XII - undefined

Delhi Public School/CBSE
Bhilai
04.1995

X - undefined

Delhi Public School/CBSE
Bhilai
04.1993

Skills

DB2 for z/OS Systems Programming

DB2 for z/OS Application DBA

SQL Optimization

Technical Leadership

Cross-Functional Collaboration

REXX & ISPF programming

DB2 Utilities

CA and BMC Tools for DB2

Problem-solving

Adaptability

Communication

Accomplishments

  • Successfully completed DB2 upgrades to V12 and V13, including all intermediate function levels, enhancing database performance and stability.
  • Led the migration from CA to BMC tools, ensuring seamless transition and minimal disruption, optimizing operational efficiency.
  • Implemented Universal Table Space (UTS) conversion and adopted new DB2 V13 features like Statement-Level Dependency for Packages, improving database management capabilities.

Timeline

Senior Specialist / Senior Database Engineer

BetaNXT
10.2008 - Current

Application DB2 DBA

Electronic Data Systems
09.2005 - 09.2008

IBM Mainframe Developer

Infosys
05.2004 - 08.2005

IBM Mainframe Developer

Cognizant
08.2000 - 04.2004

XII - undefined

Delhi Public School/CBSE

X - undefined

Delhi Public School/CBSE

BACHELOR DEGREE - BE in Metallurgical Engineering

NIT Jamshedpur/Ranchi University
SUMAN DASGUPTAMainframe DB2 Systems And Applications DBA