SUMMARY:

• An astute ORACLE APPLICATIONS DBA with 8 years of IT experience in Oracle database, Oracle E - business Suite and its boundary applications such as ADF, Agile, OSB, OBIEE, Hyperion, GTM etc..
• 3 years of experience on Oracle Internet Directory(OID), Oracle Access Manager(OAM) and integration with EBS.
• Expert-level skills in Implementation, Installations, Maintenance and troubleshooting of E Business Suite versions ranging from 11i to R12.2.6.
• Worked extensively on configuration management tools like CHEF.
• Experience in administrating and maintaining Oracle Application Server 9i, 10gR3.
• Extensive experience in implementing advanced topologies of the Ebusiness suite like Shared applications tier, Split tier architecture, Parallel Concurrent Processing (PCP) and F5 load balanced web tiers.
• Worked on EBS Upgrades from 11.5.3, 11.5.4 to 11.5.9, 11.5.10.2 and R12.1.3 to R12.2.6.
• Proficient in Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, ADOP, adctrl, adsplice, adlicmgr, adaimgr.
• Worked on Sysadmin tasks like creating and managing users and their responsibilities.
• Configured Physical Standby database via Data Guard for EBS 12.2 environment.
• Worked on various Disaster recovery exercises at various client locations.
• Worked on Cloning of EBS 12.2 integrated with OAM and OID.
• Skilled in Migration of database and EBS from Solaris to Linux.
• Experience in installing and supporting ASM and RAC for Oracle E-Business Suite.
• Worked widely on R12.2 RAC-RAC cloning.
• Expert-level skills in Installation, Configuration, Upgradation, Patching, Troubleshooting and P erformance tuning of oracle databases ranging from 10g to 12c, RAC and NON-RAC.
• Worked on Design and Implementation of Database security, Schema management, back-up, Restore, Scheduling and Maintenance task in ORACLE.
• Expert-level skills in Oracle backup and recovery strategy, designing and implementation using cold/hot backup, DATAPUMP and RMAN methodologies.
• In depth knowledge of Oracle internals, Oracle Database Tuning, SQLT, Database Migration, AWR, ADDM, ASH and UNIX native commands.
• Hand on with configuring PDB’s and CDB’s for 12c database.
• Well versed in working on Oracle engineered machines such as EXADATA.
• Worked on installation and Configuration of Golden Gate on RHEL servers.
• Good knowledge on Oracle SSO / OID configuration with E-business suite.
• As a part of A Team played an active role in scaling out OID to make sure oracle benchmark of 7.7 Million logins per hour was reached.
• Also worked on OID setup, upgrades, troubleshooting and administration, Oracle Enterprise Manager/Grid Control for environment Standardization.
• Skilled in SQLPLUS, PL/SQL and UNIX shell scripting.
• Worked on 24/7 on-call support, troubleshooting and fixing production issues.

TECHNICAL SKILLS:

Database: Oracle 8i/9i/10g/11g/12c Enterprise/Standard Edition. RAC 10g, 11g, 12c.

ERP: E-Business Suite Rel 11i, Rel 12.2.6.

Identity Management: Oracle Internet Directory (11.1.1.9), Oracle Access Manager (11gR2)

Platforms: Sun Solaris, AIX, Red hat Linux, HP-UX 11i, Win10

Languages: SQL, PL/SQL, UNIX shell scripting.

Configuration Management Tool: CHEF.

Tools: SQL*PLUS, TOAD, OEM, RMAN, SQL* LOADER, EM Grid Control, Imp/Exp and Data pump, STATSPACK, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Menlo Park, CA

Oracle Applications Database Administrator

Responsibilities:

• Worked on Upgrading EBS instances from 12.2.4 to 12.2.6.
• Upgraded database from 11.2.0.4 to 12.1.0.2 for both EBS and Non EBS instances.
• Migrated EBS apps and database instances from OEL6 to OEL7 servers.
• Upgraded OBIEE instances from 11.1.1.7 to 11.1.1.9.
• Actively participated in quarterly disaster recovery exercises for all the applications such as EBS, ADF, Appdynamics, OBIEE, GTM, Agile, Hyperion etc.
• Worked extensively on cloning of Non-Prod EBS instances from Production backup copies using RMAN and adcfgclone.
• Worked on maintaining the Databases on Delphix engines.
• Supported and maintained ASM-RAC databases running on Exadata servers.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, ADOP, adctrl, adsplice, adaimgr.
• Troubleshooting of EBS and database related performance issues.
• As a part of Quarterly Security Patching applied various patches for databases, EBS (AD and TXK), weblogic and other boundary applications such as ADF, OBIEE, PEGA, DEMANTRA, OSB etc.
• Helped Developers with deployment of ear files and other configuration setups in production application servers as per the requirements.
• Resolved various user issues in an OAM, EBS, OID integrated environment.
• Assisted testing team with their testing efforts using OATS scripts.
• Created various recipes via configuration management tool, CHEF to automate maintenance of weblogic domain files, application specific files along with other database files such as tnsnames.ora, oraInst.loc etc.
• Daily activities included ensuring the dataguard sync between Primary and Standby is intact.
• Provided 24x7 on call support in production environment on rotation basis.

