SUMMARY:

• Over 11 years of IT experience in Oracle technologies, experienced in Design, analysis, implementation, installation, configuration and Administering Oracle Databases 12C, Oracle Applications R12, Oracle Fusion middleware Products.
• Expert in installation, upgrade, configuration of Oracle Databases 11g, 12C, RAC, RMAN backup and recovery of databases.
• Expertise in Installation and Configuration of Oracle EBS Applications 11i, R12.1.3, R12.2, configured and implemented PCP, multiple node architecture, external tier DMZ node.
• Involved in Design, Architect and Implementation of Oracle 12C, OBIEE & EBS on Exadata machine, ODA machine and Exalytics infrastructure.
• Installation, upgrade of oracle Retail Merchandising system RMS 13 & 14, Oracle fusion environment and SOA integration.
• Oracle RMS 13 installation, upgrade, domain deployment, upgrade to version RMS 14, supported reporting and development issues.
• Database issues resolution for RMS 13 & 14, weblogic upgrade and integration with various other systems.
• Expert in OBIEE installation, Upgrade from 11g to 12c, migrations of various components.
• Experience of multiple end to end Financial ERP project using EBS & OBIEE, installation, configuration and maintenance of EBS & Data Warehouse, Business Intelligence Applications, and production support.
• Responsible for working with onsite Oracle consulting team, Oracle development team, Oracle war room support team for critical go live of financial ERP project.
• Architecture and performance tuning of ETL jobs across Oracle Databases, ODI, Informatica, DAC tools.
• Experienced in migrating Oracle EBS, Oracle database from HP / AIX platform to Exadata, Exalytics machine; restore from backup, clone from RAC, setup InfiniBand connections, post migration performance tuning.
• Expert in Oracle Database Installation, upgrades, patching, cloning of Oracle Databases (10g and 11g), RMAN recovery from backup, ASM disk management.
• Integrated and implemented OBIEE external LDAP, integrated with SSO - Single Sign On with various external Oracle tools like - OID/OAM, OHS, and ODSEE.
• Integrated EBS SSO -Single Sign On using OID Oracle Internet Directory, OAM.
• Experience in working with ASM for RAC and non-RAC setups, installing and configuration single node, RAC, Data guard and DR database.
• Experience with design and implementation of database backup and recovery procedures using RMAN and Grid control. Worked with storage administrators for Storage level snapshot backups etc.
• Configuration of EBS and OBIEE production environment databases on Exadata machine, with application servers on Exalytics machines.
• Worked extensively on Oracle Database, Application performance tuning of Concurrent managers, concurrent requests, scheduling of concurrent jobs, JVM tuning, request level memory allocation.
• Administering Oracle EBS 11i and R12 Instances using AD utilities: ADOP, AD Admin, AD-Patch, autoconfig and Opatch.
• Experience in administration of Oracle OBIEE, BI Publisher, Weblogic Server, Performance Tuning of Weblogic, managed servers and OBIEE services, issue resolution.
• Expertise in Cache Management, Performance tuning at OBIEE report level and database level issue resolution.
• Integration with EBS, ODI/ETL and OBIEE for financial reporting also implemented and supported FAH, GL, AP, AR, Projects and HR functional areas.
• Expert in Infrastructure and Implementation specialist for support on Oracle technologies on Exadata systems for databases and Exalytics in memory systems for OBIEE applications.
• Oracle 11g, 10g database Installation, Cloning, Patching, Performance tuning and Maintenance on RHEL Linux, Oracle Enterprise Linux 5.5 environments.
• Expert in patching OBIEE, EBS and Oracle databases, WebLogic patches, OPatch for BI APPs patching, OPatch for database patching, AD-Patch for EBS patching.
• Write and update Technical Notes and Documentation for future analysis and standardization.
• Experience Supporting 24*7 Production computing environments. Experience providing on-call and weekend support.
• Highly motivated team player with immense ability to grasp new concepts and apply them.

TECHNICAL SKILLS:

BI Applications & ERP: OBIEE 11g & 12c, EBS R12.2 & 12.1.3, Oracle RMS13 & 14, Oracle DB 11g, Apex, ADF

