Oracle Database Administrator
Port of Fujairah
مجموع سنوات الخبرة :13 years, 6 أشهر
Performed Oracle RAC installation/ database setup, configuration, patching, upgradation, migration & administration of Oracle 11g, 12c and 19c databases in UNIX Platform.
Design and implement a backup & recovery system using RMAN and Data Pump.
Configured Data Guard/Standby database to maintain disaster recovery environment for business continuity.
Implemented Oracle GoldenGate - data replication/integration tool including heterogeneous replication setup in the distributed database infrastructure platform.
Managing database user account/privileges - access management.
Performed Installation, pathching, administering and upgrading Oracle EBS 11i/R12.1/R12.2 in single node, multi node environments and managing them using various AD utilities in Oracle EBS.
Collaborate with application developers to optimize queries, database schema design, implement secuirty using grants and synonyms.
Implemeted application integration between SQL server database and Oracle database.
Worked for 2 projetcs. VCPS from General motors and Ally Bank.
Plan and schedule regular database housekeeping and maintenance activities necessary to keep the database in a healthy state and at optimum performance.
Involved Monitoring and managing databases using 12C Grid control.
DB cloning from Production to other environments.
Performed general technical trouble shooting and give consultation to development teams.
DB builds in Oracle database and SQL server database using TFS (MS visual studio 2010/2012).
Performed periodic database maintenance, including patching, regular database backup and recovery procedures, and disaster recovery tests.
Involved Administering Oracle 10g, 11g databases on Windows 2008 Server.
Code migration, database change management and data management through the various stages of the development life cycle.
SQL and Instance level tuning. Statspack and Tkprof are used for diagnosing SQL query performances.
Creation of database objects such as tables, sequences, triggers, views, synonyms, dblinks, jobs and assign privileges as per requirements.
Table and schema level refresh from production to test and development environment on need basis.
Monitoring tablespace growth, file system space.