SUMMARY

• Over 8+ years of experience in Database Design, Development, Deployment and Administration.
• Has extensive experience in physical and logical database design, performance monitoring and tuning, query analysis, optimizing backup and recovery, migration, DB2 utilities and tools.
• Developed automated system for production BACKUPS, REORGS, RUNSTATS.
• Experience in monitoring and tuning database using snapshots and event monitors; identifying problem in SQL statements and performance bottlenecks; schema changes, configuration changes and explain analysis; working with developers, working with IBM support.
• Experience of DB2 advanced database administration like performance monitoring & tuning, benchmarking, Database design & analysis, partitioning.
• Monitored DB2 using BMC Patrol, Visual Explain or Access plan and Tivoli Monitoring.
• Migrating DB2 UDB databases from old to newer versions and applying FIXPACKS to keep DB2 at most recent level.
• Installed IBM DB2 UDB ESE for AIX/NT server, Administration tools like Control Center, Command line Processor, Script Center and Alert Center.
• Performed Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
• Suggesting Backup plans as per the requirement (Offline/Online; Incremental/Delta) and implementing the same and tuning the parameters accordingly.
• Experience in developing disaster recovery procedures for offsite recovery of production DB2 environments.
• Disaster recovery expert; several 24x7 HADR/SAP & other HADR architectural designs.
• Experience in writing shell scripts for monitoring and performing day to day and weekly tasks.
• Supported SAP R/3 and Enterprise Portal environment.
• Established and Maintained DBA monitoring and reporting standards to ensure compliance with applications at service levels.
• Worked on Dprop, transferring data from various databases such as Oracle with DB2 and maintaining a connection Protocol.
• Experience in Data modeling tools ERWIN.
• Provided physical database design as well as participated in application, Stored Procedures, system architecture design using ER/Studio.
• Performed Overall Database Management and Quality Assurance.
• Provided 24/7 support for Production Database and Application Database.
• Expertise in DB2 utilities such as db2top, db2pd, db2advis, db2expln.
• Experienced in writing SQL queries, stored procedures and Packages and triggers.
• Very Strong performance tuning skills in database designing, implementation and post deployment.
• Excellent communicator and team player.

TECHNICAL SKILLS

Operating Systems: AIX 7.x/6.x/5.x, Linux 7.x/6.x, Windows NT/2K/XP,SERVER 2003,20008

RDMS: DB2 UDB 8.2/9.x/10.x, Oracle 11g, SQL Server 2008

Shell Scripting: Korn, Bash, Bourne, and C Shell

Database Tools: BMCPATROL, Event and Health Monitor, SQL Explain, Aqua Data studio, DBArtisan, SQL Server Management studio.

Application Servers: IBM Web Sphere 5.0/5/1/6.x, BEA WebLogic 5.0/6.x/7.x/8.1, MS MQ Series, Apache Web server

ERP: and SAP R/3 4.6C, BW 3.1C and PeopleSoft

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr.DB2 UDB DBA

Responsibilities:

• Install DB2 UDB software on AIX, Linux environment.
• Supported IBM in migration of servers from AIX to Linux and checking all the required parameters are up to mark as per production requirements.
• Provided solutions in Performance tuning the databases.
• Provided solutions and monitored in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the large database.
• Generated reports of database structure using DB2LOOK Utility.
• Provided scripts for changing the data base and database manager configuration parameters.
• Upgraded database from db2 LUW 9.7.4 to db2 LUW 10.1.3 and 10.5.5
• Upgraded instance and databases from 10.1.3 to 10.5.4 and 10.5.7
• Worked with Maestro job scheduler to execute database maintenance jobs.
• Involved in changing the shell scripts for daily maintenance tasks such as backups, reorgs and runstats.
• Extensively worked on tuning complex SQL queries and recommended the improvements needed to reduce the execution time.
• Worked on Capacity planning strategy for UDB databases.
• Provides solutions for storage system of tablespaces.
• Used DB2 Movement Utilities like EXPORT, IMPORT, LOAD.
• Involved in converting multiple database to automatic storage
• Wrote scripts for alerts on home file system and other files system depends on the threshold.
• Worked on migration of AIX to Linux ( v10.5.5).
• Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.

ENVIRONMENT: DB2 ESE/WSE V10.5/10.1/V9.7, ASE V15, AIX 7.x.

Confidential, MI

DB2 UDB DBA

Responsibilities:

