We provide IT Staff Augmentation Services!

Database Administrator Resume

Lakeville, MN

OBJECTIVE

Highly motivated, dependable IBM Certified Database Administrator seeking a position as DBA 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.

CERTIFICATION

IBM Certified Database Administrator (DB2 9 DBA)
IBM Certified Database Associate(DB2 9)

PROFESSIONAL SUMMARY

  • Highly analytical and results-oriented professional with over 18 Years of experience in Information Systems.
  • Involved in installation of Mainframe S/390 at four places.(DSRC, e-Funds, Madras IIT and L&T,Powai,Bombay)
  • Hands on Project Lead proficient in DB2 Database Administration methodologies with specialization in planning, estimating, forecasting and resource allocation.
  • Excellent work experience in detailed Mainframe System Administration both in Hardware and Software
  • Highly experienced in MVS Administration, DB2 Administration, CICS Administration, RACF Administration
  • Knowledge on Banking Domain - Administered Reserve Bank of India DB2 database and system for RTGS & CFMS Projects.
  • Strong working knowledge in Banking, Stocks & Financial Industries.
  • Coordination with Onsite-Offshore teams for DB2 system maintenance, documentation and development.
  • Good exposure to Quality, CMM concepts
  • Visited U.S. thrice and handled the DB2 DBA projects successfully both in Pershing 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.
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 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.
  • CICS Administration like defining the CICS entries like Files, Clusters, Tran Ids etc
  • RACF Administration over all the subsystems and managing the user and dataset profiles
  • Installation and administration of all the subsystems, MVS System
TECHNICAL SKILLS

Operating Systems: MVS-Z/OS, MS-DOS, Windows XP
Tools: BMC, Apptune, Endevor, File-aid, CICS Manager, CA-Insight,CA-Detector,DB2-PM,Visual Explain
IBM Mainframe: Cobol, CICS, DB2, JCL, VSAM, File-Aid, SQL
Other skills: DB2 Connect, CURAM, Novell Netware, WINNT

WORK EXPERINCE
  • Working as Senior Database Administrator in Confidential, U.S.A. May 2008 – Till date.
  • Worked as Database Architect in Confidential, U.S.A. Sep 2007 – April 2008.
  • Worked as Database Analyst in Confidential, U.S.A . August 3 – 31, 2007.
  • Worked as Database Analyst in Confidential, U.S.A Jan 2007 – July 2007.
  • Worked as Database Analyst in Confidential, U.S.A. June 2006 – Dec 2006
  • Worked as Project Leader in Confidential, Chennai INDIA Mar, 2003 – May 2006
  • Confidential, India. Feb, 1999 – Mar, 2003
  • Confidential, Chennai, India. May 1998 – Feb, 1999.
  • Confidential, Madurai, India June 1997- Jan 1998
  • Confidential, Chennai, India March 1996 – April 1997
  • Confidential, Madurai, India May 1994 – Jan 1996
PROJECT DETAILS:

Confidential, PA. April 2011 – till date
Senior Database Architect
Harrisburg, PA

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

  • Creating the Database Design through ERWIN and managing them in Migration, Load, Unload, etc.
  • Worked on performance tuning with CA-Detector, 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.
  • Data Migration from Development to Production regions.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • 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 subordinate DBAs 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 in 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,U.S.A. May 2008 – till date
Senior Database Administrator
Saint Paul, MN

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 8

  • Managing the DBA Team by allocating the DBA Tasks to them.
  • Creating the Database Design through ERWIN and managing them in Migration, Load, Unload, etc.
  • Worked on performance tuning with CA-Detector, 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.
  • Data Migration from Development to Production regions.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • 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 subordinate DBAs 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 in 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, U.S.A. Sep 2007 – April 2008
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 8

  • Managing the DBA Team by allocating the DBA Tasks to them.
  • Creating the Database Design through ERWIN and managing them in Migration, Load, Unload, etc.
  • Worked on performance tuning with CA-Detector, 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.
  • Data Migration from Development to Production regions.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • 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 subordinate DBAs 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 in 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, U.S.A. Aug 3rd – 31st 2007
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

  • Managing the DBA Team by allocating the DBA Tasks to them.
  • Creating the Database Design and managing them in Migration, Load, Unload, etc.
  • Worked on performance tuning with CA-Detector, 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.
  • Data Migration from Development to Production regions.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • 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 subordinate DBAs 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 in rotation basis.
  • Package reviews of DB2 online and batch programs and approvals through Endevor.

