Manager Data
Resume:
Radhika Bodepudi
Contact: 425-***-****
Mail ID:*********.*@*****.***
Skype ID:radsb372
Professional Experience:
•Professional with hands-on experience on Mainframe DB2 and IMS DBA with very strong technical, interpersonal and communication skills.
•Creating DBDs,PSBs and performing DBDGEN, PSBGEN and ACBGEN for the new or existing databases,Programs in IMS.
•Actively involved in a data migration project which involved converting and transmitting data from DB2 Mainframes to other RDBMS.
•Expert in performance tuning activities related to DB2 database activities. Advising the application teams in optimizing their complex SQL’s.
•Expertise in automating manual DBA efforts using JCL, SORT and other DB2 techniques.
•Proactively worked in multiple challenging projects on DB2 and IMS
•Experience in 24 * 7 production support on highly demanding 15 minute SLA accounts.
•Commendable efforts in Analysis, Design, and Development of DBA related activities.
•Actively involved the DB2 version changes from V8 to V9, V9 to V10 and latest being V10 to V11.
•Running IMS IBM/BMC housekeeping or maintenance utilities like COPY,LOAD/Re-Load,Rebuild.
•Maintaining and populating Test Databases through Defcut/Data refresh process for IMS & DB2 databases.
•Implemented changes related to Full-Function to HALDB conversion in IMS,HALDB partition Split.
•Production Job Monitoring, trouble-shooting and resolution.
Learning & Development on DB2 LUW:
•Self-driven DB2 on windows project at Travelers data engineering practice by installing DB2 10.5 EXP C.
•Installation of DB2 10.5 driver on test workstations to understand and implement client – server interface.
•Updating the db2cfg and db2cli files on the windows environment using Microsoft visual studio to suit the internal project requirement.
•Analyzing various issues on DB2 10.5 EXP C edition and transferring the knowledge gained on the IBM developer works community
•Processing license files by adding and removing the license file from the system
PROFESSIONAL SUMMARY:
Project Title: DB2 DBA / IMS DBA
Client: Travelers Insurance
Role: DB2 DBA – IMS DBA Team Lead
Team Size: 10
Duration: September 2014– May 2018
Location: Cognizant Technology Solutions-Chennai, Tamilnadu.
Roles & Responsibilities:
•Reviewing/Creating/Modifying the database structures as requested by Application development team.
•Grant and Revoke of privileges based on the design document. Working on the Authorization problems in Production in case of any emergency situations with the help of Incident.
•Creating and setting up of Utilities like Reorg, Copy, Runstats, Load, Unload, modify etc. through CA7 job Scheduler and Reviewing the job flows if in case of any contentions or Delays in meeting the requirements with the other Application jobs.
•Involved in IMS Version upgrade from V11 to V12 activity happened recently in all Development, Test and Production regions and have performed testing on all IMS application Database related test cases.
•Did implement Fun function to HALDB conversions for the Large databases in IMS.
•Implemented HALDB partition split for the database partitions that are reaching maximum limit.
•Do a health check of all the IMS and DB2 databases on daily basis to monitor if the objects are reaching threshold.
•Fixing abends on IMS DB if application is having problems accessing DB.
•Schedule Housekeeping jobs like Image copy,Reorg for IMS databases on weekly basis using IBM/BMC utilities .
•Migrate the database objects from one environment to another using BMC Change Manager. And have expertise in working with Migrate/Alter/Receive works through change manager, Creating Baseline Profiles in case if the structure changes involve Drop of Objects.
•Generate reports and monitor table space/index space allocations/extends and perform maintenance (Resize table space/index space, Reorgs, Runstats, etc.) whenever necessary for DB2 and IMS, for each space alert firstly discuss with application team and explain the scenario. If that line of business accepts for the changes DBA will raise a change ticket to implement the work in Production.
•Worked with customers for creation of MQTs for the first time in the LOB. While Working with MQTs I have learnt the mechanism of them, How the Refresh process for the MQTs help in solving the Memory resistance issues currently that LOB had.
•As part of DB2 version upgrade process, I have worked on brining the Objects to the current version of DB2 which involves Simple to UTS tablespace, VCAT to Storage Group Conversion, BRF to RRF format, Mutli Table tablespace to singe Table Tablespace.
•DB2 version upgrade process happened across the LOBs and I have successfully converted all the objects to most current version and regenerated all the Housekeeping Jobs Impacted(Reorgs).
•Many Line of Business here deals with the LOB (Large Objects) Tables, I did extend my support to solve the problems that LOB was facing with their Unload and Purge process for the LOB columns. With the current version of DB2 I have introduced the SPANNED yes feature which solved their problems.
•Handled the recovery scenarios for DB2 and IMS databases, Familiar with all the type of recoveries (Point in time, Previous Image copies as requested).
•Solved Backup exceptions that get reported on daily basis to keep the objects recoverable at any point in time.
•I have worked on tuning the queries and the Batch jobs that were reported by Application team as running longer due to performance impact of the queries. Tested the queries through Data studio to improve the query using the concept of Virtual Index and convinced the Line of business to implement which brought the major cost savings.
•For Implementing data base model changes for DB2 objects I have used CA ERWIN data modeler and Coolgen,Worked on maintaining the database structures similar with the database environment.
•Refresh data from production to Test regions for Sandbox testing in case of any Performance problems with the actual data for better results.
•I have worked on Performance monitoring/tuning on requests for Static SQLs using IBM data studio .
•Perform user change requests.
•Resolve production Job failures/ and work on 24x7 On-call support for DB2&IMS databases.
•Recovery of production data.
•Co-ordinate with system programming team in DB2 version upgrade.
•Resolving bind failures
•Reduction of storage space and Storage pool monitoring.
•Production database performance analysis.
•Statement level OPTHINT setup for dynamic SQL’s.
•Utilized COBOL ENTERPRISE, DB2 (online and batch) including stored procedures, IDMS (Online and VSAM, TSO/ISPF, JCL, JCL Utilities, File-Aid, IDCAMS, CA/7 for assigned projects.
•Capacity management of production DB2 objects.
•Did provide data extra reports for business users and developers with extensive data formatting in the form of Graphical or Tabular using QMF (Query management facility).
•Performance management of DB2 objects and engage with technical support teams in performance and problem resolution.
•Engage with technical infrastructure support teams and IT development teams in performance and problem resolution and application design and development.
•DB2 Objects (database, table/index spaces, etc.) cleanup and archiving.
•Used Microsoft Office Suite; ACCESS, EXCEL and WORD on daily basis for preparing Presentations, Database related reports, Knowledge transfer documents for Training other DBAs.
•I have good experience in Training other DBAs of a Team for Project/Technical activities. I did prepare Presentation to showcase the cost savings done for a project implemented for Index compression.
•I have been a lead for DB2 projects that has to deal with DB2 version upgrades, DB2 tool upgrades or Changes.
Environment: Z/OS, COBOL, JCL, TSO/ISPF, DB2, SPUFI, QMF,IMS, IBM tools, BMC tools, CA Administration tool suite, CA7,SYNCSORT.
Project Title: Telecommunications- DB2&IMS DBA Support
Client; Telstra
Role: Mainframe Developer / DB2 DBA – Team member
Team Size: 6
Duration: March 2011 – September 2014
Location: Mphasis Private Limited, Chennai
Roles & Responsibilities:
•Utilized COBOL ENTERPRISE, DB2 (online and batch) including stored procedures, IDMS (Online and Batch), VSAM, TSO/ISPF, JCL, JCL Utilities, File-Aid, IDCAMS, Expediter and CA/7 for assigned projects.
•Developed a complete production mirror test environment using MVS/JCL and batch File Aid.
•Had been a part of all regular activities like refreshing tables with data using IBM & BMC utilities, checking on all job abends reported by application team due to Db2 abend codes.
•Attend all Severity 1 & 2 issue calls and give updates from DB2 perspective.
•Involved in DB2 Version upgrade from V8 to V9,V9 to V10 activity happened recently in all Development, Test and Production regions and have performed testing on all IMS application
•Database related testcases.
•Database maintenance functions including: UNLOAD LOAD, BACKUP, RUNSTATS, REORG, Recovery, Resize etc.
•Flexible to use BMC products like Catalog Manager, RTLS etc.
•Worked on Omegamon, Endeavor, APA,CNTL-M,OMCS,FILEAID and Storage management tools.
•Had been a part of Environment build and Data refresh activity i.e. migrating data between Production to other subsystems.
•Monitoring contention reports and checking on contentions closely if it is a Non-BAU.
•Provide access (grant/revoke) to application team/Batch ids on the required Databases.
•Provide Data extraction reports against DB2 logs frequently as requested by Application team from Telstra users.
•Had been a part of release activities that happens as a part of Development projects.
•Have done data extracts for the queries requested by application team using SPUFI and QMF tools.
•Have done performance tuning for queries of Type Static and Dynamic using Omegamon and APA tools.
•Monitoring space regularly of all the DASD pools.
•Database maintenance functions including: Regular Backups, Runstats, Reorg, Recovery, Resize etc.
•Had been a part of all regular activities like refreshing tables with data using IBM & BMC utilities, checking on all job abends reported by application team due to Db2 abend codes.
•Attend all Severity 1 & 2 issue calls and give updates from DB2 perspective.
•Involved in DB2 Version upgrade from V8 to V9 activity happened recently in all Development, Test and Production regions and have performed testing on all IMS application Database related testcases.
•Database maintenance functions including: UNLOAD LOAD, BACKUP, RUNSTATS, REORG, Recovery, Resize etc.
•Flexible to use BMC products like Catalog Manager, RTLS etc.
•Had been a part of Environment build named as Defcut i.e. extracting the data from Production and refreshing all the Databases with that data in Test region.
•Provide access (grant/revoke) to application team/Batch ids on the required Databases.
•Flexible to use BMC products like Catalog Manager, RTLS etc.
•Worked on TSO/ISPF Commands,Omegamon, Endeavor, APA, CNTL-M,OMCS,FILEAID and Storage management tools.
•Have good knowledge on Environment and Architecture of Telstra applications supported
by IMS.
•As a IMS DBA I have flexibility to perform day to day activities like Database health check,
•Monitoring all IMS production jobs, checking on Space monitoring reports.
•Provide 24x7 On-call support and attend all Severity 1& 2 issue calls to give updates from IMS perspective.
•Provide Data extraction reports against IMS logs frequently as requested by Application team from Telstra users.
•Monitoring contention reports and checking on contentions closely if it is a Non-BAU.
•IMS Performance monitoring from application and subsystem perspective.
•Apart from this there are weekly activities like IMS Reorg or Resize for both the applications Of Telstra(Flexcab and UPS).
•Involved in IMS Version upgrade from V10 to V11 activity happened recently in all Development, Test and Production regions and have performed testing on all IMS application Database related testcases.
•Involved in defining new PSB’s, PSB changes, DBD changes and Transactions as a part of Development project.
•Perform Steplib changes related to Development projects and perform MFSGEN request to maintain online screens Navigation properly as requested by application team.
•Used Microsoft Office Suite; ACCESS, EXCEL and WORD tools for preparing checklist related to oncall abends, Presentations related to version changes, Monthly release activities.
Environment: S/390, Z/oS,DB2,IMS, JCL,TSO/ISPF,VSAM,COBOL,SYNCSORT
Affiliation:
DB2 Community Profile:
RUG Leader, International DB2 Users Group (IDUG): Been a Regional User Group Leader for the International DB2 Users Group, IDUG ( www.idug.org ). Active participation in events, webcasts and other community forums helping, discussing and sharing the DB2 knowledge worldwide
BOD, Chennai DB2 Users Group:
Been as the board of directors and the Chair of the planning committee for the Chennai DB2 Users Group community in India. CDUG, India is user group community dedicated for spreading the knowledge on DB2 and conducting technical conferences at Chennai, India.
Personality Traits:
•Strong motivational and leadership skills.
•Excellent communication skills in written and verbal both.
•Ability to produce the best result in pressure situation.
•Ability to work in team as well as individual.
Certifications:
•IBM Certified DB2 Database Administrator V 10 for z/OS.
Educational Qualification:
•B.Tech in Information Technology from JB institute of engineering and technology, India, 2010
Technical Skills:
Operating System: Z/OS, MVS, Windows
Languages: SQL, COBOL, JCL, C, C++,Java
Databases: DB2 for z/OS, IMS DB/DC, DB2 for LUW
Access Methods: VSAM
Tools & Utilities BMC Products: Catalog Manager, DASD Manager, LogMaster, CNTL+M, Omegamon.
CA Products: CA7, PLATINUM, CAVIEW, CA-Log master.
IBM Products: IBM DB2 Administration tool, IBM Lotus note, File-Aid for DB2/IMS
Contact this candidate