SUMMARY:

• Senior Consultant at Confidential Consulting currently onsite at Oklahoma City in USA
• Around 12 years of experience as Oracle DBA, Oracle Apps DBA and Fusion Middleware Admin

AREAS OF EXPERTISE:

• I can build and manage instance strategy, including scheduling of instance builds, refreshes, patching and backup for EBS and other Oracle instances in the project.
• Work with Oracle and vendors for sizing hardware and configuration parameters for Oracle products such as EBS and Weblogic.
• Identify and optimize backup strategy using RMAN and Linux scripts.
• Identify performance tuning opportunities and address performance issues as required.
• Maintain Oracle EBS R12.1 and R12.2, including patching, cloning and upgrading.
• Managing Oracle EBS and Databases hosted in Amazon Cloud and Oracle Bare Metal Cloud.
• Set up Database high availability for Oracle Database and EBS.
• Configure SSL for Oracle products EBS and FMW products
• Setup EBS R12 instance for DMZ configuration
• Performance Tuning Oracle WebLogic, Oracle Databases and EBS instances
• Manage backups, monitoring scripts on Database, EBS and FMW products

PROFESSIONAL EXPERIENCE:

Confidential

DBA, APPS DBA, Oracle Fusion Middleware Admin

Environment: Oracle EBS 12.1, Oracle WebLogic Server with ADF, Oracle Database

Responsibilities:

• Coordinate with team members to ensure smooth progress of client project.
• Setup and support Oracle FMW ADF instance for client hosted environment.
• Setup and support Oracle EBS 12.1, 12.2 instance
• Analyze performance issues Oracle Database, Oracle Weblogic and EBS instances
• Perform Infrastructure assessment to identify risks to production environment and to identify performance tuning opportunities in the Database and EBS instances

Confidential

DBA, APPS DBA, Oracle Fusion DBA

Environment: Oracle Fusion Application, Oracle WebLogic Server, Oracle EBS, Oracle Database

Responsibilities:

• Work with project team through Development, Integration and Test cycle as logical DBA and sysadmin to migrate objects into EBS 12.2 instance for Confidential client project
• Setup Oracle EBS 12.1, 12.2 instance on - Premise for a US based manufacturer of engineered quartz surfaces.
• Setup Oracle EBS 12.2 on Oracle Infrastructure Cloud for Confidential go to market Solution.
• Perform Infrastructure assessment to identify risks to production environment and to identify performance tuning opportunities in the Database and EBS instances for Confidential ’s client.

Confidential

Member Cloud Operation-SAAS Team

Environment: Oracle Fusion Apps

Responsibilities:

• Setup RAC Databases to be used by Fusion Apps
• Apply patches on RAC Databases
• Manage OVM templates for Fusion Apps
• Build Fusion application instance using pre-configured Fusion Apps templates

Confidential

DBA, APPS DBA, Oracle Fusion DBA

Environment: Oracle Databases, EBS, WebLogic, SOA, OBIEE and Hyperion

Responsibilities:

• Provide support for Oracle EBS R12.1 environments for clients
• Upgrade Oracle Database from 10g to 11g for Oracle EBS
• Upgrade Oracle EBS from 12.0.6 to 12.1.3
• Analyze and patches CPU Patches for Oracle EBS, WebLogic, OBIEE, Hyperion and Database
• Perform cloning of Oracle EBS using hot backup and cold backup
• Troubleshooting WebLogic day to day administration issues with Hyperion, OBIEE and SOA Suite.
• Cloning and refreshing Oracle EBS instances for single/multi node environment.
• Apply patches into different oracle products such as EBS, Hyperion, WebLogic
• Installation of R12 (12.x ) in single and multi node environment
• Monitoring Concurrent Manager, its operations & Troubleshooting problems, resolved the log/out files issues of concurrent requests
• Trouble shooting the issues related Apache
• Perform troubleshooting on EBS instance
• Manage OS level scripts/RMAN scripts to monitor environments
• Installed, configured OBIA with OBIEE 11g on Linux

Confidential

DBA, APPS DBA, Oracle Fusion DBA

Environment: Oracle SOA Suite, OBIEE, Oracle GRC, Oracle WebLogic Server, Oracle EBS, Oracle Database

Responsibilities:

• Coordinate with team members to ensure smooth progress of project work.
• Setup, patch and upgrade WebLogic and SOA Suite 11g and provide support for Weblogic and SOA 11g instance
• Work with development team deployment of ear/war/jar files.
• EBS upgrade from 12.0.4 to 12.1.3
• Cloning and refreshing Oracle EBS instance
• Analyze patches for EBS R12 environment
• Monitoring Concurrent Manager, its operations & Troubleshooting problems, resolved the log/out files issues of concurrent requests.
• Trouble shooting the issues related Apache.
• Perform troubleshooting on EBS instance.
• Apply CPU patches on Database, EBS and Middleware instances.
• Generation of forms, reports, graphics etc using adadmin.
• Used Cronjob to identify and report Disk space, alert log & CPU utilization issues.
• Responsible for scheduling using OS level scripts/RMAN and monitoring backups.

Confidential

DBA, APPS DBA

Environment: Oracle Database 8.0.6, 8.1.7.4, 9.2.0.X, 10.2.0.2 and EBS 11.5.10.2

Responsibilities:

• Monitoring database backups and perform manual backup, restoration and recovery when required.
• Review the database backup policy, highlight and eliminate risks.
• Performing health checks on database to check that the database meets Organizational standards.
• Monitor and housekeep archive log destinations for databases.
• Monitor and manage size of tablespaces in databases.
• Reviewing and modifying instance parameters as per requirement.
• Performing database cloning/refresh using scripts and manually.
• Implementing UNIX scripts to perform backup, housekeeping and other tasks.
• Applying CPU patches to the ORACLE HOME.
• Exporting and importing data between databases.
• Monitoring standby database, checking archive transfer, recovery mode, shipping archivelogs manually and performing manual recovery for standby databases.
• Using AWR and ADDM to check database performs.
• Raising and implementing changes on databases using remedy change management tool.
• Troubleshooting issues on Oracle databases through tickets.
• Using Oracle Metalink to get to solutions and diagnose issues.
• Troubleshooting Oracle EBS services.
• Making changes in Oracle Application environment using Autoconfig.
• Applying patches on Oracle Application Instance.
• Applying CPU patches to Oracle Applications 11i instance.
• Cloning Oracle Application Instance from Production to Development.
• Maintaining passwords for Application user, and APPS user.
• Using Oracle Metalink to Download patches and documents and raise service request when required.
• Presenting database and application details to external auditors.

Confidential

DBA

Environment: Oracle Database 9i and 10g

Responsibilities:

• Applying patches including CPU patch and upgrading Oracle Databases
• Managing tablespaces related issues.
• Performing housekeeping on database server.
• Taking offline & online backup and restoring and recovering databases.
• Configuring and managing physical standby database
• Using export and import utilities to export and import data across databases.
• Managing parameters and parameter files.
• Using Oracle Metalink to troubleshoot issue with the database.