Ronak Shah

Oracle Certified Professional Database Administrator and Oracle Real Application Cluster with 6+ years of extensive experience. Oracle Certified Professional Database Administrator for Oracle 9i, 10g and 11g.
 Extensively worked on Oracle database 11g, 10g, 9i, Weblogic, Webtier on RHEL, HP-UX and Sun Solaris platforms. Excellent experience in installing and managing Oracle Real Application Clusters (RAC) in 10g, 11g and 12c. Experience in configuration and maintaining Oracle Physical Standby Database. Configured Oracle 11g Active Data Guard and offloaded resource-intensive reporting jobs from production database to Oracle Physical Standby Database. Oracle DBA activities include but not limited to Installation, Configuration, Memory Management, Tablespace Management, Segment Management, User Management, Privilege Management, Role Management, Password Management, Resource Management, Export/Import, Auditing, Migration, Patch Installs, Automating Tasks with Database Scheduler, ASM Configuration, Backup and Recovery of mission critical Oracle databases using Oracle Recovery Manager (RMAN), and Performance Tuning of Oracle database. Experience in using Oracle Data Pump, SQL * Loader, Flashback, AWR, and ADDM. Tuned SQL statements using Explain Plan, TKPROF, SQL Trace, AWR, STATSPACK, Optimizer Hints, Stored Outlines, and SQL Plan Management (SPM).