OBJECTIVE

• Aspiring to do a challenging job in Software Design and Development, and Database Administration.

SUMMARY

• More than 15 years of IT Experience in database development & documentation on Mainframe Technologies and TEMPhas good expertise of Database Administration.
• 8 years of experience of as a Database Administrator.
• Experience in doing upgrade from DB2 8.1 to DB2 V9.
• Extensive experience with large databases including DB2 7.0, 8.1 & V9.
• Extensive experience on various Mainframe Application Development and Testing Tools including DB2 CONNECT, DB2 Explain, FILE - AID for MVS/DB2, BMC Log Master, BMC Apptune, BMC Admin Tools, BMC LOAD PLUS & UNLOAD PLUS, CA Database Analyzer, IBM Optim Tool, QMF, SPUFI, QMF for Windows, IBM Data Studio, DB2 Admin & DB2I.
• Extensive experience on various Mainframe Configuration Management Tools including CHANGE MAN, ENDEVOR & PANVALET
• Good Experience on REXX.
• Possesses excellent verbal and written communication skills along with premium interpersonal skills.
• Possesses extensive quality assurance experience.

TECHNICAL SKILLS

• Database Administration for DB2 V7.1, V8.1 & V9
• Performance Tuning for DB2
• Disaster Recovery of DB2 databases
• Online and Stand-alone DB2 utilities (both IBM and non-IBM)
• Extensive experience with tools.
• DB2 EXPLAIN
• Database Tuning in DB2 UDB V 8.1
• DB2 Performance Monitoring, Resource Monitoring and Tuning
• Event Monitoring
• Snapshot Monitoring
• Worked in Data sharing environment
• IBM OS/390 Version 2 release 4(MVS for S/390)
• IBM z/OS V1.10
• DB2 v610, v710, v810, v9 for OS/390
• BMC Admin Tools (Catalog Manager & Change Manager)
• BMC Log Master
• BMC Apptune
• CA Database Analyzer
• IBM Optim Tool (Formerly Princeton Softech Optim Tool)
• DB2CONNECT
• QMF/ESA Version 3 (Query Management Facility)
• QMF For Windows
• IBM Data Studio
• IBM Optimization Service Center
• AQT (Advanced Query Tool) for DB2
• TOAD Server Login Version 6.3.11.1
• PL/SQL, REXX, DB/2 SQL, SAS, COBOL
• MVS JCL (Job Control Language)

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Database Administrator

Environment: z/OS, DB2, JCL, BMC Tools, Optim Tools, DB2CONNECT, REXX

Responsibilities:

• Involved in day-to-day database administration and support for production, staging, Quality and Test environments.
• Deployed all teh Database changes across all teh environments.
• Maintaining data integrity and security.
• Setup DB2 Connect to provide access to Mainframe data.
• Involved in tuning and changed teh database manger configurations to meet teh application needs.
• Providing on call support (24X7) for all database issues.
• Physical Design and maintain database
• Code Optimization & SQL Tuning
• Space Management
• Running teh re-orgs on a regular basis
• Taking daily image copies (one before teh start of teh batch cycle, teh next one is after teh batch cycle is completed)
• Copying teh data from PROD to Read-only environment on a daily basis
• Maintaining teh Rexx programs and modified them as and when needed
• Archiving and purging data using IBM/Princeton Softech Optim tool
• Worked on Disaster Recovery
• Had set up JCLs based on Database Analyzer to generate conditional re-orgs
• Had created a process to read teh logs for changes for few tables and also particular columns in tables to create files using BMC Logmaster.
• Created batch reports using BMC Apptune.
• Worked on upgrade from DB2 V8.1 to DB2 9.0
• Worked on upgrading DB2CONNECT from V8.14 FP1 to V9.7.1

Confidential, Portland, OR

Database Administrator

Environment: z/OS, DB2, JCL, BMC Tools, DB2CONNECT, REXX

Responsibilities:

• Involved in day-to-day database administration and support for production, staging, Quality and Test environments.
• Deploying all teh Database changes across all teh environments.
• Maintaining data integrity and security.
• Deploying Stored Procedures in different environments.
• Setup DB2 Connect to provide access to Mainframe data.
• Modified teh SQL scripts for tables and store procedures.
• Involved in tuning and changed teh database manger configurations to meet teh application needs.
• Involved in creating database Snapshots during teh performance testing.
• Coordinating with other groups while fixing teh problem when site goes down.
• Providing on call support (24X7) for all database issues.
• Physical Design and maintain database
• Code Optimization & SQL Tuning
• Space Management

Confidential, Indianapolis, IN

Database Administrator

Environment: z/OS, DB2, JCL, BMC Tools, DB2CONNECT, REXX

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 teh SQL scripts for tables and store procedures
• Involved in tuning and changed teh database manger configurations to meet teh application needs.
• Involved in creating database Snapshots during teh performance testing.
• Coordinating with other groups while fixing teh problem when site goes down.
• Providing on call support (24X7) for all database issues.
• RACF (User Profile) Maintenance and Administration
• Physical Design and maintain database
• Code Optimization & SQL Tuning
• Providing uninterrupted support for Production, Development and Disaster Recovery Systems

Confidential, Pella, IA

Database Administrator

Environment:z/OS, DB2, JCL, BMC Tools, DB2CONNECT, REXX

Responsibilities:

• Responsible for day-to-day database activities.
• Involved in maintenance, administration, monitoring, performance tuning, SQL tuning.
• Worked on test, integration, QA and production databases and provided 24/7 support.
• Supported incremental and bulk loads.
• Scheduled runstats and reorgs on a timely basis before backups.
• Worked on utilities like load, import and export.
• Took snapshots for database tuning.
• Code Optimization & SQL Tuning
• Physical Design and maintain database

Confidential, San Antonio, TX

Project Leader

Environment: OS/390, MVS, DB2, JCL, COBOL, CICS, MS-Office

Responsibilities:

• Allocating work to teh team members.
• Developing teh modules dat are required.
• Providing 24 hours support to teh project.

Confidential, New York, NY

Project Leader

Environment: OS/390, MVS, DB2, JCL, COBOL, CICS, MS-Office

Responsibilities:

• Allocating work to teh team members.
• Developing teh modules dat are required.
• Providing 24 hours support to teh project.