TOS & Oracle DB Administrator
GULF STEVEDORING CONTRACTING CO. LTD. (A Member of the Gulftainer Group of Companies)
October 2004 – November 2011
Installed & maintained Oracle Apps 11i&R12.Upgraded Oracle Apps from 11i to R12. Perform L1-L4 type support service to the end users&clients.With profound expertise installed Oracle&create primary DB,designed&implemented utilities to automate several DBA functions of Oracle 8i-10g using SQLPLUS&PLSQL on Linux&Windows flavors as well as familiar with SS.To cater to the application&developer requirements&storage plans for future,created&modified TS,tables,views&indexes.Skillfully tuned the database Performance through closely monitoring TS,user sessions etc.Proficiently installed,upgraded&migrated the Test&Production Servers of Oracle 8i-10g along with taking Backups&Recovery (RMAN) both online&offline of Oracle 8i-10g&cloning databases.Generated fruitful scripts to perform Cold&Hot Backup 8i-10g&Used VERITAS for tape library.Methodically maintained communications network for 300+ terminals&500+ database user sessions.Systematically driven the creation&modification of users to maintain Security system as well as SP,triggers,jobs&cursors.Apply CPU/DB/AS Patches as available.Configured each parameter of Oracle DG on Oracle 10g&9ir2 using SQLPLUS&EM.Thoroughly tested 9i&10g RAC&ASM&implemented the same on production environment.Flawlessly upgraded 8i to 9i,9i to 10g&perfectly performed another migration of Access DB to 10g on a Production Server.Precisely maintained records for Oracle License&renew every year.Raised SR/TAR’s for severities 1-4&managed users on Metalink.Adeptly developed Reports&Forms as per the corporate requirements with DS10g,Report&Form 6i&VB.Deeply assimilated the application module&tested the same rigorously.Fix program bugs,apply data fixes&provide user-requested changes&enhancements.Conversant with installation,configuration&maintenance of Microsoft SQL Server.Upgraded DB from 9i to 10g&Form&Report 6i to DS10g.Installed&Configure 10g AS&administer the same.Preparing documents for the routine tasks performed by IT Team as approved by ISO standards.