SUMMARY

• Has 13 years of professional experience in Oracle Apps DBA, Oracle Core DBA/SQL Server, Weblogic Administration and Fusion Middleware DBA,
• Proven Experience on Oracle RAC, ASM, and Data guard
• Implementations and support experience on DMZ, SSL, Shared APPL TOP and F5/Cisco ASA Hardware Load Balancer Configurations
• Good experience in Oracle E - Business Suite Upgrades and Installations on Multinode environments and Oracle Database Upgrades. Upgraded E-Business suite 11.5.4 to 11.5.10 CU2, 11.5.9 to 11.5.10 CU2 and 11.5.10.2 to R12.1.3 and R12.1.2 to R12.2.5
• Working Experience on Oracle Golden Gate.
• Installed and Configured 12c/13c Oracle Enterprise Manager to monitor Databases, E-Biz Suite, Middleware and JVM Tuning
• Upgraded Databases/Cluster ware from 10.2.0.4 to 11.2.0.3,11.2.0.4 and to 12c
• Good Experience on 10g/11gR1/11gR2 Oracle Identity Management(OIM), Access Management(OAM), OID and OVD
• Experience on Integration to different target applications (AD 2003/2008/2012 , Share Point 2007/2010, Exchange 2007/2012, E-Business Suite R12.1.2/R12.2.4) with OIM
• Implemented Single Sign On solution for ERP, Share Point Portal, OWA over OAM 11g
• Experience on PeopleSoft/ OBIEE Administration
• Experience on Cross Platform Migrations, involved in E-Biz migrations from Solaris to Linux Environment and Windows to Linux.
• Migrated database from a Non-RAC instance to RAC and to Automatic Storage Management (ASM) database for effective I/O Performance
• Installation and Administration Experience on 11g Fusion Discoverer/11g SOA
• Good Experience in handing large Data Warehousing databases.
• Implemented and Supported Microsoft SQL Server 2008R2/2012/2014 Clusters, and SQL Always On
• Strong understanding of UNIX concepts and Shell Scripting
• Excellent communication and interpersonal skills with experience of functioning as morale owner of the team
• Analytical and able to adapt to new environments and learn new technologies quickly.

TECHNICAL SKILLS

ERP Products: Oracle E-Business Suite 11.5.4-11.5.10 CU2, R12.0.6-R12.1.3, and R12.2.4, PeopleSoft

RDBMS: Oracle 8i/9i/10g/11gR2/12c and Microsoft SQL Server 2005/2008R2/2012/2014

Cluster Ware: Oracle Cluster ware 10g/11g/12c, Windows Cluster, Veritas Cluster and RHEL Cluster.

Security Products/IDAM Products: Oracle Identity Manger 11g,, Oracle Access Manager 11g, Sun Identity Manager 7.1

Directory technologies: Oracle Internet Directory 11g, Active Directory 2003&2008, Oracle Virtual Directory

Application servers: Weblogic 10.3.5/10.3.6/12 c Oracle 10g iAS, Tomcat Apache

Languages: Core Java, C and C++

Scripting: Java Script, Unix Shell Scripting and Weblogic Scripting

Operating Systems: HP-UXB.11.23, Sun Solaris 8x/9x/10,Linux RHAS 3/4,RHEL 5.5,OEL 5.4/5.5/6 and IBM AIX

Storage: EMC(Symmerix 8730/8830/ DMX 2000),Data Ontap Netapp 7G, Netapp 7.3.2/8.0 Simulator, OpenFiler iSCSI 2.3

Virtualization: Vmware ESX 3.0/4.0/ESXi, Vmware Server, Oracle VM, Docker

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Apps DBA/ SQL Server DBA

Technologies: E-Biz R12.1.3, R12.2.5, Database 12c, 12c RAC, 11gPS3 OIM/OAM, OID, SQL Server 2012/2014.

Responsibilities:

• Upgrade the oracle clusterware and database from 11.2.0.4 to 12.1.0.2.
• Upgraded the E-Business suite R12.1.3 to R12.2.5.
• Tuned JVM’s of Weblogic server for faster response time using OEM metrics
• Re-registered upgraded E-Biz application to OID and OAM for Single-Signon
• Configured multiple oacore, oaforms Managed Instances across multiple nodes to cater 19000+ Self Services users
• Configured DMZ for Irec and Iproc Module users
• Configured Dataguard with DG broker from RAC to Standby RAC.
• Configured Golden Gate Bi-Directional replication with CDR(Conflict Detect Resolution)
• Configured 12c OEM E-Biz Application Management Pack for effective monitoring and Maintenance.
• Installed and configured SQL Server 2012/2014 Cluster with Always ON.

Confidential

Technical Architect/Lead

Technologies: E-Biz R12.1.2, R12.2.4, Oracle 11.1.0.7, 11.2.0.4 F5 Hardware Load Balancer, 12c OEM

Responsibilities:

• Upgrade the oracle clusterware and database from 11.1.0.7 to 11.2.0.4.
• Upgraded the E-Business suite R12.1.2 to R12.2.4.
• Tuned JVM’s of Weblogic server for faster response time using OEM metrics
• Re-registered upgraded E-Biz application to OID and OAM for Single-Signon
• Configured multiple oacore, oaforms Managed Instances across multiple nodes to cater 19000+ Self Services users
• Configured DMZ for Irec and Iproc Module users
• Configured 12c OEM E-Biz Application Management Pack for effective monitoring and Maintenance.
• Worked closely with Application Development Teams in deploying OAF Customizations.

