CAREER SUMMARY

• 7+ years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Capacity Planning, Application design, testing, implementation and maintenance of databases using DB2 LUW on Linux, UNIX and Windows Platforms.

• 7 years of experience in Database Administration using DB2 LUW with strong business knowledge of Financial and Manufacturing projects.
• Worked through all phases of system/S oftware development life cycle (SDLC).
• Expertise in development support activities including installation, configuration and successful deployment of database schema and other changes across all environments.
• Experience in upgrading DB2 UDB databases and applying fixpacks to keep DB2 at most recent level. Upgraded numerous databases from V8 toV9.1, V9.1 to V9.5, V9.7 and V9.7 to V10.1.
• Provided production support for critical applications running on 24/7 basis.
• Experience in implementing Backup and Recovery strategies using RTO (Recovery Time Objective) and RPO (Recovery Point Objective).
• Very good experience in running utilities like LOAD, IMPORT, EXPORT, DB2MOVE, INGEST, REORG, RUNSTATS, REBIND.
• Worked with third party tools like Tivoli Storage Manager (TSM), IBM OPTIM Performance Manager (OPM), BMC Change Manager, Toad and DB Artisan.
• Experience in Database maintenance, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
• Proficient in writing Korn shell scripts for various kinds of administration and maintenance tasks.
• Familiar with ERWIN data model tools.
• Administration of databases, storage groups, tablespaces, tables, views, indexes and referential integrity.
• Experience with data warehousing and concepts of star schema, MDC, and Table Partitioning concepts.
• Worked on DPF Environment with database size of 20+ TB with 34 DB Partitions on 5 AIX servers.
• Knowledge of database configuration using Infosphere Balanced Warehouse concepts and IBM DB2 ISAS (IBM Smart Analytics System).
• Experience in setting up federation between DB2 and other RDBMS like Informix and Oracle databases.
• Knowledge of Purescale and HADR Environments.
• Experience with Range Partitioned tables, Multi Dimensional Clustering Tables and Union ALL views.
• Experience with HADR. Experience with start HADR, stop HADR, TAKEOVER HADR Commands and also Monitored HADR status using db2pd and using database snapshot commands.
• Experience in using db2top, db2pd, SYSIBMADM views and other V9.7 table functions and MON GET functions.
• Very good experience with LINUX and UNIX (Aix and Solaris) operating systems.
• Managed database security, Creating and assigning appropriate roles and privileges to users depending on the user activity, setting up DB2 AUDIT and knowledge of Row and Column Access controls (RCAC).
• Knowledge of DB2 Work Load Management (WLM).
• Excellent analytical and functional skills with strong communication and interpersonal skills.
• Willing to learn and adapt to new challenges.

TECHNICAL SKILLS:

RDBMS: DB2 UDB, 8.2, 9, V9.1, v9.5, V9.7, V10.1

Database Tools: Quest Tools, BMC Tools, Erwin, DB Artisan, TSM, and Veritas, IBM OPM, DATA STUDIO

Hardware: IBM P570, P750, P770 and Intel Based Servers.

Operating System: AIX 7.1/6.1/5.3/4.3. x, Solaris 2.6/2.7/8, RH Linux Advanced Server 2.1, 3.0, 4.0, Windows 2005/ NT 4.0ETL, Other Software and Languages: IBM Data stage, Abinitio, Actuate, Cognos, Websphere

Programming and Scripting Languages: Shell Scripting, AWK, SED, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

DB2 LUW/UDB DBA

Environment: DB2 UDB EE/EEE(DPF) V9.5 fp4, V9.7 FP8, V10.1, AIX 5.3/6.1, Zlinux, Linux, Netbackup, Java, WebSphere 6.1, Cognos, Abinitio, Actuate

Responsibilities:

• Involved in DB2 UDB support, Physical Database design, installations, security, integrity, Backup & Recovery.

• Migrated many databases from V9.1 FP5 to V9.7 FP3a (DPF), V9.7 FP8 to V10.1 (DPF).
• Provided DBA support for various applications on AIX and Linux.
• Involved in various database benchmark testing and proof of concepts.
• Designed and implemented the test cases for capacity testing.
• Performed numerous restores (including redirected restores) from one Environment to other Environment.
• Monitored the production database regularly using various administrative views sysibmadm and MON GET functions.
• Tuned DBM, DB Configuration parameters and Registry variables for optimal database performance.
• Involved in database sizing estimates for the new projects in pipeline.
• Converted many regular Tablespaces to V9.5 large Tablespaces. Worked on DMS and Automatic Storage Tablespaces extensively.
• Extensively worked with designing and developing optimal process for data extraction, transformation, loading, integrating data in warehouse Environment.
• Provide database size estimates at each stage of implementations and suggest solutions for optimizing ETL (Ab Initio) process.
• Extensively involved in data maintenance activities like REORG, RUNSTATS, LOAD, INGEST, IMPORT and EXPORT.
• Wrote many korn shell scripts for automating many manual tasks.
• Migrated the databases from existing IBMP 570 Servers to IBM P 770 Servers.
• Analyzed many Dead lock and lock timeout scenarios and advised Application team accordingly to resolve them.
• Identified unused indexes on the tables and dropped them, thereby helping the performance of many insert queries.
• Repeatedly monitored the database and tables growth and provided capacity planning estimates to the management.
• Involved in stress testing/ performance testing of the databases and captured the performances of the queries before moving into production.
• Worked with the SAN administrators to design the physical storage.
• Worked closely with Application teams in tuning SQL queries performing badly in terms of elapsed time and CPU and also implemented MQT’s, Replicated MQT’s, Statistical Views,created appropriate indexes and thus improved the performance of the queries.
• Created V9.7 Locking event Monitors for analysis of Lock - waits and deadlocks.
• Extensively used query tuning related tools like db2exfmt, db2advis and db2batch for improving query performance.
• Worked on Attaching and detaching table partitions for Range Partitioned tables.
• Implemented DDL and DML changes in the database using new features of V9.5/V9.7/V10.1.
• Worked with ETL teams to develop the patterns for data movements and loading data into Data warehouse environments.
• Migrated databases from one datacenter to another datacenter using redirected restores.
• Worked closely with Unix System Administrators during new database creations for setting up filesystem layout, CPU, Memory and paging space configuration.
• Reviewed existing database and the system, to improve the database performance using different parameters (like Bufferpool, SORT heap and other memory parameters) in production environment.

