SUMMARY:

• Dynamic and accomplished professional with 10+ years of experience in IT industry
• Proactive decision maker, seeking to be a Senior Database Administrator/Program Manager/Delivery Manager with a well established and globally reputed organization.
• Worked as the Primary DB2 for Z/OS Database Administrator in the Centralized Database Administration Team for Prudential and Lloyds Bank UK.
• Efficient Team Leader with sound communication, interpersonal, negotiation and problem solving skills. Also very good analytical, leadership and multiple task managing capabilities.
• 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
• Worked with Data Modelling team to design Database objects for applications from scratch. Also to enhance existing relational databases.
• Worked in IBM Websphere Replication Server for Z/OS. 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.
• 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 DB2 Version 8 and Version 9 upgrade for DB2 Z/OS. Currently involved in DB2 V10 Migration
• Primary DBA for a 24 x 7 mission critical application - with volumes ranging in 100-200 millions.
• 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 of 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 report including plan, progress and risks to the stakeholders to ensure smooth progress of project activities.
• Periodically monitoring & improving system performance.
• Mentoring & training 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: 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

Platform: Z/OS 390

Software/Tools: DB2 Utilities

Database: DB2 Z/OS V8, DB2 Z/OS V 10

Senior Database Administrator/Architect

Responsibilities:

• Working as a DB2 Specialist/Architect and since this operational data store is in the receiving end, analyses the impact 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
• 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, Newark, NJ

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.
• 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.

Confidential

Developer

Responsibilities:

• Worked as a Team Member
• Involved in the Database Requirement Analysis, Database Design.
• Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.
• Development/Enhancement of Mainframe Application Programs(CICS-DB2 and COBOL-DB2)
• Development, Testing and Documentation of all the projects.
• Coordinating the Business Requirements, Delivery with the Onsite Team.