Professional Summary

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

Work  Status : US Citizen

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 7
Hardware: IBM  P7 Power System , SAN,Sun  E5000, HP-9000, Sun Sparc

EXPERIENCE

Client   : Confidential,   USA LLC, 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, Administration -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 Server

Duties  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  Qualification

UDB LUW & Informix Database  Administrator

  Informix - 4GL Certified Professional

  BS Electronics & Communication  Engineering