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.
• Fourteen years of experience working with Accenture, Deloitte, GE in countries like US, UK, South Africa, and Riyadh in a Senior Oracle Consultant role, in designing and building development, test and production environments involving different Oracle integrated Applications.

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

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

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: Application Version 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.

Confidential

Technical Architect

Responsibilities:

• Infrastructure consulting services for various Oracle databases and technology stack components and applications including Oracle EBS R12.
• Installation and configurations of multimode high availability clustering for Oracle EBS R12 applications using hardware load balancer for application and Oracle RAC 11gR2 database.
• Implemented parallel concurrent processing with three node cluster
• Worked closely with Oracle support and HP team for Real application cluster kernel issues
• Oracle Enterprise Linux Administration and performance troubleshooting
• Configuration of Oracle Single Sign (SSO) On for Oracle EBS.
• EBS SOA Gateway configuration and support for integration with OSB
• Defined the Application development standards for development team and deployment workflow for testing team
• Development and deployment support for CAMLI objects to test and production environment.
• Code repository setup and deployment workflow
• Oracle Database support to FMW and CC&B development, test and production environments
• Oracle EBS upgrade from version 12.0.6 to 12.1.2
• Oracle Database 11gR2 Upgrade - 11.1.0.7 to 11.2.0.1
• Created operations manual for DBA support team
• Knowledge transition to offshore DBA support team.

Confidential

Technology Architect / Sr. Oracle Apps DBA

Responsibilities:

• Infrastructure and detailed environments plan of Oracle EBS R12, Siebel CRM and SOA Suite.
• Environment Sizing and optimization development, test and production
• Installation and Configurations of EBS R12 with high availability option for production applications and Oracle (11g RAC) databases
• Virtualization of environments using Windows VMware
• Installation and configuration of EBS R12 applications for development and test environments
• Patching, cloning of Oracle application and databases for development and test environment.
• Responsible for performance tuning of applications and Oracle database
• Application system administration activities like registration of custom top, creation of custom schema, database objects, creation of custom responsibilities, menus and functions.
• Setup for Workflow notification mailer
• Registration of printers at applications and operating system level
• Implementation of database back and restorations using RMAN.
• Installation of Oracle Enterprise Linux and operating system packages, kernel parameter setting.

Confidential, MN

Senior Oracle Apps DBA

Responsibilities:

• Installation and configuration of Oracle EBS Suite 12.0.4 and SOA Suite 10g
• Patching, cloning / refreshes of Oracle EBS R12 and SOA applications and databases.
• Troubleshoot the user issues, interaction with end users / coordination with development teams and end users to carry out the patching and new changes to system.
• Carried out the Application system administrator activates like creation of custom responsibilities, menus, registration for forms and reports, creation of users and assigning responsibilities.
• Deployment of custom code / CEMLI on test environments
• Performance tuning of Oracle applications and databases and custom codes.
• JRE upgrade for EBS
• Database space and user management.
• Support integration and Oracle EBS and SOA Suite.

Confidential

Onsite Environment Lead / Sr. Oracle Apps DBA

Responsibilities:

• Onshore DBA Lead - responsible for development, test and production environments of Oracle EBS and SOA Applications.
• Environment planning and co-ordination with development and testing team
• Installation, patching, cloning of Oracle EBS R11i and SOA applications and databases.
• Analyze and troubleshoot application and database issues
• Resolving the database and application performance issues with help of Oracle support
• System administration activities such as user creation, registration of custom top, printer configurations.
• Monitor and support Oracle SR and coordination with technical team members and Oracle support.
• Troubleshooting and making recommendations on performance issues for long running concurrent programs
• Setting Oracle Application alter, adding new concurrent managers, scheduling of concurrent requests