SUMMARY:

• Over 20 years of experience, including 16 years as DBA in development and production environment
• Ensure Confidential DB2 d Confidential base systems operate efficiently and securely
• Skilled in SQL performance tuning and system resource analysis
• Manage internal d Confidential bases, 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 d Confidential base 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), Confidential DB2 ADM Tool for Z/OS(ADM, ALA, HPU, ETI, AUTOMATION TOOL, CQM, SPA), OMEGAMON XE for DB2,PUREXML.

LUW: UNIX, Windows, Confidential DB2 Universal D Confidential base, DB2 Connect, D STUDIO, ER-WIN, MS-Access, MS-SQLSERVER, KORNSHELL, BORNSHELL,REGINA-REXX, LINUX

PROFESSIONAL EXPERIENCE:

DB2 UDB for Z/OS Administrator,

Confidential,

Responsibilities:

• Responsible for DB2 physical d Confidential base design, implementation and maintenance on Z/OS
• Identify, recommend, and implement all new d Confidential base 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
• D Confidential base changes control & Object Conversion. Customizing and implementing Confidential DB2 ADM tool, CA RC/MIGRATOR, CA RC/COMPARE, CA RC/SECURE.
• Managing d Confidential base 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 D Confidential base 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 d Confidential base refresh scripts
• Customizing S/W supporting DB2. WLM, DB2 Install Parameters, Confidential
• DB2 tools, CA DB2 Tools, OMEGAMONXE for DB2, STROBE, QMF, Program Migration Facilities (SCLM, Install-1, TWS), DB2 CONNECT, D Confidential STUDIO
• Involving projects (ETL, NYCERV)
• Managing DB2 CONNECT

Confidential, NY

Responsibilities:

• Implemented D Confidential Archiving procedures for SCOFFTOW d Confidential base.
• Coded KORNSHELL scripts communicating UNIX and DB2.
• Performed Dynamic SQL Tuning

Confidential, CT

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 d Confidential base Reorganization procedures
• DB2,MVS,STROBE,BMC for DB2,COBOL,REXX,CLIST,JCL,ERWI
• Developed D Confidential base 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
• Responsible for D Confidential base maintenance
• Performed application Performance Monitoring and Tuning
• D Confidential base changes control
• Mentored Migration Team
• Customized and implemented Utilities for BMC for DB2
• Implemented and scheduled D Confidential base Maintenance Scripts
• DB2, CICS, TSO, ISPF, JCL, REXX, CLIST, BMC DB2, VSAM, TMON, FILE-AID, ACCESS, MVS, CHANGE MAN, ZEKE

Confidential, SEOUL, KOREA

Responsibilities:

• Logical D Confidential base 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 D Confidential base 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

Oracle SQL,

Confidential,SEOUL, KOREA

Responsibilities:

• Wrote teh 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,SEOUL, KOREA

Responsibilities:

• Physical DB design & implementation
• D Confidential BASE Maintenance: Implemented D Confidential base Maintenance scripts. DB2 and BMC utilities (Backup, Recovery, Reorg, Load)
• Built Program Migration Strategy with managing DBRM, BIND PLAN
• D Confidential base changes control
• Developed D Confidential base 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, SEOUL, KOREA

Responsibilities:

• 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, SEOUL, KOREA

Responsibilities:

• 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