Confidential, U.S.A. Jan 2007 – July 2007
DBA
Baton Rouge, LA

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
Others: CURAM
Database: DB2 Version 8

  • Managing the DBA Team by allocating the DBA Tasks to them.
  • Creating the Database Design for LOBs(Large Objects) and managing them in Migration, Load, Unload, etc.
  • Using DB2 UDB for windows for easy access of Mainframe DB2 to solve the problems.
  • Installed the CURAM Software which is a frame architecture used for designing databases, migration and worked extensively with CURAM.
  • Worked on performance tuning with CA-Detector, 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.
  • Data Migration from Development to Production regions.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • 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 subordinate DBAs 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.
  • Taking the Image copies of the tablespaces, Active logs, Archive logs etc.
  • Package reviews of DB2 online and batch programs and approvals through Endevor.

Confidential, U.S.A June, 2006 – Dec 2006
DBA
Troy, MI

Environment:

Operating Systems: MVS-Z/OS, Windows XP
Tools: BMC, Apptune, Endevor, File-aid, CICS Manager, CA-Insight
IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL
Database: DB2 Version 8

  • Managing the offsite DBA Team by allocating the DBA Tasks to them.
  • 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.
  • Data Migration from Development to Production regions.
  • Database, Tablespace, Table Structure migration from Development to Production regions.
  • 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 subordinate DBAs 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.
  • Taking the Image copies of the tablespaces, Active logs, Archive logs etc.
  • Package reviews of DB2 online and batch programs and approvals through Endevor.

Confidential, Chennai INDIA Mar, 2003 – May, 2006
Project Leader

Client: Confidential, New Jersey, U.S.A

Environment:

Operating Systems: MVS-Z/OS, Windows XP
Tools: BMC, 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

  • Solving the problems in DB2, faced by the developers from different Projects.
  • Maintaining the Databases, Tablespaces, Indexspaces in good condition.
  • Database design both in logical and physical and creation of DB2 objects, etc.
  • Backup, Restore and Disaster recovery of tables, etc.
  • Data Migration from Development to Production regions.
  • 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
  • Taking the Image copies of the tablespaces, Active logs, Archive logs etc.
  • Package reviews and approvals through Endevor.
  • Handling 3 teams (DBA Group, DA Group, System Documentation Group)

Confidential, Chennai, India Feb 1999 – March 2003
Senior System Executive/Administrator

Client: Deluxe Corporation Inc., Minnesota, U.S.A.

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

DB2 ADMINISTRATION:

  • 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.

MVS ADMINISTRATION:

  • 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.

RACF ADMINISTRATION:

  • Creating and maintaining profiles.
  • Auditing unauthorized resource access,.
  • Providing Access and managing Users and Groups
  • Maintenance of RACF Database

CICS ADMINISTRATION:

  • 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

Confidential, Chennai, India May 1998 – Feb 1999
Junior System Administrator

DB2 ADMINISTRATION:

  • 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.

MVS ADMINISTRATION:

  • 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.

RACF ADMINISTRATION:

  • Creating and maintaining profiles.
  • Auditing unauthorized resource access,.
  • Providing Access and managing Users and Groups
  • Maintenance of RACF Database

CICS ADMINISTRATION:

  • 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.

Environment:

Operating Systems: MVS-OS/390, Windows 95,98
Tools: Endevor, File-aid,
IBM Mainframe: Cobol, CICS, JCL, VSAM, File-Aid, SQL
Database: DB2

Confidential June 1997 – Jan 1998
Customer Support Engineer

  • Installation of WINNT and administrating the network
  • Installation of Novell Netware and administrating the network
  • Handling LAN comprising of both Novell Netware and WINNT Network (Client: Arvind Eye Hospital, Madurai)

Confidential, March 1996 – April 1997
Customer Support Engineer

  • Installation of WINNT and administrating the network
  • Installation of Novell Netware and administrating the network
  • Handling LAN comprising of both Novell Netware and WINNT Network

Confidential, May 1994 - Jan 1996
Computer Service Engineer

  • Servicing the IBM range of PC’S PC-386, PC-486
  • Novell Netware Installation and administration of the network in the customer location
  • Giving Customer Support by giving solutions in the case of Hardware Problems.
EDUCATION
  • Bachelor of Engineering in Electronics & Communication
TRAINING
  • DB2 UDB Installation and Administration Training from IBM Global Services in Nov 2000.
  • IBM Systems Administration Training ( DB2 DBA, CICS/ESA Basic Tailoring, MVS Systems Programming, RACF Administration) from IBM Global Services in Jun’99-Aug’99.
  • IBM Mainframe Training from Electronics Research and Development Centre, Government of India, Trivandrum at 1998.
  • SEI CMM in eFunds International, Chennai, India.
  • Banking, Securities & Brokerage, eFunds, India

Hire Now