Confidential, Moline, IL.

SR DB2 UDB DBA

Environment: DB2 UDB EE V 8.1 fp14, V 9.5 fp1, V9.7 FP1,AIX (5.3), Solaris 10,TSM, Java, WebSphere 5.1.

Responsibilities:

• Providing UDB DB2 DBA support for many productions and testing environments.

• Checking the consistency of the databases using different db2 commands.
• Migration of databases from V8 to V9.5 FP1.
• Migration of Clients from db2 V8.1 to V9.5 FP1 on Datastage (ETL) and Websphere (APPLICATION) servers.
• Implemented UNION ALL views for improving the OLAP queries.
• Worked on IBM Infosphere Federation server creating Nick names.
• Wrote many korn Shell scripts to automate many of the day to day processes.
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold (70%).
• Creating and Monitoring Users, authorities and responsibilities and password management.
• Creating, altering of the different types of tablespaces, bufferpools and creating schemas as per the user requirements.
• Created AIX Korn shell scripts to collect bufferpools and tablespaces utilization data on a regular basis to calculate DB2 UDB and system performance trends.
• Created Problem Management Tickets (PMR) with IBM and solved numerous issues and even applied new patches.
• Created event monitors, snapshots analyzing the event monitor data for effective database tuning.
• Restored databases in between all the environments as per the requirement, till point in time recovery and to end of logs. Also implemented redirected restore using the V9 automatically generated restore script.
• Discussed with the development teams about the poorly performing queries and improved the performance of such long running queries.
• Monitored the BUFFERPOOL HIT RATIOon a regular basis and modified the bufferpool pages as necessarily.
• Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
• Cataloging different databases on different servers.
• Requested System Administrators for creation of new Volume groups and filesystems for creating new database and Tablespaces in the designated way.
• Implemented INCREMENTAL BACKUP and RESTORE process in numerous Environments.
• Improved the performance of long running SQL’s by taking the db2expln and visual explain, and analyzing the access plan and taking necessary steps based on the access path.

Confidential, Pleasanton, CA

SR DB2 UDB DBA

Environment: DB2 UDB EE V 8.1 fp12, V 9.5 fp1, AIX (5.3), Solaris 9, NetBackup, Java, WebSphere 6.0.

Responsibilities:

• Developed and maintained production, test and development DB2 UDB databases on AIX, Solaris and Windows.

• Created and maintained databases, table-spaces, tables, views, nicknames and indexes.
• Migration of databases from V8 to V9.5.
• Migration from Sun Solaris to AIX.
• Created new partitions for V9.5 Range partitioned tables using ATTACH PARTITION of ALTER TABLE Statement.
• Extensively involved in SQL Query Tuning including Decision Supporting Queries and Federated Queries and recommending SQL queries for better performance using snapshot monitor, visual explain, index advisor, db2expln, db2exfmt.
• Implemented the database backups, restores and disaster recovery.
• Coordinated with business team and application teams for incorporating new functionality and implementing the updates.
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Generated reports of database statistics using DB2LOOK Utility.
• Recovered data to a prior point in time using ROLLFORWARD command.
• Developed logical and physical tables design using Erwin Data modeler.
• Identified and eliminated unused indexes in the databases Using DB2PD tool and improving the performance of the databases.
• Monitored databases using database monitors, snapshot monitoring and event monitoring.
• Granting and revoking the access to users and groups on the database and database objects.
• Assisted application teams with all DB2 issues and questions during ON and OFF peak hours.

Confidential

DB2 UDB DBA

Environment: DB2 UDB EE V 8.1 fp12, AIX (5.3), Solaris 9, NetBackup, Java, WebSphere 6.0.

Responsibilities:

• Developed and maintained production, test and development DB2 UDB databases on AIX, Solaris and Windows.

• Created and maintained databases, table-spaces, tables, views, nicknames and indexes.
• Migration of databases from V8 to V9.1.
• Coordinated with business team and application teams for incorporating new functionality and implementing the updates.
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Generated reports of database statistics using DB2LOOK Utility.
• Developed logical and physical tables design using Erwin Data modeler.
• Monitored databases using database monitors, snapshot monitoring and event monitoring.
• Granting and revoking the access to users and groups on the database and database objects.
• Assisted application teams with all DB2 issues and questions during ON and OFF peak hours.