SUMMARY:

• IBM Certified Solutions Expert.
• Over 20 years of experience in IT industry with more than 16 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.
• IBM Certified Specialist.

DATABASE ADMINISTRATION ACTIVITIES PERFORMED:

• 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 IBM 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.
• Performed 24/7 supports for Production Database.

HARDWARE AND OPERATING SYSTEMS:

IBM RS/6000 AIX 4.3.2, S4500, Sun Solaris V 5.7, IBM mainframe ES/9000, IBM 3090, PC/AT 486-586,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.

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

DB2 LEAD CONSULTANT

Configurations. This project McKinsey is using DB2 LUW 10.1 is backend db. This system should available for 24 7 365 days, for this we implemented HADR multiple standby solution with TSA automatic failover between Primary and Primary Standby database servers .

Confidential

Project Description: Working on IBM commercial accounts NASCO, Kaiser, Blueharmoney. Implemented MDC's, MQT's and table compression to some Data Warehouse DW projects. All these projects IBM is using globally and 24 7 support. Supporting multiple projects for db2 V9, V9.5 and db2 V9.7 on AIX 5.3, 6.x, Z-Linux and Windows.

Confidential

Project Description:

• JP Morgan chase planned their CIG databases migration from Oracle 10G to DB2 V9.7 FP3a with special builds.
• 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 IBM 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

DB2 LUW DBA / DB2 DBA

Project Description:

• Brown Brothers Harriman BBH is a privately-held financial institution that has been a thought leader and solutions provider for almost 200 years. BBH serve the most discerning and sophisticated individuals and institutions with expertise in Corporate Banking, Mergers Acquisitions Advisory, Investment Management, Wealth Management and Investor Services.
• In BBH mainly supporting Infomediary application db's, portal db's are LUW and ETF db, Keystone db are mainframe DB2. Involved in db2 connect and DB2 ESE software installations.
• 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

DBA Tasks and Responsibilities:

• Creation of db2 instance on AIX.
• Installation of DB2 UDB 7.2 EEE 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: IBM 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

DBA Tasks and Responsibilities:

• Data Flow analysis.
• Data Joiner V2.1 installation and configuration.
• Creation of DB2 UDB EEE instances on AIX.
• 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: IBM RS/6000 SP, AIX 4.3.2, DB2 Universal Database Version 7.1EEE, DB2 connect, BMC Patroller, Erwin and WindowsNT 4.0.

Confidential

DB2 UDB DBA

DBA Tasks and 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: IBM 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

DBA Tasks and Responsibilities:

• Creation of DB2 instances on AIX.
• Installation of DB2 EE 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

DBA Tasks and 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