Database Administrator Resume Lakeville MN - Hire IT People

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

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:

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:

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:

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

We provide IT Staff Augmentation Services!

Database Administrator Resume

Lakeville, MN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship