Highlights:

Skills:DB2 UDB LUW DBA

ADVISORY TECHNICAL SERVICES PROFESSIONAL 06/2009 - 07/2013
IBM INDIA PRIVATE LIMITED, Chennai, TamilNadu India
DB2 UDB DBA
DB2 Installation, Upgradation and Fix pack Installation. Performance Tuning and SQL Replication. Data refresh and Shell Scripting for database maintenance and monitoring tasks. Applying Fix Packs in both HADR and Non-HADR environment. Snapshot Monitoring and monitoring diagnostic logs. Restoration of databases from online and offline backups. Redirected Restore of databases from online and offline backups. Roll forward of databases to a point in time. Perform daily operational Database management, including, administration, performance and utilization monitoring, capacity management and problem resolution activities. Plan, schedule, test, implement, and document change activities within allocated time frames, without impacting other activities. Proactive capacity planning and Provide robust, secure, scalable, supported, high-performing Databases systems. Perform Reorgchk, Reorg and Runstats. Keep up to date on the latest security risks and apply appropriated countermeasures to environments to protect the systems.--
PROJECT LEAD 10/2008 - 06/2009
SATYAM COMPUTER SERVICES LIMITED, Chennai, TamilNadu India
DB2 UDB DBA
Data refresh from one environment to another. Restoration of databases from online and offline backups Redirected Restore of databases from online and offline backups. Roll forward of databases to a point in time. DB2 Installation and Fix pack Installation. Migration from DB2 UDB v8 to v9. Validating and applying the DDL. Performing Reorgchk, Reorg and Runstats. Shell Scripting for database maintenance and monitoring tasks. Snapshot Monitoring, Event Monitoring and Monitoring diagnostic logs. Performance tuning and tuning queries. Federation of databases between DB2 UDB and Oracle. Database Replication using HADR and TSA.--
IT ANALYST 03/2006 - 10/2006
CATERPILLAR LOGISTICS SERVICES INDIA PRIVATE LIMITED, Chennai, TamilNadu India
DB2 UDB DBA
Database maintenance activities like reorgchk, reorg and runstats. Redirected restore of DB2 UDB Databases. Restoration of Databases from the online backups. Loading Data into a table having constraints. Customizing Perl Scripts for backup, extending / reducing the tablespaces, reorg and runstats. Writing recursive query using WITH clause. Monitoring the health of DB2 UDB Production databases--
SYSTEMS ANALYST 11/2006 - 09/2008
COGNIZANT TECHNOLOGY SOLUTIONS, Chennai, TamilNadu India
DB2 UDB DBA
Data refresh from one environment to another. Restoration of databases from online and offline backups Redirected Restore of databases from online and offline backups. Taking Incremental backup of partitioned database. Loading Data into a table using various file type modifiers and pipes. Loading Data into a table having large objects and constraints. Monitoring the transaction log space of partitioned database. Monitoring the run queue, system and user CPU usage. TSM configuration, moving directories from one server to another, binding. Creation of Materialized query tables. Validating and applying the DDL. Performing health checks on databases. Monitoring the Stress and Performance of databases. Performing reorg and runstats. Shell Scripting for database maintenance and monitoring tasks. Snapshot Monitoring, Event Monitoring and Monitoring diagnostic logs.--
SOFTWARE ENGINEER 09/2005 - 12/2005
INFOSYS TECHNOLOGIES, Chennai, TamilNadu India
DB2 UDB DBA
Database maintenance activities like reorgchk, reorg and runstats. Redirected restore of DB2 UDB Databases. Restoration of Databases from the online backups. Loading Data into a table having constraints. Customizing Perl Scripts for backup, extending / reducing the tablespaces, reorg and runstats. Monitoring the health of DB2 UDB Production databases--
PROGRAMMER 08/2003 - 08/2005
VISUALSOFT TECHNOLOGIES, Chennai, TamilNadu India
DB2 UDB DBA
Maintaining all Latest Tables, Columns, Relationships, Indexes Changes in ER-Diagrams using Silverrun. Forward and Reverse Engineering using Silverrun. Writing Queries and user defined functions. Creating Databases from SQL scripts and maintaining all Databases with latest changes. Federation of Databases by Creating Wrapper, Server, User Mapping and Nicknames. Creating User Temporary Tablespace for Declaring Global Temporary Table. Generated Access Plans for Queries Using “db2exfmt”. Creating Indexes for Queries Based On “db2advis”.--

National Institute Of Technology 06/1999 - 04/2003
Warangal, AndhraPradesh, India
Degree: Bachelor's Degree
Major:COMPUTER SCIENCE AND ENGINEERING.
Bachelor of Technology (B.Tech) (1999-2003) College: National Institute Of Technology (Regional Engineering College), Warangal. Major: COMPUTER SCIENCE AND ENGINEERING. Secured 66.81% as Aggregate. Date of completion: April 2003

CV