SUMMARY OF QUALIFICATIONS

• 20 years of IT experience, including 16 years of advanced DB2 Z/OS database administration experience in overall DB2 versions up to V10 in development and production environment, with at least 7 or more years of experience as a senior-level Database Administrator.
• Ensure IBM DB2 database systems operate efficiently and securely
• Advanced to expert level experience in SQL performance tuning
• Highly skilled in DB2 best practices and standards
• Expertise in administration tools from IBM, CA and BMC
• DB2 Universal Database Advanced Administration Workshop
• Good knowledge and skilled in DB2 UDB in AIX, Oracle in Unix , SQL-Server and LINUX, Shell programming
• System programming level experience of mainframe products STROBE, RACF, DFSMS ACS , Install-1, TWS, SCLM, CA for DB2, DB2 TOOL
• Strong troubleshooting skills and be able to debug most DB2 problems
• Problem solving with good communication, presentation and analytical skill
• General mainframe system knowledge, including mainframe system programming and proficiency with the principles of SDLC, database theory, disaster recovery, database security, database design, capacity planning, performance analysis, change management
• Superior skill of scripting processes, customizing products and automating procedures using TSO, REXX, CLIST, JCL, K-shell
• DB2 UDB EEE for Unix Performance Monitoring and Tuning Workshop
• LINUX Introduction at Learning Tree International INC
• MS-SQLSERVER Admin workshop
• Attending DB2 USER GROUP Meeting TRIDEX and SHARE Florida/Boston

Technical Skills

Mainframe:

ZOS, DB2 for ZOS, TSO, ISPF, JCL,REXX, CLIST, COBOL, CICS, SDSF, STROBE, CA7, TWS, CA DB2 products RC/MIGRATOR, RC/COMPARE, RC/SCURE, RC/UPDATE, FAST-UNLOAD, QUICK-COPY, RAPID-REORG, LOGANALYZER , IBM DB2 ADM Tool for ZOS ADM, ALA, HPU, ETI, AUTOMATION TOOL, CQM, SPA , OMEGAMON XE,PUREXML, INSTALL-1, SCLM, Micro-Focus Relativity Enterprise Analyze sever

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

NYC Department of Finance / IT division:

• Lead DBA team : responsible for database administration for Production, Development, Testing , QA databases
• Perform Physical database design and, implement Database changes data conversion for each environment
• Consult with Logical DB design DA and Application group
• Perform Application and SQL performance monitoring and tuning
• DB2 Subsystem Performance Monitoring and Analysis
• Identify and resolve day to day production database application issues
• Support verification of DB2 subsystem upgrade and Customize 3rd party vendor products, DB2 Install parameters, WLM, IBM DB2 tools, CA DB2 Tools, OMEGAMONXE for DB2, STROBE, DFSMS ACS , QMF, SCLM, Install-1, TWS, RACF, DB2 CONNECT, DATA STUDIO
• Build and maintain strategy of BACKUP, RECOVERY, REROG, RUNSTATS and daily database maintaining procedures
• Control DB2 security RACF, CA-RC/SECURE, Vanguard
• Manage Governor and Remote access
• Manage DASD Storage Space for Database and Sort work
• Consult with Migration and Operation group
• Develop automated in-house scripts using JCL, XMIT, REXX, CLIST, ISPF DIALOG, ISPF, SQL-Server, MS-ACCESS, MS-EXCEL
• provide Database Refresh and Re-Refresh with cross-environment
• Install and maintain DB2 CONNECT for distributed accesses
• Support ETL processes for DW team
• Install and customize Micro Focus Relativity Enterprise Analyzer 3.4 with SQL-server
• Provide On-Call support to production database and application issues

Confidential

DB2 UDB V7 for UNIX

• Stored procedure and dynamic SQL performance tuning
• Supported Logical Database Designing team
• Implemented scripts for refresh database from production to Test, and Archiving process
• K-shell, AIX,DB2 UDB

IT department

DB2 DBA Consultant

• Responsible for providing SQL guideline to Application team
• Application and SQL performance tuning
• Supported Logical DB design team
• Physical DB design implementation
• Supported application teams.
• DB2,MVS,STROBE,BMC for DB2,COBOL,REXX,CLIST,JCL,ERWIN

Confidential

DB2 DBA Consultant

• Developed Database Space Monitoring Facilities
• Built the automated procedure to optimally resize overall DB2 object spaces
• Implemented Application Performance Annual Comparison Procedure
• Responsible for SCHEMA DDL migration to production environment
• DB2,MVS,REXX,COBOL,CLIST,JCL,IDEAL,BMC-DASD/Catalog/Change,Manager,File-Aid, INSIGHTDB2, QMF,CPMA

Confidential

DB2 DBA Consultant

• Responsible for Database maintenance of Production, Development and Testing databases for Welfare Deliver system of the State of Delaware
• Performed Application and SQL Performance Monitoring and Tuning
• Database changes control Object Conversion using DB2 utility, BMC Change Manager
• Supported Application Migration Team
• QA team support
• Day-to-day problem solving
• Customized and implemented Utilities using BMC DB2 tools
• Provided on-call support
• DB2, CICS, TSO, ISPF, JCL, REXX, CLIST, BMC DB2, VSAM, TMON, FILE-AID, ACCESS, MVS, CHANGE MAN, ZEKE

Confidential

• 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, Platinum for DB2, ERWIN etc