SUMMARY

• Over 12 + years of experience in software development.
• 10 Years of experience as DBA Experience in DB2 UDB 5/6/7/8/9.
• 2 years in Balance warehouse.
• 5 Years of experience as DBA in Oracle 10g/11g.
• 3 Years of experience as DBA in SQL Server 2000/2005/2008.
• 10 years experience in database designing, architecture and SQL tuning
• 5 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.

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 5.x/7.x/8.x/9.x UDB, Oracle7/8/9/10/11, MSAccess7.0, BW.
SQLServer2000/2005/2008, Lotus Notes 4/5/6, PostGreSQL, 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.

EXPERIENCE:

Project Name: DBA (DB2, SQL Server, Oracle) 
Client: Confidential, NC 
Duration: May 2011 - Current
Designation: DBA

Admin Roles:

• 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.
• 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.
• Versatile team player with excellent analytical, communication and inter personal skills

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

Project Name: DBA 
Client: Confidential, NC 
Duration: March 2008 – May 2011
Designation: DBA

Admin Roles:

• Installing Database Servers DB2 UDB, Oracle, SQL Server.
• Applying patches for Oracle, DB2 UDB, SQL Server.
• Performance tuning of the DBM and DB configurations.
• 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.
• Updated the /etc/services files with the IP.
• Moved the DB2 V8.2 Warehouse to DB2 V9.7 FP2, IBM BCU environment.
• Resolved the I/O bound DB2 V8.2 warehouse by doing the redirected restore with proper physical designing.
• 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.
• Reviewing the IBM recommendations for optimizing the data warehouse performance.
• Working on the Range Partitioning of the largest Tables in the Warehouse db.
• Working on the Deep Compression to minimize storage consumptions, thus saving on the storage costs.
• Designing Databases.
• 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
• Supporting Vendor Applications.
• Resolving the issues with Oracle, IBM, and Microsoft on trouble shooting applications.
• Participating in the DR (Disaster Recovery) exercise.
• Recommendations/suggestions on Physical Database design.
• Writing Stored Procedures, PL/SQL and Scripts.
• Versatile team player with excellent analytical, communication and inter personal skills

Web Roles:
Maintaining a web application which will store all useful information for the DBA like storing the Physical hostname, Virtual Hostname names, instance, port, SQL accounts with their passwords, and also checks all the servers for the errors and dump those error in that database.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.

Project Name: W4 , CBCC (IITC), DMIW
Client: Confidential, NC 
Duration: Oct- 2000 – Feb 2008
Designation: DB2 UDB DBA/ Team Lead/ Sr DB2 Developer/ Sr Web Developer/ Sr Database designer/ Sr Data Analyst.

Roles:

• DB2 DBA & Team lead
• Database Design.
• Designed a 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.

Project Name: Automation
Client: Confidential, NY 
Duration: Feb-2000 to Sep- 2000
Developed internal web site for the users to check the reports online.
The Reports are created through an automated process, using VBA Macros where the code takes the Data from the Excel Sheets/ SQL Server Database and create charts dynamically.

Role: Created ASP pages, COM objects in VBto find the number of people entered the site, Used Java Script, Macros in VBA (Excel & Word) and performed Database Admin roles. 
Environment: VB 6.0, ASP, COM, VBScript, JavaScript, HTML, ADO, SQL Server, Interdev, VBA, Excel, DB2 UDB 5.

Project Name: Solution Central
Client: Confidential, CA 
Duration: Oct--99 to Jan-2000
The purpose of this Project was to develop Web site for a Company, Which Provides information and Technical training to Software professionals

Role: Designed and developed ASP pages, Stored Procedures. Used Java Script, VBScript And used Seagate Crystal Report-7.0 for generating Reports.
Environment: VB 6.0, ASP, COM, VBScript, JavaScript, HTML, ADO, SQLServer7.0, Interdev and Seagate Crystal Reports-7.0

Project Name: Partner resource center
Client: Confidential, CA 
Duration: July-99 to Sep-99 
This is a multi tire architecture using MTSto incorporate all the business rules.

Role: Creating ASP Pages, COM objects using Active X DLL, involved in the coding of trouble tickets, User Profile.
Environment: VB 6.0, ASP, COM, VBScript, HTML, ADO 2.0, SQLServer7.0, Interdev.

Project Name: Cyber Exam
Client: Confidential, AL 
Duration: Mar-98 to June-99
This project involves in creating a package called Cyber Exam this includes. This is an online computer test, which are given to the schools and business centers that want to recruit people by keeping test.

Role: Creating ASP Pages, COM Objects using Active X DLL.
Environment: VB 6.0, ASP, VBScript, HTML, ADO 2.0, SQL-SERVER 7.0, Interdev.

EDUCATION: 
B.S in ENGINEERING on Electronics & Communications.