SUMMARY:

• Exp on Oracle Applications R 12, Rational Rose Design Tool and on Project Management Professional guidelines from PMI (USA), more than Fourteen years of hardcore Oracle Database including RAC and Data guard setup /Oracle Applications 11i/R12/R12.1 with AIA, SOA Administration experience, including operations as Installations, Performance Tuning, Upgrade, Enhancement & Service Support, working on - site both Nationally & Internationally, in IT sector, gaining insightful experience & expertise in Management of Full Life Cycle Commercial Applications, seeking senior level leadership challenges in IT infrastructure.
• Trained competence through on Oracle Applications R12, Oracle Application Integration Architecture (AIA), Rational Rose Design Tool and on Project Management Professional guidelines from PMI.
• Skilled expertise in SQL Tuning and Performance tuning of Oracle Applications (from 11.0.3 to 11.5.10.2/Rel12 and Rel12.1)
• Expertise in SOA Administration JVM and OC4j tuning, Heap size, Garbage collection and Failover for BPEL and trace and log
• Expertise in configuration and installation of 11gRAC and 10g/11g Data guard in different protection modes as per the company requirement.
• Golden Gate configuration in unidirectional replication.
• Presently working on R12@exadata, Exadata Cell, Flash cache 384GB Flash cache or5.2TB for the cluster Working on capacity planning and ROI.
• Core competence in Oracle Applications Upgrade/Point Migrations, Enhancement & Service Support of Oracle Products & Applications
• Skilled expertise in RMAN for backup and restore, Golden gate, Database Creation/Tuning/Reorganization, SQL Statement Tuning, Backup/Recovery, General Troubleshooting, Crisis Management, Capacity Planning and Planning Disaster Recovery Strategy, Developer/Integrator Relations, Script Development, Documentation and DBA .
• Proven proficiency in Installation of Printers, Parallel Concurrent Processing and Rapid Clone as well as Apply Patches to Oracle Applications.
• Hands-on experience & expertise of Installation, Upgrades, Patches, TAR Support, Database Tuning, Concurrent Manager Administration, Cloning and Oracle Apps SYSADMIN functions.
• In-depth Functional competence in Oracle Applications like AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, BIS, FII, I Procurement and OPM.
• Similar competence in Pre Sales Technical Support like Proof of Concept, Presentation, RFP Analysis and Techno-commercial Proposal/Negotiation etc.
• Assertive Leadership & Team Management abilities in task planning, activity allocation, target scheduling, monitoring, feedback, issue resolution, motivation and guiding team to excellence
• Proven Team Leader and Committed Team Player with Fast Learning Curve along with strong analytical, problem solving, organizational, planning, communication & interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, California

Responsibilities:

• Responsible for Performance & Production to Oracle Applications to clients around the globe.
• Managing installation, upgrades, patches, TAR support, database tuning, concurrent manager administration and cloning along with Oracle Apps SYSADMIN functions.
• Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery and general troubleshooting.
• Involved in developer/integrator relations, script development, documentation and DBA .
• Understanding business process, study and analyze workflow to design solutions.
• Participating in Pre Sales Support like Proof of Concept, RFP Study, Proposals etc.
• Re-Implementation and support of 11i to R12 and Oracle VM implementation.
• Code review for performance check and Oracle standards and perform periodic migration.
• Co-ordinate weekly & daily meeting with client for project forecast and support activities.

Exadata and Oracle Middleware Administrator

Confidential, California

Responsibilities:

• Worked with Oracle Exadata migration project from X2-8 to X3-8 full RAC.
• Worked with Exadata storage servers, database servers and InfiniBand switches maintaining, patching and upgrading to higher versions, troubleshooting with Cell servers and firmware
• Worked with performance tuning, cell offloading and smart scan, storage indexes, hybrid columnar compression, OLTP table compression and parallel operation
• Worked with Golden Gate 11g replication solutions to facilitate data flow between databases.
• Led and mentored the project team from both technical and functional perspectives including database development, data architecture, integration development, requirements identifications, testing, and project management.
• Statspack/AWR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, database growth
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Completed minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
• Set up a new database instance with Prod and Test Environment and provided database related support.
• Created a purge script to remove more than one-year-old data.
• Involved in designing Strategy for backup and recovery of Oracle Database instances.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Created automated backup scripts using exp/imp utilities for seamlessly refreshing the development/testing databases with production data.

Advanced Compression Implementation - Database

Confidential

Responsibilities:

• Implemented Advanced Compression - Solution Presented at Oracle Open World 2015
• During Phase 1 of Advanced Compression included implementing ILM, Advanced Compression and Space Reclaim. Size of undo was maintained as part of Month End Maintenance. This reduced the database size from 25 TB to 15TB.
• ILM was implemented with co-ordination between DBA’s, Functional Teams and Informatica Technical Teams.
• During Phase II implementation, Indexes on the tables currently being compressed were reviewed and Index compression implemented. This was expected to reduce space utilized by Indexes. Indexes were currently using 41% of the overall database size. Tables with small footprint constitute about 13% of the overall database size and growth rate has been stable. 6% of the current database size is utilized by tables, which have been compressed during Phase I of this project. Large tables have been further segregated into groups, and each group has been categorized into compression eligibility. Redefinition API/Alter Move for Advanced compression would be use to on tables to complete advanced compression) DBMS REDEFINITION- if the source table has PRIMARY Key associated). ALTER TABLE MOVE- if the source table does not have a primary key or the source table is less than 110GB in size

Oracle ERP Application Upgrade 11i to R12

Confidential

Responsibilities:

• Integration between Oracle Applications and Tax Engines: Analysis of low performance of Invoice Validation Program in Oracle Applications R12.0.3 was a major effort with the client, Oracle Development, Oracle Product Support and Oracle Consulting. Analysis was done on tables, indexes, sql id, db dictionary data, RPC calls, Java Execution as well plsql execution. The strange part was that ASH analysis reveals 88% from total time as Java execution and only 9% sql execution. SQL only for 30% of activity. Rest was accounted by Java and PL/SQL. Ultimately, using my knowledge of integration between Oracle and Tax ware, it was identified that the performance issue was with the tax interface to calculate taxes during order entry, due to the number of times that the system calculates sales tax on an order, then on the advice of Tax ware we cleared this option. Also, another Issue was identified more on the tax ware side, whenever any invoice is having Zero dollar Value then it was not able to count the tax and spin for long time. This issue was worked with Tax ware team which fixed it on their system.
• WebLogic Administration Monitoring and Troubleshooting using Admin Console Managing and Monitoring the JVM Performance by adjusting Web Logic heap size and garbage collection parameters maintain the applications among Web Logic run-time processes in a cluster of application servers Performance tuning of Web Logic server with respect to heap, threads and connection pools. Work with JProbe in-order to adjust JVM Heap Size and reduce memory leakage
• ERP Upgrade specialist for Oracle applications Suite from 11i to 12.0.6
• Oracle ERP Engineering Performance Lead to support database and CEMLI Tuning, Form session Tuning, Self-service application tuning. Generated Stats pack/AWR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth. Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries. Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database. Set up a new database instance with Prod and Test Environment and provided database related support.
• Oracle Database Administrator: Created a purge script to remove more than one year old data. Involved in designing Strategy for backup and recovery of Oracle Database instances. Perform root cause analysis on failures. Resolve performance tuning related issues and queries. Created automated backup scripts using exp/imp utilities for seamlessly refreshing the development/testing databases with production data. Using the AD utilities for maintaining the application systems (ad patch, adctrl, adadmin, adrelink, adsplice). Installation and administration of 11gR2 RAC. ASM, databased and scan listener on Linux and RAC Physical Data Guard MAA, Worked with designing logical and physical backup/recovery procedures.

Integration Performance Tuning Expert

Oracle EBS, Oracle SOA and Legacy Systems, Confidenti

Responsibilities:

• Enterprise Application Integration Performance Tuning between Oracle Applications, Oracle database, Oracle SOA framework and external Financial/non-financial systems.
• Territory Online Planning Systems (TOPS) is the online task assignment and the incentive calculation system built using .Net Framework. It runs a daily program to load the changes of assignments for all the sales agents and also calculates the sales percentages at the end of every quarter. This load from EPM and few other legacy systems into Oracle takes a long time. The data transfer is primarily invocation of SOA Framework. The BPEL process uses Oracle Applications Adapter for EBS to integrate TOPS and Oracle. TOPS have a data mapping defined in Oracle CRM. All the sales agents are defined as Human Resources and several custom tables are built to manage the sales commissions. The refresh of this application integration was running for more than 24 hours. Over 11600 DISTINCT queries were executed by this program. Program is CPU bound because it needs to hard parse every query - are not using bind variables and literals are used instead. Also, there are some library cache lock wait events as well, from the same reason. A different concurrent manager was suggested for the program and Materialized view was recommended for the refresh. Several indexes on the custom tables were introduced. Received Oracle Consulting Vice President’s Honor for this Performance Improvement on both the Enterprise Applications.
• JVM Crashes in Production: JServ sessions were taking 54% of the memory under high memory utilization. Memory footprint associated with JServ session was increasing over a period of time. 3 instances of JServ sessions were occupying about 30% of the total memory. Largest sized instance were from JServ sessions, taking about 10.22% of the total memory. This memory consumption was from custom java class with a total of 17,137 hash table entries persisted in memory by this custom class.
• Transactions per Second Record Management: Created Transaction Score card for the management on Oracle Servers for active monitoring - Oracle Database 9i, 10g, 11g.

Oracle Database Upgrade 9i to 10g

Confidential

Responsibilities:

• Monitored the databases using sql plan management, explain plan, histogram, trace file, alert log files, mv view, AWR, ADDM, grid control, index re-index, Defragmenter, shrink table space and explain plan, Hints, and using wait events.
• Performance tuning the database by using sql plan management, explain plan, SQLT, tkprof, histogram, OS Watcher, indexing, sql hints, ADDM, AWR ASH defragmenter, shrink table space and gathering statics, and using wait events.
• Rewrote of shell scripting of RMAN backup and database monitor scripts
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager OEM.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.

Confidential

System Manager

Responsibilities:

• Accountable as Oracle Applications Database Administrator providing Production & Performance service support.
• Established best practices and best procedures for database administration.
• Responsible for Software life-cycle support to include migration of all custom application changes to production.
• Managed data integrity & data security, involving back-up and user configuration.
• Involved in all installations and upgrades of ORACLE Financial systems
• Served as Oracle Financials System Administrator as well as the UNIX System Administrator.
• Performed day-to-day team administration and performance monitoring activities as well as appraisal for the team.

Confidential

Financials System Analyst/Strategy Implementer

Responsibilities:

• Responsible for Software life-cycle support to include migration of all custom application changes to production from 11.0.3. to 11.5.9
• Quality Analyst for Oracle Apps Finance reports using tools like Oracle Reports 6i and Load Runner
• Upgrade and configuration of Finance modules in 11.5.9 multi-org architecture
• Post upgrade verification and sanity checks