SUMMARY:
Over 7 years of experience in Oracle Applications and Oracle Database Administration. Extensive knowledge on AD utilities like adpatch, adadmin, adclone, adctrl etc. Worked extensively on SYSADMIN task on front end of oracle Applications 11.5.9, 11.5.10, R12. Good experience in applying patches and cloning the database and oracle applications 11i and R12 versions of e-business suite. Worked with team to support 24*7 production environments. Implemented Oracle Apps 11.5.10.2 with Oracle RAC. Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite. Good experience on Tuning the database for better performance on Oracle Applications 11i (using STATPACK, TKPROF, SQL Trace, Explain Plan Upgrading of Oracle applications from older versions to newer versions. Good knowledge on Autoconfig tool in Apps to configure Oracle Applications 11i. Installation and maintenance of Oracle10g/11g RAC database. Oracle 10g Dataguard, configuration and maintenance. Experience with Data Modeling. Migration of Databases from Oracle 9i to Oracle 10g. Migration of Databases from Oracle 10g to Oracle 11g. Experience in Data warehousing and ETL Expertise in maintaining Database Security and auditing. Hot Backup, Cold Backup, RMAN backups and recovery Management of schemas, objects & partitioning the tables & indexes. Experienced in using 10g features like Data Pump, Flash-Back Recovery and ASM. Experience in Data Migration, Benchmarking etc Well versed at Unix operating System & Shell Scripts Experience in SQL, PL/SQL. Experience in Data Modeling, Logical and Physical database design. Good Analytical skills and problem solving skills with ability to capture minute details and an effective team player, ability to interact with developers, coordinate and manage the tasks assigned, backed by strong technical knowledge.
Technical Skills:
ERP Oracle Applications 11i/R12 (OID/SSO, BPEL, SOA)
RDBMS Oracle 10g RAC/11g RAC/ 9i RAC/ 8i / 8.x / 7.x
OPERATING SYSTEMS UNIX (Sun Solaris, HP-UX, AIX, Linux), Windows.
TOOLS SQL*Plus,, SQL*Loader, dbverify, oradebug, tkprof, statspack, Opatch, Oracle Diagnostics Pack , AD Utilities, Oracle Applications Manager (OAM), Oracle Enterprise manger (OEM), Recovery Manager (RMAN), Designer 2000, Discoverer, Tutor, Quest Software (TOAD, SQL Lab etc.)
Education: Bachelor of Engineering