We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Saint Paul, MN

OBJECTIVE:

Highly motivated, dependable IBM Certified Database Administrator seeking a position as Database Lead with an opportunity to deliver the jobs in a world class organization and utilize my technical and communication skills in a challenging, team - oriented environment and contribute towards the overall growth of the organization to the best of my abilities.

PROFESSIONAL SUMMARY:

  • Highly analytical and results-oriented professional with over 18 Years of experience in Information Systems.
  • 15+ years of experience as DB2 Database Administrator on DB2 Z/OS for DB2 V5, V7, V8 and V9 in a Data Sharing/SYSPLEX & Non-Data Sharing Environments.
  • Has extensive experience in, performance monitoring and tuning, SQL Query analysis thru Explain, optimizing backup and recovery, DB2 Migration from V5 to V7, V7 to V8, V8 to V9, DB2 utilities and tools.
  • Extensive use of Realtimestatistics table for monitoring database health.
  • Active role in production Implementation which involves assisting developers in problem determination and performance tuning.
  • Familiar with new DB2 Version 9 and version 10 features.
  • Involved in analyzing and developing physical and logical database modelling.
  • Running stand alone utilities like DSN1COPY, DSNJU004, DSN1COMP, DSN1PRNT.
  • Oncall support for all the DB2 administration jobs in Production, Development and Test
  • Worked extensively on DB2 stored procedures.
  • Ability to work independently, as a member of a team, and with external clients and vendors.
  • Excellent communication, presentation and customer interaction skills.
  • Visited U.S. thrice and handled the DB2 DBA projects successfully both in Confidential and Efunds.
  • Excellent foreseeing, issues resolving, task, people management and interpersonal skills.
  • Excellent team player, hard worker with commitment to quality and excellence
  • Highly motivated, fast and continuous learner with a burning desire to excel. Always willing to go extra mile.
  • Involved in installation of Mainframe S/390 at four places.(DSRC, e-Funds, Madras IIT and L&T,Powai,Bombay)

CORE COMPETENCIES:

  • DB2 Database Administration
  • Solving the DB2 requests using the tools like, Apptune, BMC, CA-Insight, CM(CICS Manager),CA-Detector Visual Explain, DB2-PM, etc.
  • DB2 Objects Estimation, Designing through ERWIN, etc.
  • Backup, Restore and Disaster Recovery of DB2 tables
  • Performance tuning in DB2 SQLs
  • Installation of the DB2 subsystems
  • Good working knowledge in File-Aid, Endevor by casting the packages, package approvals.
  • SQL-Rep, Q-Rep installation and administration

TECHNICAL SKILLS:

Programming Languages: COBOL II & 370 CICS SAS IMSDC REXX JCL V Script, Easytrieve C and C++ Fortran

Operating System: OS/390 Solaris windows 95/NT/2000/XP z/OS 1.4, 1.7 and 1.10

Databases: DB2 V12 on OS/390 and z/OS

Other Software: IBM Data Studio DB2 Control Center, DBArtisan ERStudio, DB2 Platinum Products BMC Catalog Manager for DB2, BMC Change Manager for DB2 BMC Recovery Manager for DB2, BMC DASD Manager for DB2 BMC Opertune for DB2, Apptune for DB2 SQL Explorer for DB2, BMC Mainview for DB2 CA-Detector, Omegamon/XE for DB2 on z/OS File-Aid for DB2, Expeditor DB2Admin, Platinum RC/Query for DB2 Platinum RC/Update for DB2, Platinum RC/Migrator for DB2 Plan Analyzer for DB2, Platinum Thread Terminator CA-Insight for DB2, Strobe Infoman, Chageman Visual Explain

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator, Saint Paul, MN

Operating Systems: MVS-Z/OS, Windows XP

Tools: BMC Apptune, BMC Change Manager, BMC Catalog Manager, Endevor, File-aid, CICS Manager, CA-Insight,Visual Explain, DB2-PM, Erwin, DBArtisan

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 10

