SUMMARY:

• An astute ORACLE APPLICATIONS DBA with 10 years of IT experience in Oracle database, Oracle E - Business Suite.
• 2 plus years of experience on Oracle Internet Directory, Oracle Access Manager and integration with EBS for Single Sign-On.
• Expert-level skills in Implementation, Installations, Maintenance and troubleshooting of E Business Suite 11i and R12.2.6 and databases until 12c.
• Supervised a team of 4 along with hands-on experience in EBS Upgrade from R12 to R12.2.6.
• Proficient in Oracle E-Business environment administration and management of online patching using ad tools such as ADADMIN, ADAUTOCFG, ADOP, ADOPMON, ADCTRL.
• Extensive experience in implementing advanced topologies of the Ebusiness suite like Parallel Concurrent Processing (PCP) and F5 load balanced web tiers.
• Hands on experience on Oracle Cloud(OCI) for E-Business Suite.
• Worked extensively on AWS EC2 servers in creation and Maintenance and troubleshooting of databases.
• Lead an effort which saved around $40K in Operating Expenses for the client, by analyzing and reducing of storage consumption on AWS servers.
• Hands on experience working on EXADATA servers including quarterly patching.
• Worked on upgrading the RAC and NON-RAC databases and Grid Infrastructure from 11g to 12c and then to 18c.
• Expert level skills in DATAGUARD configuration, troubleshooting and performance tuning for NON RAC and 3 node RAC databases.
• Zero Downtime migration of databases from security vulnerable servers to highly secured Tier 0 storage servers.
• Experience in using diagnostic tools like EXPLAIN PLAN, SQLTRACE, TKPROF, AWR, ADDM, ASH, SQLHC, SQLT to resolve database performance issues.
• Experience in collecting/refresh stats, creating/rebuilding indexes, partitioning tables/indexes and creating SQL-profiles to improve SQL/PLSQL performance.
• Supported GoldenGate Uni-directional set up for critical Tier 0 application replication.
• As a part of A-Team played an active role in scaling out OID to make sure a record oracle benchmark of 7.7 Million logins per hour was reached.
• Working knowledge and understanding of Maria DB and Oracle Postgressql database.

TECHNICAL SKILLS:

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

E: Business Suite Rel 11i, Rel 12.1, Rel 12.2.6, EBS for Cloud

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

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

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

DB Performance Tuning Tools: HANG ANALYSIS, SQLHC, TFA, SQL TUNING, SQL PROFILING, SQLT, AWR, ADDM, ASH.

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Lead Oracle Apps DBA/Cloud DBA (Hands-on)

Responsibilities:

• Lead a team of four DBA’s in end to end upgrade of all the EBS environments from their existing 12.1.3 to 12.2.6 versions including database upgrades.
• Implemented patch cycle strategies which accounts to applying stable PSU patches on all the components of the EBS environment within stipulated period of 3 months.
• Migrated onsite EBS instances to OCI using EBS tools in a Lift and shift strategy.
• Applied all the latest Techstack, product based, database and Grid Infrastructure PSU’s and other bug fixing patches using ADOP, OPATCH, OPATCHAUTO.
• Enabled Parallel Concurrent Processing (PCP) to improve the performance of the Concurrent processing managed servers.
• Lead the Zero Downtime Storage Migration project to migrate the storage to XIO tier 0 storage from existing tier 1 storage.
• Upgraded databases from 11.2.0.3 to 12.1.0.2 and further to 18c for primary and standby running on RHEL, HP-UX and Windows.
• Resolved performance bottlenecks by providing performance tuning advice using tools like SQLT, SQL health check, Hang Analysis, 10046 tracing, Foreign Key Indexing etc….
• Implemented SQL profiles and migrated SQL BASELINES, Creating and rebuilding Index’s, re-organizing tables.
• Cloned the main centralized 20TB 4 node RAC database and EBS application from production to QA as part of quarterly refresh.
• Configured DataGuard broker in the DataGuard environment for easy role transitions between the primary and the standby databases.
• Migrated databases from Old Security vulnerable servers to new servers using dataguard methodologies.
• Applied Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environment.

Confidential, Menlo Park, CA

Senior EBS Database Administrator

Responsibilities:

• Upgraded EBS from 12.1.3 to 12.2.6 on various environments.
• Upgraded database from 11.2.0.4 to 12.1.0.2 for both EBS and Non EBS instances.
• Worked vastly on SSL configuration in EBS along with fixing SSO issue.
• Worked on maintaining the Databases on DELPHIX engines.
• Spearheaded the PSU patching for all databases, EBS and surrounding applications such as ADF, OSB, OBIEE etc.
• Migrated database instances from OEL6 to OEL7 servers.
• Worked extensively on cloning of Non-Prod instances from Production backup copies using RMAN.
• Supported and maintained ASM-RAC databases running on Exadata servers.
• Worked on Quarterly Patching of Exadata.
• Worked on building the dataguard sync between Primary and Standby is intact.
• Troubleshooting of EBS and database related performance issues by using tools such as SQLHC, HANG ANALYSIS, TFA.
• Experience in Flashback Technologies, RMAN Active Database Cloning, Virtual private Catalogs and Merging Recovery Catalogs
• Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects to point in time.
• Installation, Configuration and Maintenance of Oracle 11g/12c RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
• Scheduled Oracle Jobs using DBMS SCHEDULER and Backups using CRONTAB
• Configured Active Snapshot standby databases for production databases using Oracle Dataguard for disaster recovery.
• Tested switch over & fail over for standby database using Dataguard broker DGMGRL.
• Performed various tasks in RAC Cluster pinning nodes, and performed backup of OCR, OLR and voting files, Multiplex Voting files.
• Upgraded databases in Dataguard Environment from 11.2.0.4 to 12.1.0.1 for primary and standby.
• Created various recipes via configuration management tool, CHEF to automate maintenance of database files such as tnsnames.ora, oraInst.loc.
• 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.
• Patched the EXADATA servers with the quarterly patches.
• 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.
• 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.
• 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.
• Played an active role in scaling out OID to provide 7.7M logins per hour.
• Automated the OID and ODSSM password reset routine.
• 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.
• 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.
• 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.