Sr. Oracle Database

Vendor : Oracle.

Total-TECH Co.

” The Job Descriptions”

  • Install, Upgrade, Create, and Administer Oracle database 11g, 12c, 18c, 19c and 21c.
  • Handel Oracle DB under Linux, UNIX and windows server.
  • Planning the database and Configure the database for an application.
  • Worked in Both DSS and OLTP database environment.
  • Installing, Upgrading and Managing Oracle RAC with ASM.
  • Managing Oracle standby databases (Data Guard).
  • Experience in upgrade and migration of oracle database to higher version in multi platforms.
  • Monitoring and optimizing the performance of the databases.
  • Generate the StatSpack, AWR, ADDM and ASH Report for gathering the performance data.
  • Identifying Problem SQL Statements using advisors.
  • Using SQL Performance Analyzer and Database Replay.
  • Implement, configure and troubleshoot database instances, backup, partitions, encryption, security and storage.
  • Working closely with developers and QA to support operations in UAT and production environments.
  • Periodic Patching of database.
  • Moving Data using (Export/Import, Data Pump, SQL*Loader).
  • Ensure daily backup for all production databases are finished successfully.
  • Plan and implement backup and recovery strategy using RMAN, Flashback.
  • Restoration of successfully taken backups to test the data & to estimate timelines for restorations when needed.
  • Audit and follow up on Daily, Weekly Cold, Hot Backups and archive logs.
  • Worked to many Backup Solutions.
  • Planning, scheduling and Monitoring daily Dayend operation and night jobs using OEM.
  • Manage Database Component from Enterprise Manager Cloud Control 13c.
  • Use Enterprise Manager Clone Oracle Home tool to clone an Oracle home to one or more destination hosts.
  • Upgrade Oracle Enterprise Manager Cloud Control.
  • Comply with SAMA requirements.
  • Manage database team and ensure service delivery based on ITIL standards.
  • Fulfill DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, undo segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
  • Working on Exadata cloud at customers machine consolidation and support.
  • Patching Exadata all component.
  • Migrate , Purge , Create DB homes on Exadata.
  • Troubleshooting and solve Exadata issues.
  • Exadata configuration, maintenance, and tuning.
  • Migrating and Upgrade Database on Exadata.
  • Replication using Materialized View and Oracle Streams.
  • Replication with Different Platform using Golden Gate.
  • Implement Golden Gate between Oracle/SQL Server to Oracle.
  • Manage Monitor Oracle Golden Gate using (EMCC 13c, Oracle GG Veridata and Oracle GG Monitor).
  • Configure Audit, VPD, OLS, Proxy Users, Profile and Authentication.
  • Encryption: Data Masking, DBMS_CRYPTO, TDE, RMAN Encryption, Data Pump Encryption.
  • Security Solution: Implement Database Vault, Audit Vault and Database Firewall.

Tagged as: , , , , , , , , ,

Upload your CV/resume or any other relevant file. Max. file size: 3 GB.

Job Overview
Job Location