We provide IT Staff Augmentation Services!

Sr Web Developer Resume

NC

SUMMARY

  • Over 13 + years of experience in software development.
  • 10 Years of experience as DBA Experience in DB2 UDB (LUW) 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.

SQLServer 2000/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:

Confidential, NC

DBA (DB2, SQL Server, Oracle)

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.
  • 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 (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 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.

Confidential, NC

DB2 UDB DBA/ Team Lead/ Sr DB2 Developer/ Sr Web Developer/ Sr Database designer/ Sr Data Analyst.

Responsibilities:

  • 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.

Confidential, NY

Role: Created ASP pages, COM objects in VB to 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.

Hire Now