SUMMARY: Over 7 years of Experience in Oracle Database Administration, Oracle Applications, tuning, development, analysis, design, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.• Hands on experience in installing and maintaining 11i,R12 Oracle EBS.• Configure, architect, patch, upgrade, monitor and support all Oracle database instances, keeps the Oracle databases and applications at current release and maintenance levels. Modules supporting Financials (AP, AR, Fixed Assets & GL), HR (Payroll, Time & Labor, Benefits). Supply Chain (Inventory, Warehouse distribution), Manufacturing (WIP, BOM).• Experience in Upgrading “10.2.0.5” database to “11.2.0.2” database • Experience in cloning and patching E-Business environments utilizing tools such as rapid clone, adadmin, adctrl and adpatch.• Experienced in Installation and Configuration of Oracle ASM for RAC and NON-RAC Environments.• Established Backup policy using RMAN and Network backups. Also managed Backup, Restore using Data Pump, Traditional Export and Import and Recoveries using RMAN and conventional UNIX shell scripts.• Oracle Database Administration in a variety of environments including Linux, HP-UX, • Used Automatic workload repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Statspack Reports for trouble shooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.• Setup procedure for Database statistics gathering – Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.• Collections of performance data for specific time range using STATSPACK.• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
Listed skills include Oracle Applications, Oracle E Business Suite, Sql, Pl/Sql, and 4 others.