Provided architectural expertise database on different layouts for 3 TB of data access and 180 million records. Involved in developing Conceptual/Physical data models.
Improved the query access time for 180 million records accessed from different tables
Monitored and Tuned the Database using snapshot, event monitoring scripts.
Supported backup and recovery scripts for 24/7 databases.
|
| Environment |
| Aix v(5.1), ERWIN4.1, DB2 UDB EEE (7.2) Control Center,Db2 Tuner, Ftp and Scripts using Korn Shell, ERWin3.5.2, DBArtisan, Quest Central for DB2 v1.1, C, C++,EMC Meta’s. |