SUMMARY

• Senior Oracle Consultant with eighteen years of IT experience, fifteen years of experience working with Oracle E - Business Suite (R11/R12) as Oracle Applications DBA.
• Extensively worked on large complex End-to-End Oracle System integration implementation and support for Oracle EBS Projects. Integration of EBS Suite with SSO, Oracle Fusion Middleware Oracle RODOD Applications. Having good working experience with Siebel CRM, Oracle Billing and Revenue Management (BRM), Order and Service Management (OSM), Unified Inventory Management (UIM).
• Have worked on Oracle 12c, 11g, and 10g versions in database administration, production support, installation, configuration, upgrades, patches, migration, backup/recovery, performance tuning, cloning, space management and security.
• Worked extensively on Oracle 12c features like multitenant container & pluggable databases with Flex Cluster & Flex ASM, and Enterprise Manager 12c Express, Cloud Control and Grid Control.
• High level experience and expertise include, developing Oracle application architecture for new requirements and define the complete technical infrastructure environment creating architecture scope, definition, construction, and execution consultancy for methodologies and standards for design, development, and unit testing phases working as a Technical Resource to Support Oracle E-Business Suite Applications and Databases.

TECHNICAL SKILLS

Oracle E-Business Suite: Oracle EBS Suite R12(12.1.3, 12.2.4) and R11i. Applications Modules: Financial, e-AM, Manufacturing, Order Management and Supply Chain Management, Human Resource Management, Oracle CRM Modules

EBS Specific Skills: Oracle Apps DBA, Sysadmin, Architecture, Integration, Installation, Patching, Configuration, Cloning, Applications and database upgrade

Domain Knowledge: Telecom, Utilities, Health Care

Operating System: Red Hat Enterprise Linux 6.x, Oracle Enterprise Linux 5.x, HU-UX 11, AIX, Sun Solaris 8,9, Windows

Database: Oracle RDBMS 9i, 10g, 11g, 12c, Oracle RAC 10g, 11g

Web Server: Oracle HTTP Server, Oracle WebLogic 10g & 11g, IBM Web sphere Server

Tools: JDK 1.6.x, Jrockit, OEM, Fog Light, Clarify, Veritas, Mercury, Putty, Toad, SQL, SQL Developer, FileZilla, Perl, Remedy, Winscp, Clear Case, SVN, Rational Rose, Eclipse (with plugins SVN & XQDT), Novel IDM, Microsoft Active Directory (AD), Citrix

Exposure to Other Oracle Products: Oracle SOA Suite 10g and 11gOracle Siebel CRM 8.1.x, 8.2.x

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Oracle Apps DBA

Responsibilities:

• Infrastructure / Environment planning, designing of Oracle EBS R12.1, 12.2
• Oracle EBS Installation, configuration, upgrade, customization, support and administration.
• Oracle Application Online patch management ADOP, ADPATCH, ADADMN, ADCTRL, ADRLINK, ADIDENT, ADMERGE
• Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases
• Experience using enhanced features in 12c like - Real Application Testing(RAT), Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Upgrading and migrating Oracle 11gR2 Databases to Oracle 12c Pluggable Databases running on the latest platforms.
• Application and database Cloning for development and test environments
• Install and manage Oracle Real Application Cluster (Oracle RAC) with ASM.
• Troubleshooting issues of development team related to custom code development for Dev, Test and Production environments.
• Carried out Application System Administrator activities like registration of Reports and Forms to Oracle Applications, creation of responsibilities, custom menus and registration of Users.
• Backup and Recovery using RMAN, performance tuning of Oracle database and application
• Application and database monitoring using OEM GRID control 11g.
• Configurations and custom code deployment for development and test environment.
• Applications and database related product bug fixing with help of Oracle product support team by raising service request (SR).
• Configured the EBS SOA Suite gateway for integration with third party system
• Defined Application Development standards for development team.
• Database space and user management

Environment: Oracle EBS Suite 12.2.4, FMW 11.1.1.5, WLS 10.3.5, 10.3.6, Oracle Application Server 10.1.3

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Infrastructure / Environment planning, designing of Oracle EBS R12.1, 12.2
• Oracle EBS Installation, configuration, upgrade, customization, support and administration.
• Oracle Application Online patch management ADOP, ADPATCH, ADADMN, ADCTRL, ADRLINK, ADIDENT, ADMERGE
• Cloning / Refreshing of development and test environments
• Implementation of high availability with Oracle Real Application Cluster (RAC 11gR.2), Automatic Storage Management (ASM), Oracle Enterprise Manager 11g.
• Application and database monitoring using OEM GRID control 11g.
• Backup and Recovery using RMA
• Installation and Configuration of Oracle 12c Multitenant container and pluggable databases, in a 12c multi-tenant architecture.
• Installation and maintenance of Enterprise Manager 12c Express, Cloud Control and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes.
• N, performance tuning of Oracle database and application
• Troubleshooting issues of development team related to CEMLI development and data migration team for development, tests and production environments.
• Monitoring Application, database Services, server CPU and memory usage
• Configurations and custom code deployment for development and test environment.
• Applications and database related product bug fixing with help of Oracle product support team by raising service request (SR).
• Configured the EBS SOA Suite gateway for integration EBS BRM integration
• Integration from EBS OPH to BRM and Siebel CRM FWM AIA middleware application and Master Data Management (MDM PIP).
• The Oracle E-Business Suite concurrent processing for batch integration.
• Defined Application Development standards for development team.
• Set up code repository for custom code

Environment: Oracle EBS Suite 12.1.2, 12.2.1, Siebel CRM 8.1.1.10, BRM 7.5, UIM 7.2.3, OSM 7.2.2.4, FMW 11.1.1.7, WLS 10.3.5, 10.3.6, Oracle Application Server 10.1.3 /10.1.2 , BIP 11.1.1.9

Confidential

Sr. Oracle Apps DBA / Architect

Responsibilities:

• Infrastructure planning, design, build, optimization, ongoing maintenance, fault tolerance detection and corrective actions.
• Installation and configuration of multi node development and test environments of Oracle EBS R12.
• Clone environments, application and database patches, licensing of Oracle products as well as monitoring of EBS Suite using OEM R11g.
• Trouble shooting of database and applications related performance issues and recommendations.
• Support to development team for RICEFW objects and data migration team for conversion.
• Fixed the Applications and Database related bugs with help of Oracle product support team by raising service request and follow-up for the same.
• Oracle Workflow notification mailer setup and deployment of customize workflow.
• Implementation of database backup and restorations.
• Defining the Application Security mechanism for new Oracle applications
• Assessment of the AS-IS communications (Printing/SMS/email) capabilities and the new communications (Printing/SMS/email) requirement.

Environment: EBS Suite 12.1.2, Siebel CRM 8.1.1.5, BRM 7.5, FMW 11.1.7, WLS 10.3.3, Oracle Application Server 10.1.3 /10.1.2 , MDM 2.0.1, MWM 2.0.1, WebLogic Server 10.3.4, CCB 2.3.1, RTD 3.0, OBIEE 11.1.1.5