Description
Professional Summary * Oracle DBA with 10+ years of experience in software industry and oracle applications and database administration in production, development and test environments. Valuable experience in Oracle E-Business Installation, patching, upgrading, Configuration and Database Upgrade and maintenance. * Experienced in 10g, 11g, 12c RAC Database administration & Oracle Applications 11i - R12.2 DBA. * Adept Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers. * Expertise in administering Oracle R12 Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc. * Applications sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions. * Applied patches (one-off patches, patchsets, CPUs/SPUs, PSUs, maintenance patches and RPUs) to update and implement security fixes to Oracle E-Business Suite11i, R12.1X. Applying them on routine basis as suggested by Oracle support. * Proficient in the installation, Configuration and maintenance of Oracle 10g/11g/12c, E-Business 11i, R12 * Worked on Customizations, Custom Application, Code Migrations. * Conducted multiple upgrades of Oracle Apps R12, which includes database upgrade from 10g to 11g as well as application tier upgrade from R12 to R12.2. * Worked Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM). * Worked on Security options like TDE column encryption and TDE Tablespace Encryption and Audit Vault integrations. * Adept at installing, configuring and maintaining Oracle Grid Control and RAC. * Worked on Golden Gate, Data Guard, and Audit Vault configuration. * Extensive experience in working with the utilities like OEM, TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied DBMS_PACKAGE. * Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan. * Adept on the following Oracle Fusion Middleware components like OID, OAM, Oracle Discoverer, Oracle Portal, Oracle WebCenter, Oracle WebTier, Oracle OBIEE, Oracle SOA, Oracle WebTier, Oracle HTTP Server, OIM * Integrated all external components with EBS 11i, 12.1 and 12.2 and documented the process in ADOP (Online Patching environments) * Upgraded EBS 11i to 12.1.3 and 12.2on Linux 32 and 64bit environments. Handled all kinds of Database and EBS upgrades * Administered EBS 11i, 12.1 and 12.2 environments with OAM, OID, SSO integrations. * Played a vital role in migration of Portal 10g to FMW Portal for EBS R12.1 and R12.2. * Expertise in System Administration to manage concurrent managers, application user setup, defining responsibilities and printer setup, configuration & Maintenance for Oracle EBS * Played significant role in streamlining upgrade guide Release 11i to 12.2 and Release 12.0 and 12.1 to 12.2. * Knowledge of Migration, lift and shift, Data recovery of Oracle Database on Oracle Cloud and Oracle VM. * Knowledge on Database creation/patching/administration on Oracle cloud. * Able to work flexible when and while needed. * Able to work/learn on modern technologies with great passion with minimal guidance. Firmly believe in " If you put your heart into something, you are very enthusiastic and invest a lot of energy and challenging work in it."