Engineering systems: Exadata machine, Exalytics machine, Exalogic VM s, Infiniband connections.

Oracle Tools: ODI ETL, OHS, BI Publisher, Essbase 11.1.1, Exalytics, Exadata, ODSEE, OID, OAM

Database: Oracle Database 12c, Oracle RAC, Oracle 11g, Oracle 10g.

Operating System: HP-UX, RHEL Linux, Oracle Enterprise Linux, Windows Server 2003, 2008.

Performance Tools: TKPROF, STATSPACK, Explain Plan, ORADEBUG

Programming: SQL, PL/SQL, UNIX Shell Scripting, Java.

Tools: Toad, SQL Loader, Oracle Developer 2000, OEM, OAM, SQL Tuning Advisor.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, San Francisco, CA

Environment: Oracle Database 12c & 11g, RAC, Flexcube12.2, EBS 12.1.3, EBS12.2, Fusion Middleware, WebLogic 12C

Responsibilities:

• Upgrade Databases from 11g to 12C technology stack, including Flexcube, EBS and Fusion Middleware components.
• ETL setup using ODI and Oracle Data warehouse, performance tuning and issue resolution across objects.
• Installation, Configuration of Oracle Database 12C, upgrade from 11g stack and patching security and critical patches.
• Support and multiple run of Adop patching and refresh EBS R12.2 environments.
• Upgrade issue resolution and database issues post upgrade code migration and performance.
• Installation, patching, data refresh, upgrade for oracle Flexcube 11 & 12, component migrations, domain deployments.
• Upgrade of WebLogic to 12C and EBS 12.1.3 to 12.2, issues regarding patching and new domain and managed creation fixed.
• Multiple environments build for development and testing purpose with Oracle Database 12C.
• Adop and opatch issues resolution, fixing Rman backup and Database issues with Capacity planning.

Sr. Oracle Apps DBA

Confidential, Houston, TX

Environment: Oracle Database 12c & 11g, RAC, OBIEE 12C, 11g, EBS R12.2.4, RMS 14, ODI, Essbase, BI Publisher 11g

Responsibilities:

• Expert in OBIEE installation, Upgrade from 11g to 12c technology stack including database, migrations of various security components.
• Installation Configuration, upgrade of Oracle Database 11g, 12C, ASM, two node RAC support, administration.
• RMAN backup and recovery setup, Disk administration, supporting Database migrations from Legacy to Oracle Linux systems.
• Oracle RAC for Data warehouse and EBS, OLTP and OLAP systems integration with ODI ETL configuration.
• Installation of oracle RMS 14, integration with EBS and SOA 11g, weblogic upgrade and database support.
• POC and build out of four 4 Oracle RMS version 13 and 14 for Dev, Test, UAT and PROD env’s.
• Installation and configuration of multimode EBS R12.2.4, WebLogic 12C, OBIEE 11g and 12C, ODI, SOA on Global ERP project.
• Support and multiple run of Adop patching and refresh EBS R12.2 environments.
• EBS R12 architecture with multi node and DMZ node and SSL load balancer across all nodes.
• Experience in issue resolution from EBS 12.2 ADOP patching, EBS R12.2. upgrade, WebLogic Stuck thread.
• OBIEE Multi Node Horizontal scaled model, vertical scaling and implemented failover for 11g architecture, 12c architecture.
• Oracle database 12c and 11g - install, upgrade, patching, config, administration and support.
• Upgrade OBIEE and ODI complete stack to 12C, component migration RPD, catalog, Security realms, LDAP.
• Multi node EBS R12.2.4 installation on Oracle RAC, PCP, SSL, SSO and load balancing configuration.
• EBS and OBIEE WebLogic issue resolution, monitoring thread level and JVM memory monitoring.
• Migration of database objects, components, Repository & Catalog for OBIEE environments and patching administration and configuration of more than 10 environments.
• Install, configure, implement architectural design and provide support to Oracle Fusion middleware 11g, OBIEE 11.1.1.7.1 and Weblogic, ODI stack.
• EBS R12.2 to represent financial ERP and configuration, installation of ODI to ETL data load.
• Ensured performance issues by monitoring and review of application logs, trace files, alert logs, and concurrent logs, reports involving CPU, I/O Activity, and memory utilization.
• Patching latest patchset for Oracle Fusion middleware, OBIEE, upgrade Weblogic, patching OBIEE to resolve role and responsibility migrations.
• Resolved critical ADOP issues regarding failure to complete on multimode EBS and resolved upgrade issues from EBS R12.2.4.

