OBJECTIVE:

• Looking for a career growth opportunity where I can apply my leadership skills and technical expertise.

TECHNICAL SKILLS:

Operating Systems: Windows 95 / NT / 2000 / XP, IBM AIX, Linux, Sun Solaris, Unix.

Database Monitoring Tools: Quest Spotlight, Foglight.

Programming Languages: Java, Turbo C, MS Visual C++ 6.0, C#, Perl, Microsoft Visual Basic, COBOL.

Distributed Architecture: CORBA ( Jacorb 1.4.1), J2EE 1.4.

Web Servers: Tomcat, IIS (Internet Information Services), IBM Http Server.

Software Testing Tools: IBM Rational Robot, IBM Rational Test Manager, IBM Rational XDE Tester (Robot J), Test Director, Segue SilkTest, WinRunner, LoadRunner, Junit 3.8.1, Jprobe

Version Control Tools: IBM CMVC (Configuration Management Version Control), Rational Clear Case, Rational Clear Qwest, Remedy.

Test Tracking Databases: IBM TTT ( Test Tracking Tool ) database, IRUP ( IBM Rational Unified Process )

PROFESSIONAL EXPERIENCE:

Confidential, Downers Grove, IL

Senior DB2 DBA

Responsibilities:

• Currently working as senior DB2 UDB DBA with primary responsibility of maintaining total 30 DB2 databases which include partitioned and non - partitioned databases.
• I have gathered strong working experience of installing / uninstalling / configuring DB2 v9.7, v9.5, v8 and fixpacks on AIX operating system.
• Also as a Senior DBA, I work to design the database layout ( defining tablespaces, bufferpools, indexes with their naming conventions ). Also, I work to design the mount point layouts and space requirements on AIX system to accommodate those databases.
• I have designed and implemented a complete solution for database backups. This solution performs full / incremental and delta backups for each database depending upon the day of the week. For delta and incremental backups it also identifies if any tablespaces have been created and if so, it automatically backs them up. This script takes all the parameters and so is being used for all the databases including single and multi partitioned.
• Have been working on improving query performance by working with Application Developers. I have identified many culprit queries by capturing them from snapshots. Then I've explained them and also have suggested proper indexes to improve performance.
• Have independently worked on the restore database scenarios for single and multi partition databases. These cases include simple restores, restores with roll forwarding options and also scenarios where the load utilities might have happened during database backups. Also, the scenarios included single to multiple tablespace restores.
• Have successfully implemented a cluster failover solution for DB2 databases by creating database instances on both failover nodes locally and configuring all data mount points on VERITAS.
• Have successfully designed, documented and performed a Disaster Recovery exercise by crashing the database and then restoring the data as well as logs to bring the database status working as close to the disaster as possible.
• Have independently worked on automating test cases for DB2 quarterly audit with Guardium tool. According to the company policy, we run audit report every quarter to identify vulnerabilities. I have automated all the SQL scripts and also worked on fixing all the vulnerabilities. This has helped DB2 audit pass with more than 90% success ratio.
• I actively work with database development / architect teams to in corporate new tables / infrastructure in current database.
• As a DBA, I've creaetd database maintenance scripts ( runstats / reorgs ) and also the health monitor scripts which have been put as kron jobs to make sure that the database is available and running. If not, it sends email to the DBA.
• Working on on-call rotation with on-call pager and cellphone.
• Great experience in database performance tuning and using tools like Quest foglight, spotlight for database performance monitoring.
• Currently I am working to setup HADR for DB2 databases to increase availability. I am the primary DBA assigned to research and set these databases and test it to pass the Disaster Recovery test.

Confidential, Milwaukee, WI

Senior Systems Engineer

Responsibilities:

• Worked on installation, configuration and maintenance of DB2 8.1 FP 14 for the ECM solution for invoices.
• Developed and implemented disaster recovery plan for DB2 UDB by enabling online database backups and restore procedures using Tivoli Storage Manager.
• Created and maintained object model in DB2 for DB2 Content Manager including very complex workflow for different business projects.
• As a DBA, I was responsible for running the database maintenance, performance tuning and help troubleshoot long running / failed queries in DB2.

Confidential, Chicago, IL

Senior Software Engineer

Responsibilities:

• Assisted the team to build a 3-tier architecture with IBM Content Manager and DB2 on zOS platform to satisfy ECM requirements.
• Developed a validation document for each individual component in this architecture like WebSphere, DB2, IBM Content Manager and IICE client.
• Helped the team to installing various ECM components on Windows, AIX and zOS platforms.
• Helped DB2 team to install the DB2 ESE, DB2 Connect products, create databases and perform the DB2 administrative tasks.

Confidential, Milwaukee, WI

Management and Database Technical Consultant

Responsibilities:

• Have provided technical consultation for setting up IBM Content Management infrastructure to a newly built Content Management Infrastructure team at Northwestern Mutual which is responsible to setup therepository as IBM Content Manager and migrate from Documentum.
• Installed and configured IBM DB2 UDB 8.2 and IBM WebSphere 6.0 with High Availability option in a clustered environment on development, testing, staging and production environments.
• Performed the DB2 Administration tasks like setting up the authorities and privileges for the various users and groups, configuring the client/server connectivity, scheduling jobs, creating and maintaining SMS and DMS tablespaces.
• Also, as a DB2 DBA, I was involved in monitoring the DB2 performance using EXPLAIN, VISUAL EXPLAIN, Query Monitor utilities. On the top of that, I performed the database backup / restore, execute REORGCHK, REBIND, and RUNSTATS utilities. I have a very good experience working with all the DB2 GUI tools.
• As a Content Management Technical Expert, I was Installing and configuring IBM Content Manager 8.3 suite onto these environments and troubleshooting all the technical issues and monitoring service requests.
• Migrating thousands of financial records from Documentum to IBM Content Manager.
• Led an effort for using IBM DB2 Document Manager as an internal document management client and developing a prototype and design document for the same.
• As a SQL Server 2000 DBA, I have optimized SQL for SQL Server for better performance.
• Designed and created tables, views and stored procedures in SQL Server 2000.

Confidential, San Jose, CA

Software Engineer

Responsibilities:

• Have worked as an FVT (Functional Verification Test) lead for release 8.3.1 of IBM DB2 Document Manager product and managed a team of 5 people.
• Have developed an automation driver for DB2 Document Manager using Java, JDBC, Swing and GUI which can work with automated scripts.
• Have opened and debugged more than 100 defects while working on manual FVT in one month for DB2 Document Manager and fixing them using C, MFC and COM technologies. This helped the company fix them before a product was shipped to customers and save lots of dollars.
• Have single handedly developed 7 test plans and 200 test cases in one month for 7 new line items to be delivered as the fix pack 1 of DB2 Document Manager product.
• Have Implemented functional test for developed 200 test cases manually on various operating systems like Windows, AIX, Sun Solaris and zOS and also developed automated scripts for almost 150 test cases using Rational Robot, Rational Test Manager, Test Director and Microsoft Visual Studio .Net 2003.

Confidential, San Jose, CA

Software Engineer, DB2 Content Manager

Responsibilities:

• Developed 25 test plans and almost 3500 test cases for line items for eClient release 8.2.1 and 8.2.2.
• Exposed almost 400 defects for eClient and other underlying components during functional test on various operating systems like Windows, Sun Solaris, AIX.
• Wrote thousands of lines of Java/JDBC code to develop standalone test driver with enhanced logging capability and integrated automated 2700 test cases to this driver.
• Fixed almost 35 FVT and TVT defects for eClient using J2EE, Java API, JSP, Servlets, JDBC, Java Beans API and swing concepts in less than 2 months to enable timely signoff.
• As a loan to the regression testing team, I developed and maintained test script execution tool for IBM DB2 Content Manager Products using Java/JDBC.
• As a loan to the portlet development team, I fixed almost 20 defects in one month using J2EE, Java API, JSP and Servlets API to enable timely DCUT signoff.
• Developed a document lifecycle structure for various types of documents to be routed through various stages of approval process on distributed and federated databases on eClient using WebSphere MQ Series and MQ Workflow software.

Confidential, Maywood, IL

Website Developer/ Technical Helpdesk

Responsibilities:

• Maintained Computer Networks in for three different servers (Finance, Human Resources and Admin).
• Technical Helpdesk for Software, Hardware as well as Computer Networks.
• Developed graphics using Adobe Photoshop and Adobe Photo Illustrator on Windows 2000 as well as Macintosh Environment.