Responsibilities:

  • Worked as a Senior Applications DBA for 6 applications in Confidential . All these 6 applications are for Credit Card Divisions for different countries.
  • All the databases were created from scratch to end for all these applications.
  • Primary DBA for these 6 applications and solving the ad-hoc requests by the applications groups.
  • Doing the change requests in UNIT,INTG, UAT and PROD by the Application Groups, through HP OPAS system.
  • Training junior DBAs and allocating tasks to them.
  • Participating in the DR exercise in every quarter to check the utilities, LPL, indoubt threads, postponed threads, etc and solving those in DR exercise.
  • Creating the Database Design through ERWIN and managing them in Migration, etc.
  • Worked on performance tuning with BMC Apptune,CA-Insight, Visual Explain, etc.
  • Solving the problems in DB2, faced by the developers from different Projects.
  • Database design both in logical and physical and creation of DB2 objects, etc.
  • Backup, Restore and Disaster recovery of tables, etc.
  • Maintaining the Databases, Tablespaces, Indexspaces in good condition.
  • Monitoring the Databases, Tablespaces, Indexspaces on daily basis and sending the Health Check Report to the various project teams.
  • Giving solutions and suggestions to the developers for better way of programming and getting results.
  • Tuning the Programs in SQL, to avoid excessive CPU Usage by using Apptune
  • Monitoring the jobs for seeing the CPU Time, Jobs going in loop or waiting for resources etc. by using CA-Insight
  • Monitoring the Availability of RCT Entries using CICS Manager.
  • Coordination with my team members and Project Managers by having meetings and Conference Calls to solve the problems and report the status.
  • Coordination with DBA Group to send various reports and giving training on Apptune, Endevor, File-aid, BMC Utilities etc to the Group Members.
  • Table designing, performance tuning, running DB2 utilities like reorg, runstats, etc.
  • Setting up the production jobs for REORG, RUNSTATS, IMAGECOPY, etc.
  • On call production support for one week, once in two months on rotation basis.
  • Solving the ad-hoc problems through BMC Apptune and Mainview, like contentions, deadlocks, etc.
  • Package reviews of DB2 online and batch programs and approvals through Endevor.

Confidential

Database Architect, San Antonio, TX

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: BMC, Apptune, Endevor, File-aid, CICS Manager, CA-Insight,CA-Detector,Visual Explain, DB2-PM, Erwin, DBArtisan

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 9

Responsibilities:

  • Worked as a Database Architect doing data modeling and implementing the physical model on the Mainframe DB2 subsystems.
  • Had meetings with the applications group while doing database designing.
  • Giving suggestions to them on various scenarios on DB2 attributes, column changes, data type, length, Primary key, Foreign key constraints, etc.
  • Creating the Database Design through ERWIN and managing them in Migration, Load, Unload, etc.
  • Solving the problems in DB2, faced by the developers from different Projects.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • Implementing the change requests through SPUFI or BMC catalog Manager.
  • Participated in Development on call support .
  • Reviewing the programs and giving suggestions to the developers for performance tuning of the SQLs and checking the naming conventions as per the DB2 Standards and policy followed in Confidential .

Confidential

DBA, Saint Paul, MN

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: BMC, Apptune, Endevor, File-aid, CICS Manager, CA-Insight,CA-Detector,Visual Explain,DB2-PM

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 8

Responsibilities:

  • Worked as an Applications DBA for three finance applications as the DBA for those applications was on vacation for long time.
  • Solved the change requests through DDL, raised by the application groups through BMC Remedy system.
  • Technical Support to the programmers.
  • Create and maintain various house keeping tasks on database objects.
  • Solving the problems in DB2, faced by the developers from these applications.
  • Tuning the Programs in SQL, to avoid excessive CPU Usage by using Apptune
  • Monitoring the Availability of RCT Entries using CICS Manager.
  • Setting up the production jobs for REORG, RUNSTATS, IMAGECOPY, etc.
  • Package reviews of DB2 online and batch programs and approvals through Endevor.

Confidential

DBA, Baton Rouge, LA

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: Omegamon, Apptune, Endevor, File-aid, CICS Manager, CA-Insight,CA-Detector,Visual Explain,DB2-admin

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 8

Responsibilities:

  • DB2 Database Administrator for DB2 V8 on Mainframe Operating system for the Department of State,Louisiana.
  • As part of a Production DB2 DBA Team, primary responsibility was to ensure the integrity and stability of the production databases.
  • Multiple Data Sharing Sysplex Environments consisting of multiple members in Production, Testing, Volume Testing, Sandbox etc. as well as Non-Data Sharing DB2 Sub-Systems.
  • Responsibility includes the creation of stored procedures, Triggers, database objects as well as scheduling and monitoring of database utilities.
  • Identification of database performance issues and recommendation of solutions.
  • Responsible for assisting Application Teams in writing efficient SQL, DB2 Performance monitoring and problem resolution using OMEGAMON DB2 z/OS monitoring tool.
  • Establish application recovery plan based on the volume of activity on the tables.
  • Assist application/development team in any technical issues.
  • Run utilities for Image Copies, Reorganisations, Runstats and modify recoveries.
  • Carry out activities like Repartition and Rebalance of tables.
  • Provide 7 x 24 on-call support on a rotating basis for Production databases
  • Perform SQL analysis for the application developers using Visual Explain tool.
  • Perform DML or DDL with SPUFI, File-Aid and various other IBM utilities.

