Database administration of Production, development and test instances of Oracle versions 7.3, 8, 8i, 9i on VMS cluster and Windows 2000 cluster on failsafe mode. Installed Oracle 8i, 9i on VMS and Windows 2000 and upgraded the database from 7.3 to 8i and then from 8i to 9i Developed script/VMS DCL Script to monitor max extent, next extent, broken jobs, invalid objects, alert logs, export logs, load logs of all databases, run batch jobs Developed PL/SQL stored procedure and set up batch jobs to load data into database from the files that come from mainframe.
Also written batch script to save last 10 days data files for diagnostics purposes. Generated output from Oracle database and ftp to mainframe. Developed PL/SQL procedure for generating report on daily, weekly, monthly, quarterly and yearly basis.
Developed Pro*C programs for ETL Modified Pro*C programs to include new fields and populate these fields based on logic. Refreshed development database from production Restructured database to improve the availability and performance of the system Developed Knowledge Base for existing system Reverse engineered the database in All Fusion ERWIN 4.1
Administered COGNOS IMPROMPTU Version 6.0.3 and Created catalogs in COGNOS for users to retrieve data from database Developed COGNOS reports for users. Used Oracle Enterprise Manager and Embarcadero DBArtisan 7.1.0 for database administration
Environment comprised High Availability Alpha 1200 Cluster Fiber channel, Disk array HGS80, VMS 7.3 64bit, TCPIP 5.1, ECO 5, Compaq DL380, Compaq Evo, Compaq DL-380 (clustered), Microsoft Cluster Server Windows 2000, Oracle 7.33, 8, 8i, 9i, RMAN, ERWin, COGNOS, Veritas Net Backup, Virtual Network Computing VNC 3.3.3 R2, Reflexion 8.0.2, Veritas NetBackup