PROFESSIONAL SUMMARY

• Highly Experienced with Installation, Implementation, Upgradation, Recovery, Migration, Administration, Cloning of Oracle E - Business Suite Applications from 11.5.8 / 11.5.10.2 / R12 including Single and Multinode environments.
• Good Experience in managing Oracle Databases from 9i / 10gR2 / 11g
• Experience in working with various Operating Systems like Sun Solaris / HP Unix / RH Linux / Win 2k
• Highly Experienced in Installation/Configuration/Support of EBS R12 based systems along with other applications like Discoverer / Oracle Configuration Control Governance - OCCG / Oracle Enterprise Manager / Snap Manager for Oracle - SMO.
• Have performed Project Management for various Infrastructure Projects including OS Upgrade / Data Centre Migration / Applications Migration / Applications Upgrade.
• Experience in various Oracle / non-oracle Products like Oracle OEM, Oracle SMO, TOAD and I3.
• Have good understanding with programming using SQL, PL/SQL.
• Have good understanding of Oracle Data Guard, Oracle RMAN Backup and Recovery procedures.
• Have good exposure to Six Sigma / ITIL / CMM 5 Certification / ISO process and documentation.
• Experience in handling various fortune 500 clients across the globe.
• Logica Diamond Award (Bronze) for the performance factor “Committed” 2011
• 6 Accenture Celebrating Excellence Performance Awards for the 2007-08
• Maximizes Team's Performance
• Organizes and Directs Quality Work Efforts
• Anticipates and Handles Critical Situations (got the award 3 times for this performance factor)
• Drives for Value Added Results
• ‘The Living on the Edge’ - Annual Accenture award 2006
• ‘Instant Karma’ - Accenture award for exemplary individual performance and valuable contribution 2005.

PROFESSIONAL EXPERIENCE

Confidential, VA

Responsibilities:

• Provides Production Technical Support for the internal project environments, database and applications.
• Has been involved in day to day support activities which include Monitoring / Performance Tuning / AD Support.
• Has Applied both Oracle CPU Patches, AD Mini Packs, Maintenance Packs, DB Patches and other Oracle provided Bug Fixes.
• Has been involved in Cloning / Refreshing of EBS R12 multi node environments. This includes both Database and Applications.
• Derived a proactive purging strategy for the custom, audit and temporary tables.
• Involved in Patch Analysis for oracle applications patches.
• Performed initiative activities like resetting high water mark for the huge interface/base tables

Confidential

Service Leader - IT Consultant/ Oracle Apps DBA

Responsibilities:

• Provides Production Technical Support 24X7 for the database and applications in production, development, pre-production, and DR environments.
• Installation of 10g/11g databases, Oracle Grid Control 11.1.0.1, Oracle Configuration Control Governance, Web Logic Server 10.3.2
• Performed various upgrades:- Oracle Database Upgrade from 10.2.0.3 to 10.2.0.5, Database Upgrade from 10g to 11g, Oracle E-Business Suite Upgrade from 12.0.4 to 12.1.1, Oracle Home Upgrade, Opatch Utility Upgrade, Apache Tomcat Upgrade, Java Version Upgrade, OCCG Version Upgrade, OEM Version Upgrade
• Has been involved in day to day support activities which include Monitoring / Performance Tuning / AD Support / Oracle SR Support and client user requests.
• Has been involved in Cloning / Refreshing of EBS R12 multi node environments. This includes both Database and Applications.
• Has Applied both Oracle CPU Patches, AD Mini Packs, Maintenance Packs, DB Patches and other Oracle provided Bug Fixes.
• Troubleshooting performance related issues related to RDBMS, Concurrent Managers and user sessions.
• Performed Oracle E-Business Suite / Database Hardening Activities in production and other environments.
• Maintaining the SLA agreed with the client for all type of incidents / change requests and ensuring that there are no slippage / negative variance in addressing the problems and implementing any requests.
• Created an upgrade factory (Oracle E-Business Suite Upgrade Factory OEUF) for Logica. This is now in use for all e-biz upgrade projects bidding for Logica
• Provided estimation (effort) for oracle ERP Migration project RFQ (Request For Quotation) for Etihad Airways
• Led the DBA shared services and assist support desk which had 3 clients (Vodafone, Addax petroleum, UCLH)

Environment: Oracle Applications 11.5.10.2 / R12.1.1, Database 10g / 11g with 1 DB and 1 Web nodes. The environment includes OCCG 5.1, 5.5.1, SMO, OEM 11.1.0.1, Sun Solaris 9/10, Linux 5, Application Management support of 2 multi node environments and 3 single environments.

Confidential, Chalotte, NC

Senior Consultant - ERP / Oracle Apps DBA

Responsibilities:

• Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production.
• Ensured minimal/no slippage in the SLA agreed with the client Confidential, US.
• Managed/Solved the tickets raised (in Unicenter Service Desk) for all the problems/change requests.
• Derived the strategy for creating new databases (like Infogix Insight DB), compressing the partitions of the objects as and when required.
• Responsible for the capacity planning and space management
• Performed HWM reset for interface base tables to improve the performance of the system.

Confidential, Memphis, TN

Senior Software Engineer, Oracle Apps DBA

Responsibilities:

• Ensuring a minimal response / resolution time for meeting the SLA’s defined for the Incident tickets (Low/high/Business Critical) for Pfizer.
• Good consulting experience in planning for the Custom Components Migrations (across all the streams P2P, O2C and R2R), DB growth analysis and UC4 / Tivoli Batch job Schedules.
• Have contributed extensively as technical architect in developing and managing the OS migration of PRODUCTION / Disaster Recovery and Development servers from Solaris 9 to Solaris 10 which involved around 60 servers and 30 Oracle EBS environments.
• Created a new patch process / patching strategy techniques for Pfizer. The strategy techniques involve keeping the application/DB up to date with the latest oracle recommended baseline patches.
• Successfully completed 3 year-end closures. Completed 3 Financials year-end Closures (AP, AR, GL and PA) in Pfizer by taking proactive steps (before year end) for a smooth closure which includes Index rebuilds, workflow tables purge, resetting high water mark (HWM) for the heavily used objects etc.,
• Configured and Implemented CM Queues - Functional Grouping. Experience in the Concurrent Manager Grouping based on the functionally under Supply Chain / Financials / Order Management / etc for the CCM load balancing.
• Worked in Pfizer Dublin, Ireland for 1 year and supported the France/Belgium & Canada market rollouts.
• Hands on experience in Oracle iPayment/Oracle Discoverer Issues.
• Have Load Balanced the concurrent jobs across nodes by creating new managers and implementing specialization concurrent rules.
• Cloned Oracle E-Business environments from Production to Production support and Project environments (both single node and multi nodes) based on the client requirements for country rollouts, conversion and training.
• Have completed upgrade of Production / DR / DEV E -Business Suite environments from DB 10.2.0.2 to 10.2.0.4
• Have successfully upgraded JDK software in around 25 Oracle EBS environments.
• Applied Patched and performed Patch synchronization in other environments with Production. It includes both application and database patches.
• Derived a proactive purging strategy for the custom, audit and temporary tables.
• Good consulting experience in DB capacity planning and successfully completed 3 CP’s based on the requirements of the market and the volume of transactions.
• Performance tuning using Symantec i3, OEM.
• Supported Europe / UK / USA and India based client users. Supported other functional / development / testing teams in troubleshooting application issues
• Migrated the custom codes to PRD using the PVCS Version Control.
• Provided 24*7 support to all the GFSS production EBS servers.

Environment: Oracle Applications 11.5.10.2 / 10g RAC with 3 DB and 3 Web nodes. DR with Data guard solution. PCP with Failover capability and hardware Load balancing of web nodes. The environment includes OEM, Symantec i3, Sun Solaris 9/10. Application Management Support of 15 single node environments and 5 multinode environments.

Confidential

junior DBA

Responsibilities:

• Administration and maintenance of Oracle 8i, 9i in Windows 2000 server and LINUX Itanium Server Platforms.
• Created Duplicate Database Cloning through Oracle Recovery Manager, RMAN configuration, standby server for failover situation.
• Establish and maintain sound backup and recovery policies and procedures.
• Responsible for supporting developers and customers through Installation, Maintenance, Tuning, Troubleshooting and Coding.
• Taken logical cold & hot backups of the database. Was responsible to implement backup & recovery procedures as per Oracle best practices.
• Successfully created Recovery Catalog Database and maintenance.
• Performed general technical troubleshooting and giving consultation to development teams.
• Implement and maintain database security (Create and maintain users and roles, assign privileges).
• Development of customized systems using Developer 2000, Oracle Forms6i, and PL/SQL programming.

Environment: Data centre with 14 Servers including WinNT / RH Linux / Linux Itanium / HP UX for exchange servers, Database Servers, Application Servers to support various subsidiary companies of Sundaram Group like Sundaram Mutual, Royal Sundaram, Confidential, Sundaram Motors, Wheels India and Brakes India Limited.

Oracle Database Administrator

Confidential

Responsibilities:

• Installed and configured Enterprise Manager tools to help in day-to-day monitoring activities.
• Daily Monitoring and Maintenance of the database, including creation of daily reports on extents, free and used space, lock report and database Listener.
• Providing the support to the end-users.
• Maintenance activities such as rebuilding tables / indexes.
• Responsible for Space and User Management.
• Automated the backup jobs (hot, cold, export, full and Incremental).
• Setup and Maintain Documentation and Standards.
• Worked as a part of 5 member team and provided 24X7 supports when required.