SUMMARY

• 15 Years of total experience with 13 Years of experience as an Oracle Application DBA Consultant in full life cycle implementations and up gradation of Oracle e - Business Suite applications, Providing *24/7 Support on Production Instances and training.
• Expertise in Performance Tuning, Migrations, Scripting, Disaster Recovery techniques, Backup & Recovery for Oracle 10g RAC, 9i, 8i Databases using shared Storage (SAN/NAS).
• Have good knowledge in e-Business Suite Architecture.
• Installation of Oracle Application with single node and multi nodes in R12 and 11.5.10.2 on Linux/Unix environments.
• Good at applying patches of Oracle Applications and Maintenance using AD Utilities.
• Performing Regular Application Health Checkups.
• Monitoring Concurrent Manager and Troubleshooting.
• Expertise in setup, configure and maintain RMAN, Data Guard and ASM components.
• Experience with OEM, OAM and Oracle Grid-control.
• Expertises in configure Discoverer 10g with Oracle Applications R12.
• Up gradation of Oracle database from 9.2.0.6 to 9.2.0.8 and 10g to 11g and also Oracle Application from 11.5.10.2 to R12.
• Configuration and Troubleshooting of Workflow Notification Mailer.
• Expertise in Configuration of Oracle Discoverer 10g.
• Capacity planning, monitoring, auditing, database/application performance optimization and other tasks.
• Ability to multitask be flexible under pressure, and work with changing priorities in a dynamic environment.
• Manage project - task estimation, planning, risk mitigation analysis, etc.
• Very good experience working with Oracle Applications as Technical Developer.
• Worked with Oracle for resolving critical and transactional issues through SR’s and OWC’s.

TECHNICAL SKILLS

Database: Oracle 9i, 10g, 11g RAC, MS SQL Server 2000 & 2005, MS Access.

Middleware: Oracle Application Server 10g, WebLogic, SSO, OID, LDAP.

Hardware&OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003.

Programing: SQL, PL/SQL, Shell Scripts, C, HTML, JavaScript and XML.

NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet.

Tools: & Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control.

Oracle Tools: Dev.2000 (Forms 10g/6i/4.5, Reports 10g/ 6i), Discoverer 10g/6i/4i, SQL*LOADEROracle SQL Navigator, TOAD, RUEI

