SUMMARY:

• Over 7 Years of experience as an Oracle Apps DBA for all versions from 11. and Oracle DBA for all releases from 10g to 12c.
• Experienced and proficient with Oracle E - Business suite application (11.5.10, 12.1.1 and 12.1.3) and Oracle Applications Server (9i/10g) in Red Hat Enterprise Linux, AIX and Windows environments.
• Expert in upgrading Oracle Applications from 11i to R12.
• Experience in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation.
• Sound knowledge in AD Utilities, Enabling Multi Org, MRC, NLS settings.
• Expert in Cloning from RAC to Non RAC and Non RAC to RAC databases.
• Extensive knowledge and proven experience in all phases of e-business suite 11i, R12 implementation and software development life cycle.
• Proven experience in capacity planning and benchmarking of e-business environments using mercury interactive and quest performance monitoring and load testing tools.
• Demonstrated ability to think creatively and ability to manage multiple priorities to consistently deliver results.
• Expert in monitoring applications and databases using OAM and OEM.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Extensive knowledge on Oracle tools and utilities (Export, Import, SQL*Loader, PL/SQL, OEM, OAM, SQL Navigator, TOAD, Data Load, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environments.
• Implemented shared APPL TOP in 11.5.10.2 and 12.1.3.
• Experience in Cloning/Refreshing of Database and Applications.
• Skilled in handling a heavily customized 11i/R12.1.1 applications issues, Knowledge in Workflow Configuration.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning Database and Oracle Applications.
• Very strong in cloning using utilities like ADclone, ADconfig and Rapid clone.
• Used utilities like ADadmin, ADrelink etc. to maintain application and database tier.
• Backup and recovery of oracle database using RMAN.
• Installation and configuration of Application Desktop Integrator (ADI).
• Used shell scripting controlled from Crontab for the automation of job Scripts to Startup, Shutdown and Health Check of Databases and of various concurrent processes as well as FTP process.
• Performed Daily Health Check Up of the Database using STATSPACK, AWR, ASH, ADDM, TKPROF, and EXPLAIN PLAN.
• Installed and configured DELL STAT tool for Oracle EBS 12.1.3.
• Excellent experience in design, development & implementation of systems in a wide variety of cutting edge environments. Implemented SSL. Proven record of successfully managing complex ERP, OLTP and OLAP environments.
• Monitor system performance, identify bottlenecks and ensure problem resolution
• Good Analytical problem-solving skills, excellent verbal and written skills.
• Successfully managed the change requests, development and maintenance schedules and cross-platform environment issues.

TECHNICAL SKILLS:

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g AS, web logic

Application Servers: 10gAS (10gR2, 10gR3), IAS (10222), Web logic 11g

Databases: Oracle 9i, 10g RAC, 11g RAC, 12c

Operating Systems: HP-UX 11.31,11.23, 11.11, Solaris 9, 10, AIX 5.1, 5.2, 6.1, Suse Linux 10.3, 11.1, Red Hat Linux RHEL 4.x,5.x and Oracle Enterprise Linux 5,6

Languages: SQL, PL/SQL, PERL, Shell scripting, C, C++

Performance Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.

Others: AD Utilities, SQL * Loader, TOAD, XML/BI PublisherWorkflow Builder, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Sr. Oracle Apps DBA

Responsibilities:

• Implemented 11g RAC (4 node) using oracle Clusterware and ASM.
• Upgraded EBS from R12.1.1 to R12.1.3.
• Configured ASM file system and administered ASM Instances and Disk Groups in RAC.
• Involved in the Cloning and Patching of Oracle Databases and Oracle Applications R12.
• Hands on experience with RapidInstall, RapidClone, adadmin, adsplice, adctrl and adpatch utilities for Oracle Applications.
• Installed and configured DELL STAT tool for Oracle EBS 12.1.3.
• Performed Cloning and Refreshing on Applications and Databasesusing RAPIDCLONE.
• Configured Clusters on WebLogic using WebLogic Console.
• Performed WebLogic installation, clustering, domain configuration and load balancing.
• Implemented shared APPL TOP in 12.1.1 and 12.1.3.
• Configured backup of ERP systems using RMAN and performed database cloning using RMAN as well as scripts.
• Configured RMAN backups (Full, incremental and cumulative) and performed recovery, incomplete recovery and disaster recovery for oracle 11g.
• Set up, configured and maintained data guard for oracle 11g(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Installed OracleGolden GateforEBS ReportingDatabases.
• Installed, configured and supported Golden Gate (11g)replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Performed Daily Health Check Up of the Database using STATSPACK, AWR, ASH, ADDM, TKPROF, and EXPLAIN PLAN.
• Perform Applications administration using AD utilities.
• Periodic cleaning of Log/Output files.
• Worked on User management (i.e., creating users, profiles and privileges) and Storage Management (i.e., Managing Space, Table spaces, Segments and Extents).
• Monitored databases and applications using Oracle Enterprise Manager (OEM) and Oracle Applications Manager (OAM).
• Used utilities exp, imp, expdp and impdp to import schemas.
• Performed System Administration activities and monitored the file systems on production environments.
• Used shell scripting controlled from Crontab for the automation of job Scripts to Startup, Shutdown and Health Check of Databases and of various concurrent processes as well as FTP process.
• Resolved issues related to Web server, forms and reports.
• Responsible for platform migration of Oracle Applications R12.
• Supported EBS with Oracle Access Manager.
• Good Knowledge in Data Modeling tools like Erwin.
• Troubleshooting the issues raised by user community and development.
• Maintenance of Concurrent managers and Parallel concurrent Process.
• Maintained concurrent processing requests and concurrent managers.
• Debugged Oracle Reports and Oracle Forms programs.
• Provided go-live support for upgraded Oracle Applications.
• Configured load balancing on Apache and Forms Servers.
• On-Call 24x7 DBA support for very large databases.

Environment: Oracle Applications 11.5.10.2, R12.1.1, R12.1.3, Oracle 11g, AIX Oracle Enterprise Linux, AIX 7.1, RHEL, OEM, SQL plus, SQL Loader, Toad, Oracle RAC Grid Control, ASM and Data guard, web logic, DELL STAT.

Confidential, Framingham,MA

Sr. Oracle Apps DBA

Responsibilities:

• Installed 12c cloud and migrated all the databases from 11g to 12c RAC (4 node).
• Performed RAC all nodepatching and Rollingpatching.
• Upgraded EBS from 11.5.10.2 to R12.1.1 and R12.1.1 to R12.1.3.
• Migrated Solaris EBS R12.1.1 database to Redhat Linux using export/import utility.
• Configured ASM file system and administered ASM Instances and Disk Groups in RAC.
• In depth knowledge and experience with RapidInstall, RapidClone, adadmin, adsplice, adctrl and adpatch utilities for Oracle Applications.
• Performed Cloning and Refreshing on Applications and Databasesusing RAPIDCLONE.
• Performed WebLogic installation, clustering, domain configuration and load balancing.
• Configured backup of ERP systems using RMAN and performed database cloning using RMAN as well as scripts.
• Set up, configured and maintained data guard for oracle 11g(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Installed OracleGolden GateforEBS ReportingDatabases.
• Installed and Configured Golden Gate for replication of production databases to Report Database and troubleshoot Golden Gate issues.
• Involved in the Cloning and Patching of Oracle Databases and Oracle Applications (11i, R12).
• Performed Daily Health Check Up of the Database using STATSPACK, AWR, ASH, ADDM, TKPROF, and EXPLAIN PLAN.
• Worked on User management (i.e., creating users, profiles and privileges) and Storage Management (i.e., Managing Space, Table spaces, Segments and Extents).
• Applied patches whenever necessary by downloading from Metalink.
• Implemented shared APPL TOP in 12.1.1 and 12.1.3.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) and Oracle Applications Manager (OAM).
• Used shell scripting to automate Startup, Shutdown and Health Check of Databases, Analyzing of Tables and Rebuilding of indexes.
• Responsible for platform migration of Oracle Applications R12.
• Supported EBS with Oracle Access Manager.
• Implemented EBS security that leverages technical options with customers’ demands.
• Performed System Administration activities and monitored the file systems on production environments.
• Good Knowledge in Data Modeling tools like Erwin.
• Perform Applications administration using AD utilities.
• Maintenance of Concurrent managers and Parallel concurrent Process.
• Used utilities exp, imp, expdp and impdp to import schemas.
• Conversion to Multi-Org using ADAADMIN utility.
• Periodic cleaning of Log/Output files.
• Maintained concurrent processing requests and concurrent managers.
• Debugged Oracle Reports and Oracle Forms programs.
• Provided go-live support for upgraded Oracle Applications.
• Configured load balancing on Apache and Forms Servers.
• Troubleshooting the issues raised by user community and development.
• On-Call 24x7 DBA support for very large databases.

Environment: Oracle Applications 11.5.10.2, R12.1.1, R12.1.3, Oracle 11g, AIX Oracle Enterprise Linux, AIX 7.1, RHEL, OEM, SQL plus, SQL Loader, Toad, Oracle RAC Grid Control, ASM and Data guard, web logic.

Confidential, San Diego, CA

Sr. Oracle Apps DBA

Responsibilities:

• Installed and upgraded Oracle applications 11.5.10.2 to 12.1.1.
• Installed and configured Oracle 11gR2 RAC using ASM.
• Implemented Oracle 11g new features like Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Worked on Linux 5.8 operating systems and Solaris 10 operating systems.
• Upgraded and migrated databases from Oracle 10.2.0.5 to 11.2.0.4.
• Involved in the Design and implementation of oracle 11g data guard both physical/logical standby databases in high availability mode.
• Monitored Data Guard configurations on standby database using Data Guard broker.
• Implemented Data Guard and Stand-by databases for fail-over and recovery.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Periodic refresh and preparation of release environments and databases for Install Testing.
• Strong experience in implementing and configuring Single Sign on (SSO) and Oracle Internet Directory (OID) with Oracle Applications R12.
• Performed capacity planning before implementing the architecture for R12.
• Hands on experience with RapidInstall, RapidClone, adpatch, adadmin, adsplice and adctrl utilities for Oracle Applications.
• Expert in Tuning Oracle Applications, Concurrent managers, Apache, Forms and Reports servers.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent manager operations.
• Good understanding of the Oracle Applications Release Process, architecture of Automated Release Updates.
• Creating Code Check-ins and testing them once the developers provide code builds and validate check-ins patches through Automated Release Updates.
• Creation of Application instances and database for the development and production environment.
• Optimized R12 Performance via OC4J Load-Balancing.
• Creation of users and assigning responsibilities. for offshore team.
• Taking periodic backup of Applications & Databases.
• Application of Patches as and when need arises.
• Conversion to Multi-Org using ADAADMIN utility.
• On-Call 24x7 DBA support for very large databases.

Environment: Oracle 10g, 11g Grid, Oracle applications 11.5.10.2, 12.1.2, Solaris 10, Redhat 6, TOAD, Sql Loader, RMAN, Oracle RAC Grid Control, ASM and Data guard, web logic.

Confidential, Ann Arbor, MI

Oracle Apps DBA

Responsibilities:

• Installed, upgraded and maintained Oracle 10.2.0.5 on Sun Solaris 9 and Redhat4.
• Applied Patches 10.2.0.5 and Oracle DST Patches on Oracle 10.2.0.4 database.
• Troubleshoot issues encountered during patching of environment.
• Implemented Cloning using Rapid clone, Autoconfig and adclone utility.
• Clone environment for various user testing.
• Enabled SSO for Oracle Apps.
• Supported the 2- node RAC enviornement.
• Troubleshooting Jserv and Apache Issues related to Hardware Load Balancer and Multiple JVMs
• Refreshing of Databases from Production to development servers and adding Table spaces, scheduling dba jobs for alerts.
• Enabled SSL for Apache for front end access using VIP.
• Enabled PCP to allow concurrent managers to failover and back using 2 node CP tier.
• Experienced on Migrating 10g AS from Solaris to UNIX.
• Worked with Oracle on user issues by logging SR for upgrade specific problems.
• Periodic refresh and preparation of release environments and databases for Install Testing.
• Maintaining the Oracle Applications System including Oracle databases, Middle tier iAS, Applications tier for testing patches.
• Performed Database refreshes using hot and cold backups.
• Download and stage patches to various environments.
• Apply DST and CPU patches to enhance security.
• Creation of users and assigning responsibilities for offshore team.
• Taking periodic backup of Applications & Databases.
• Application of Patches as and when need arises.
• Analyze patches from Oracle, check pre-requisites, coordinate patch release
• Coordinating with Oracle Corporation for raising the Tar’s and supported activities.
• Conversion to Multi-Org using ADAADMIN utility.
• Periodic cleaning of Log/Output files.
• Script writing and execution on UNIX, LINUX and Windows environments.
• Automated cloning using OAM for release 11.5.10.2
• Installed EM grid agents for centralized monitoring.
• On-Call 24x7 DBA support for very large databases.

Environment: Sun Solaris 5.10, Oracle RDBMS 10G(10.2.0.2), Oracle ERP: E-business Suite 11i (11.5.10.2), AP, AR, PO, HR, ONT, JDeveloper 9i, Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)

Confidential

Oracle Apps DBA

Responsibilities:

• Installed, Created and maintained 3 Node 10g RAC with ASM and created database for production, development and test environment on HP-UX platform.
• Migrated oracle database from 9.2.0.8 to 10.2.0.5 (RAC)
• Maintained concurrent processing requests and concurrent managers.
• Debugged Oracle Reports and Oracle Forms programs.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Participated in converting data files across different platforms using RMAN convert, Transportable Table spaces (TTS), Export/Import and Data pump (expdp/impdp).
• Managed and maintained database and user security using OEM Grid Control.
• Created and monitored the concurrent managers.
• Capacity Planning/Management (space/machine load/network)
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Resolved system errors, disk space problems, huge file sizes errors
• Monitoring Oracle Applications users
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.)
• Used shell scripting to automate all RMAN jobs.
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server
• Performed Application admin tasks using ADADMIN utility
• Monitored the Applications and database using OAM.
• Effective use of Oracle Web cache with multiple applications.
• Moved the objects from one instance to other using FNDLOAD.
• Prepare and implement system management and maintenance procedures
• Troubleshooting and on-call support (7x24)

