Have 6+ years of experience in Oracle database. Good in standalone, RAC and dataguard.
Installed and configured Oracle databases on multiple environments using manual and DBCA
method Administrating Oracle databases (10g, 11g ,12c and 19c) on Linux
platforms.
• Performing Re-org for better performance and optimization of space.
• Monitored & troubleshoot all database issues in Standalone and RAC
environments.
• Set up database users, manage database permissions and setup database
roles
• Implement and maintain Oracle Dataguard Physical and Logical standby
databases for disaster recovery. Ensure that standby database is always in
Sync with production database by checking archive logs and copying missing
ones over to the standby database when required.
• Good experience on RMAN configuration and performing RMAN Backup,
Restore and recovery. Performed database refreshes and database cloning
• Good experience on managing ASM storage environments.
• Knowledge and Experience on applying Patch.
• Knowledge on UNIX Scripting (Used to write shell scripts & implemented
Using cronjob for day to day activities.
• Good experience on Database and schema level refreshes as well as object
level export/import using both data pump as well as traditional export.
• Good experience on configuring alert monitoring for both Standalone and
RAC environments using crontab.
• Good experience on OEM installation and Configuration