Application Tuning (using cost-based optimizer to tune SQL, Wes Data Segments and Materialized Vlews). Depth knowledge of PL/SQL for creating Triggers, Procedures, Functions and Packages)
Database performance monitoring using Oracle supplied tools like AWR, ADD and OEM.
Backup and recovery using MAN and Data pump utilities.
Regularly monitoring the components of Real Application Cluster (voting disk, cluster ware, and storage space utilization)
Effective usage of ASM and various UNIX file systems for a database storage.
Managing files between ASM and UNIX file systems Managing and troubleshooting integrity of Distributed database using oracle tools and o/s techniques.
Install and Configure Application Server (WebLogic 10.3.6) Familiar in deploying Forms and Reports application Basic skills of deploying Java application in WebLogic