DBA Experience summary❑ Having 8.5 years of relevant experience as a DB2 DBA for z/OS (Mainframe)❑ Experienced in DB2 Administration for Production support and Application support projects❑ Capable in creating & maintaining database objects, associated privileges & running utilities on them in Test & Prod environments❑ Successfully handled 24 x 7 production On-Call DBA support responsibilities❑ Provided technical support to application teams in resolving application and database related issues❑ Experienced in using tools like BMC & IBM Change manager, BMC Catalog Manager, IBM DB2 Admin tool❑ Experienced in altering DB2 objects and using DB2 utilities like COPY, UNLOAD, LOAD, REORG, RUNSTATS❑ Access path review of existing and new SQLs & Stored Procs, which includes performance analysis & tuning of SQLs if needed❑ Implementation & back out job preparation and testing of those jobs in Dev & Test environments for Production releases

Project DescriptionRBS Group is the largest banking group in Scotland. The RBS Group operates a wide variety of banking brands offering personal and business banking, private banking, insurance and corporate finance throughout its operations located in Europe, North America and Asia.Role and ResponsibilitiesAs part of RBS DB2 Projects Team (January 2019 till now):- Working on DB2 Production releases as part of RBS DB2 Project (eOBAO)- Understanding release requirements from Application Team, presenting them to the client and implementing those requirements in Dev, Test and PROD regions- Release implementation includes Creation/Altering of DB2 Objects, Implementation of the CDLs created- Implementation and Backout jobs preparation and testing of those jobs in Dev and Test Environments for Production releases- Stored Procedures Drop, Creation and Access path review- Space calculations of DB2 objects- Access path analysis for SQLs, which also includes setting up and analyzing the trace for DB2 packages- Replication setup of required tables and altering of already existing DB2 objectsAs part of RBS DB2 CONFIG Team (September 2018 till December 2018):- Creating, maintaining and altering DB2 database objects- Syncing up of database objects structures from one region to another region- Performing Online Reorg, RUNSTATS, Load and Unload utilities- Performed Image copy, QUIESCE, recovery to point in time and to Image copy as per request of application team- Performing bind and rebinds- Granting access on DB2 objects as per request- Provided 24/7 on call support for production databases on a rotation basis

Project DescriptionAustralia’s government based telephone service provider, supported by Mphasis earlier and later by HCL as a DB2 DBA services team include FLEXCAB, MICA and UPS which works with DB2 and IMS at the backend databases.FLEXCAB and MICA are the core of Telstra’s billing system for both ‘Retail’ and ‘Wholesale’ set of applications. The system supports ‘Integrated Invoice’ generation to provide customer with a single invoice for all the Telstra services subscribed to such as Fixed Line Phones and Mobile Phones Internet Service.Role and Responsibilities- Maintain 3 subsystems (supporting Development, Testing and Production regions)- Creation of Objects and their maintenance- Working on IBM and BMC utilities like Load, Unload, Copy, RUNSTATS and Reorg- Handling requests initiated through E-mail and Clarify ticketing & Change control tool- Implementation or Promotion of Objects and Data between Subsystems- Support to development teams for database issues- Data refresh within subsystem and cross subsystem- Production changes implementation- Support in fixing jobs related to Copy, Reorg, Load, Unload, RUNSTATS and other scheduled jobs- Provide 24x7 on-call support for DBA related jobs and database related application jobs for DB2 related issues like production Job Monitoring, trouble-shooting and resolution- QUIESCE to create appropriate Recovery Points- SQL review for new queries- Testing related to DB2 version upgrade

Project DescriptionAustralia’s government based telephone service provider, supported by Mphasis earlier and later by HCL as a DB2 DBA services team include FLEXCAB, MICA and UPS which works with DB2 and IMS at the backend databases.FLEXCAB and MICA are the core of Telstra’s billing system for both ‘Retail’ and ‘Wholesale’ set of applications. The system supports ‘Integrated Invoice’ generation to provide customer with a single invoice for all the Telstra services subscribed to such as Fixed Line Phones and Mobile Phones Internet Service.Role and Responsibilities- Maintain 3 subsystems (supporting Development, Testing and Production regions)- Creation of Objects and their maintenance- Working on IBM and BMC utilities like Load, Unload, Copy, RUNSTATS and Reorg- Handling requests initiated through E-mail and Clarify ticketing & Change control tool- Implementation or Promotion of Objects and Data between Subsystems- Support to development teams for database issues- Data refresh within subsystem and cross subsystem- Production changes implementation- Support in fixing jobs related to Copy, Reorg, Load, Unload, RUNSTATS and other scheduled jobs- Provide 24x7 on-call support for DBA related jobs and database related application jobs for DB2 related issues like production Job Monitoring, trouble-shooting and resolution- QUIESCE to create appropriate Recovery Points- SQL review for new queries- Testing related to DB2 version upgrade