SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with 8 plus years’ experience in Oracle under UNIX environment.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications
• Experienced and proficient with Oracle E - Business suite application (R 12 12.1.3/12.1.1/12.0. x, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Sun Solaris, Oracle Enterprise Linux, Red Hat Linux, AIX and Windows environment
• Expertise in upgrading Oracle Applications from 11.5.10.2 to 12.0.4/12.1.1/12.1.3
• Configuring Oracle RAC utilizing Veritas Cluster Service, Golden Gate.
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing
• Expertise in Implementing SSL for Oracle E-Business Suite Applications
• Expertise in implementing Shared APPL TOP and PCP
• Expertise in troubleshooting Workflow and Notification Issues
• Implemented Sabrix Taxing Software and integrated with 12.0.4 Applications
• Expertise in installing Discoverer and integrating to ERP Applications
• Implemented 10g Grid Control and applied Applications Management Pack for monitoring Applications
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues
• Proficient in Oracle tools and utilities (Net8, Svrmgr, WebDB, OAS 4.0.8, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, OEM, IA, SQL Navigator, DB Artisan, ER Studio, Glance, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Experience in general troubleshooting, fire fighting, development of scripts, documentation, issue resolution, and TAR/SR support
• Well versed in implementing System Management and Monitoring procedures
• Strengths include skills in Shell Programming, SQL, SQL*Loader, Import/Export and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings
• Experience in Security Management and Database Auditing
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX)
• Troubleshooting Login, Self Service Application, JInitiator and Network related issues
• Skilled in handling a heavily customized 11i applications and upgrades
• Applying RDBMS and Application patches. Sound knowledge in AD Utilities
• Enabling Multi Org, MRC, NLS settings
• Monitor system performance, identify bottlenecks and ensure problem resolution
• Capable of tuning SQL using EXPLAIN PLAN, tracing at user level and TKPROF
• Work independently to ensure that the databases are operating efficiently and ensure proper backup and disaster recovery methods are maintained
• Experienced in Space Management, Memory Tuning and Application Tuning
• Troubleshooting expertise for all tiers (client, middle-tier, database)
• Create and Maintaining the Technical Notes and Documentation.
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities with excellent communication skills.

TECHNICAL SKILLS

Hardware Platforms: Sun SPARC (E10000, E3500, E250, SUN Ultra and R Class), IBM AIX, IBM compatibles (IBM AIX 5L/4.3), Dell PowerEdge

Operating Systems: Red Hat Linux 4/3, Oracle Enterprise Linux 5.5, UNIX (HP UX 11/10.1/10.20 , Solaris 8/2.4/2.6/2.7 , SCO, IBM AIX 5L/4.3), MS-WINDOWS XP/2000, MS-WINDOWS NT 4.0 Enterprise edition

Database: ORACLE 11g/10g (10.2.0.3), 9i (9.2.x), 8i (8.1.x)/8.0

Forms Servers: Developer 10g/9i, dev2000 (1.6.1 and 1.3.2, 1.5.1), Dev6i

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

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Applications: Oracle Applications R 12.2.2/12.1.3/12.1.1/12/0. x, 11i (11.5.7, 11.5.8,11.5.9, 11.5.10,11.5.10.2, 12.2.2, 12.2.4), JDA, Vertex, EZTax, Moneta

Modules: AOL, GL, INV, AR, AP, PO, Iprocurment, HRMSSupply chain modules,Order Management, Install Base, iStoreIPayments, BI Dash board

GUI: DEVELOPER 6i, ADI, OAM, OEM, Kintana, Quest Stat

Tools: and Utilities: Oracle Tools OEM/OAM, SQL*PLUS And third party tools like Clear orbit, Jet forms, Quest Software (TOAD, SQL Lab) etc

Advanced Technology: Distributed Databases (Advanced Queuing, Materialized views), High Availability Options (Real Application Cluster (RAC) and Standby Databases) and Performance (Database, locking, parallel execution, partitions and SQL tuning)

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Sr .Oracle Apps DBA

Responsibilities:

• Managed a successful upgrade from 11.5.10.2-12.2.2 on an AIX 6.1 environment.
• Maintained stability in the process of the upgrade in a 6 multi node application environment.
• Upgraded and configured best practice of ISupplier Node as an external node with DMZ setup.
• Coordinated with Sysadmin team in process of implementing Load Balancer setup between 4 web nodes in R12.2.2.
• Configured load balancer for external node and helped sysadmin team to install certificate on load balancer.
• Upgraded OPatch to 11.2.0.3.6 as part of requirement for the R12.2.2 upgrade.
• Ran the checkDBpatch.sh as part of identifying database one off patches to be applied prior to applications upgrade.
• Applied Pre database patches, pre module level patches and also post patches as part of R12 patching activities.
• Upgraded the jdk version from 1.4.2 to 1.7.0 for AIX operating systems.
• Coordinated with sysadmin team in upgrading AIX operating system from 5.3 to 6.1 as an R12 requirement from OS side.
• Analyzed the long running jobs as part of American English Upgrade driver and tuned them for better performance.
• Provided an instance strategy planning keeping insight of the activities ahead.
• Applied and configured Online patching functionality ADOP for R12.2 to keep both file systems in sync.
• Applied latest R12.AD.C and R12.TXK.C version Delta 5, 12.2.2 driver patch and support patches for stabilization and better performance for the environment.
• Run prepare, apply, finalize, cutover, fsclone as part of ADOP activities for preparation of patching in R12.2 environments.
• Added more oacore servers and form servers in weblogic for accommodating more users and better performance on the applications.
• Configured and personalized heap sizes for weblogic Adminserver and Managed servers based on the environment requirement.
• Troubleshooted issues with Enterprise Manager and used it to monitor managed servers.
• Built DEV, TST, SIT and UAT environments as milestones for reaching to PROD upgrade.
• Setup and configure Workflow Notification Mailer with 12.2 specifications.
• Added nodes to existing environments and also Cloned R12 environments.
• Troubleshooted issues with boundary systems and managed interfaces coming to the ERP.
• Upgraded Vista Plus to make it compatible to R12.2.
• Coordinated with offshore team and troubleshooted issues from the user and development perspectives.
• Worked on administering Rel 12.2 oracle Applications.
• Performed multiple patching cycles with AD Online patching in 12.2.2.
• Maintaining Patch file systems of 12.2 applications and always keeping in sync with Run file system.
• Written many UNIX scripts to automate the process.
• Worked closely with Dev and QA team on their DBA related issues.
• Applied patches to E-Business suite and Oracle databases.
• Followed up with Oracle on SR for Database and application related issues on continuous 24/7 support if required.
• Troubleshoot ORA-errors in the Database.
• Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
• Expertise in installing, maintaining and administering Oracle Applications 11i (11.5.8, 11.5.9, 11.5.10, R12) instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Worked on SSL and Key stores.
• Worked on identifying and tuning of long running sqls.
• Perform Application and database tuning by analyzing the AWR reports.
• Applying SQL profiles to long running SQLs in OEM.

Confidential, San Jose, CA

Sr .Oracle Apps DBA

Responsibilities:

• Installation ofOracleEBS R12 and upgrade from 11i to R12.
• Administration of EBS 11i/R12 and Database like patching, cloning/refreshes, trouble shooting performance and other issues.
• Upgraded Database from 11.2.0.1.0 to 11.2.0.3.7.
• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Installing OracleGolden GateforEBS ReportingDatabases
• Oracle and SQL server Database Capture usingOracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden GateEXTORA, RMTHOST, RMTTRAIL
• Implemented Shared APPL TOP
• Troubleshooting the issues raised by oracle ERP from both user community and development
• Taking care of the performance issues both at the database level and applications level
• Scheduled the backups using RMAN and disk backups
• Supported multiple production, test and dev environments concurrently.
• Performed and supported Backup and recovery strategies.
• Experience working on RMAN Backups and recovery procedures.
• Monitor and tune performance ofOracleDatabases with GRID control.
• Custom code migrations and related setups on EBS.
• Worked in environments with ASM Storage system.
• Worked on setting up High Availability of the database using RAC, Standby, Data guard.
• Supported the data conversion team in resolving the issues on production database while conversions.
• Resolving the performance issues of concurrent programs.(sql tuning)
• Worked using export/import of schemas, tables etc., as per requirements.
• Worked on managing users, menus, responsibilities and other sysadmin responsibilities.
• Worked on resolving connectivity issues related to TNS entries and SQLNET.
• Supported the Discoverer admin.
• Worked on resolving SSO related issues.
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, ADCTRL.
• Assisting developers with coding PL/SQL.
• Worked on Configuring Workflow Notification Mailer, OAM.
• Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases (Data Guard).Created agile schema after installing the database and copying the companion.
• Trouble shooting Forms server, Reports server, Apache server, Jserv, Jinitiator and Workflow.
• Expert in 11i Apps Cloning, Implemented new techniques for Apps Refreshes.
• Applied Patching, Upgrades, framework, SSL For 11i Apps.
• Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configuration.
• Created Database using EM and also copied agile companion codetree to make it suitable for agile environments.
• Installed agile application and configured on all the nodes.
• Installed AutoVue on Viewer host for agile environments.
• Installed SUN JDK (1.7.0 17), Weblogic 12c on application nodes.
• Configured Node Manager on weblogic servers. (Remote managed server start and stop.)
• Upgraded SOA from 11.1.1.5.0 to 11.1.1.6.0 .
• Expertise in Installation and Configuration of Apache HTTP 2.0 Web server and OHS 11g.
• Upgraded Webtier OHS from 11.1.1.5.0 to 11.1.1.6.0 , jrocket-jdk from 1.6.0 17 to 1.6.0 37 and also Weblogic from 10.3.5 to 10.3.6.
• JDBC Connection Pool and Multipool configuration with Oracle.
• JMS Configuration and Setting up Topics, Distributed queues, connection factories.
• Installed Oracle Weblogic (11g /10g/ 9i), SOA 11g on Red Hat Linux and Windows Environments.
• Handling all the aspects of administration tasks such as day-to-day site monitoring and maintenance, Installation, Configuration, Clustering, Deploying Applications, Troubleshooting, Load Balancing, Performance Tuning and Maintenance of WebLogic Server.
• Proficient in Weblogic and SOA Administration activities such as Upgrades, Patches.

Confidential, NYC, NY

Sr .Oracle Apps DBA

Responsibilities:

• Managed upgrade project from 11i/10g to R12/11g HA implementation on AIX in an 11g RAC environment.
• Part of implementation 11g RAC in all non-production environments.
• Instituted proactive performance monitoring measures (using ADDM, AWR) to ensure SLA performance goals.
• Implemented SSO/OID - AD to OID and EBS to OID
• Oracle eBusiness 12/11i HRMS suite (PAY, PER, BEN, etc.)
• Self-service Web Applications (I Procurement, I Store).
• Availability clauses which included RMAN setup and configuration and Data Guard installation.
• Configuring Replicat ParametersASSUMETARGETDEF, REPOR, DISCARDFILE
• CreatingGLOBALS for GoldenGate and Adding database Checking points
• Worked On DB2 server and also offered DBA DB2 support for application development team
• Configured Clusters on WebLogic using WebLogic Console.
• Building bothwebas well as J2EE applications using ant scripts and source from MKS.
• Performed WebLogic installation, clustering, domain configuration, load balancing and performance tuning
• Helped in work with File Adapter, Database Adapter, AQ Adapter, JMS Adapter and Oracle Applications Adapter for establishing connection with services in BPEL.
• Helped in building BPEL processes that subscribe to various EBS events around sales order processing functionality and participate in database and JMS transactions. Used the various activities available in BPEL to perform transformations and write business logic
• OSB (Oracle Service Bus) is used to create wrapper for the services developed in Jdeveloper
• Switch activity to create logical flow in BPEL processes for Order Reprocessing
• JMS adapter was used for Producing and consuming the messages.
• Created JMS queue and topics for message transfers
• Experience on various modules such asFinancials, MFG, CRM,AR, AP, GL, PO, HRMS and INV.
• Applications/DatabaseCloning & Refresh using RAPIDCLONE
• Implemented EBS security that leverages technical options with customers demands
• Upgraded Oracle Applications from 11.5.10.2 to R12.1.3
• Supported the 2- node, 3-node, 4-node RAC environment.
• Provided go-live support for upgraded Oracle Applications
• Configured Clusters on WebLogic using WebLogic Console.
• Performed WebLogic installation, clustering, domain configuration, load balancing and performance tuning
• Cloning and Patching of Oracle Databases and Oracle Applications 11i/R12
• Troubleshooting the issues raised by user community and development
• Responsible in platform migration of Oracle Applications R12.
• Supported EBS with Oracle Access Manager.
• Discoverer 10g Installation and configuration, EUL upgrade and refresh.
• Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Configured load balancing on Apache and Forms Servers
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, TKPROF & Stats pack.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) /Oracle Applications Manager (OAM)
• Configured backup of ERP systems using RMAN.

Environment: Oracle Applications 11i (11.5.10.2), R12.1.3, Oracle 10g/11g, AIX Oracle Enterprise Linux, RHEL, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, San Diego, CA

Sr. Oracle Apps DBA

Responsibilities:

• Implemented upgrade from EBS 11.5.10.2 to R12.1.2 while also upgrading underlying database. Part of the pre and post GO LIVE team for production support. Currently resolving underlying GO LIVE performance issues. This is a 3TB environment on Oracle Solaris 10. Installed and configured Weblogic 11g and OID 11g. Implemented Financials and HRMS modules.
• Monitoring the Oracle applications and provided 24x7 On-call support
• Managing the patches and dealing with Oracle Support for many production and test/development Instances.
• Cloning of Oracle Applications 11i RAC to RAC and RAC to Non RAC.
• Upgraded Oracle Applications from 11.5.10.2 to R12
• Upgraded 9i database to 10g (10.2.0.4) database
• Post go-live support of Oracle Applications R12
• Maintenance of 10g databases and other non-ERP Databases
• Implemented parallel concurrent processing in R12
• Configured ASM on one of the Prod OLTP instance.
• Cloning DEV and UAT instances from Production for testing
• Providing support for Oracle applications and also Vertex
• Implementing and troubleshooting of forms server, report server, Discoverer server, Web Server.
• Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Worked on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listeners running, disk space availability, checking for errors in alert logs etc.
• Setup a Crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc
• Worked on Application system Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs.
• Implemented Dataguard (Physical Standby database set up in production)
• Successfully implemented 3-node RAC setup and made the environment stable
• Configured load balancing on Apache and Forms Servers
• Applied the Patchsets, one-off patches, OPatch to the Development and production servers
• Monitoring of databases using 10g OEM grid control
• Implemented the Oracle E-business suite Application Management Pack on OEM
• Recovering the databases at critical situations
• Worked with Oracle Support on resolution of SRs
• 24x7 on call support for Oracle ERP applications and production databases

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Sun Solaris10, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, Atlanta, GA

Oracle Apps DBA

Responsibilities:

• Monitoring of multiple production instances of versions R12 & 11i residing on various Operating systems such as Linux, HP-UX.
• Supported 4 highly volume based production instances and 10 dev and test systems.
• Multi-node installation of R12 applications.
• Upgraded applications from 11.5.10 CU2 to R12.
• Patching and Cloning of Oracle Applications using adpatch &Rapid clone utility.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) /Oracle Applications Manager (OAM)
• Configured backup of ERP systems using RMAN.
• Developed Shell Scripts for daily monitoring of databases, Applications, RMAN backup and backup validate.
• Supported the 2- node RAC environment.
• Upgraded database from 10.2.0.4 to release 11.1.0.6
• Discoverer 10g Installation and configuration, EUL upgrade and refresh.
• Providing high database availability and data protection using Data Guard.
• Installed Oracle Data Integrator 10.1.3.5 to integrate with PeopleSoft GL modules.
• Configuring and tuning concurrent managers.
• Perform system administration tasks like application AOL object setup (users, menus, responsibilities, forms, reports, folders, request groups, request set etc.) and Purge AOL tables.
• Responsible for Java Mailer Configuration and Workflow Administration.
• Creation of new users and assigning of responsibilities.
• Successful set up of a new custom Schema and making it fully functional.
• Analysis and application of both apps and database patches.
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, Tkprof & Stats pack.
• Assisting users in resolving the printer related issues and setting up new printers.
• Developed Unix Shell scripts and SQL queries
• Worked on TAR, coordinating with Oracle for SEV 1/2 issues.
• Provided 24 x 7 on call support for Production databases.