Confidential

DBA, Troy, MI

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: BMC, Apptune, Endevor, File-aid, CICS Manager, CA-Insight,Ventyx EAM, Asset Suite

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 8

Responsibilities:

  • DB2 Database Administrator for V8 on State Farm Insurance Application system.
  • Involved in migration activities from DB2 V7 to V8.
  • To execute validation scripts to test new features of DB2 Version 8.
  • Perform Online DB Maintenance - Alter space, perform Reorgs, Runstats, Backup, Rebalance
  • Perform online and offline backups for both incremental and full copies depending on the application updates/inserts.
  • Implement new database objects, Modify existing Objects, Drop database objects.
  • Execute DCL, DDL, and DML on database objects using JCLs and SPUFI.
  • Expertise in IBM Utilities like COPY, LOAD, REORG, RUNSTATS, REBIND etc.
  • Data base modelling using Er-Win software.
  • Security audits which includes granting and revoking privileges, authority to users, plans & packages, collections.
  • Expertise in performance tuning of bad SQL’s using IBM’s Visual Explain tool
  • Run Traces and read trace output in DB2 using BMC’s Mainview to identify potential problems.
  • Run Validation Scripts against dummy database objects after an IPL.
  • Perform Non-Urgent Restore/Recovery as requested by Application team.
  • Refresh data from production to test environment on request from application team.
  • Documentation of best practices, procedures followed in the organisation.
  • On call on shift basis to attend problems in production, development and test region.
  • Involved in many project releases in production, testing and development environments.
  • Experience in NDM tool to transfer files across production, development and test regions.

Project Leader

Confidential, New Jersey

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: BMC Change Manager, Catalog Manager, DASD Manager, Apptune, Endevor, File-aid, CICS Manager, CA-Insight

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 7 and DB2 Version 8

Responsibilities:

  • Created the tablesspaces, tables, indexes, aliases, synonyms, etc and granting access rights appropriately.
  • Solving the problems in DB2, faced by the developers from different Projects.
  • Maintaining the Databases, Tablespaces, Indexspaces in good condition.
  • Implementing the DB2 Objects from physical design.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • Monitoring the Databases, Tablespaces, Indexspaces on daily basis and sending the Health Check Report to the various project teams.
  • Giving solutions and suggestions to the developers for better way of programming and getting results.
  • Tuning the Programs in SQL, to avoid excessive CPU Usage by using Apptune
  • Monitoring the jobs for seeing the CPU Time, Jobs going in loop or waiting for resources etc. by using CA-Insight
  • Monitoring the Availability of RCT Entries using CICS Manager.
  • Coordination with my subordinate DBAs and Project Managers by having Conference Calls to solve the problems and report the status.
  • Coordination with DBA Group to send various reports and giving training on Apptune, Endevor, File-aid, BMC Utilities etc to the Group Members.
  • Table designing, performance tuning, running DB2 utilities.
  • Package reviews and approvals through Endevor.

Confidential

Senior System Executive/Administrator

Environment: Operating Systems: MVS-Z/OS, Windows 98, 2000

Tools: BMC, Apptune, Endevor, File-aid, CICS Manager, CA-Insight

IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL

Database: DB2 Version 5

Responsibilities:

  • Creation and administration of DB2 Objects like Storage Groups, Databases, Tablespaces etc.
  • Loading and reorganization of table spaces.
  • Granting and revoking privileges to users.
  • Backup, Restore and Disaster Recovery.
  • Table designing, performance tuning etc.
  • Installation of various DB2 subsystems for various levels.
  • Physical and logical database designing of databases, tables, etc.
  • Data and Structure migration from one environment to other environments etc.
  • Installation and Configuration of OS/390 and its related products.
  • Maintenance of system Datasets (like PARMLIB, PROCLIB).
  • Coding JCL procedures for various system activities like Backup and Restoration etc.
  • Management of Storage and Tape library.
  • Creation and testing of Single pack system.
  • Initial Program Loading of the IBM Mainframe system, Creating User-ids and giving access rights to them.
  • Creating and maintaining profiles.
  • Auditing unauthorized resource access,.
  • Providing Access and managing Users and Groups
  • Maintenance of RACF Database
  • Total Administration of CICS that includes installation and management of CICS.
  • Administrating CICS entries in various tables like FCT, PCT, PPT, DCT and RCT
  • Customization of new CICS regions.
  • Definitions of new Connections etc.

Environment: COBOL, DB2, JCL, VSAM, File-Aid, TSO/ISPF, SPUFI, Apptune, BMC, CICS Manager, CA-Insight

Hire Now