Involved in logical and physical database design of Operational Claims Management System and Auto Adjudication System.
involved in data migration from Sybase 11.9.2 to db2 UDB.

Performed routine maintenance, database performance tuning and monitoring Scripts were written to move Millions of records from Mainframe to DB2 UDB on aix using ftp, datajoiner, db2connect, Fileport Etc.

Involved extensively in migrating data from DB2 on OS/390 using db2propagator, which gets the data in ASCII test format to DB2 on AIX and NT Systems.

Porting data from AS/400 to UDB database

Worked with reverse engineering two databases known as PROCLAIM and MHS.

• Created Visual Explain Access plans and tuning applications.
• Designed and trained employees on transitioning from mainframe to Unix environment.
• Mentored junior DBAs transitioning from Mainframe to DB2 UDB
• Backup/Recovery scripts were written to backup the data to Tivoli ADSM manager.
Environment: Aix v(4.3), DB2 UDB EEE (7.2) Control Center, Tera_Term, Fileport, Ftp and Scripts using Korn Shell, ERWin3.5.2, Datajoiner 2.1.1, DBArtisan, Quest Central for DB2 v1.1, C, C++, datapropagator, OS/390, Visual Age Java front end, websphere, LAN , WAN , TCP/IP connection, Tivoli Backup.