We provide IT Staff Augmentation Services!

Db2 Database Administrator Resume

SUMMARY:

To utilize my skills and abilities to excel in the field of Information Technology and to deliver high quality software products, offers professional growth while being resourceful, innovative and flexible.

TECHNICAL SKILLS:

Technology: Mainframe

Primary Skills: DB2 DBA, PL/I, JCL

Operating System: MVS/OS - 390,z/OS, Windows

Database: DB2 V8 on Z/OS.

Tools: / Utilities: TSO/ISPF, SCLM, File Manager, SPUFI, QMF, Omegamon,DB2 Admin tool, Query Monitor tool, Object Comparison tool, Endeavor tool,BMC tool,EZDB2,SMF,Db2 Performance Trace.

Online Subsystems: CICS

PROFESSIONAL EXPERIENCE:

Confidential

Environment: DB2, JCL, Z/OS

DB2 Database Administrator

Responsibilities:

  • Involved in RFP and SOW as a Technical consultant for Pre-sales activity.
  • Presenting the technical area of the company in giving presentations.
  • Worked on MIPS optimization with existing customer thereby helping them improve their performance
  • Worked with clients and done POC on MIPS optimization.

Confidential

Environment: DB2, JCL, Z/OS, Db2 V8.1, CA Insight for DB2, CA Db2 Admin tool.

DB2 Database Administrator

Responsibilities:

  • Creating Altering and Maintaining Various DB2 objects in the environment.
  • Performance monitoring of all Partition and non-partition tablespaces.
  • Running Various DB2 utilities like Unload, Load, Run stats, Re-org, Image Copy, Repair.
  • Db2 Production support for any application related issues.
  • Automating lot of Manual process using REXX
  • Diagnosing Db2 Product related problem and raising APAR with Confidential for the fix.
  • Monitoring the DB2 product licensing and apply license before the expiration date.
  • Performing Db2 recovery during project back out in case of any critical issues.
  • Below are the list of DB2 products which I have worked on Installation and configuration.

Confidential

DB2 DBA

Environment: DB2 V 10 and DB2 V11, JCL, Z/OS,File Aid for DB2,CA Insight, CA Detector, BMC DB2 Admin tool

Responsibilities:

  • Involved in Design review in analyzing designs for various applications.
  • Assisting application team from end to end, right from design review to db2 objects implementation and warranty support.
  • Implementing the house-keeping strategy for different applications.
  • Running performance traces during application team NFT testing and suggest them in improving the access paths.
  • Running Monitor traces for Dynamic Sqls and analyzing their accesspaths.
  • Extracted trace reports from SMF data and reporting it to application team.
  • Worked on Uni-directional Queue replication between different sub-systems.
  • Wide usage of BMC tool (Change manager and Catalog Manager) and EZDB2.
  • Worked on ODBC as well as JDBC and type 2 and Type 4 driver installation.
  • Automating processes using REXX Language.
  • Checking for performance of sql queries for every project implementation.

Confidential

Environment: DB2 V9.1, JCL, Z/OS,CA DB2 Admin tool, CA Detector, Confidential Application Performance Analyzer

Database Administrator

Responsibilities:

  • Wide usage of Data Manager tool for DB2 administration purpose.
  • Creating, altering and maintaining Various Database Objects in Datawarehouse environment.
  • Performance monitoring of all Partition and non partition tablespaces.
  • Running Various DB2 utilities like Unload, Load, Run stats, Re-org, Image Copy, Repair.
  • Copying objects in QMF from one environment to another.
  • Doing Annual clean up and Annual split of very large tablespaces.
  • Automating processes using REXX Language.
  • Checking for performance of sql queries as well as various DB2 objects using Detector

Confidential

Environment: DB2 V8.1, JCL, Z/OS,IMS

DB2 Database Administrator

Responsibilities:

  • Wide usage of BMC Admin tool for DB2 administration purposes.
  • Doing scheduled Refreshes in the development environment using BMC tool.
  • Creating, altering and maintaining Various Database Objects in production environment.
  • Involved in RAT (Release acceptance testing) in the pre-production region before implementing the changes to production.
  • Running Various DB2 utilities like Unload, Load, Run stats, Re-org, Image Copy, Repair.
  • Copying objects in QMF from one environment to another.
  • Performance monitoring of DB2 objects, and scheduling adhoc reorgs for the objects which is about to create outage.
  • Creation of PSBs and DBDs in IMS regions.

Confidential

Environment: DB2 V 8.1, JCL, Z/OS

Database Administrator

Responsibilities:

  • Wide usage of DB2 Admin Panel for DB2 administration purposes.
  • Doing scheduled Refreshes in the development environment using Object Comparison tool.
  • Creating, altering and maintaining Various Database Objects from testing to development.
  • Running Various DB2 utilities like Unload, Load, Run stats, Re-org, Image Copy, Repair.
  • Preparing Reports from Production for refreshes using QMF.
  • Checking for performance issues of Stored Procs, sql queries as well as various DB2 objects using Query monitor tool as well as Omegamon tool.
  • Performing Mass bind, free package and Resolving Bind Errors as a Part of Refresh.
  • Coding jobs needed for the various DB2 objects.
  • Support for Production Assurance system issues as PA support specialist on a 24X5 Basis.

Confidential

DB2 DBA & Developer

Environment: DB2 V 7 and V8.1,PL/1, in Mainframes, JCL, Z/OS

Responsibilities:

  • Wide usage of DB2 Admin Panel for DB2 administration purposes
  • Creating, altering and maintaining Various Database Objects.
  • Running all DB2 utilities like Unload, Load, Run stats, Re-org, Image Copy, Repair.
  • Refresh between Test and Production Tables as per needs Supporting end user with the various issues they face while using DB2 data.
  • Checking for performance issues of DB2 objects as well as the various SQL Queries issued.
  • Using Omegamon for monitoring various DB2 activities especially Load jobs activities for partitioned Tablespace.
  • Coding jobs needed for the various DB2 objects.
  • Support for production issues as production support specialist on a 24X7 Basis.

Hire Now