SUMMARY:

• Over 17 + years of experience in software development.
• 15 Years of experience as DBA Experience in DB2 UDB (LUW) 5/6/7/8/9/10
• 5 Years of experience as DBA in Oracle 10g/11g.
• 5 Years of experience as DBA in SQL Server 2000/2005/2008 .
• 12 Years of experience in database designing, architecture and SQL tuning
• 7 years of experience in developing web applications using Visual Interdev, ASP, IIS, JavaScript, VBScript, HTML, DHTML, Web Sphere, Servlets, JSP, J2EE, PHP, Struts, Java
• Exposed to various levels of software development life cycle.
• 4 years of Experience as Business analyst.
• 5 years of Experience as Team Lead.

TECHNICAL SKILLS:

Languages: C, VS COBOL II, SQL, PL / SQL, VBA, Lotus Notes 4/5/6

Operating System: UNIX, Win95/2000/NT/XP, DOS, Linux, AIX, TSM.

Databases: DB2 /7.x/8.x/9.x/10.x UDB, LUW, Oracle7/8/9/10/11, MSAccess7.0, BW.

SQLServer 2000/2005/2008, Lotus Notes 4/5/6, Post GreSQL, Sybase.

Web Technologies: HTML, JavaScript, XML, WebSphere5, J2EE, PHP, Servlet, Applet, Swing, Java, Struts, Ajax, Hibernate

GUI: Visual Basic 4/5/6, Forms 4.5, Lotus Notes 4/5, CICS

Tools: /Utilities:Reports 2.5, Toad, Quest, db2haicu, Control Center, Command Center, Merge Backup, Optim, Confidential Development Studio, DB2MON, Foglight, Remedy.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh NC

Responsibilities:

• Testing and implementing different physical and logical backup and recovery methods like point in time, cross node recovery, media recovery, full/partial and export/import, Incremental delta backup, online reorgs, compression (data, index)
• Tricare clearance for handling federal Databases.
• Performance tuning of the SQL, DBM and DB configurations.
• Setting up the HADR.
• Opening/working with Confidential on the PMR’s.
• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance.
• Designing databases and database layout, automating the process by writing shell scripts.
• Recommendations/suggestions on physical database design.
• Annual database storage management (Capacity planning).
• Analyzing and implementing new features of 10.5.
• Working with the application team and resolving their issues.
• Level 2 supports for any production support.
• Implementing the Avamar backup and recovery scripts.
• Versatile team player with excellent analytical, communication and inter personal skills

Environment: DB2 UDB 9.1/9.5/9.7/10.1 UDB LUW, Toad, SAN, AIX, LINUX, Remedy, HADR, HACMP, EMC Avamar storage

Confidential, Jacksonville FL

DBA

Responsibilities:

• Conversion specialist from Oracle to DB2 UDB and SQL Server.
• Production support, with on call duties.
• Installing and applying patches for Database Servers DB2 UDB, Oracle and SQL Server.
• Mergers and Acquisitions of Bi - lo with Winn-dixie.
• Testing and implementing different physical and logical backup and recovery methods like point in time, cross node recovery, media recovery, full/partial and export/import, Incremental delta backup, merge backup, online reorgs.
• Performance tuning of the SQL, DBM and DB configurations.
• Setting up the HADR (ROS) using db2haicu.
• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance.
• Implementing Manhattan Vendor Application on DB2 UDB
• Designing databases and database layout, automating the process by writing shell scripts.
• Recommendations/suggestions on physical database design.

Environment: DB2 UDB 8.2 /9.5/9.7 UDB LUW, Oracle 10g/11g, SQL Server 2005/2008, Quest, RMAN, PL/SQL, ASM, SAN, db2top, db2pd, db2diag, Merge Backup.

Confidential

DBA

Responsibilities:

• Installing and applying patches for Database Servers DB2 UDB, Oracle and SQL Server.
• Performance tuning of the DBM and DB configurations and
• Setting up the HADR (ROS) using db2haicu.
• Production support with on calls duties.
• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance.
• Capturing the long running queries and executing Explain and db2advis to create indexes and examine the access plan.
• Buffer pool management, checking the hit ratio and other parameters.
• Working on the migration plans for moving over to v9.X from v8.X
• Designing databases and database layout, automating the process by writing shell scripts.
• Testing and implementing different physical and logical backup and Recovery methods like point in time, cross node recovery, media recovery, full/partial and export/import
• Recommendations/suggestions on Physical Database design.

Environment: DB2 UDB 8.2 /9.5/9.7 UDB LUW, Oracle 10g/11g, SQL Server 2005/2008, Quest, Toad, RMAN, PL/SQL, ASM, SAN, RAC, db2top, db2pd, db2diag.

Confidential, NC

DBA

Responsibilities:

• Installing Database Servers and applying Patches for DB2 UDB, Oracle, SQL Server.
• Performance tuning of the DBM and DB configurations and SQL.
• Production support with on calls duties.
• Working on the migration plans for moving over to v9.5 from v8.2
• Performance monitoring of the complete DB activities, which include Lock/Deadlock situations, Log archiving, Table space size issues.
• Monitoring of the CPU and Memory utilizations periodically and present to the Management in a report format.
• Designing Databases and Automating the Process by writing Shell Scripts.
• Testing and implementing different physical and logical backup and Recovery methods like point in time, cross node recovery, media recovery, full/partial and export/import
• Resolving the issues with Oracle, Confidential, and Microsoft on trouble shooting applications.
• Participating in the DR (Disaster Recovery) exercise.
• Recommendations/suggestions on Physical Database design.

Environment: DB2 UDB 8.2 /9.5/9.7 UDB, Oracle 10g/11g, SQL Server 2000/2005/2008, Sybase, Tivoli (TSM), Java, Struts, Quest, Toad, RMAN, PL/SQL, ASM, SAN, RAC, Struts, Java, Tomcat, balance Warehouse.

Confidential, NC

Sr Database designer/ Sr Data Analyst.

Responsibilities:

• DB2 DBA & Team lead
• Design database and web application with web sphere, servlet and jsp on apache.
• Business Analyst Interacting with the users and gathering new enhancements.
• Technical Team Lead

Environment: DB2 UDB 5/7/8, Oracle 9i, Web Sphere (WSAD), JSP, Java, J2EE, Lotus Notes, DESC, LEI, JavaScript, HTML, DB2 Stored Procedure Builder, Visio, Notes pump, ASP Visual Interdev, Tomcat, Apache, PHP, PostGreSQL, XML, Servlet, Struts, Ajax, Hibernate.