• Install DB2 UDB software on AIX, Linux and Windows environment.
• Provide database backup and recovery support, used TSM API to backup db2LUW databases.
• Involved in Performance tuning the databases
• Involved in creating and configuring the databases.
• Upgraded database from db2 LUW 9.7.4 to db2 LUW 10.1.3.
• Upgraded instance and databases from 10.1.3 to 10.5.4
• Supported db2 LUW on both enterprise and work group
• Worked with TWS scheduler to execute database maintenance jobs.
• Developed shell scripts for daily maintenance tasks such as backups, reorgs and runstats.
• Extensively worked on tuning complex SQL queries and recommended the improvements needed to reduce the execution time.
• Performing full version Upgrades and applying Fix packs when necessary.
• Generated reports of database structure using DB2LOOK Utility.
• Recovered data to a prior point in time using ROLLFORWARD command.
• Developed Capacity Planning strategy for all UDB databases.
• Working with Instance and Database configuration parameters to automate tasks such as logging, memory management and Database storage.
• Involved in converting multiple database to automatic storage
• Wrote a script to monitor automatic storage tablespaces, monitor will alert if threshold id reached.
• Worked on physical and logical designing, performance monitoring, maintenance, query analysis, optimization, backup, recovery, replication and migration.
• Experience in working on quarterly database health checks
• Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the large database.

ENVIRONMENT: DB2 ESE/WSE V10.5/10.1/V9.7, ASE V15, AIX 7.x, DBArtisan, windows NT/XP.

Confidential, Phoenix, AZ

DB2 UDB Database Administrator

Responsibilities:

• Migrated databases from V9.5 to version 9.7 of DB2 UDB on AIX 5.x
• Provided day time on - call support.
• Involved in upgrading instances from 9.5.4 to 9.7.5.
• Upgraded instance fix pack from 9.7.3 to 9.7.4.
• Worked on Proof of concept for V9.7 testing.
• Worked on DPF environment.
• Experience working with MDCs, MQTS, Range-Partitioned tables, and Range-Clustered tables.
• Worked on migrating databases from Windows to AIX platforms.
• DB2 for SAP support such as tablespace maintenance and backups.
• Handled Db2 Database on SAP Environment, Implemented the SAP Notes on the Database.
• Involved mainly in customer database maintenance, troubleshooting, backups, restore, export, import and load, reorg, runstats, data propagation (DPROP) and HADR issues
• Worked on database federation
• Worked with BO team to setup data movement using load utility
• Worked on setting up log archiving to TSM using API.
• Working closely with Developers to create database objects (tablespaces, schemas, tables, views, indexes, etc) as per the requirement.
• Developed Capacity Planning strategy for all UDB applications.
• Worked on load testing Hardware upgrade for a mission critical production database.
• Provided support on DB2 client related applications.
• Developed shell scripts for calculating the database size
• Extensively used DB2TOP for monitoring databases both in Interactive and Batch modes.
• Providing security at various levels, Instance, Database, Objects and granting privileges & authorizations to users and groups respectively.
• Worked on tuning complex SQL queries, developing stored procedures, and functions.
• Worked closely with Informatica team to optimize the batch jobs and monthly data loads process to minimize the batch period.
• Worked on federated environment in setting up wrappers, mappings, and information integrator.

ENVIRONMENT: DB2 ESE/EEE v9.7/9.5, and SAP R/3 4.6C, BW 3.1C, AIX 6.x, windows NT/XP&Dprop

Confidential, Plano, TX

DB2 DBA Administrator

Responsibilities:

• Advanced knowledge of DB2 ESE in a UNIX-based data warehouse environment and perform administrative tasks under partitioned databases, such as: increasing tablespaces, checking applications status, creating backups, performing restores.
• Implemented disaster recovery of a highly transactional OLTP environment with HADR and TSA (Tivoli Software Automation).Used root authority on the test servers and produced a step-by-step documentation to implement both HADR and TSA across the primary and the standby clusters.
• Automated the Daily Online backups to TSM, Manually Archiving the Logs to TSM in case of backup failures, setting up the TSM prams for the Redirected restore.
• Extracting the backup image of one database and redirecting to another database from TSM to disk.
• Configure file system caching, Configure maintenance.
• Configuring and fine tuningDB2 DBM and DB configuration parameters for better response, throughputs and proper utilization of Global memory.
• Handled Db2 Database on SAP Environment, Implemented the SAP Notes on the Database.
• Experienced in using Imports, Exports, db2move utilities on the schema level and table level.
• Worked on physical and logical designing, performance monitoring, maintenance, query analysis, optimization, backup, recovery, replication and migration.
• Proactively managed multiple databases in Production, Development, and QA environments.
• Extensively used DB2 utilities like RUNSTATS to collect table and index statistics and REORG to reorganize tables and indexes to improve access and storage efficiency
• Handed over the work & methodology to offshore team.

