Summary:

• A Senior DB2 UDB Database Administrator with 10 years experience of DB2 UDB on AIX/Linux.
• Experience at providing 24x7 on call support for production environment and responding to off hour emergencies, generating solutions rapidly and work well under pressure.
• Extensive experience with planning, documenting and performing Database upgrades and migration.
• Extensive experience with setting up new database environments and create database servers and database server moves.
• Experience in database software management (patch and version management).
• Experience in problem analysis and troubleshooting database related issues. Provide performance tuning support to development teams for resolving issues with space usage, stored procedures, SQL Tuning and application monitoring.
• Experience with case management of IBM DB2 technical support
• Technologies include DB2 UDB LUW v7.x, v8.x, v9.x, v9.7, AIX v5.x, Sun Solaris, Linux, BMC Patrol, DB Artisan, Control Center, DB2 client, DB2 Connect, Performance Expert, Optimal Performance Manager (OPM), Quest, db2support, db2move, db2advis, db2batch, db2pd, Visual Explain, export/import/load, Tivoli Storage Manager (TSM), Oracle, PERL, Shell Script.

WORK Experience:

Confidential, Jersey City, NJ 02/06 – present
Sr. DB2 UDB Database administrator

• Managed database instances for Consolidated Online trading system in DB2 UDB in version 8.x and 9.x on AIX 5.3 and Linux servers.
• Provided DBA 24x7 on call Support for company wide UDB Production databases. Responded and troubleshoot all database related issues and had a 100% on-time resolution for all PROD and DR issues. As a results no Production or DR database had any downtime throughout the years.
• Managing DB2 UDB databases on 30 Unix servers, sizes up to a few hundreds GBytes. Troubleshoot all database related problems.
• Responsible for company wide DB2 UDB upgrade planning and design, including from version 7.x to version 8 and from version 8.x to version 9.x. Function as DB2 Engineering DBA. Presented upgrade plans including comprehensive Fallback Plans to application and business users. Carefully designed and planed the upgrade strategies including changing the database file system layout during the upgrade, separated the database file systems, file systems for tablespaces and the instance owner’s file system which had been all under one file system in old version. Database performance was improved as a result. Separating the file systems enforced the UDB database standard practice and it also simplified tablespace and file system maintenance.
• Analyzed and tuned problematic SQL statements, As a result, the response time of some slow running queries went from hours to minutes or in some cases even to seconds, resulted in dramatic reductions in application processing time.
• Assisted developers with the performance test initiatives. Performed index analysis and made recommendations to development teams.
• Monitored database and Unix system performances identifying and removing bottlenecks. Monitored the performance of the databases utilizing event monitors on statements, snapshots on database, locks, applications, bufferpools and tablespaces etc. Selected appropriate Database configuration parameters for efficient database operation. Optimized buffer pool configurations on DB2/UDB server. Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems.
• Work with BMC team to comprehensively test and configure UDB Monitoring thresholds and scenarios for version 8.2 and 9.1 to ensure BMC monitoring was available when databases were upgraded in Production environment.
• Responsible for researching various UDB FixPacks for v8.x and v9.x and provided assessment of these FixPack to the upper management. Applied various FixPacks to v8.x and v9.x database servers.
• Installed Performance Expert and OPM (Optimal Performance Manager). Configured and tested both software products in Engineering, test and QA servers.
• Created UDB instances and Databases for both v8.2 and v9.x in Engineering, Test, QA, DR and PRODUCTION environments. Provided full DBA supports during application life cycle, including database change requests and business processes analysis. Worked on database release changes and supported migration of release changes from test environments to QA and Production environment.
• Reviewed production database and dbm settings and provided recommendation for database configuration changes. Set up database performance monitoring after config changes to measure the performance improvements. Measurements showed over 30% improvement in performance.
• Evaluated and examined disk space allocation in PROD environments on an ongoing basis to ensure sufficient disk space to cover the size increase of PROD/DR databases.
• Performed problem analysis and created monitoring scripts to capture a snapshot of Locking Issues. Added indexes to existing tables to fix the locking issues.
• Worked on data center move project to move all the engineering, test, qa and Production servers from Lincoln Harbor to Bluestone data center in CT.
• Opened PMR’s with IBM DB2 support and worked with support engineer to resolve database and OS related issues.
• Performed backup and restore functions using TSM. Redirect restored test databases with production databases. Moved databases from one server to another or from existing file systems to new file systems.
• Managed some Oracle databases for multiple applications and functioned as an Oracle backup DBA.
• Technical expertise in the following: Technologies include DB2 UDB v7.x, v8.x, v9.x, UNIX, Linux, Oracle, PERL, Shell Script, BMC Patrol, DB Artisan, Control Center, Performance Expert, Optimal Performance Manager (OPM).

