Professional SummarySenior Database Administrator primarily on DB2 UDB for the past 13 years. Experienced in various aspects of DB2 UDB including physical and logical design, performance monitoring, maintenance, query analysis, optimization, backup and recovery and migration. 
Looking to work in a technically challenging environment.

Core Strengths:

• Database Administration
• Analytical Problem-Solving
• Disaster Recovery
• Project Management
• Performance Monitoring
• Documentation

Key Qualifications:

• Senior Database Administrator with 10 years of DBA experience in UDB and 4 years in Informix. Working knowledge in Oracle DBA Administration.
• Worked in large databases (over half terabyte) demanding 24x7 production support.
• Have extensive experience in Unix shell scripts ,sed and awk scripts,
• Experienced in Stored Procedures , Triggers and tools like Load
• Experience in various aspects of DB administration such as performance and tuning, backup and recovery procedures, runstats and reorg.
• Experienced in data management policies and procedures .
• Experienced in logical and physical modeling and data architecture.
• Have worked in variety of applications such as Call Call center applications, CRM applications, Telemarketing services applications, Web applications, Loan Disbursement, Banking applications
• Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and can work as a part of a team as well as independently.
• Experienced in setting up and maintaining HADR .Worked with HACMP for failover server as well.
• Implemented data compression on larger tables resulting in space savings.

RDBMS: UDB Version 9.7 and 9.5 , Informix On-line 9.3, Oracle 9i Tools : Data Studio, Control Center, Load , Runstats, Backup, Restore , Reorg ,TSM, High Performance Loader, ACE report writer, TOAD , AQT 
OS : AIX 6.1 & 5.3, Linux 5.1, HP-UX 9.0, Solaris 8, Windows 7Hardware: IBM P7 Power System , SAN,Sun E5000, HP-9000, Sun Sparc

EXPERIENCE

Client : Confidential, NJ
Duration : Jan ‘99 - Present
Role : Senior Database Administrator Description : Part of database team providing 24x7 production support for around 60+ UDB databases running version 9.5 & 9.7 with SAN storage .Also  worked as Oracle and Informix Database administrator.Duties include

• Backup/restore, tuning and optimizing.
• Upgrading versions, installing fixpack, day to day monitoring .
• Working with Triggers, Stored procedures, Load utility
• Running periodic runstats and reorg to ensure optimal performance
• Unix shell scripting and awk scripting for task automation etc
• Maintain security administration includes handling instance / database level authorities.
• Troubleshoot locking, loading issues, connectivity, performance issues.
• Application snapshots, event monitors and db2pd tools for troubleshooting purposes.
• Experience with implementing up and maintaining HADR and HACMP for automatic failover.
• Compressed most of the large tables with over 50% space saving and improved query performance ..
• Setting up federated severs to connect to mainframe/other UDB DBs to avoid replicating tables .
• Responsible for overseeing the Informix to UDB database migration
• Participated in disaster recovery exercise to ensure smooth database recovery.
• Maintained Informix database doing day to day administration, performance tuning and optimization.
• Worked as database administrator for mbusa.com website running Oracle 9i on Sun Solaris 8
• Worked on stored procedures and shell scripts

Client : Confidential-NY
Duration : July ‘98 – Dec ‘98
Role : Analysis/Design/Programming 
Description : Involved in design, coding of the main financial management  system for three major city agencies. The system acts as a data warehouse for keeping track of the debits/credit of the three
agencies and generating various reconciliation reports.Duties include

• Complete redesigning ,rewriting and enhancing the existing system
• Writing and maintaining programs in 4GL and Esql –C languages

Client : Confidential–NY
Duration : Feb ‘98 –July ‘98
Role : Analysis/Administration/Programming
Description : Involved in enhancing/modifying the main budgets application for the Housing Authority .Responsible for porting applications from Informix -SE and turbo systems to the Online Dynamic ServerDuties include

• Porting applications from Informix -SE to Informix Online Dynamic Server
• Writing several stored procedures for implementing business rules
• Solely responsible for modification and enhancements for four different projects.
• Provided user menus using isql’s bulit-in menu-handler.

Client : Confidential, St. Louis, MO
Role :Analysis/Screen Designing/Programming 
Duration : Jan \'97 - Jan ‘98 Description : Maritz provides telemarketing solutions to various Fortune-1000  firms. I was responsible for developing various screens/programs  in Informix 4GL and ESQL-C for teleservices projects for clients like Iomega and Toyota.Duties include

• Designing and developing 4GL programs and screens .
• Developing triggers and stored procedures for main tables to audit the changes to them.
• Writing various shell scripts and awk programs for day to day task automation.

Professional QualificationUDB LUW & Informix Database Administrator
Informix - 4GL Certified Professional
BS Electronics & Communication Engineering