SUMMARY:

• Dynamic and accomplished professional with 17+ years of experience in IT industry
• Currently Working as the Production DB2 DBA for Z/OS at JP Morgan and Chase
• Worked as the Production DB2 DBA for Z/OS at GEICO
• Worked as the Primary DB2 for Z/OS Database Administrator in the Centralized Database Administration Team for Prudential and Lloyds Bank
• Efficient Team Leader with sound communication, interpersonal, negotiation and problem solving skills. Also very good analytical, leadership and multiple task managing capabilities.
• Expert in using BMC Recovery Manager to recover data from Image Copies.
• Expert in using BMC Log Analyzer to analyze the history of data modification and other database issue
• Worked extensively in BMC NGT REORG to perform cleanup/reorganize large DB2 objects. Testing and upgrading of multiple DB2 Utilities include BMC REORG
• Involved extensively in Performance Tuning of Application SQLs.
• Good knowledge on IBM’s Performance Tools like Data Studio, Visual Explain and Platinum Detector for Z/OS
• Sound knowledge on PLAN TABLE - and manual EXPLAIN, to survive in the world of No Performance evaluation tools
• Sound knowledge on Database Administration Utilities - like COPY, UNLOAD, LOAD, REORG, RUNSTATS, MODIFY, REBUILD, REPAIR, CHECK, QUIESCE, RECOVER, STOSPACE.
• Worked in changing Logical Data Model to Physical Data model, using ERwin to design Database objects for applications from scratch. Also to enhance existing relational databases.
• Worked as a Project Lead to monitor team’s progress in implementing projects. Created Data Metric reports for Senior Managers.
• Worked in IBM Websphere Replication Server for Z/OS, Infosphere Change Data Capture. Setting up Capture, Apply tables for replication of data
• Worked in Infosphere Q Replication for Z/OS - that replicates data from 4 instances to an Operational Data store.
• Worked with the Datastage team, to implement Data Warehouse Repository for an application called Transaction Operational Data Store
• Played a key role in setting up Replication for more than 1500 tables, using Infosphere Data Replication for Z/OS
• Played a major role in the design of a Performance Monitoring System for DB2 applications
• Involved in Performance Tuning of DB2 Queries and saved more than half a million dollars in CPU Time for Prudential
• Planned, Designed and executed the database testing for DB2 Version 8, Version 9 upgrade and Version 10 Upgrade for DB2 Z/OS.
• Primary DBA for a 24 x 7 mission critical application - with volumes ranging in billions of rows.
• Acting as Senior DBA with good knowledge on Database, and supporting multiple application teams across Prudential
• Acting as a Lead managing different applications to successfully deliver projects of various sizes.
• Recommending efficient System solutions for
• Critical Reports
• Projects involving cleaning up a large amount of data.
• Projects involving update of large amount of data
• Performing Database Requirement Analysis, Database Design.
• Maintained Database Security by providing proper authorities and privileges.
• Developing Data Definition Language for implementation across End to End, QA, UAT and Production
• Performing proactive Database Maintenance, Improving Space Utilization and thereby cost
• Conducting volume testing, performance tuning
• Providing periodical status reports including plan, progress and risks to the stakeholders to ensure smooth progress of project activities.
• Periodically monitoring & improving system performance.
• Mentoring & junior DBAs to attain overall project & organizational objectives.
• Conducted business & system impact analysis, risk assessment, end-to-end effort estimation.
• Translated business requirements into detailed specifications and managing design & development activities.

TECHNICAL SKILLS:

Database & Tools: DB2 for Z/OS, SPUFI, QMF,Platinum Detector,Data Studio, BMC Change Manager

Languages: COBOL, JCL, Rexx, ISPF Panels, VB.NET(Developed a small application)

Operating Systems: MVS,OS/390

File Management: VSAM, File-Aid

Communication: CICS, TSO/ISPF

Other Tools: Changeman, Strobe, Omegamon

Application Package: MS Office (Excel, PowerPoint, Word), MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Production DB2 DBA Support with an on Call rotational basis
• Enterprise Release Support
• Monthly Database Maintenance
• On-Call Production Support
• DB2 Performance and Health checks
• Queue Replication Support
• Development Activities
• Application Development Database Changes
• Environment Data Sync
• Development/QA/UAT Testing Support
• Switching Q-Replication from one UAT to another
• JETS support - JETS is a shadow environment of Production maintained in a completely different machine
• JP Morgan maintains copies of Production data and different environments data using Queue Replication method. Involved in setting up Queue Subscriptions, supporting replication.
• Involved in tuning existing Batch jobs that run for hours, by introducing new indexes.

