We provide IT Staff Augmentation Services!

Db2 Dba Resume Profile

5.00/5 (Submit Your Rating)

Objective: Seeking a DB2 DBA position performing database planning and design, performance tuning and optimization UDB and/or LUW

IBM DB2 DBA Summary

  • Proven production support DB2 DBA, resolving database issues and meeting SLAs
  • Experience on development projects, modeling and implementing physical database designs and tuning for favorable performance
  • Specialty in designing and implementing database solutions that improve database performance, availability, and capacity
  • Experience working with hardware and software upgrades and patch installs to ensure smooth transitions
  • Expertise working on SQL and DB2 monitoring and tuning tools
  • Adept at monitoring application code to ensure optimal DB2 access path selection
  • Assisting with running regression scripts after DB2 and IMS software upgrades
  • Tuning and supporting multiple large DB2 partitioning tablespaces up to 600 GB each for business solutions

Systems Expertise:

DB2 UDB and LUW, IBM z/OS Mainframe, AIX, Linux, Microsoft Windows Server/Windows 7, SQL, db2top/Omegamon/Mainview/Apptune, TSO/ISPF, JCL, Toad, RedHat, HADR, SPUFI, QMF, IMS DB/DC, CICS, VSAM, ADABAS, IDMS, CA7, AIX, Linux, Windows 7 / 2003 server, Endevor, ChangeMan, Panvalet, Xpediter, RACF, ACF2, FILE-AID, PeopleSoft, QRep, Erwin, IBM IDA Information Data Architect , OLTP/Data Warehousing, COBOL, REXX, CLIST, Crontab, korn shell scripting

Accomplishing Results:

Confidential

  • Upgrading z/OS application database objects from IBM DB2 V8 to V10
  • Maintaining logical and physical data models using IBM IDA
  • Implementing DB2 LUW and fixpacks plus DB2 database DDL on multiple Linux IIS servers using RedHat filesystem failovers, and HADR disaster recovery involved in capacity planning
  • Troubleshooting SQL performance issues by running PE Performance Expert reports from SMF trace data and using monitors like Omegamon, Mainview and Apptune
  • Participating in projects for DB2 application systems by running DDL to install and maintain database structures and implementing DB2 utilities for backups/reorgs/runstats
  • Developing and supporting in-house DB2 technical best practices and standards
  • Supporting DB2 LUW on Wintel servers for Reverse Mortgage and MQ Message Broker
  • Writing shell scripts to proactively monitor HADR status and ensure backups running smoothly

Confidential

  • Supported QRep data synchronization amongst multiple copies of PeopleSoft DB2 tables
  • Analyzed, designed and supported DB2 database systems for high availability
  • Performed logical and physical database design, implementation and production support
  • Planned, tested, and executed DB2 Disaster Recovery procedures for fail over
  • Designed, developed, and supported in production z/OS DB2 databases, including large partitioned tablespaces ranging from about 50GB to over 600GB each
  • Managed a two-year department-wide expense reduction project resulting in ten million dollars in annual savings due to database performance tuning and streamlining efforts personally contributing hundreds of thousands of dollars in savings to the effort
  • Ensured continued 24 x 7 availability via pro-active database statistics and production support on-call duties
  • Conducted scheduled DB2 technical training sessions to internal customers

Confidential

  • Supported customer requirements and applied fixes to z/OS skeleton JCL, panels and DB2 SQL for IBM's DB2 Administration Tool
  • Unit tested PTF's for DB2 utility jobs, DDL and catalog functions to ensure continued high quality software production of the DB2 Administration and Object Compare tools

We'd love your feedback!