SUMMARY:

• Over 21 years of experience in IT industry with more than 17 years of experience in database administration (DPF & ESE), which includes database design, implementation, migration and maintenance of different applications including Java Applications. 4 years of experience in Programming, analysis, design and development on Mainframe systems.
• Working on DBMS DB2 LUW, Oracle, MSSQL and DB2 on Mainframe.
• Installation of DB2 UDB/DPF and ESE for LUW server, Administration tools like Control center, Command line processor, Script center, Alert Center.
• Database and Instance Creation, Database partitioning, Archival logging implementation.
• Worked on design, engineering, and operational readiness of Data Warehouse (DW) platforms and Data Mart (DM) platforms.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR, offline transaction log shipping, split mirror images, data replication, and HACMP clusters.
• Implemented multiple standby HADR solution.
• Implemented Automatic Failover between Primary and Primary Standby servers using Confidential TSA technology.
• Worked on SAP implementation and upgrade projects for DB2 LUW as a DB2 migration and upgrade.
• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
• Synchronization of data model (Erwin tool) with the physical schema objects. - Normalization and subsequent definition of the relational model including defining and implementing the referential integrity, constraints, cardinality and creation of the data dictionary, attributes, entity relationships.
• Data maintenance utilities used REORG, RUNSTATS, LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, and DB2MOVE.
• Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools
• Setting up of user accounts and user groups with LUW authentication.
• Involved in setting up Qreplication between Operational Database and Reporting database and troubleshooting issues associated with Qrep control and source tables.
• Involved in setting up SQL Replication between sources and reporting databases. Involved in setting up QReplication between Operational Database and Reporting database and troubleshooting issues associated with Qrepl control and source tables..
• Performed QReplication and SQL Replication bypass procedures to avoid full refresh of data whenever needed with data consistency.
• Database Space Management and Schema creation, Data Transformation Services.
• Strong DB2 UDB SQL experience
• Worked on MDC tables, MQT tables and Table Compression techniques in Data Warehouse (DW) databases.
• Shell Scripts for running database scripts.
• Worked on Oracle and SQL server dbs
• Supported z/os db2.
• Performed 24/7 supports for Production Database.

TECHNICAL SKILLS:

HARDWARE AND OPERATING SYSTEMS:IBMRS/6000 AIX 4.3.2, S4500, Sun Solaris V 5.7, Confidential mainframe ES/9000, Confidential 3090, PC/AT, Pentium machines, AIX 7/6/5/4/3.x, Windows NT, MVS/ESA

DBA TOOLS: Control Center, Visual explain, Platinum Erwin/ERX, SQLGUY, QUEST, DPROPR, DJRA V2.1 and DB2 Performance Expert, OPM and TOAD.

SOFTWARE: CICS /ESA V4R1, TSO, ISPF, QMF, VSAM, DB2PM, MF-Revolve, Expeditor, DATA JOINER, SPUFI, DB2 utilities, DB2 UDB, DDL, DML, DCL, CA7 Job Scheduler, File Aid DB2, Panvellette, Endeavor, Intertest, Viasoft, DCLGENS, TSQ, TDQ, PVCS, BMC Patrol, Query Patroller, DBArtisan, SAP R/3 ( BWI,CCMS), PEOPLESOFT, People Tools, Web sphere Information Integrator.

LANGUAGES: SQL, COBOL, Cobol II, JCL, Java 2, Java script, XML, HTML

PROFESSIONAL EXPERIENCE:

Confidential, New York

DB2 LEAD CONSULTANT

Responsibilities:

• Successfully migrated 12 TB db (slot) from oracle to db2.
• Successfully migrated profile database for chase.com from oracle to db2.
• Involved project planning, implementation discussion with tech ops leads, architects and project managers.
• Used IDMT tool to unload data from oracle and used db2 load utility to load data into db2.
• Implemented HADR and Qreplication from different data centers.
• Worked on attach and detach for range partition tables.
• Extensively involved in proactive tuning and provided suggestions.
• Worked on Confidential OPTIM performance manger.
• Worked closely with the Toronto Lab to report PMRs, obtain fixes and install special builds.
• Extensively worked on PL/SQL packages compilation and fixed invalid procs and packages

Confidential, Jersey City

DB2 LUW DBA / DB2 DBA

Responsibilities:

• Informediary app takes in data in any electronic format, normalizes it, and then translates, transforms, and transmits the information over networks such as SWIFT or via proprietary connection.
• Worked db2 on LUW and Mainframe DBA

Confidential

DB2 UDB DBA

Responsibilities:

• Creation of database and database objects
• Creating groups, users & giving privileges.
• 24/7 Production Support
• Giving authorities (SYSADM, SYSCTRL, and SYSMAINT) by updating the DBM and granting DBADM (maintaining database level security).
• Setting up & updating the environment variables, command options.
• Running utilities like Copy, Load, Import, Export, REORG, RUNSTATS, Rebind, REORGCHK and Setting constraints (Check pending)
• Creating table spaces for DMS and SMS.
• Taking offline and online backups for Databases and table spaces.
• Restoring database backups into exiting database or creating new Databases with database backups.
• Created Dprop environment for Source and target databases
• Migration for DB2 V6,V7 to DB2 Version8
• Set up for Disaster Recovery databases
• Database monitoring and tuning through snapshot and event monitors.
• HACMP cluster set up for db2 databases
• Created Dprop environment for Source and target databases
• Migration for DB2 V6,V7 to DB2 Version8
• Fine-tuning the performance by using explain plan tables.
• Creation and maintenance of various database objects