Confidential

Senior Database Administrator

Responsibilities:

• Production DB2 DBA Support with an on Call rotational basis
• Requirement Analysis, Impact analysis w.r.t DB2
• Database Administrator for Development, FNST, Integrated, Fast Track and environments.
• Involved in the Database Requirement Analysis, Database Design.
• Creation of Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
• Coordinating implementation of Database Objects in Production Databases
• Primary Support for the IIDR CDC Replication product for a Big Data - Data Warehousing Project
• Setting up of Subscriptions to replicate data for more than 1000 Policy and Billing Tables
• Primary Support for implementing AGILE Methodology in SOD Production DB2 DBA group

Confidential

Senior Database Administrator/Architect

Responsibilities:

• Working dual role as a Senior DB2 DBA.
• Requirement Analysis, Impact analysis w.r.t DB2
• Database Administrator for Development, SIT, ST, OAT Databases.
• Involved in the Database Requirement Analysis, Database Design.
• Creation of Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
• Coordinating implementation of Database Objects in Production Databases
• Running Backup - Image Copies, Unload at regular intervals or on an On Demand basis.
• Restoring Database or specific tables, with Image Copies, Unload Files
• Maintained Database Security by providing proper authorities and privileges.
• Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular intervals.
• Analyzing Performance Problems for different application SQLs, using Plan Tables, Visual Explain, Detector etc.
• Tuning the existing SQLs, Suggesting Indexes to save the CPU time and the Run Time.
• Working on Tools like BMC Change Manager, CA Detector, SQL Explorer which helps in the definition and performance monitoring
• Working on setting up Replication using Infosphere Replication Server, Change Data Capture
• DB2 Migration
• Documenting the new features of DB2 V9, V8 based on the upgrade
• Coordinating with application teams, to benchmark performance and functionality in lower version. Compare, analyse the performance in the upgraded version
• Performing the following activities as a backup DBA for DB2 UDB
• Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities.
• Insert data into application tables using IMPORT command and LOAD Utility
• Recover data to a particular point using ROLL FORWARD command

Confidential

Senior Database Administrator

Responsibilities:

• Database Administrator for Development, Quality Assurance, End to End and User Acceptance Databases.
• Involved in the Database Requirement Analysis, Database Design.
• Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
• Coordinating implementation of Database Objects in Production Databases
• Running Backup - Image Copies, Unload at regular intervals or on an On Demand basis.
• Restoring Database or specific tables, with Image Copies, Unload Files
• Maintained Database Security by providing proper authorities and privileges.
• Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular intervals.
• Analyzing Performance Problems for different application SQLs, using Plan Tables, Visual Explain, Detector etc.
• Tuning the existing SQLs, Suggesting Indexes to save the CPU time and the Run Time.
• DB2 Migration
• Documenting the new features of DB2 V9, V8 based on the upgrade
• Coordinating with application teams, to benchmark performance and functionality in lower version. Compare, analyse the performance in the upgraded version.

Confidential

 Database Administrator/Team Lead

Responsibilities:

• Database Administrator for Development, Quality Assurance, End to End and User Acceptance Databases.
• Involved in the Database Requirement Analysis, Database Design.
• Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
• Coordinating implementation of Database Objects in Production Databases
• Running Backup - Image Copies, Unload at regular intervals or on an On Demand basis.
• Restoring Database or specific tables, with Image Copies, Unload Files
• Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular intervals.
• Maintained Database Security by providing proper authorities and privileges.
• Working on setting up Replication using Infosphere Replication Server, Change Data Capture
• Analysis, Design and SQL Coding
• Worked in all phases of Software Development Life Cycle
• Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.
• Involved in Preparing System Design Document, Installation Guidelines and Detailed Test Plan.
• Involved in high-level design for major projects.

Confidential

 Application Team Lead

Responsibilities:

• Worked as a Tech Lead
• Involved in the Database Requirement Analysis, Database Design.
• Worked as a Module Leader and lead a team of 10 associates.
• Worked as a Module Leader for Production Core Remedy Fix team.
• Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.
• Involved in Preparing System Design Document, Installation Guidelines and Detailed Test Plan.
• Involved in high-level design for major projects.
• Development of new Mainframe Application Programs(CICS-DB2 and COBOL-DB2)
• Review the work items developed by the team members
• Development, Testing and Documentation of all the projects.
• Coordinating the Business Requirements, Delivery with the Onsite Team.