SUMMARY OF QUALIFICATIONS:

• 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 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, 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, Confidential, Confidential, 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

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 F inancial 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.
• Have 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.