SUMMARY

• 10 years of experience on Oracle Applications 11i/R12.1 R12.2 Implementations and maintenance support of Oracle Databases 9i/10g/11g/12c.
• Experienced in Installation, Configuration, Patching, Cloning, Sysadmin, Concurrent manager and up gradation of Oracle E - Business Suite 11i/R12.1.x/R12.2.x
• Troubleshooting and Managing Configurations of the Oracle E-business Technology Stack like Web server, Forms server, Reports server, Discoverer server and Concurrent Processing Server.
• Experience in working with AD utilities like ADADMIN, ADMERGE, ADPATCH and ADCTRL.
• Extensive experience in cloning Oracle E-business suite using RAPIDCLONE and some custom scripts.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Implementation of High Availability solutions with Oracle 10g/11g/12c RAC with ASM, Physical and Logical Standby Databases (Data Guard).
• Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11gr2 RAC environment.
• Experience on Create objects like Table spaces, Segments, User management, Networking and security.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump,
• Migrated databases from non-Exadata servers to the Exadata X5 Database Machine using the RMAN 11g duplicate standby and using Rconfig method.

TECHNICAL SKILLS

ERP: Oracle Applications (EBS) 11i, R12.

Database: Oracle 9i, 10g, 11i, 12c, Oracle Exadata, Sql Server 2012

Operating System: Red hat Linux, Solaris, HP-Unix, Windows server 2012 R2

Oracle Tools: OAM, OIM, ODI, OID, Golden Gate.

ETL Tools: Informatica 11, SAP BODS 4.1.

Reporting Tools: OBIEE, SAP BO4.1 (Web, dashboard, Crystal Reports).

Utilities: Export, Import, RMAN. Sql Loader, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Technology Lead

Responsibilities:

• P performed the upgrade tasks of Oracle EBS applications version 12.1.3, 12.2.3 and12.2.5 Upgraded Oracle databases from version 11.2.0.3 to 12.1.0.2.
• Applying Oracle EBS patches using online patching(ADOP).
• Performed Cloned application database from singe node to multi node system using Raid Clone
• Experience on setting up Standby Database RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O and Sizing of tables.
• Creation of metrics and monitoring mechanism for Oracle applications and databases using OEM 12c.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
• Upgraded some of our databases from 11gR1 to 11gR2. Worked with Oracle support to resolve the bugs related to 11gR2.
• Applying Oracle EBS patches on multi node for bug fixes and quarterly patches.
• Performing Patch analysis and applying the patches and troubleshooting Patch issues.

Environment: Oracle Applications EBS 11i, R12 Database 10g, 11g and 12c, OEM 12c, Data guard, RAC, Fusion middleware 11g, SOA, OID, Web Logic 11g

Confidential

Technology Lead DBA

Responsibilities:

• Periodic Cloning of Development, Quality and Testing from Production using Database hot backup.
• Apply of Jan2016 patches on OEM Grid Database home (12.1.0.2), OMS Home (12.1.0.5.0 ) and Agent Home (12.1.0.5.0 ) and regular patches for issue of EBS Application and Database.
• Maintain user security and created users for client to access Application. Created users and attached them needed responsibility by using Data Loader Tool.
• Monitor of Performance issues of Concurrent Requests, Managers, Application and Database and resolved.
• Experience in DATAGUARD and DISASTER RECOVERY.
• Applied patches to Exadata cell storage servers using Patchmgr utility via rolling fashion method and
• Good exposure and support experience on Fusion Middleware products OBIEE, SSO/OAM Oracle Access Manager, Oracle Identity Management (OIM), Oracle Internet Directory (OID), Web Logic, SOA Suite
• EBS Security is maintained by following Single-Sign-On, Limit on Access and Authentication, Audit Trail.
• Performing regular backups of Applications and Database (Cold and RMAN utility) and ensuring backups
• Implementation of OEM 12c for database monitoring (Including Exadata Database systems).

Confidential

Associate DBA Consultant

Responsibilities:

• Performing clones from Production EBS to DEV, INT and UAT instances.
• Analyzing and applying the patches, troubleshooting patch issues.
• Upgrading Applications from 11.5.10.2 to 12.1.3 and database from 10.2.0.4 to 11.2.0.3
• Troubleshooting Issues related Applications and Database
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
• Upgrade of Database from 10g to 11gr2
• Convert NON-ASM to ASM
• Configured oracle applications Release 11i with 11g RAC.
• Database DB refresh, Performance Tuning
• RMAN backups and restores, cold and hot backups to tapes and file system.

Environment: Oracle Applications EBS 11i, R12 Database10g, 11g and 12c, OEM 12c, Data guard, RACConfidential

Associate Consultant

Responsibilities:

• Scheduling jobs for daily backups and monitoring daily backup reports.
• Performing Patch analysis and applying the patches and troubleshooting Patch issues.
• Collecting monthly maintenance data, finding log errors and troubleshooting them
• Experience developing secure, reliable, scalable, python applications on the AWS cloud.
• DB upgrade from 11.1.0.7 to 11.2.0.3
• Upgraded Discoverer from 10g to 11g
• Performing pre-patch analysis and pre-config analysis
• Patching with adpatch and use of other EBS utilities like ADADMIN, ADPATCH, ADRELINK, and ADCTRL.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs,Trace files and to work proactively on alerts for the file system and CPU issues.
• System administration activities such as creating executable, programs, request sets and attaching program to request group.
• Troubleshoot problems with web server, web listener, forms server concurrent managers, workflow and database.
• Configured Active Data Guard for all production databases.
• Managing the mount points and cleaning log directories.
• Created shell scripts for automation of application and database clone configurations.

Environment: Oracle Applications EBS 11.5.10.2, 12.1.3, Oracle Database 11g, Discoverer 10g & 11g, Data guard