Environment: DB2 v 9.7/9.1.3/8.1.5 , AIX 5.3/6.1/7.1, IBM Web sphere Commerce Suite, DB2RC (DB2 Replication Center), Tivoli Storage Manager (TSM), DB2 Control Center

Confidential, Baltimore, MD

DB2 UDB DBA

Responsibilities:

• Worked as level 2 support
• Worked on installation of different versions9.1, 9.5, and 9.7 of DB2 UDB on AIX 5.x/6.x.
• Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the database.
• Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Data modeling (logical and physical data modeling using ERWIN.
• Responsible for backup, restore and moving the data between different databases/servers.
• LOGGING and ARCHIVING Database LOGS.
• After Normal work load on the data for 5 hours Perform Inspect Check on live DB2 data.
• Using Db2 look to generate Data Definition Language (DDL) for the existing database objects.
• Tutored IT staff members when conducting routine administration tasks and standard operating procedures.
• Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs).
• Developed document that provides an overview of the physical and logical design of the database environment implemented.
• Involved in updating DB2 UDB 9.1.4 to 9.1.5 on production and development servers.
• Worked on opening PMRs with IBM
• Performed capacity planning.

ENVIRONMENT: DB2 ESE v9.1/9.5, Web sphere, AIX 5.x, windows NT/XP, Server

Confidential

DB2 Developer/Admin

Responsibilities:

• Using the DB2 Command Line Processor (DB2 CLP) as well as the GUI interface for operating system commands and SQL statements.
• Managing DB2 instances, Database objects, optimizing queries, scheduling jobs, writing and saving scripts and working with DB2 commands.
• Working closely with Developers to create database objects (tablespaces, schemas, tables, views, indexes, etc.) as per the requirement.
• Documented plans and procedures in terms of backups, restores and disaster recovery.
• Maintaining, connecting, managing and administering a list of databases.
• Restricting which rows and columns can be viewed or updated by certain users by creating views.
• Continuous monitoring of compliances of the database.
• Working with and creating database objects such as tables, views indexes, schemas, buffer pools, log files, table spaces using Data Definition language (DDL) and Data Manipulation language (DML).
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Involved in upgrading instances from 9.1.3 to 9.5.4.
• Upgraded instance fix pack from 9.5.4 to 9.5.5.
• Cataloging Instances and accessing databases from remote clients.
• Creating, modifying and deleting database objects.
• Using Structured Query language (SQL) to define and manipulate database objects such as defining a database table, inserting data into the table, changing the data in the table and retrieving data from the table.
• Working with Security Access Request Systems.
• Experienced in maintenance of SAP and PeopleSoft Applications on DB2 UDB (EE).
• Enforcing constraints and rules on a column of a table or a set of columns.
• Implementing system managed table spaces and creating database managed table spaces for databases.
• Working with DB2 load, import /export utilities to create backup of the critical tables in the database.
• Performing typical database administration tasks and using server administration tools for remote database administration such as generating, managing and scheduling scripts.
• Granting and revoking access to database objects using data Control language (DCL).

Environment: DB2, AIX, DB2 Client, Windows NT/2003, 2008

Confidential

Assistant System Engineer / DB2 UDB

Responsibilities:

• Database administration and support.
• Experience in database restores and disaster recovery.
• Logical and Physical Database design.
• Altered tables and added check constraints and referential integrity.
• Created and maintained databases, tablespaces, tables, views, and indexes.
• Interact with business team and development teams for incorporating new functionality.
• Participated in enterprise-wide application and database production releases.
• Designed and implemented backup architecture viz., backup requirements, backup standards and retentions.
• Involved in upgrading instances from 9.1.3 to 9.5.6
• Prepared SOP’S for backups, restores and disaster recovery.
• Checking the consistency of the databases using different db2ckbkp.
• Data maintenance activities like REORG, RUNSTATS, LOAD, IMPORT and EXPORT.
• Tuning application queries, databases and systems for best performance.
• Performed performance tuning and capacity planning using the parameters of dbm and dbcfg files and various db snapshots.

Environment: DB2 UDB V9.1/9.5, Windows NT