SUMMARY:

• Over 9+ Years of IT Experience in the field of Database Administration in DB2 UDB V8.1, V9.5, V9.7, V10.1 and V10.5 on Windows, LINUX and AIX platforms.
• Over 1+ years of experience in DB2 UDB V8.1, V9.5, V9.7 Development.
• Performed database system and SQL performance tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor, and OS commands(topas, vmstat, and iostat), updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.
• Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges.
• Planned, designed, implemented, and promoted the physical databases, table spaces, tables, views, Indexes.
• Established backup and recovery strategies (Full, Online backup) using Commvault and TSM.
• Involved in implementing HADR(High Availability Disaster Recovery) environment by preparing Primary database and Standby database, configuring parameter, and cloning the primary database (backing up primary database and restoring to standby database)
• Designed and implemented logical and physical database modelingusing Erwin tool.
• Planned, Designed, and implemented MQT, and Datapartitioning for improving performance.
• Planned, designed and implemented backup schedules and procedures, and DB system monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment.
• Developed and implemented backup(online, offline), runstats, reorg, rebind, and tablespace capacity monitoring report using Korn shell scripts on DEV, QA (UAT), and PROD system
• Perform database capacity analysis, predict growth trends and forecast ancillary needs.
• Participate in staff rotations of “on - call” responsibilities.
• Performed Db2 Database Server migration.
• Work directly with developmental staff and supervise level I database administrators while implementing applications or packages.
• Execute and run commands by using CLP and CLI.
• Interact regularly with internal technical, applications and operational staff to ensure database integrity, security and availability.
• Experience of db2pd, db2advis, db2expln etc.
• Usage of BASH or KSH on Linux plaforms.
• Worked on configuration/troubleshooting federated database environment.
• Performed Database migration/upgrades between multiple versions.

TECHNICAL SKILLS:

Operating system: AIX 5L, 6, Linux(Redhat, SUSE, Windows)

DBMS: DB2 UDB EEE/V8/V9/V10

Case Tool: ERwin

Language: SQL, SQL/PL, Stored Procedure, JAVA, C Language

Software: Shell Script, Confidential Tivoli TSM, HADR, DB2 Utilities

PROFESSIONAL EXPERIENCE:

DB2 UDB DBA

Confidential, COLUMBUS, OHIO

Responsibilities:

• Monitor the use of the database to identify opportunities for performance improvements.
• Installed, Upgrade and configured DB2 v10.1 and DB210.5 on Linux, AIX and Windows.
• 24/7 On call Production support.
• Recommend and maintain standards for monitoring and event management to be used in production databases.
• Monitor/Setup and manage Q-Replication procedures.
• Performing the setup, manage, troubleshoot with DB2 LUW High Availability and Disaster Recovery (HADR) procedures.
• Maintain and facilitate standard backup procedures, retention plans, and restore testing.
• Assist with data migration between systems including regular data refreshes and making production data anonymous for use in testing environments
• Assist in tuning SQL in stored procedures.
• Perform testing and production builds involving data changes and stored procedure building while following established change management procedures
• Assume all DBA duties in testing and development environments, maintaining design and data consistency throughout
• Maintain standard procedural documentation related to all aspects of operating the database platforms.
• Working knowledge of OPM - Optim Performance Manager / DB2 Performance Expert.
• Document known errors or workarounds in the shared Knowledge Base.

Environment: Db2 UDB V9.1, 9.5, 9.7 Commvault, BMC Patrol, HADR(High Availability Disaster Recovery), Db2 Optim, Quest Central, TSM, Java, JSP, AIX, LUW, SQL Server, Oracle, MySQL.

LEAD DB2 DBA

Confidential, Cary, NC

Responsibilities:

• Monitor the use of the database to identify opportunities for performance improvements.
• Installed and configured DB2 v9 .7fp5 on Linux, AIX and Windows.
• Migrated DB2 v9.5 databases to DB2 V9.7
• Change Management - Schedule change, get approvals, do broadcast and work on change tickets.
• Data refresh at table level and database refreshes across prod/non-prod environments.
• Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance. The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.
• Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings with users and managements and drew out relevant statistics for upper management to study.
• Performed day to day online/offline database backups using Commvault Console.
• Used Remedy for Change Control/Change Management.
• System crash and hang analysis - collecting stack trace, running db2support and uploading the same to Confidential Support to investigate PMR.
• Moving databases from Development to Production after successful completion of application testing.
• Installed/ Configured CDC in LUW/AIX.
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.
• Supported developers to write SQL statements and test them before running it in Production environment. Take the backup of the database when restarting the dprop.
• Database backup & recovering the database at the time of crash.
• Involved in HADR setup, monitoring, rolling up upgrades.
• Created DPF and Range partitioning tables, MQT.

Environment: Db2 UDB V9.1, 9.5, 9.7 Commvault, BMC Patrol, Db2 Optim, Quest Central, TSM, Java, JSP, AIX, LUW, SQL Server, Oracle, MySQL.

LEAD DB2DBA

Confidential, KS

Responsibilities:

• Provided 24*7 supports to over 100 database instances. This includes 15 UAT, 25 Development and over 50 Production DB2 Mission Critical databases running on AIX, and Windows 2000 environment. Databases included OLTP Batch Processing systems.
• Installed and configured DB2 v9 .7fp5 on Linux, AIX and Windows.
• Migrated DB2 v9.5 databases to DB2 V9.7
• Change Management - Schedule change, get approvals, do broadcast and work on change tickets.
• Data refresh at table level and database refreshes across prod/non-prod environments.
• Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance. The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.
• Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings with users and managements and drew out relevant statistics for upper management to study.
• Performed day to day online/offline database backups using Commvault Console.
• Used Remedy for Change Control/Change Management.
• System crash and hang analysis - collecting stack trace, running db2support and uploading the same to Confidential Support to investigate PMR.
• Moving databases from Development to Production after successful completion of application testing.
• Installed/ Configured CDC in LUW/AIX.
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.
• Supported developers to write SQL statements and test them before running it in Production environment. Take the backup of the database when restarting the dprop.
• Database backup & recovering the database at the time of crash.
• Involved in HADR setup, monitoring, rolling up upgrades.
• Created DPF and Range partitioning tables, MQT.

Environment: Db2 UDB V9.1, 9.5, 9.7 Commvault, BMC Patrol, Db2 Optim, Quest Central, TSM, Java, JSP, AIX, LUW, SQL Server, Oracle, MySQL.

SOFTWARE ENGINEER

Confidential, Sanfranscisco, CA

Responsibilities:

• Administration DB2 V9.7 databases on LUW platform.
• Installed and configured DB2 v8, v9, V9.5, V.9.7on Linux, AIX and Windows.
• Database creation and designing.
• Fixpak installation.
• Performance Tuning
• Backup and Recovery and Problem Solving.
• Database migration
• Working and troubleshooting on day-to-day problems via opening and closing tickets.
• Explain and Snapshots, Buffer pools performance optimization, SQL performance evaluation, analysis, and optimization.
• Federation of DB2 databases across the environments.
• Developing the database codes, scripts for databases
• Deploying store procedures for application users.
• Based on the security level granting privileges to users.
• Involved in production/development setup, configuration and support
• Reverse engineering, schema generation & Complete compare using Erwin tool.
• Monitored backup operations, and schedules manual backups as needed
• Usage of tools like DB2 Load, Import, Export and Reorg, Run stats, Reorg Check, Backup, Restore, Db2move, and Db2look
• Performed Redirect restore.
• Performed Database migration/upgrades between multiple versions.
• Performed Server migration.
• Provide 24/7 Oncall support on rotational basis.

Environment: Java, Servlets, JDBC, JSP, Confidential Web sphere Application Server 6.0.2, Veritas Net Backup, Confidential DB2 UDB 8.2,9.1,9.5,9.7, Rational Application Developer (RAD), AIX 5.3.0.3, Oracle 9i,10g, Sql Server 2000,2005, Sybase

SOFTWARE ENGINEER

Confidential

Responsibilities:

• Administration DB2 V9.7 databases on LUW platform.
• Installed and configured DB2 v8, v9, V9.5, V.9.7on Linux, AIX and Windows.
• Database creation and designing.
• Fixpak installation.
• Performance Tuning
• Backup and Recovery and Problem Solving.
• Database migration
• Working and troubleshooting on day-to-day problems via opening and closing tickets.
• Explain and Snapshots, Buffer pools performance optimization, SQL performance evaluation, analysis, and optimization.
• Federation of DB2 databases across the environments.
• Developing the database codes, scripts for databases
• Deploying store procedures for application users.
• Based on the security level granting privileges to users.
• Involved in production/development setup, configuration and support
• Reverse engineering, schema generation & Complete compare using Erwin tool.
• Monitored backup operations, and schedules manual backups as needed
• Usage of tools like DB2 Load, Import, Export and Reorg, Run stats, Reorg Check, Backup, Restore, Db2move, and Db2look
• Performed Redirect restore.
• Performed Database migration/upgrades between multiple versions.
• Performed Server migration.
• Provide 24/7 Oncall support on rotational basis.

Environment: Java, Servlets, JDBC, JSP, Confidential Web sphere Application Server 6.0.2, Veritas Net Backup, Confidential DB2 UDB 8.2,9.1,9.5,9.7, Rational Application Developer (RAD), AIX 5.3.0.3, Oracle 9i,10g, Sql Server 2000,2005, Sybase

SYSTEMS ENGINEER

Confidential

Responsibilities:

• Database Design of tablespaces, bufferpool and tables
• Designing and development of table structures and maintain data dictionary for product development.
• Created dump files for Admin Tables, which maintains the Database privileges, using Export and Import utility.
• Monitoring the database using DB monitoring tools.
• Implemented ARCHIVELOG process to maintain active log files.
• Extensively used and optimized SQL queries for faster retrieval.
• Develop, test, implement software (Database triggers, Stored Procedures and functions) that are related to database and/or application.
• Taking offline and online backup & restore of database.
• Restored database using full-offline backup.
• Performance Tuning on Stored Procedures
• Grant and Revoke privileges to users.
• Preparing data model by using ERWIN tool.
• Performance Tuning Plan documentation.
• Usage of database maintenance utilities like reorg, runstats, rebind etc
• Use software packages BMC Patrol and/or local scripts, monitor performance, space, DB2 UDB database parameters and tuned as required.
• Support developers in performance tuning and query rewrite in a few very large, continually growing UDB databases.

Environment: Java, Servlets, JDBC, JSP, Confidential Web sphere Application Server 6.0.2, Veritas Net Backup, Confidential DB2 UDB 8.2, Rational Application Developer (RAD), AIX 5.3.0.3, Oracle 9i,10g, Sql Server 2000,2005, Sybase.

SR S/W ENGINEER

Confidential

Responsibilities:

• Install Confidential UDB DB2 8.1 on Linux Server on three systems, install DB2 client on Workstations and Catalog the Database.
• Involved in creation of four Databases and maintained for Development, QA and Production (Test Data and Migrated data) environments.
• Involved in designing and development of table structures and maintain data dictionary for product development.
• Created dump files for Admin Tables, which maintains the Database privileges, using Export and Import utility.
• Monitoring the database using DB monitoring tools.
• Implemented ARCHIVELOG process to maintain active log files.
• Implementing Replication Process for eSeva Schema tables, which import the data from and to MAS database.
• Created Database Stored Procedures for search criteria and reports which generates the XML Page.
• Creation of users and giving roles and privileges.
• Extensively used and optimized SQL queries for faster retrieval.
• Maintaining of Version Control for Stored Procedures.
• Data variance report for computerized ULBs.
• Designed and developed Data Migration Process for conversion of legacy data in MSACCESS, SQL*SERVER to DB2 using SQL*SERVER DTS, Visual Basic.
• Documentation on Data migration Strategy.
• Created dump files using Export and Import utility.
• Develop, test, implement software (Database triggers, Stored Procedures and functions) that are related to database and/or application.
• Taking offline and online backup & restore of database.
• Restored database using full-offline backup.

Environment: Java, Servlets, JDBC, JSP, EJB, Confidential Websphere Application Server5.0, XML, XSL, HTML, Dream weaver Ultradev, Confidential UDB DB2 8.1, Confidential Websphere Application Developer 5.0, Rational Rose 2001 A, Confidential UDB DB2 8.1, Windows NT 4.0 / Windows 2000, Linux 8.1.