Environment: RS/6000, P650, S80, AIX 5.x, 4.3.3, Red hat Linux 7.2, WindowsNT 4.0 & Windows 2000, DB2 Universal Database V7.2 (EE & EEE) & V8.2 ESE (DPF and non-DPF), DB2 connect, DB2 PE, Web sphere Information Integrator (WII), Dprop, Web sphere 5.0 & 4.0, MQ-series, ADSM, Java, People soft, SAP R/3 (BWI and CCMS).

Confidential, WALNUT CREEK, CA

DB2 UDB DBA

Responsibilities:

• Installation of DB2 UDB 7.2 (EEE) on AIX.
• Creation of db2 instance on AIX.
• Creation of nodegroups and Partitions.
• Developed the Autoloader scripts to transfer data from MVS tapes to UDB tables using Autoloader Utility.
• Changing the dbm and db configuration parameters for performance.
• Performance monitoring and tuning for databases using BMC Patrol.
• Created explain tables and ran the db2expln utility for SQL statements.
• Running the REORGCHK, REORG, REBIND and RUNSTATS UTILITIES.
• Configured database recovery in case of instance failure and other situations
• Configured the backup and recovery issues on LAGADO server.

Environment: RS/6000, S80, AIX 4.3.2, WindowsNT 4.0, DB2 Universal Database V 7.2EEE, TERADATA, MVS Tapes, Data Joiner2.1.1, Relational Connect, DB2 connect and BMC Utilities

Confidential, Nashville, TN

DB2 UDB DBA

Responsibilities:

• Data Flow analysis.
• Creation of DB2 UDB EEE instances on AIX.
• Data Joiner V2.1 installation and configuration.
• Business logic and Functional Analysis of the System.
• Logical Design and Physical Design of the database.
• Created Nodegroups and Partitions.
• Configuring Client-to-Server Communications Using the CCA
• Fine tuning the databases, if there are any problems relating to performance issues.
• Loading the monthly updates into the production.
• Loading data from production to various regions for testing for the QA team and developers.
• Loading the data from AS/400 to the respective regions using DATAJOINER whenever needed.
• Taking backup and recovery process.
• Creating the shell scripts for the automation of backups, RUNSTATS, REORGCHK, REORG, space monitoring etc.
• Creating Stored Procedures, Functions, Packages, and Database Triggers for Database and Application uses.
• Creating databases in various regions whenever needed.

Environment: Confidential RS/6000 SP, AIX 4.3.2, DB2 Universal Database Version 7.1EEE, DB2 connect, BMC Patroller, Erwin and WindowsNT 4.0.

Confidential, Minneapolis

DB2 UDB DBA

Responsibilities:

• Installation of DB2 UDB 6.1 EEE & EE instances on different AIX.
• Configured the backup and recovery issues on server as cronjobs overnights
• 24/7 Production support
• Created Nodegroups and Partitions
• Performance monitoring and tuning for DB2 databases
• Changing the database manager and the database configuration for performance
• Running the reorgchk, reorg, and runstats utilities.
• Putting trace monitor on databases for table spaces, tables etc and calculating the buffer pool hit ratios for various table spaces.
• Creating EXPLAIN tables and running the visual explain utility on sql statements.
• Undertook database recovery in instance failure and other situations
• Creating users for both the database as well as operating systems.
• Replication using DB2 DPropr.
• Cataloging different databases on servers.
• Worked on Enterprise Java Beans (EJB) and Servelets.
• Worked on Web sphere Application Server

Environment: Confidential RS/6000 SP, Aix 4.3.2, Sun Solaris, DB2 Universal Database Version 6.1 EEE & EE, DB2 Connect, Windows NT 4.0, DB2 Data Propagator, DBArtisan, Web sphere, Java, XML, and ERWIN

Confidential

DB2 UDB DBA

Responsibilities:

• Installation of DB2 EE on AIX
• Creation of DB2 instances on AIX.
• Created separate environment for PeopleSoft Applications
• Maintained and Customized PeopleSoft (HR) tables
• Developed the scripts for transferring data from Informix to DB2 using Data Joiner architecture
• Configured the backup and recovery issues on server as CRON jobs
• 24*7 Production support
• Performance monitoring and tuning for DB2 databases
• Changing the database manager and the database configuration for performance.
• Running the REORGCHK, REORG, RUNSTATS utilities.
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Undertook database recovery in instance failure and other situations
• Creating users for both the database as well as operating systems
• Catalog different databases on servers.

Environment: UDB DB2 V 6.1 EE, DB2 Connect, AIX 4.2, Sun Solaris, PeopleSoft (HR), Windows NT, and Erwin

Confidential

DB2 UDB DBA

Responsibilities:

• Installation of DB2 UDB EE Product on AIX, Windows NT including DB2 Connect.
• Creating and Updating of admin (DAS) instance, Db2 instance (DBM) and databases.
• Design and creation of database and database objects
• Creating groups, users & giving privileges.
• Giving authorities (SYSADM, SYSCTRL, and SYSMAINT) by updating the DBM and granting DBADM (maintaining database level security).
• Setting up & updating the environment variables, command options.
• Running scripts & Creating user defined data types.
• Running utilities like Copy, Load, Import, Export, REORG, RUNSTATS, Rebind, REORGCHK and Setting constraints (Check pending)
• Creating table spaces for DMS and SMS.
• Taking offline and online backups for Databases and table spaces.
• Restoring database backups into exiting database or creating new Databases with database backups.
• Fine-tuning the performance by using explain plan tables.
• Database monitoring and tuning through snapshot and event monitors.
• Writing stored procedures.
• Design, creation and maintenance of various database objects
• Writing shell scripts.
• Designing database objects using ERWIN tool

Environment: UDB DB2 V 6.1 EE, AIX 4.2, DB2 Connect, Windows NT, and Erwin