Confidential, Columbia, MD

Oracle Access Manager Engineer.

Responsibilities:

• Developed cold and hot back backup strategy and making necessary scripts.
• Used import/export, Datapump and SQL- loader to load data into tables.
• Worked on Oracle backup and recovery strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• Monitored all the database and OID instances with EM 13c.
• Upgraded existing OID/OVD instances from 11.1.1.7 to 11.1.1.9.
• Designed, developed, implemented and integrated directory services to support large implementation of Identity and Access management.
• Worked on Data Center migration for OID, OVD and Databases.
• Provided troubleshooting expertise to fix issues with OID and OVD.
• Installed and configured the complete stack of OID, OVD and database.
• Upgraded OID and OVD instances from 11.1.1.7 to 11.1.1.9.
• Applied bundle patches to both OID and OVD to keep the environments to the current levels.
• Creating and Managing Tree Structure in OID instances by using processes such as OIDLDAPD, OIDSRV, OIDREPLD.
• Create adapters in OVD as per requirement.
• Played an active role in scaling out OID to provide 7.7M logins per hour.
• Worked on automating the OID and ODSSM password reset.
• Performed migration of approximately 2 million users and groups between two containers.
• Installed and configured Oracle Access manager 11gR2 along with OHS and web gate.
• Experience Integrating E-Business Suite with OID and OAM.

Confidential, Boston, MA

Oracle Applications Database Administrator

Responsibilities:

• As part of EPASS project for new R12 instances worked on enabling SSL on R12 environments.
• Registered R12 database with Single Sign On (SSO).
• Enabled XML gateway OTA configurations for R12 environment.
• Worked on Setting up E- Business Suite Help Menu Integration for R12.
• Worked on JRE upgrade of R12 Oracle E- Business Suite.
• Upgraded database from 10.2.0.4 to 11.2.0.1 for both EBS and Non EBS.
• Applied all the latest Techstack, product based and other bug fixing patches using Adpatch, Opatch.
• Created Application Users, Profiles, Responsibilities, Menus, and Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Tuned the slow running concurrent requests and defined concurrent managers.
• Worked on Kofax Markview packaged application for AP.
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, adctrl, adsplice, adlicmgr, adaimgr.
• Customizing autoconfig templates according to the environment requirements.
• Migration of existing Oracle 11.5.9 to 11.5.10 by implementing Oracle Financial modules GL, AP, AR & FA.
• Supported HRMS and applied all HRMS related patches.
• Migrated to Oracle Applications Tablespace Model using the OATM migration tool.
• Installed and administered the 2 node RAC database for Oracle EBS R12.
• Installation of 10g, 11g databases for Testing, Development and Production.
• Worked on cross platform migration of production databases from Solaris to Red Hat Linux.
• Worked on Oracle backup and recovery strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• Involved in day to day activities like user/table management, performance tuning, backup/recovery database replication for high availability etc.
• Performed cloning of database using RMAN cloning
• Closely worked with SQL loader, Export/Import, Data pump for data transfer.
• Created Users, roles, profiles, triggers, procedures, functions, and sequences as per business requirements.
• Created AWR report to tune the instance also used Oracle Enterprise manger to monitor.
• Configured and Installed the OBIEE databases by working closely with the OBIEE team to decide on the parameters for Spend Analytics and Global HR.
• Installed the Open Pages Software from the DBA perspective on all Dev, UA and Production databases for Government Risk Compliance.
• Worked as a Primary DBA on high priority applications such as Siteminder and other database for applications such as Financial Data Warehousing, OBIEE, ESSBASE, Business Performance Management, OFSA, Financial Certification System, Auditor Assist Management and Information Assurance Centre.
• Take care of day to day DBA activities.
• Helped the OEM team with OCM installations and set up OEM grid controls for the database instances.

Environment: Red Hat Linux 5, Solaris 10, Oracle 9i, 10g & 11g, Oracle Applications 11i (11.5.10.2), R12.