SUMMARY

• 15+ years of professional experience in information technology industry as an Oracle APPS DBA with good hands on in administering of Oracle Databases,Oracle Tools, Oracle ERP Applications, Fusion Middleware and Oracle Applications
• Extensive experience on Oracle E - Business Suite R12.2.5,R12.1,R12.0,11i and Oracle Databases 12cR2,12cR1,11gR2,11gR1,10gR2,10gR1,9i, OEM 12c,11g,10g
• Extensive experience with Oracle Fusion middleware products like OID, OAM, OIM, Webcenter content, OBIEE and tools like Quest STAT, Automic/UC4 .
• Worked on oracle products hosted on-premise Exadata/Exalogic systems.
• Well Exposed to Oracle Consulting Practices and Procedures in Administration that includes installation, configuration, upgradation, remote administration and support of Oracle Databases on almost all major Operating Systems.
• Fully conversant with Application DBA activities like Oracle ERP Installation, configuration, cloning, patch application on all major platforms.
• Strong knowledge of Oracle DBA activities comprising of Creation of Primary Database Storage Structures, Reorganization of Databases, Planning for backup and recovery.
• Lead DBA experience with offshore responsibilities.

TECHNICAL SKILLS

Operating Systems: HP-UX, Linux (RHEL,SUSE,OEL),Windows,Sun Solaris sparc, AIX

Software: Sql*Plus, Sql*Loader, PL/SQL, UNIX Shell Scripting.

Languages: Sql, Pl/Sql and Shell Programming.

RDBMS: ORACLE 9i, 10g R1/R2, 11gR1/R2, 12cR1/R2

Oracle: 11.5.4/11.5.8/11.5.9/11.5.10/11.5.10.2/ R12.0/R12.1/R12.2,9iAS, 10gAS,Weblogic 11g/12c

Backup: RMAN, Veritas, Tivoli, Commvault galaxy, XBP, EMC

Tools: /Others: Citrix, OEM, TOAD, Oracle Discoverer, web ADI and Oracle express server, veritas tools

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps DBA

Responsibilities:

• Upgrade EBS 12.1.3 to 12.2.5 and parallel migration from RHEL to Exadata/Exalogic OEL6.
• Setting Up DataGuard for EBS and FMW products and participating in yearly DR Drill.
• Install / config and support R12.1.3 multi-node environments running on 11gR2/12cR1 RAC/ASM.
• Production support of EBS R12.2.5 and R12.1.3 including monitoring during month end close.
• Fusion middleware ( OID 11gR1, OAM 10g/11gR2,GRC, Webcenter content/SOA/IPM 11g) install and integration with EBS R12.
• Upgrade FMW products Database to 12cR2.
• Install and upgrade Grid control to 12c
• Implement EBS scheduling tool like UC4/Automic and upgrade to latest versions.
• Change management using STAT tool and make necessary changes to STAT as required for R12.2.5 architecture dual filesystem.
• Administration of Fusion Middleware products like Weblogic 11g,GRC, OID 11g, OAM 10g/11gR2, IPM 11g,OBIEE 11g.
• Install 11gR2 RAC for EBS R12 and convert to Highly available architecture including setting up of Active Data guard.
• Upgrade R12.1.3 database to 12cR1 .
• Upgrade 11gR2 ASM to 12cR1 and migrating ASM storage to new Hardware/platform.
• Troubleshooting issues with Active Dataguard and monitoring using dgmgrl and Grid control 12c.
• Supporting R12 Implementation project team for conversions, OAF issues, BI publisher reports.
• Upgrade GRC including AACG, CCG, PCG .
• .Resolving issue with OID DIP sync with Microsoft AD, bootstrapping users from AD to OID, EBS users sync up with OID. setting up and Troubleshooting issues with Kofax and IPM which is integrated with EBS R12.
• Integrating OID 11g with OAM and EBS via EBS accessgate and troubleshooting issues.
• Upgrade OID to latest patchsets and testing integration with EBS and FMW products like Webcenter content Imaging, OBIEE.
• Upgrade Webcenter content imaging to latest Patchsets and install AXF solution required for EBS integration between EBS and Imaging.
• Upgrade Oracle access manager from 10g to 11gR2 and migrate artifacts from 10g to 11gR2 including webgates 11g.
• Integrating R12.1.3 and R12.2.5 environments with Oracle access manager 11gR2 .
• Integrating Webcenter content Imaging /OBIEE with Oracle access manager 11gR2.
• Cloning EBS instances from RAC to RAC and RAC to non-RAC residing on ASM.
• Applying EBS R12 patches using adpatch, opatches and weblogic patches using smart update.
• Setting up EBS Roles/responsibilities as required for production and troubleshooting FNDLOAD issues.
• OBIEE 11g administration including user roles/privileges setup.
• IPM 11g users roles/responsibilities setup via OID and troublshooting issues with OAM webgates.

Confidential

Oracle Apps DBA

Responsibilities:

• Creation of DMZ 11i instances for iSupplier and sourcing modules.
• Trouble shoot issues with hardware load balancers as part of the DMZ configuration.
• Install and configure 10g and 11g OBIEE for POC as required by the BI & DW team
• Siebel Database support and preparing production Instance for go-live.
• Implement Oracle recommended best practices ( init.ora parameters, Database character set, OS kernel parameters etc ., ) for Siebel databases .
• Upgrade ERP database from 10g R2 to 11g R1.
• Production support of current 11.5.10.2 ERP instance.
• Implementing and integrating Oracle Audit vault with EBS 11i for auditing purpose.
• Setting up PASTA printing as required for BI Publisher reports and resolving technical issues with BI Publisher required for 11i EBS.
• Assisting development team to convert existing 6i EBS reports to BI publisher reports.
• Applying latest ATG RUP and developer 6i patches.
• Setup and maintain AMP 3.1 for monitoring oracle EBS through 10gR5 GRID control
• Setup and maintain 3rd party products like Right Fax running on Windows server, Markview
• Change management using quest STAT tool for 11i EBS.
• Migration from Desktop ADI to web ADI.
• Implementing BCV backups for 11i Database.
• Upgrading EBS 11i Database from 10.2.0.4 to 11.2.0.2.

Confidential

Oracle Apps DBA

Responsibilities:

• Part of the Implementation and support team responsible for delivering R12 as a Global instance with high availability architecture.
• Supporting the development and functional implementation team.
• Convert non-RAC to 10gR2 RAC using rconfig and manual conversion.
• Implement Shared Appl top, PCP, Hardware Load Balancing of applications
• Install and configure 10g OEM GRID.
• Upgrading R12 environment to 11gR1, R12 RUP6 and 10g AS tech stack upgrade
• Cloning Databases from RAC to RAC, RAC to Non-RAC.
• Configure ERP databases and applications for monitoring by GRID. Install the latest GRID AMP for E-biz.
• Using GRID for monitoring production database and identifying DB bottlenecks.
• Implementation of Data guard (Physical Standby) for the Primary RAC Database and testing of failover and switchover scenarios for Disaster recovery readiness.
• Using NetApp snapshot backup for managing backups and restores.
• Production support of current 11.5.5 instance and 11.5.10 instance and Data warehousing databases.
• Applying patches and change management using STAT tool.
• Implement shell scripts for regular database maintenance and monitoring activities.