SUMMARY:

Database administrator (DBA) with extensive experience designing, coding, testing and supporting database solutions in DB2 & IMS databases for z/OS environment. Also possesses of work experience in programming with COBOL, JCL, CICS, REXX, CLIST, DB2, IMS DB/DC, and VSAM. Proficiency in using technology to enhance data and information management. Excellent analytical and problem solving skills.

SKILLS & EXPERTISE:

Hardware: IBM Mainframe, NT, PC

OS: OS/400, Windows, DOS

Databases: DB2, IMS, MS Access

Db2 Tools: Platinum, Db2 Admin, Visual Explain, Tivoli OMEGAMON XE for DB2 Performance Expert, IBM Query Management Facility(QMF), SPUFI, BMC utilities, File - Aid for DB2, Query Monitor(QM)

Languages: SQL, COBOL, JCL, CICS, REXX, CLIST, VSAM, FOCUS, ASSEMBLER, EASYTRIEVE

Other: TSO, ISPF

Version Control Tools: Endevor, CHANGEMAN

Scheduling tools: CA - 7

PROJECT EXPERIENCE HIGHLIGHTS:

Confidential, Wilson, NC

DB2 Database Administrator

Responsibilities:

• Offer DB2 DBA support for application development team
• Monitor database performance and recommend improvements for operational efficiency.
• Assist in capacity planning, space management and data maintenance activities for database system.
• Perform database enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on daily and weekly basis.
• Audited application SQL code with DB2 Explain prior to production implementation.
• Assisted developers in database and application tuning for optimal performance
• Loaded and refreshed non-production databases for application testing
• Provided 24/7 on call support for production databases on a rotation basis
• Identify and recommend database techniques to support business needs.
• Assist in implementation of new features and program fixes in databases.
• Maintain database security and disaster recovery procedures.
• Perform troubleshooting and maintenance of multiple databases.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.

Tools / Technologies: MVS, DB2, DB2 DDL, DB2 package binds, JCL, REXX, CLIST, COBOL, Platinum RC/QUERY, RC/ALTER, RC/Migrator, TSO/ISPF, SPUFI, File aid for DB2, QMF, CA database analyzer, IBM utilities for DB2, Omegamon online monitoring tool, VSAM.

Confidential, New Jersey

DB2 & IMS database administrator

Responsibilities:

• Perform database maintenance functions
• Move, rebuild, or change database objects as required in production
• Review physical structures
• Review performance, maintenance and utilities associated with each structure (i.e., REORGS, LOAD, UNLOADS)
• Implement, maintain, and test backup & recovery strategies
• Review SQL performance and Tuning
• Reviewing application's access to the database structures
• Evaluate and test new features/functionality
• Review, where required, the purge/archive criteria
• Monitoring database/subsystem performance issues
• Performed reorgs on a monthly basis and installed quarterly application releases
• Support and maintain production to test database downloads.
• Analyzed and performed tuning on IMS and DB2 databases which resulted in reduced DASD and tape usage

Tools / Technologies: Mainframe, z/OS, TSO, ISPF, COBOL, CICS, JCL, DB2, IMS, SPUFI, QMF, BMC database performance tools for DB2 & IMS such as Main view, database analyzer, CA platinum tools for DB2, RC query, RC Migrator, RC Update, Detector, Log Analyzer, Plan Analyzer, DB2 SQL Performance analyzer, File-Aid for DB2, REXX, CLIST, ISPF Macros

Confidential

DBA & IMS database administrator

Responsibilities:

• Monitor database performance and recommend improvements for operational efficiency.
• Monitor space utilization for all IMS & DB2 databases, Logs, etc.
• Monitor IMS database fragmentation and perform reorgs when required.
• Perform database enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on daily and weekly basis.
• Develop and maintain patches for database environments.
• Identify and recommend database techniques to support business needs.
• Assist in implementation of new features and program fixes in databases.
• Maintain database security and disaster recovery procedures.
• Perform troubleshooting and maintenance of multiple databases.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.

Tools / Technologies: Mainframe, z/OS, TSO, ISPF, COBOL, CICS, JCL, DB2, IMS, SPUFI, QMF, Tivoli OMEGAMON XE for DB2 Performance Expert on zOS, TSO / ISPF, BMC database performance tools for DB2 & IMS such as Main view, database analyzer, CA platinum tools for DB2, RC query, RC Migrator, RC Update, Detector, Log Analyzer, Plan Analyzer, DB2 SQL Performance analyzer, File-Aid for DB2, VSAM, REXX, CLIST, ISPF Macros, CA7, Endevor.

Confidential, Colorado

DB2 Database Administrator

Responsibilities:

• Provide logical and physical database design and implementation of physical DB structures
• Assist in capacity planning, space management and data maintenance activities for database system.
• Provide technical and lead database support
• Daily core-hour on-site support presence and on-call availability during off hours
• Manages DB2 table changes to support application design and development efforts.
• Responsible for application database backups, reorgs, migration between environments.
• Tuning queries: Using EXPLAIN to improve SQL performance, Ensuring efficient predicates and sub-queries, influencing access path selection, updating catalog statistics, giving optimization hints to DB2 etc.

Tools / Technologies: Mainframe, z/OS, TSO, ISPF, COBOL, CICS, JCL, DB2, SPUFI, QMF, CA platinum tools for DB2, RC query, RC Migrator, RC Update, Detector.

Confidential

DB2 & IMS Database Administrator

Responsibilities:

• Assist with SQL development with the Application group as required.
• Doing health checks for databases.
• Involved in various DB2 & IMS version upgrades.
• Interaction with onshore and client team leads to vet the design and validate impact analysis.
• Work closely with application teams to create and maintain database objects, refresh databases, SQL tuning, and provide production support.
• Ensured business continuity by performing data maintenance, backup planning and recovery, data reorganization and updating DB statistics
• Provide support for user acceptance testing and defect fixing.
• Provide deployment and production support.
• Review of project documentation, ensuring project compliance to qualify standards.
• Completed BIND/REBIND, SQL code reviews for new/existing applications.
• Acted as the offshore liaison for multiple projects, providing technical and subject matter expertise to the team and guided them to ensure smooth deliveries.

Tools / Technologies: Mainframe, z/OS, TSO, ISPF, COBOL, CICS, JCL, DB2, IMS, SPUFI, QMF, BMC database performance tools for DB2 & IMS such as Main view, database analyzer, CA platinum tools for DB2, File-Aid for DB2, REXX, CLIST, ISPF Macros, CA7.

Confidential

Application Programmer

Responsibilities:

• Establishing a detailed program specification through discussion with clients
• Breaking down program specification into its simplest elements and translating this logic into a programming language
• Combining all elements of the program design and testing it.
• Conducting testing and installing the program into production
• Reacting to problems and correcting the program as necessary
• Evaluating and increasing the program's effectiveness

Tools / Technologies: MVS, DB2, JCL, COBOL, TSO/ISPF, VSAM.

Confidential

Application Programmer

Responsibilities:

• Coding and design
• Application management
• Contribute technical expertise to requirements analysis to enhance the quality of the solution design.
• Complete testing and gather feedback to improve the quality and reduce operational risk of the developed application

Tools / Technologies: ISPF, TSO, COBOL, CICS, DB2, JCL, VSAM, CA7, ENDEVOR.