We provide IT Staff Augmentation Services!

Db2 V10 For Z/os Dba Resume

NY

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

Hire Now