SUMMARY OF QUALIFICATIONS

• Over 20 years of experience, including 16 years as DBA in development and production environment
• Ensure IBM DB2 database systems operate efficiently and securely
• Skilled in SQL performance tuning and system resource analysis
• Manage internal databases, from planning and testing stages through implementation and support
• Superior skill of scripting processes, customizing products and automating procedures
• In-depth understanding of system programming, application,security and backup procedures to ensure database integrity
• Keeping good knowledge of LUW structures and operations while working on Mainframe environment
• Problem solving with good communication, presentation and analytical skill

Technical Skills

Mainframe:

ZOS V1R13, DB2 V10, SDSF, TSO, ISPF, JCL,REXX, CLIST, COBOL, CICS, IMS, STROBE, TWS, CA DB2products RC/SCURE, RC/UPDATE, FAST UNLOAD, QUICK COPY, RAPID REORG, LOGANALYZER , IBM DB2 ADM Tool for Z/OS ADM, ALA, HPU, ETI, AUTOMATION TOOL, CQM, SPA , OMEGAMON XE for DB2,PUREXML.

LUW:

UNIX, Windows, IBM DB2 Universal Database, DB2 Connect,DATA STUDIO, ER-WIN, MS-Access, MS-SQLSERVER, KORNSHELL, BORNSHELL,REGINA-REXX, LINUX

Professional Task / Project

Confidential

Oracle DBA Consultant

• Responsible for DB2 physical database design, implementation and maintenance on Z/OS
• Identify, recommend, and implement all new database technologies
• Subsystem Performance Monitoring and Analysis. Building historical repository of DB2 Account/Statistic traced information using OMEGAMONXE for DB2. LOCK/LOG/POOL/THREAD threshold monitoring and analysis
• Responsible for Application Performance Monitoring and Tuning
• Leading DBA team to enhance DBA man-hour and DBA task automation, and perform problem solving
• Physical DB design: Applying New functions to maximize and optimize resource efficiency and integrity
• Database changes control Object Conversion. Customizing and implementing IBM DB2 ADM tool, CA RC/MIGRATOR, CA RC/COMPARE, CA RC/SECURE.
• Managing database security. Securing DB2 subsystem resource using RACF. Designing Implementing DB2 authority using CA RC/SECURE and RACF Profile Secondary ID. ManagingGovernor and Remote accesses
• Support Application Group System Group.
• Managing DISK Storage Space for Database and Sort work
• Developing DBA'sIN-HOUSE facilities. Using scripting products JCL, XMIT, REXX, ISPF, ISPF DIALOG, CLIST, SQL-Server, MS-ACCESS, MS-EXCEL
• Designing and implementing database refresh scripts
• Customizing S/W supporting DB2. WLM, DB2 Install Parameters, IBM DB2 tools, CA DB2 Tools, OMEGAMONXE for DB2, STROBE, QMF, Program Migration Facilities SCLM, Install-1, TWS , DB2 CONNECT, DATA STUDIO
• Involving projects ETL, NYCERV
• Managing DB2 CONNECT

Confidential

DB2 UDB V7 for UNIX

• Implemented DATA Archiving procedures for SCOFFTOWdatabase.
• Coded KORNSHELL scripts communicating UNIX and DB2.
• Performed Dynamic SQL Tuning

Confidential

Oracle DBA Consultant

• Responsible for providing SQL guideline to Application team
• Performed SQL tuning and SQL migration QA control
• Supported Logical DB design team
• Physical DB design implementation
• Supported application developers.
• Created database Reorganization procedures
• DB2,MVS,STROBE,BMC for DB2,COBOL,REXX,CLIST,JCL,ERWIN

Confidential

DB2 DBA Consultant

• Developed Database Space Monitoring Facilities
• Implemented Application Performance Annual ComparisonProcedure
• Responsible for SCHEMA DDL migration to production environment
• DB2,MVS,STROBE,BMC for DB2,REXX,COBOL,CLIST,JCL

Confidential

DB2 DBA Consultant

• Responsible for Database maintenance
• Performed application Performance Monitoring and Tuning
• Database changes control
• Mentored Migration Team
• Customized and implementedUtilities for BMC for DB2
• Implemented and scheduled Database Maintenance Scripts
• DB2, CICS, TSO, ISPF, JCL, REXX, CLIST, BMC DB2, VSAM, TMON, FILE-AID, ACCESS, MVS, CHANGE MAN, ZEKE

Confidential

DB2 V4 V5 for OS/390 Consulting DBA

• Logical Database Design IAA modeling
• Physical DB design and Implementing
• Lead DBA team to implement initial subsystem setup
• Involved Capacity Planning Task
• Coordinated BATCH Scheduling strategy building
• Developed Database Maintenance Utility JCL
• BACKUP RECOVERY automation
• Lead TFT team to test and launch DB2 3rd vendor tool among BMC, CDB and Platinum
• DB2, OS2, OS/390, CICS, OPC, OMEGAMON, REXX, CLIST, FILE-AID, TSO, BMC DB2, ERWIN etc

Confidential

Test DB2 and Oracle SQL and write the Optimized Query guide book for users

• Wrote the guide book of how to code optimized query in Oracle for developers
• Took Oracle Admin, PL/SQL and UNIX CSHELL courses
• Built Guideline of Indexing for high performance
• Instructor role to train SQL users
• SUN Solaris, ORACLE, PL/SQL, CSHELL

Confidential

DB2 DBA

• Physical DB design implementation
• DATABASE Maintenance: Implemented Database Maintenance scripts.DB2 and BMC utilities Backup, Recovery, Reorg, Load
• Built Program Migration Strategy with managing DBRM, BIND PLAN
• Database changes control
• DevelopedDatabase Maintenance scripts
• Monitored and implemented CICS RCT
• DB2, CICS system programming, Installed Upgraded DB2 subsystem and 3rd vendor tools
• Application System Performance Monitoring and Tuning
• DB2, OS2, OS/390, CICS,ROSCOE RFP , ACF2, CONTROL-M, OMEGAMON, COBOL2, REXX, CLIST, FILE-AID, TMON, TSO, BMC DB2, ERWIN etc

Confidential

Program Analyst

• EDI LU6.2/X.25 COBOL CICS Application Developing
• ACS/ARS system management
• SAS Application Maintaining
• MVS, ROSCOE, CICS, XPEDITER, FILE-AID, COBOL II

Confidential

Application Programmer

• Air Plane's Product Part Tracking System project
• Performed business analysis in Warehouse, Inventory tracking, Part Assemble and Repair Shop
• Involved in Conversion project from IMS to DB2
• IMS Online PL/I programming
• DB2 PL/I programming
• OS/390, DB2 V3.1, IMS DB/DC, PL/I, TSO, EXEDIT,NATUAL Language