Sr. Oracle Database

” 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: addm, AWR, linux, OEM, OLS, oracle db, proxy., SQL, unix, VPD