With 8 years of working experience in the Z/OS , to seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Logical DBA
Stellantis ,IBM Consulting India
03.2022 - Current
Experience in utilities and tools used for database monitoring (DB2 traces, online performance monitoring, Explain for access path analysis), data movement and organization (LOAD,UNLOAD, REORG), data consistency and manipulation utilities (RUNSTATS) etc.,
DB2 Bind card creations using DRM Tool and resolving incidents related to bind compilations in Drive IT
Providing support on IMS database unavailable issues, deque transactions. Incident Management using Service now.
Fine tuning the SQL’s in the program with BMC Explain and providing necessary recommendations to the application users.
Auditing SOX on DB'S with relevant evidences, activities and theories .
Providing access to users on DB2 objects on requirement basis
DCCS Approvals , checkpoint restart logic approvals for COBOL Programs in IMS DB , PSB generations in the DCCS
Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
QA Tester
ePricer IW , ePricing ,IBM India PVT LTD
06.2015 - 06.2022
Monitored resolution of bugs, tested fixes and helped developers tackle ongoing problems by providing QA perspective using SERVICENOW / DRIVE IT
Documented testing procedures for developers and future testing use.
Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
Maintaining RACF ID's and system environment ID's on lower environments through IBM CLAS , ASO, ITIM
Experienced in DB2ADMIN panel for all DB2 Utilities
Experienced in Create/Alter/Drop DB2 Objects based on the user requests.
Experience in utilities and tools used for database monitoring (DB2 traces, online performance monitoring,Explain for access path analysis), data movement and organization (LOAD,UNLOAD, REORG), data consistency and manipulation utilities (RUNSTATS) etc.,
Experience in batch scheduling IBM tools such as OPC Tiwoli and CA7
Experienced in mainframe to cloud migration with lift and shift planning and implementations on respective environments
Experienced in data replication through crossloader JCL's with Dpropr DRDA
Extra care during weekend production change window and addressing issues quickly.
Monitored system resources, including memory usage, CPU utilization, and disk space, and took corrective action when needed to maintain optimal performance levels.
Application DBA
IACRR , IBM IGA
12.2015 - 04.2018
Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
Participated in situation management of incidents to support database operations.
Experienced in Create/Alter/Drop DB2 Objects based on the user requests.
Performing unit,regression testing and preparing the test results for the developed functionalities.
Providing Grants / revokes to users on requirement.
Production Promotion of code changes after testing and live support on production deployments
Education
Bachelor of Engineering - Electronics And Communications Engineering
Andhra University College of Engineering
Visakhapatnam
05.2015
Intermediate - Maths Physics And Chemistry
NRI Academy
Vijayawada
05.2011
SSC -
Aditya Public School
Bhimavaram
05.2009
Skills
Root Cause Analysis
JCL
VSAM
DB2 Utilities
RDBMS
OPC, CA7 Schedulers
Agile Methology
Data Replication
Certification
Ibm certifications on DB2 V9 and V10 610
Ibm certifications on DB2 and V10 DBA -612
Timeline
Logical DBA
Stellantis ,IBM Consulting India
03.2022 - Current
Application DBA
IACRR , IBM IGA
12.2015 - 04.2018
QA Tester
ePricer IW , ePricing ,IBM India PVT LTD
06.2015 - 06.2022
Bachelor of Engineering - Electronics And Communications Engineering