Sr. Oracle Admin

Confidential, Dallas, TX

Environment: Exadata, OBIEE 11g, EBS R12.1.3, Informatica, Dac

Responsibilities:

• Installation and configuration of EBS R12.1.3, OBIEE, Informatica, on Global ERP project.
• Migration of database objects, components, Repository & Catalog for OBIEE environments and patching administration and configuration of more than 10 environments.
• Install, configure, implement architectural design and provide support to Oracle Fusion middleware, weblogic, OBIEE environments.
• Various upgrade steps for OBIEE from 11g with migration of components, and SSL and SSO setup.
• POC for EBS R12.1.3 to represent financial ERP and configuration.
• Responsible for administration, monitoring databases, ASM space issues, database object extents growth and review existing database initialization parameters.
• Administration of Weblogic and Fusion middleware technology stack.
• Ensured performance issues by monitoring and review of application logs, trace files, alert logs, and concurrent logs, reports involving CPU, I/O Activity, and memory utilization.
• Patching latest patch set for OBIEE, upgrade Weblogic, patching OBIEE to resolve access issues over internet explorer.
• Patching and cloning of EBS R12 environments, administration and migrations over different environments.

Sr. Oracle EBS Admin

Confidential, Deerfield, IL

Environment: Exadata, Exalytics, OBIEE 11.1.1.7.1, EBS R12.1.3, EBS R12.2, RMS 13.1 & 14, DB 11.2.0.2, BI Publisher

Responsibilities:

• Responsible for the full cycle implementation of the Financial ERP project, Implementation of OBIEE and EBS and integration with ODI on Exadata and Exalytics machine.
• Responsible for implementing financial modules of Oracle EBS R12, implementing life cycle of Development, Test and Production ERP systems.
• Coordinated among functional, technical, systems and internal DBA team for installation, implementation, upgrade and issue resolution on EBS R12.1.3 and OBIEE.
• Implemented EBS R12.2 environment with multi node architecture and demonstrated Fusion middleware and adop patching.
• EBS R12.1.1 upgrade to R12.1.3, Patching, cloning multiple environments, troubleshooting issues, post go live support, resolving issues concurrent programs, building internal and external DMZ nodes.
• Responsible for administration, monitoring databases, ASM space issues, database object extents growth and review existing database initialization parameters.
• Ensured performance issues by monitoring and review of application logs, trace files, alert logs, and concurrent logs, reports involving CPU, I/O Activity, and memory utilization.
• Installation of OBIEE 11g application on Exalytics server and Exalogic VM’s servers in single and cluster mode.
• Experience in working with SSL certificate and software level load balancer on EBS application servers.
• Excellent knowledge with integrating Oracle Single Sign-on (SSO), SSL load balancer and Oracle Internet Directory (OID) and Oracle Access Management - OAM on Oracle EBS R12.1.3 release.
• Integration of Essbase cube and RDBMS objects for various level of Reports and drill down.
• Oracle application installation of R12.2 and R12.1.3 and Oracle application database upgrade to 10.2.0.3 to 11.2.0.3.
• Oracle RMS 13 installation and supported 6 environments, patching, upgrade to version 14 and integration with EBS environment.
• Production support for RMS 14 and active database support, patching, bug fixes, weblogic and deployment support.
• On business team for Retail Enterprise system for Confidential store reporting using RMS14, EBS and OBIEE reporting.
• Starting and stopping apps services, Concurrent Manager Configuration.
• Oracle application maintenance of R12.1.1 and upgrade to R12.1.3 by ensuring support is provided for escalated issues/SR with ORACLE support team.
• Integration with EBS, ODI/ETL and OBIEE for financial reporting also implemented and supported FAH, GL, AP, AR, Projects and HR functional areas.
• Configuration of EBS and OBIEE production environment on Exadata machine, building infiniband connections with application servers on Exalytics machines, resolving TNs issues, monitoring and tuning ETL jobs using Infiniband connection.
• Expert in Infrastructure and Implementation specialist for support on Oracle technologies on Exadata systems for databases and Exalytics in memory systems for OBIEE applications.
• Supported Functional end users to fix any issues related to Applications and resolved database performance-related issues.
• Integration of OID and EBS Application, implemented Single Sign on SSO & SSL for EBS and OBIEE.
• Implementing Security certificates for EBS & OBIEE and integrated with Load balancers and multiple Web servers and HTTP servers, Proxies.
• Implemented Best Practices on OBIEE, weblogic, Fusion middleware, OWB and Proactive measures taken on performance bottlenecks.
• Implemented Oracle APEX and Oracle ADF for development database systems framework.
• Worked on LDAP Authentication, Role Based Authorization Model, Display Tabs, Default Landing Dashboard, Object Level/Data Level Security, and Prompt Values using OBIEE.
• Supported migration of Essbase cube between different environment and integrating drill down for same.
• Designed and developed the metadata layer (RPD) to meet the business requirements.
• Designed OBIEE Repository at 3 layers i.e., Physical Layer, Business Model Layer, and Presentation Layer.
• Did the Necessary RPD and Catalog upgrades and applied OBIEE and WebLogic patches.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Created several dimensional hierarchies in the BMM layer for reporting drill-down functionality.
• Configuring Repository, Session variables for user security and to generate dynamic reports.
• Supported Performance monitoring and tuning for various reports and worked with server architect to tune CPU, Memory and DISK for the environments.
• Migrated Repository & Web Catalog from Development to Test & Production server using Oracle Enterprise Manager/Catalog Manager.
• Created dashboard and reports using pivot views, column selector, view selector, presentation variable, master-detail reports, pie charts, bar charts, etc.
• Implemented MUDE (Multi User Development Environment) in OBIEE.
• Extensively used Action Links to navigate from Parent to Child Report passing filters/prompt values.
• Set Up Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g.
• Created Application Roles using Oracle Enterprise Manager & assigned different permissions on dashboards and reports.

Sr. OBIEE & EBS Admin

Confidential, Santa Barbara, CA

Environment: OBIEE, RHEL Linux 5, Oracle EBS R12.1.1, Oracle RDBMS 11.2.0.2, PL-SQL, Toad.

Responsibilities:

• Responsible for implementing financial modules of Oracle EBS R12.1.1, implementing life cycle of Development, Test and Production ERP systems.
• Coordinated among functional, technical, systems and internal DBA team for implementation and issue resolution.
• Patching, cloning, troubleshooting and post go live support.
• Responsible for monitoring database space issues, database object extents growth and review existing database initialization parameters.
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Created several dimensional hierarchies in the BMM layer for reporting drill-down functionality.
• Configuring OBIEE Repository, Session variables for user security and to generate dynamic reports.
• Supported OBIEE Performance monitoring and tuning for various reports and worked with server architect to tune CPU, Memory and DISK for the environments.
• Ensured performance issues by monitoring and review of StatsPack reports involving CPU, I/O Activity, and memory utilization.
• Oracle application installation of R12.1.1 and Oracle application database upgrade to 10.2.0.3 to 11.2.0.3.
• Starting and stopping apps services, Concurrent Manager Configuration.
• Oracle application maintenance of R12.1.1 and upgrade to R12.1.3 by ensuring support is provided for escalated issues/SR with ORACLE support team.
• Integrated EBS SSO -Single Sign On using OID Oracle Internet Directory, OHS Oracle HTTP Server.
• Implemented Best Practices on OBIEE, OWB and Proactive measures taken on performance bottlenecks.
• Worked on LDAP Authentication, Role Based Authorization Model using OBIEE.
• Supported Functional end users to fix any issues related to Applications and resolved database performance-related issues.
• Application and database Tuning using AWR, ADDM, ASH, SQL Tuning Advisor, STATSPACK, EXPLAIN PLAN, and SQL TRACE for performance tuning.
• Cloned Oracle home to all non-prod instances and made sure everything is in sync with production.
• Upgraded Java from 1.6.0.17 to 1.6.0.35 and supported application team in resolving the post-upgrade issues.
• Verified all instances are up and running and all Application Services are on-line.
• Scheduled & automated back-end jobs and monitoring scripts.
• Registered Executable, created Concurrent Programs and Request Groups
• Identified programs causing performance issues and worked with development team to resolve them.
• Set standards for access and use of databases with objectives of data integrity, data security, and efficient operation and audit requirements.
• Continuous exposure to the issues related to various modules like HRMS, OM, Finance, etc.
• Installation and configuration of WebLogic server.
• Supported OID11g on standalone database with failover data guard.

