Must have a minimum of 3-4 years of enterprise level Oracle database administration that includes troubleshooting Windows and Linux environments.Must have SQL knowledge – SSIS, SSRS, Database administration, SQL migration from legacy to cloud platforms.
Oracle 12c /11g database experience required including functionality of RMAN, Advanced Security, Diagnostics and Tuning. Managing Data Warehousing.
Knowledge in Oracle supported OS administration with physical and virtual environments.
Plans and performs database server installations and upgrades
Assist in developing standards and procedures based on best practices
Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
Assist in maintaining and improving database operational efficiency
Performs database reviews and provides input to database design.
Knowledge of High Availability and Disaster Recovery options.
Experience with backups, restores and recovery models.
Experience in Setting up/Configure Oracle databases on Unix
Advanced Knowledge on Oracle DBA skill on Day to day monitoring & maintenance Experience in Oracle CPU Patching and Upgrades to latest version
Expertise in Oracle Backup & Recovery using RMAN .
Experience in Migration and upgrade for database and instances between versions of Oracle.
Experience in Database Cloning or Refresh.
Experience in Disaster Recovery solutions such as Data Guard.
Experience in setting up ASM & Migrating to ASM.
Working knowledge on tools such as Toad, OEM, SQLPlus.
Experience in RAC is an added plus