SUMMARY

• Over 10 years of IT Experience as a Database Administrator, Designer, Architect, Data Modeler, Analyst, Engineer and Developer
• Over 6 years of experience of as a Mainframe DB2 DBA
• Proven expertise as a Mainframe DB2 DBA running on z/OS
• Extensive experience wif large databases including DB2 Versions 7,8 & 9
• Worked in implementation of DB2 V8 running on z/OS
• Involved in day - to-day database administration and support for Critical Test regions, staging, Quality, Test and Production environments
• Extensive experience in carrying out DB2 Database Administration activities involving development, database design, modeling and tuning, query optimization, back-up and recovery, space management and security maintenance
• Assisted Systems Programmers while installing products in testing
• Possess experience in working wif Business Analysts/Functional Analysts to understand and carry out business needs/requirements
• Extensive experience on various Mainframe Application Development and Testing Tools including TMON for DB2, TMON for MVS, DBA-XPERT, CHANGEMANAGER, RC/Query, SQL EASE, MAINVIEW, APPTUNE, DB2 Explain, FILE-AID for MVS/DB2, EXPEDITOR, TSO/ISPF, QMF & SPUFI
• Proven ability to create, administer, migrate and TEMPeffectively performance tune large number of databases on a 24X7 basis in a High Availability environment.
• Thorough knowledge in creating and modifying application database, Tablespaces, tables and indexes in DB2 running on z/OS
• Maintaining data integrity and security
• Worked wif a wide range of utilities including LOAD, LOADPLUS, UNLOAD, RUNSTATS, REORG, COPY etc
• Deploying Stored Procedures in different environments
• Providing Production support (24X7) for all database issues
• Physical Design and maintain database
• Code Optimization & SQL Tuning
• Used various tools (especially TMON/APPTUNE/MAINVIEW/SQL EASE) as part of performance analysis
• Possesses excellent verbal and written communication skills along wif premium interpersonal skills
• Recovered damaged table spaces

TECHNICAL SKILLS

Mainframe: IBM OS/390 Version 2 release 4(MVS for S/390) IBM z/OS

Database Management Systems: DB2 v7, v8 & v9 for z/OS

Tools: QMF/ESA (Query Management Facility) BMC Tools for DB2 V7.1/V8.1/V9.1 RC/Query TMON SQL Ease SPUFI MAINVIEW RC/Secure APPTUNE DBA-XPERT TSO/ISPF

Programming Languages/GUI: PL/SQL, REXX, DB/2 SQL, COBOL MVS JCL (Job Control Language)

PROFESSIONAL EXPERIENCE

Confidential, Storrs, CT

Mainframe DB2 DBA

Environment: z/OS, DB2, JCL, BMC Tools, DBA-XPERT, TMON, SPUFI, TSO/ISPF, SQL SERVER

Responsibilities:

• Creating and maintaining the databases, table spaces, tables, indexes, schemas (both administrative and development) in DB2 for developers
• Deploying Database changes across all the environments
• Troubleshoot and fix both development and operational systems (Development/Testing and Production)
• Monitor and maintain all DB2 objects found in the BDM database. This includes availability of DASD storage, maintenance of VSAM extents, tuning of queries and related objects..
• Monitor and maintain all DB2 utilities used to extract, transform and load (ETL) the BDM database
• Provide production support 24/7
• Support SADM (SQL SERVER & Decision Stream)
• Model the table structure that will be needed to add HR/Payroll history to BDM
• Coordinate user testing of the BDM HR/Payroll history data. Migrate the enhanced BDM table structures from development to test to production
• Provide additional BDM enhancements as requested
• Prepared Database/Tablespace progress reports based on space allocation/management
• Data Architecture, getting specs from business analysts and working closely wif them to implement database changes
• Working wif Logical and physical data modeling group
• Re-clustering of Indexes across the shop
• Maintaining data integrity and security
• Involved in Performance tuning for application batch processing
• Physical Design and maintain database
• Database maintenance for development, and synchronizing it wif production databases
• Code Optimization & SQL Tuning of existing legacy system
• Database creation and various objects' creation using CA tools
• Running utilities like COPY, LOAD, REORG, RUNSTATS and setting constraints

Confidential, Chicago, IL

Mainframe DB2 DBA

Environment: z/OS, DB2, JCL, BMC Tools, APPTUNE, REXX, RC/Query, Main View, Move for DB2, SQL Ease, RC/Secure, QMF, TSO/ISPF

Responsibilities:

• Troubleshoot and fix both development and operational systems (Development/Testing and Production)
• Involved in day-to-day database administration and support for Application groups, staging, Quality and Test environments.
• Deploying the Database changes across all the environments.
• Creating and Maintaining Databases, Tablespaces, Tables, Indexes (both Administrative and Development) in DB2 Environment for Application groups.
• Also, assisted systems programmer in installing products
• Setting up of Full Volume Test Region
• Prepared Database/Tablespace progress reports based on space allocation/management.
• Data Architecture, getting specs from business analysts and application groups.
• Working wif Logical and physical data modeling group.
• Re-clustering of Indexes across the shop
• Maintaining data integrity and security.
• Involved in Performance tuning for application batch processing
• Also involved in creating database copies during performance testing
• Physical Design and maintain database
• Database maintenance for development, and synchronizing it wif production databases.
• Code Optimization & SQL Tuning of existing legacy system
• Provide production support 24x7

Confidential

Mainframe Developer/DB2 DBA

Environment: z/OS, DB2, JCL, TSO/ISPF, BMC Tools, QMF, SPUFI

Responsibilities:

• Involved in day-to-day database administration and support for production, staging, test and development
• Setup DB2 Connect to provide access to Mainframe data.
• Modified the SQL scripts for tables and store procedures
• Involved in tuning
• Involved in creating database Snapshots during the performance testing
• Coordinating wif other groups while fixing the problem
• Responsible to Maintain database
• Code Optimization & SQL Tuning
• Providing uninterrupted support for Development & Test Environments
• Send weekly report to on-site manager on issues and discuss corrective measures

Confidential

DB2 Developer/DBA

Environment: DB2 & .NET

Responsibilities:

• Coded, tested, debugged, implemented, and managed DB2 applications.
• Modified the SQL scripts for tables and store procedures
• Involved in tuning
• Involved in creating database Snapshots during the performance testing
• Coordinating wif other groups while fixing the problem
• Responsible to Maintain database
• Done peer reviews as well as Internal/external reviews
• Code Optimization & SQL Tuning
• Providing uninterrupted support for Development & Test Environments