We provide IT Staff Augmentation Services!

Db2 Dba Consultant Resume Profile

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

Hire Now