Environment: Oracle Applications R12 (12.1.1/12.0.6 ), 11i (11.5.10.2), Oracle 9i/10g, Sun Solaris 8, Netapps, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, Tampa, FL

Oracle Apps DBA

Responsibilities:

• Created and monitored the concurrent managers.
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Oracle Applications upgrades, patches using various AD utilities
• Troubleshooting and on-call support (7x24)
• Resolving 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.)
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF STATSPACK.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Monitored the Applications and database using OAM.
• Rebuild the Indexes and dropped unused indexes.
• Setting up the printers in Application environment.
• Upgraded JDK 1.2 to 1.4.1
• Troubleshooting throughout the project phases and TAR Management
• Effective use of Oracle Web cache with multiple applications.
• Capacity Planning/Management (space/machine load/network)
• Moved the objects from one instance to other using FNDLOAD.
• Performed Application admin tasks using ADADMIN utility
• Cloning of Database and Applications
• Prepare and implement system management and maintenance procedures
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server

Environment: Oracle Applications 11i (11.5.10.1), Oracle 9i/10g, HP UNIX TRU-64, Precise, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer, JDK 1.2/1.4.1

Confidential

Oracle Apps DBA

Responsibilities:

• Cloning of Oracle APPS 11.5.9 Instance on HP-UX 11.11 platform
• Upgraded Oracle Applications 11.5.9 to Oracle Applications 11.5.10 on HP-UX 11.11 platform
• To tune and configure Oracle 8i Database for optimum performance.
• Provided production support.
• System Administration of release 11i
• Applied the patches using ADPATCH
• Setting up of printers
• Developed backup scripts for Application 11.5.10
• Created Responsibilities and Application Users
• Performed Application admin tasks using ADADMIN utility
• Maintenance of Concurrent Managers
• Verified all instances are up and running
• Verified that all Application Services are on-line
• Resolved Jinitiator issues.

Environment: Oracle, Oracle Applications 11.5.9/11.5.10 E-Business Suite, OEM, SQL*plusImp/Exp, RMAN, SQL, PL/SQL, SQL*loader, tkprof, HP-UX 11.11.

Confidential

Oracle Apps DBA

Responsibilities:

• Reorganization of the Database using export import Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.9, 11.5.10
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgrading the Base install 11.5.9 to 11.5.10 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• 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, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.

Environment: Oracle, Oracle Applications 11.5.9/11.5.10 E-Business Suite, OEM, SQL*plusImp/Exp, RMAN, SQL, PL/SQL, SQL*loader, tkprof, HP-UX 11.11.