Senior System Analyst
Saudi Global Ports Company
Total years of experience :19 years, 10 Months
Managing various Database's like Oracle, SQL Server & DB2(AS400), Core business Application TOS (COSMOS) administration of the company. Developing reports required by the company, Saudi Customs and Port Authorities using SQL Server Reporting Services (SSRS). Working & coordinate with contractors for managing of IBM PureFlex, Network switches and the backbone including Primary site and secondary site at remote location as well as helping in implementing HR System on Microsoft Dynamic.
Create and maintain Applications users access with required responsibilities as per the users requirements and according to their Jobs. Develops, modify and maintain Applications as per the Business Requirements. Support & assistance to users for solving their problems in the Application. Design DB as per the Business need. Use maximum security measure to provide high availability system with zero data loss and no downtime using RAC & Datagaurd.
With profound expertise installed Oracle create & designed DB and implemented utilities to automate several DBA functions of Oracle 11g, 10g, 9i and 8i using SQL*PLUS & PL/SQL.
Skillfully tuned the database Performance.
Installed, upgraded and migrated the Test and Production Servers on Oracle 8i, 9i & 10g along with taking Backups & Recovery (RMAN) both online & offline of Oracle 8i, 9i & 10g and cloning databases.
Developed scripts to perform Cold & Hot Backup and Used VERITAS for tape library.
Maintained communications network for approximately 300+ terminals and 500+ database user sessions.
Systematically driven the creation & modification of users to maintain security system as well as stored procedures, triggers, jobs & cursors. Apply DB / AS patches.
Configured each parameter of Oracle DG on Oracle 10g & 9ir2 using SQL*PLUS and Enterprise Manager.
Thoroughly tested Oracle 9i and 10g RAC and ASM and implemented the same on production environment.
Flawlessly upgraded Oracle 8i db to Oracle 9i & 9i to 10g on production & perfectly performed another migration of Access DB to Oracle 10g.
Timely raised SR (Service Request) or TAR’s on Metalink for severities 1-4 and managed users of it.
Adeptly developed reports as per the corporate/Agent/Port requirements with DS 10g, Report 6i & 10g.
Deeply assimilated the application module and tested the same rigorously. Create & follow up error/enhancement cases on Navis website for issues we have.
Upgraded Form 6i & Report 6i to DS 10g and Installed & Configure Oracle 10g AS & administer.
Preparing documents for the routine tasks performed by DBA’s, System Engineers & IT Operators.
Genuinely engaged in Navis - Express upgrades for ver 2.0 to 2.4, 2.4 to 2.9 & Sparcs upgrade for ver 2.8 to 3.1, 3.1 to 3.7 with configuration of Prime Route and Expert Decking. Passively engaged in Sparcs N4 implementation for Al - Jubail Branch.
Recently Installed Oracle 11g and Export Data from Oracle 10g on test environment.
Project Work