Confidential, Armonk, NY 11/2005 – 02/2006
Sr. DB2 UDB System engineer

• Assisted client to build new database servers on site for their new data centers.
• Assisted clients to trouble shoot database server and performance issues.

Confidential, BAsking Ridge, nj 01/2002 – 10/2005
Lead Database Administrator

• Managed OLTP databases for B2B Electronic Eligibility Systems in DB2 UDB 7.2 and 8.1 on AIX 5.2.0.
• Managed DB2 UDB databases running on 18 UNIX servers, sized up to 300 to 400 GBytes. Provided on call support. Trouble shoot database related problems.
• Created UDB instances and Databases in development environments. Provided full DBA supports during application life cycle, including database change requests and business processes analysis. Worked on database release changes and supported migration of release changes from test environments to pre-production and production environment.
• Migrated databases from UDB 7.2 to 8.1. Participated in projects supporting physical move of all the database servers from Connecticut to Minnesota.
• Performed backup and restore functions using TSM. Redirect restored test databases with production databases. Moved databases from one server to another or from existing file systems to new file systems.
• Analyzed and tuned problematic SQL statements, As a result, the response time of some slow running queries went from hours to minutes or in some cases even to seconds, resulted in dramatic reductions in application processing time.
• Assisted developers with the performance test initiatives. Performed index analysis and made recommendations to development teams.
• Monitored database and Unix system performances identifying and removing bottlenecks. Monitored the performance of the databases utilizing event monitors on statements, snapshots on database, locks, applications, bufferpools and tablespaces etc. Selected appropriate Database configuration parameters for efficient database operation. Optimized buffer pool configurations on DB2/UDB server. Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems.
• Resolved production performance issues and provided recommendations to production DBA.
• Configured UDB servers to use stored procedures. Helped developers to trouble shoot problems related to stored procedures.
• Created shell scripts to monitor file system/tablespaces usage and automatically notify DBA of database performance problems, resulting in increase of database availability.
• Created various shell scripts to automate database maintenance such as reorg/runstats and backup/restore/snapshot monitors.
• Performed Load, Import and Export Utilities.

Confidential, JERSEY CITY, NJ 02/1998 – 12/2001 
dATABASE aDMINISTRATOR

Managed and maintained 24x7 production databases on Oracle 8.1.7 for online stock trading  information retrieving system for clients Discovery, Waterhouse and Suretrade. Managed  production database for BPSA customer information on Oracle 8.1.7 for clients Waterhouse, Morgan Stanley  and Lehman Brother and CIBS on Sun Solaris 2.6.Major responsibilities are:

• Performed environment analysis, system analysis, business requirement analysis, entity relationship design, and physical database design. Configured Oracle database instances and physical data structures for the application development and testing. Provided full Oracle DBA supports during application life cycle, including database requests and business processes analysis.
• Managed Oracle databases running on UNIX and Windows NT environment. Created and maintained users, roles, systems and object privileges. Selected appropriate INIT.ORA parameters for efficient database operation. Created Tables, Indexes, Views; Manage Tablespaces, Rollback Segments, Redo Logs and other database objects.
• Worked with data modeller and developer to design and implement data warehouse database based on Star Schema. Analysed logical and physical layout of Oracle database and OS environment for data warehousing. Bitmap Indexes are used to reduce response time.
• Implemented OFA (Optimal Flexible Architecture) standard based Oracle server infrastructure required to ensure successful application deployment and easy maintenance. Created and configured Oracle database instances and physical data structures for the application development and testing.
• Created and set up Database Links. Configured SQL*Net and Net8 for network computing using two types of Connection Pooling – Net8 connection pooling, Connection object pooling.
• Conducted data Import/Export and loading using direct SQL*Loader.
• Implemented database and application backup and recovery plans. Developed database backup, restore and recovery procedures. Performed cold-backup, hot-backup, logical and physical database backups; complete and incomplete recoveries.
• Monitored and optimized database performance using Explain Plan, UTLBSTAT & UTLESTAT, TKPROF and Enterprise Manager. Performed Application Tuning.
• Created standby Database for the purpose of cloning test databases which are used for bench marking purposes.

Education:MS in Computer and Information Science

Certifications/Training:IBM EDUCATION: DB2 UDB Database Administration 
Advanced Database Administration v9.x 
DB2 9 for LUW Advanced Database Recovery
DB2 9 for LUW Advanced Database Administration for Experts 
DB2 for LUW Performance Tuning and Monitoring Workshop
UNIX System Administration