ERP Modules: Oracle Applications R12/11i(Oracle Receivables, Oracle Payables, General Ledger, Purchasing, Order Management, Shipping, Fixed Assets, Cash Management, Inventory, Advance Pricing, Oracle Workflow, Oracle e-Commerce Gateway and Oracle Projects (PA), iExpenses, iProcurement, iSupplier, Oracle HRMS and Oracle Payroll, Bill of Materials, Quoting, Inventory, Configurator, Integrated SOA Gateway.

Methods: Oracle Applications Implementation (AIM) Methodology.

Others: SAN/NAS, Vmware, VERITAS Net Backup.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Apps DBA Lead

Responsibilities:

• Worked on Upgrade of Oracle Applications from 12.1.3 to 12.2.4
• Integration of E-Business Suite with Oracle SSO 11g (Single Sign on)/OID (Oracle Internet Directory), Oracle Access Manager ( OAM ) with LDAP (Microsoft Active Directory) configuration.
• Administration and managed Web logic Server 11g
• Apply online patches (ADOP) to the production environment in Oracle EBS 12.2.4.
• Coning from Prod to Test/Dev environments.
• Extensively worked on managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
• Generated and analyzedSTATSPACK, AWR, ADDMreports and monitored statistics for performance tuning of the database.
• Monitor all the production Alerts and do necessary changes in the production
• Support 24x7 Support in all the production environments.
• Worked extensively with production support tickets with proper SLA's and admis
• Oracle Support (Metalink) SR maintenance and administration.

Environment: Oracle EBS 12.1.3, Oracle 11.2.0.4, RH Linux 5.7, Weblogic11g, SSO/OID/OAM 11g

Confidential, Chicago, IL

Oracle Apps DBA

Responsibilities:

• Implemented PGP encryption Program in Production to send the files to JPMorgan Bank in encrypted format. Worked with JPMorgan on PGP encryption testing and the Process.
• Implemented 3rd party tool LiveVault Web Management Portal to backing up the SSO EBS production servers.
• Implemented Load Runner 11.50 and created scripts to do load testing on HYATT HYPERIAN production servers.
• Setup DR and tested DR environment for Hyatt.
• Worked on SSO environment with Oracle On Demand.
• Proactively worked heavily to streamline workflow inbound/outbound notifications (I-Expenses) and cleaned up all the open notifications and filter all notification which are not valid.
• Involved daily regular Production support.
• Extensively worked on Patching and Coning.
• Created all the Process documents for Hyatt.
• Created Virtual machines on UNiX environment and install operating Systems Linux/Redhat for creating SSO environment using CITIX XenCenter.
• Ability to communicate with business users at all levels to resolve production issues.
• Monitor all the workflow notification IMAP server, backups, VM ware Servers.

Environment: Oracle Applications 11i/R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, Weblogic, WebCenter, SOA, OBIEE, HYPERIAN . VM’s

Confidential, Sunnyvale, CA

Oracle Apps DBA Support Lead

Responsibilities:

• Worked on Production DBA Lead to support multiple Production environments and Development Oracle Application environments.
• Developed shell scripts to automate some of the processes like Struck order, custom concurrent Managers, Workflow deferred agents.
• Developed queries for SOX control for production environments.
• Worked on Oracle Application 12.0.3/11i with 11.2.0.2 4 node RAC Database with WebCenter, WebLogic, SOA and OBIEE environment.
• Worked on SOA with BPEL/OBIEE and worked creation and supporting of WSDL’s for SOA in R12/11i Environment.
• Extensively worked on integration issue to figure out the SOA issues from SOA monitor with SOA users and Webservices.
• Extensively worked on Upgrades, Patches and Coning and Change Management Process.
• Worked extensively with Kintana tool for Production Migrations.
• Monitor all the production Alerts and do necessary changes in the production.
• Strong experience working with all boundery systems like PeopleSoft, Siebel, SOA, CMAT, SFDC.
• Extensively worked on OMC and troubleshoot OMC user issues and access.
• Worked extensively on weekly production major and minor releases.
• Support 24x7 Support in all the production environments.
• Worked extensively with production support tickets with proper SLA's
• Working with Oracle support: opening, managing, and resolving Oracle SR's.
• Created Process documents for all the releases and trained the onsite and offshore DBA's.
• Work closely with Development Team to identify potential future re-designs efforts supporting continuous improvement of the system.
• Ability to work with other infrastructure teams like Storage, UNIX, Tools and Windows etc.
• Documentation of solution knowledge and process monitoring techniques for re-use by Development and Support teams.
• Worked with Performance tools AXIBASE, BAC (Business Availability Center), RUEI (Oracle Real User Experience Insight).
• Trained off-shore DBA team and coordinate all the DBA activities.
• Created all the process documents for the Production environments.

Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, Weblogic, WebCenter, SOA, PeopleSoft, Siebel, CMAT, SFDC, OBIEE.

Confidential, St Louis, MO

Oracle Apps Dba/SysAdmin

Responsibilities:

• Implemented new feature in R12 Role Back Access Control (RBAC) in User Management for Financial modules, HRMS, Quality and Advanced Supply Planning.
• Migrated FSG Reports from one instance to other instances.
• Worked on implementing Report Manager (Web based FSG reports) new feature in R12.
• Worked on migrating objects from one instance to other.
• Experience in managing and working through Oracle's TAR escalation process.
• Ability to work closely with users, cross-functional teams and external vendors.
• Ability to multitask be flexible under pressure, and work with changing priorities in dynamic environments.

Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, SQL, SQL*Plus, PL/SQL.

Confidential, MI

Oracle Apps Dba

Responsibilities:

• Worked on Cross platform Migration from HP-UNIX to Sun Solaris on Apps 11.5.10.2. in shared APPL TOP environment.
• Worked on migrating database nodes on R12 environment.
• Worked on the Oracle Diagnostic Tool.
• Worked on Forms & Reports 6i Patch 19 with Patch validation report.
• Deployed SUN JRE for E-Business Suite on 11i and applied interoperability Patch.
• Applied latest TXK AUTOCONFIG and TEMPLATE ROLLUP PATCH.
• Worked on advanced cloning for 11i and R12 instances
• Upgrade JAVA version.
• Worked on custom Forms and custom concurrent reports.
• Worked on ASM based databases with RAC.
• Patch Application to resolving and fixing bugs.
• Backup and recover databases using RMAN scripts.
• Apply Quarterly cumulative patch updates CPU.
• Troubleshooting Apache and Jserv.
• Worked with Oracle for resolving critical production issues.

Environment: Oracle Applications R12/11i, Oracle 11g/10g, Oracle Application Server 10g, SunSolaris, Database Grid Control, SQL, SQL*Plus, PL/SQL, SQL*Loader

Confidential, San Jose, CA

Oracle Apps Dba

Responsibilities:

• Worked on Application upgrade from 11.5.10.2 to R12 (12.1.1).
• Worked on Cloned appsTier, dbTier and apply patches.
• Configured 4 node 11gRAC setup on Linux5 platform and Performed GRID home and RDBMS home from RAC systems using SAN.
• Worked on cross platform migration (Solaris to Linux), upgrading from 10g to 11g database and perform auditing between the source and the target databases.
• Worked as support Dba in all CISCO databases.
• Worked on Hyperion Environment.
• Worked with Oracle for resolving critical and transactional issues through SR’s

Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, SQL, SQL*Plus, PL/SQL, SQL*Loader

Confidential, Atlanta, GA

Oracle Apps Dba Lead

Responsibilities:

• Involved in Real Application Clusters installation and creating the RAC databases using raw devices and asm instance.
• Migrated from NON-RAC database to RAC database.
• Successfully Added node to the existing cluster database.
• Implementing sound backup and recovery strategies, for rac databases using rman according to the SLA. Taking the backup of voting Disk and OCR as per the backup policy.
• Monitoring and administrating rac database using utilities like srvctl, crsctl, crs stat, olsnodes and ocrconfig.
• Configured Flash Recovery Area, monitoring and working with FRA.
• Created ASM instance and disk groups.
• Migrated non ASM based database to ASM based database.
• Cloning the production database and refreshing the test and development databases to synchronize with production database.
• Perform regular database activities like database health check up, space management.
• Monitoring the scheduled jobs and solving any issues related to failed jobs.
• Managing Tablespaces, Data files, Control files, Redo Log files and Archived logs.
• Applied Interim and Patch set Patches.
• Upgraded database from 9i to 10g.
• Security Administration by creating Users with appropriate ROLES and PRIVILEGES.
• Monitoring the System response time and detect for any bottlenecks by using AWR reports and ADDM reports.
• Used Oracle Diagnostics tools such as SQL Trace, TKPROF to analyze timing and execution plan for SQL query to tune the SQL statements.
• Rebuilding the Fragmented Indexes, Pinning or Unpinning Objects like PL/SQL packages, procedure, functions in Production environment to improve performance.
• Keep track of invalid objects and compiling them.

Environment: Oracle 11g/10g, RMAN, SQL Server 2000 & 2005, Oracle Application Server 10g, Red Hat Linux, Database Grid Control, Windows 2003, HP, Toad, Verities Netbackup.