SUMMARY

• An astute ORACLE APPLICATIONS DBA with 11 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, Oracle Access Manager 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 Performance 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 noledge 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 noledge 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, R12.1, 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, OEL

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 Core/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 Applications Database Administrator

Responsibilities:

• As part of EBS project for new R12 instances worked on implementing PCP and enabling SSL.
• Upgraded database from 11.1.0.7 to 11.2.0.4 and then to 12.1.0.2 for both EBS and Non EBS.
• Upgraded EBS instances from 12.1.1 to R12.1.3 then to R12.2.0 further upgraded them to R12.2.5
• Applied all the latest Techstack, product based and other bug fixing patches using Adpatch, Opatch.
• Created new Concurrent managers, Purged concurrent requests table.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, adctrl, adsplice, adlicmgr, adaimgr.
• 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 EBS instances with EM 13c.
• Upgraded existing OID/OVD instances from 11.1.1.7 to 11.1.1.9.
• Registered Oracle E-Business Suite Release 12 with Oracle Internet Directory 11gR1 and OAM 11gR2.
• 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 Core/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.
• Upgraded EBS from 11i to R12.1.2
• 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.
• 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.

Confidential

Oracle Database Administrator

Responsibilities:

• Team member in 5-member DBA team, which is supporting development/ testing/ demo instances.
• Installation of Oracle 9i, 8.1.7 Configuration and patches.
• Created the Development, Test and Production databases.
• Has written shell scripts for automation of various database-monitoring activities.
• Database security - this activity includes creating/revoking users. Creating roles, grant/revoke roles from users/roles.
• Extensively involved of the Performance Tuning of Production database which includes identification of Resource consuming / Problematic SQL. Also tuning at the database level to ensure Optimal Performance of Database. Also using TKPROF.
• Capacity planning for development, test, Production databases for next six months.
• 24 X 7 Support to the Production database, which includes off-hour support also.