Environment: Oracle Applications 11i (11.5.4), Oracle RDBMS 9i (9.0.2), Sun Solaris 5.8, GL, AP, AR, FA, INV, OE, OM, PO, OSM, BOM. TOAD, Sql/PLSql, UNIX scripting

Confidential

Oracle Apps DBA

Responsibilities:

• Responsible for both managing and supporting all Production, Development and Test instances of Oracle Applications 11.5.10.2, 11.5.9.
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgraded 11.5.9 to 11.5.10 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• Setting up of printers In the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and development of major processing at the back-end through DB-Triggers, Stored Packages and Procedures using SQL and PL/SQL and SQL.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.

Environment: Oracle 10g, Oracle Applications 11i, Sun Solaris, Red Hat Linux, RAC, Oracle Enterprise Manager, SQL, PL/SQL, TOAD,ASM, RMAN, TKPROF, Explain plan, ADDM, AWR, STATSPACK, SQL* Loader

Confidential

Oracle Apps DBA

Responsibilities:

• Installed, upgraded and maintained Oracle 10.2.0.3 on Windows 2003.
• Installed and maintained Oracle application 11.5.9.
• Applied patches on both Server side and Client side.
• Responsible for managing production, development & test databases and applications.
• Estimation and creation of Control file, Log file (including multiplexing), Data files, Table spaces and rollback segments.
• Implemented Hot, Cold and RMAN Logical backup plans.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Generated PL/SQL blocks proficiently using dynamic cursors.
• Maintained concurrent processing requests and concurrent managers.
• Debugged Oracle Reports and Oracle Forms programs.
• Prepared various analysis documents and manuals for better understanding of the business process which are in company specific format.
• Performed code performance tuning (rule based and cost based) and optimization using Execute Plan, TK Prof and Trace files generating indexes and providing hints.
• Loaded data from flat file into the Oracle system developing SQL* LOADER scripts.
• Wrote shell scripts to automate the data loading.
• Implemented Hot, Cold and RMAN Logical backup plans.
• On-Call 24x7 DBA support for databases.

Environment: Oracle 10g, Sun Solaris 9, SQL, PL/SQL, SQL* LOADER, SQL* PLUS, TOAD, AD Utilities, RMAN