Confidential, Mountain View, CA

Oracle EBS DBA consultant

Environment: RHEL Linux 5, Oracle EBS R12.1.1, R12.1.3, PL-SQL, Oracle RDBMS 11.2.0.2, Toad.

Responsibilities:

• Responsible for 24x7 maintenance and upgrade to Oracle EBS R12, implementing life cycle of Development, test and Production systems.
• Coordinated among functional, technical, systems and internal DBA teams for implementation and issue resolution.
• Production support, maintenance, performance tuning, troubleshooting by ensuring all instances are backed up and available for users.
• Oracle applications maintenance of R12.1.1 and upgrade to R12.1.3 by ensuring support is provided for escalated issues/SR with ORACLE support team.
• Supported Functional end users to fix any issues related to Applications and resolved database performance-related issues.
• Performed complete refresh of the development environment from the production using Rapid Clone.
• Configured shared application tier on the development environments with SSL and SSO.
• Based on the requirement created the custom top and configured them on EBS.
• Worked on patching activities like patch analysis, merging and applying patches using the utilities like admrgpch and adpatch and troubleshooting the issues faced during the process.
• Responsible for managing production, development & test databases and applications.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier iAS Applications.
• Involved in Upgrading of Oracle database & Oracle Applications 11.5.5, 11.5.2 and supporting the production team.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Involved in database migrations cloning Oracle Applications (11.5.5, 11.5.2) production system, for testing and development purpose using rapid clone.
• In depth experience with oracle application utilities such as Rapid Installer, Rapid Clone, adpatch, adadmin, adsplice and adctrl.
• Responsible for all Remedy tickets, communicated and resolved in a timely fashion
• Oracle database installation, maintenance for production, development and test environment.
• Support for customization and upgrade for Oracle database.

Confidential, Natick, MA

E-Business Suite DBA consultant

Environment: HP-UX, Oracle EBS 11i, Oracle 11g, PL-SQL, Toad.

Responsibilities:

• Provided 24x7 Production Oracle database administration and Oracle Application administration support.
• Creation of users, assigning responsibility, creation of custom menus for Oracle Apps 11i and R12.
• In depth experience with oracle application utilities such as Rapid Installer, Rapid Clone, adpatch, adadmin, adsplice and adctrl.
• Pre-patch analysis and document preparation with pre and post patch installation steps.
• Worked with business team and Functional team on issue resolution and performance enhancement.
• Generating automatic scripts for backups.
• Upgraded of Oracle Applications from 11.5.10.2 to 12.0.4 and upgrade of databases from 10.2.0.3 to 11.2.0.2
• Enabled Auditing feature for tables such as FND USER etc.
• Created new concurrent managers, Purged concurrent requests table.
• Performed daily and weekly backups using Netbackup snapshot technology.
• Coordinated and reviewed among DBA team for any new installations, upgrades and configuration changes to the existing environments.
• Worked on patch analysis, merging and applying patches using the utilities like admrgpch and adpatch.
• Used AD utilities like adctrl and adadmin to resolve the issues while applying the patches.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.