SUMMARY:

• DB2 for Z/OS Administrator with experience in maintenance, security, performance analysis and tuning, and backup and recovery as supporting Subsystem and Application
• 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, NY

DB2 V10 for Z/OS DBA

Responsibilities:

• 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. Managing Governor and Remote accesses
• Support Application Group & System Group.
• Managing DISK Storage & Space for Database and Sort work
• Developing DBA’s IN-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, NY

DB2 UDB V7 for UNIX

Responsibilities:

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

Confidential, CT

DB2 DBA Consultant

Responsibilities:

• 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, DE

DB2 DBA Consultant

Responsibilities:

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

Confidential

DB2 DBA Consultant

Responsibilities:

• Responsible for Database maintenance
• Performed application Performance Monitoring and Tuning
• Database changes control
• Mentored Migration Team
• Customized and implemented Utilities 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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
• Developed Database 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