SUMMARY

• Having 7 years and 7 months of professional IT experience in Administrating and Maintaining DB2 UDB Databases.
• Expertise in Unix, Red Hat Linux Enterprise 5, AIX - 6, UDB 9.7 versions.
• Designing & Creating Database objects like tables, views, indexes etc.
• Scheduling Script to automate the database administration tasks and performance tuning.
• Administering and providing support for end-users, developers, software installation and trouble-shooting.
• Provided 24 hour production support that involved maintenance of Instance failures, Database failures, etc, in the environment.
• Effective communication skills developed through continous interaction with global clients and management.
• Supported SQL replication and build/rebuild HADR database environments.
• Excellent ability to handle significant workload with experience in managing multiple projects concurrently in a fast pace environment.
• Worked on Database server Upgradation from DB2 v8.2 to DB2 V9.1 databases.
• Capacity planning for the databases - Performing capacity planning to ensure disk will have sufficient storage for a specific period of time say about 1-3 years.
• Create instances and databases with appropriate initialization parameters and database structures.
• Monitoring Databases, using Database monitors, snapshot monitoring and Event monitoring.
• Upgraded the software to the latest fixpaks to alleviate known DBMS problems.
• Reviewing and analysing SQL and database performance.
• Hands on Experience in Server management, configuring federated databases, DB2 architecture involving process and memory modelling, database Partitioning, creating maintenance plans for routine backup of system databases, user databases and transactional log backup.
• Creating maintenance plans for integrity check, update statistics, reorg and rebuild indexes.
• Granting various authorizations to different users in the company.
• Solving deadlock/block issues on databases, tuning of queries for query optimization and creating DB2 Utility jobs like Reorg, Runstats and backup, releasing them into production and scheduling it on regular basis.
• Recovering the data to a prior point in time using ROLLFORWARD command.

TECHNICAL SKILLS

Operating Systems: IBM-AIX, Sun Solaris 9 & 10, Red Hat Linux ES & AS, Windows Servers.

Databases: IBM DB2 UDB V8.2, V9.1 and V9.7 (Enterprise Edition and Extended Enterprise Edition), Netezza 7.0 and SQL Server 2008.

Tools: Quest Central, Exceed 2006, Toad for DB2, IBM data studio developer v2.1, Sybase Power Designer, VERITAS Net backup, HP service center, Toad for DB2, IBM MTK-2.0.5.0, DB2 Recovery Expert

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Performance tuning and optimization of databases using Performance Monitor tool and ScrutiNet tool.
• Providing fix to production problems
• Setting and Maintaining high availability solutions
• Attending high level meetings for migration activities.
• Preparing plan for migration and implementing the same.
• Writing scripts for monitoring the database activities automatically by triggering them.
• Incident root cause analysis.
• Handling any Change Requirements for the databases
• Monitoring database server and automating performance monitoring and preparing other statistics reports by writing scripts.

Environment: IBM-AIX, Sun Solaris 9 & 10, Red Hat Linux ES, IBM DB2 UDB V8.2, V9.1 and V9.7 (Enterprise Edition and Extended Enterprise Edition), Netezza Twinfin, BMC monitoring tool, Control-M tool, Quest Central, Toad for DB2, Managenow, Infoman and InfoWeb.

Confidential

Database Administrator

Responsibilities:

• Monitored Databases, using Database monitors, snapshot monitoring and db2pd.
• Analyzed the Database performance impact.
• Worked with export, import, load utilities to manage table data.
• Collected the statistical information about the Tables and Indexes.
• Evaluated the Database Bufferpool utilization and Hit ratios.
• Troubleshoot the development issues.
• Evaluated the database shared memory and instance shared memory allocations.
• Analyzed the stored procedures and User defined functions performance tuning.
• Changed the database configuration parameters based on performance impacts.
• Extracted the DDL structure of the Database objects using db2look.

Environment: Windows Servers, IBM DB2 UDB V9.7 (Enterprise Edition), Control Centre, Toad for DB2, IBM data studio developer v2.1.

Confidential

Database Administrator

Responsibilities:

• Monitored Databases, using Database monitors, snapshot monitoring and db2pd.
• Analyzed the Database performance impact.
• Analyzed the Database server system and Configuration files.
• Worked with export, import, load utilities to manage table data.
• Collected the statistical information about the Tables and Indexes.
• Evaluated the Database Bufferpool utilization and Hit ratios.
• Troubleshoot the development issues.
• Evaluated the database shared memory and instance shared memory allocations.
• Changed the database configuration parameters based on performance impacts.
• Extracted the DDL structure of the Database objects using db2look.

Environment: IBM-AIX, Sun Solaris 9 & 10, IBM DB2 UDB V9.7 (Enterprise Edition), Control Centre, Toad for DB2, Quest Central, Servicenow, HP service center.

Confidential

Database Administrator

Responsibilities:

• Involved in the installation, configuration and managing of DB2.
• Developing & maintaining naming standards for database objects such as tablespaces, tables, indexes & views.
• Granting various authorizations to different users in the company.
• Creation and implementation of stored procedures for implementation of custom required processes.
• Create instances and databases with appropriate initialization parameters and database structures.
• Involved in the Installation of fix packs.
• Monitored Databases, using Database monitors, snapshot monitoring and Event monitoring.
• Recovered data to a prior point in time using ROLLFORWARD command.

Environment: IBM-AIX, Sun Solaris, Red hat Linux, IBM DB2 UDB V9.7 (Enterprise Edition), Toad for DB2, Quest Central, Servicenow, HP service center,Sybase Power Designer and Exceed 2006.