Confidential

Technologies: Linux, Oracle Identity Manger 11g, Oracle Access Manager 11g, Oracle Internet Directory, Web Logic

Responsibilities:

• Coordination with different applications owners and gather required details for PIM integration
• Design the solution architecture
• Develop the road map for migration from Oracle IAM 10g to 11g.
• Interacting with client to understand the requirements for migration and issue in the existing implementation.
• Installation and configuration of new system Fusion middleware 11g
• Integration to different target applications (AD 2003 &2008, Exchange 2007/2012, ERP 12.1.2)
• Developed custom connectors for home grown application in Oracle 11g
• Developed custom self-service portal for password management in Oracle 11g to enable end users to reset their password.
• Implemented Single Sign On solution for ERP, Portal, OWA over OAM 11g
• IDM 11gR1 to R2PS1 migration
• Project documentation Requirement Document, Design, Configuration document
• Define the support model

Confidential

Senior DBA

Responsibilities:

• Managing relationship with the client and other stakeholders of the project.
• Guiding team to design the overall solution for upgrade, including Oracle custom application and reporting solution.
• Reviewing deliverables and action plans on a periodic basis.
• Developed a robust upgrade strategy
• Have reviewed the requirement & proposed HA configuration.
• Led the approach for upgrades (AIX, GPFS, Oracle RAC, Oracle Database, EBS R12)
• Carried out the implementation of the Active Data Guard and Backup Strategy to support the failover of Application and Database along with Shared Application Tier & DMZ.

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Performed RMAN cloning of the existing 11.5.10.2 Installation to Dev, Test and UAT Environments.
• Performed Database Upgrade from 9.2.0.5 to 10.2.0.4
• Performed R12 upgrade from E-Business suite 11.5.10.2
• Converted Non ASM to ASM and Non-Oracle RAC to RAC System
• Implemented Shared Appl Top and enabled PCP
• Application Maintenance using AD utilities like adpatch, adctrl, adadmin, adrelink, etc.
• SYSADMIN Activities like Concurrent Manager Management, User Creation, etc.
• Configuration and Maintenance of Work Flow.
• Shift Coordination, which include assigning roles and responsibilities to the team members and interacting with Online Support team for handling TARs.
• Troubleshoot the issues as and when required.
• Participating in team lead meeting, weekend plan meeting and process meetings.

Confidential

Senior Database Consultant

Responsibilities:

• Performed database Upgrade from 9.2.0.6 to 10.2.0.3
• Migrated database from Windows to Linux using 10g RMAN Convert Utility
• Migrated Applications from Windows to Linux and also converted Single node to Multinode Environment.
• Implemented RAC on the existing E-Business suite database.
• Configured PCP(Parallel Concurrent Processing) to support load balancing of the concurrent requests.
• Configured Dataguard on 11i E-business Suite Database for High Availability
• Supported Technical team in debugging post Upgrade issues.
• Shift Coordination, which include assigning roles and responsibilities to the team members and interacting with Online Support team for handling TARs.
• Troubleshoot the issues as and when required.

Confidential

Senior Database Consultant.

Environment: Oracle E-Business Suite 11.5.8 CU2 (Multi-Node), Solaris 5.10, Oracle 9.2.0.7

Responsibilities:

• Performed database cloning through Hot Backup.
• Upgraded database from 9.2.0.7 to 10.2.0.3
• Upgraded Oracle E-Business Suite from 11.5.8 to 11.5.10.2.
• Analyzed and applied ATG RUP 6.
• Applied Latest Financial Family packs
• Supported Technical team in debugging post Upgrade issues.
• Shift Coordination, which include assigning roles and responsibilities to the team members and interacting with Online Support team for handling TARs.
• Troubleshoot the issues as and when required.

Confidential

Senior Database Consultant

Responsibilities:

• Performed Database Upgrade from 9.2.0.6 to 10.2.0.3.
• Laid R12 Oracle Applications File System, by selecting Oracle Upgrade option in Rapidwiz utility.
• Applied Maintenance Driver file to Upgrade the existing 11i system to R12.0.4
• Actively debugged the issues in upgrade.
• Supported Technical team in debugging post Upgrade issues.
• Shift Coordination, which include assigning roles and responsibilities to the team members and interacting with Online Support team for handling TARs.
• Troubleshoot the issues as and when required

Confidential

Environment: Oracle E-Business Suite 11.5.10 CU2 (Single Node), HP-UX 11i, Oracle 9.2.0.7

Responsibilities:

• Performed upgrade from Oracle Apps 11.5.4 to 11.5.10 CU2 on Production/UAT/Dev/Test Environments.
• Performed manual cloning of the existing 11.5.4 Installation to Dev, Test and UAT Environments.
• Performed Database Upgrade from 8.1.7.4 to 9.2.0.7.
• Cloning of Production to staging server using hot backup and recovered the database as per the business requirement.
• Installed latest Oracle9i Application Server 1.0.2.2.2.
• Upgraded JDK to 1.4 and Initiator to 1.3.26.
• Application Maintenance using AD utilities like adpatch, adctrl, adadmin, adrelink, etc.
• SYSADMIN Activities like Concurrent Manager Management, User Creation, etc.
• Configuration and Maintenance of Work Flow.
• Applied Oracle RDBMS patches using opatch utility.
• Troubleshoot the issues as and when required.
• Participating in team lead meeting, weekend plan meeting and process meetings.