Oracle Database Consultant-Database Team Lead
MOMRA (MINISTRY OF MUNICIPAL AND RURAL AFFAIRS)
Total years of experience :21 years, 5 Months
~ Design and architect new DB projects.
~ Lead DB team of 6 DBA’s
~ Project to migrate all 17 amanat DB’s to MOMRA DC and have Data Guard on DR.
~ Project to migrate all MOMRA oracle DB’s into EXACM X7 (EXADATA Cloud Machine)
~ Design and implement all new bank ORACLE DB’s as it is newly open in both DC and DR.
~ Design and implement Using RAC and DataGuard oracle 12C and 11G.
~ Design and implement DB’s backup.
~ Implement Sybase Database (Adaptive Server Platform).
~ Contract’s negotiation and specification.
~ Lead the team to administrate and operate the environment.
~ Involved in contract setup and deals negotiation.
@Design, implement and administrate three ORACLE RAC 11g database under RedHat OS for AFIS (automatic fingerprint system) which hold the kingdom finger prints in NIC (national information center).
@Migrate the data from old AFIS DB2 database to the new 3M AFIS ORACLE RAC 11g Databases.
@Supporting AFIS with different OS platforms and applications (ie. Tomee, cc2json).
@Implement backup strategies using RMAN.
@Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
@Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
@Analyze AFIS Data stored in oracle DB to develop SQL reports.
@Functioning as the Senior Database Administrator, providing consultancy on implementation of Oracle DB as per requirements.
@Plan, coordinate and manage the execution of ERP project by building Oracle 10g databases for the same.
@Facilitate tuning to apply ORACLE backup strategic plans.
Applying Dataguard, RAC &ASM on ERP DB.
@Performance tuning of Oracle DB, Updating DB with latest CPU and PSU patches for proactive maintenance.
@Installing and upgrading the Oracle 10g R2 to Oracle 11g on Sun SPRAC Solaris and Windows.
@Functioned as the Netbackup Consultant/Team Lead, for Global Backup Engineering Team, part of Integration Engineering Tower.
@Channeled the administration of oracle 10g database which contain 4 layers like DEV, TEST, CERT and PROD and contained data sourced from j2EE in-house development and web sphere portal,
@Created and managed primary database storage structures like Tablespaces, Data Files etc.
@Implemented and managed the Schema Objects, Transportable Tablespaces, Roles, Privileges, Temporary Tables etc.
@Integrated Oracle Utilities for Data Transfer, Data Maintenance and Database Administration
@Held multifaceted responsibilities like backup using RMAN & export dump files, SQL*Plus scripting, Grid control, performance monitoring and tuning & PL/SQL programming.
@Structured DB utilities EXPDP/IMPDP, TOAD, SQL navigator, SQL*LOADER.
@Facilitate platform design for business continuity, scalability and high availability platform using RAC and data guard technology.
@Served also as an administrator for oracle 9i ERP database, oracle 10g billing system database and patient scheduling system 10g database.
@Administrating and managing Microsoft active directory and MOM. Also, administrating CITRIX solution.
@Using Managing Microsoft Systems Management Server (SMS) to deploy packages.
@Functioned as the System Integrator Engineer and worked on Picture Archiving and Communication System.
@Channeled picture archiving and communication system PACS on Sybase/Solaris platform.
@Involved in the installation, configuration & integration of the PACS system
King Fahd University of Petroleum & Minerals Dhahran, Saudi Arabia B.S. in Computer Engineering Feb 5, 2003.