SUMMARY:

• I have over 17+ years of experience in all phases of architect, design, installations, implementations, Data Center Migrations, Upgrades (EBS - 11i & R12) and production support of Oracle applications.
• My areas of EBS expertise include 11i and Release 12 Oracle Apps Database administration, PSU and security patches, configuring Real Application cluster services (RAC), configuring Data Guard (DR),Active Data Guard, ASM, cloning, Patching, ASCP, upgrading, migrating Apps environments, Performance tuning, table partitions, LOB & indexes, 10gAS, OID, SSO,OAM, Webgate, Portal, Discoverer, DMZ, Adding/Merging Appltops, Fusion Middleware, SOA architect, BPEL, ODI, Weblogic.
• I have DBA lead experience with offshore/onshore model to provide 24x7 production supports.
• I have also worked with Oracle on-demand.
• I have In-depth knowledge of Oracle recommended technical architecture and system management of Oracle E-business Suite including installation, configuration, support, and upgrade of Oracle Applications 11i, Release 12, and 10gAS including technology stack components: Apache server, Forms, Reports, Application/Web, Concurrent Processing servers, discoverer, OEM including Application Management Pack.
• I have upgraded various versions of jinitiator and JAVA to latest versions.
• I have implemented shared APPL TOP by merging existing APPL TOPs on 11i and R12.
• I have expert knowledge of implementing backup strategies, recovery and high-availability solutions: RMAN, Obacktack, Omniback, Veritas, Legato, Netapp.

SKILLS SUMMARY:

Oracle Platform and Architecture

Oracle 11g, 10g, 9i and 8i

Clustering

ASM

Oracle Application Server 10g

High Availability

Performance Tuning

Oracle Platform migrations

Non-Oracle Databases

Sybase, MS SQL

Oracle Applications DBA

Applications Install

Point Release upgrades

Major upgrades

Performance Turning

Patching, Cloning

Complex Architecture including - RAC, PCP, DMZ, Load balancer etc.

Oracle Core DBA Experience

Database upgrades

Database patching

Database creation

Database maintenance & troubleshooting

RMAN

Hardware & Operating Systems

AIX

Sun Solaris

HP-UX 11.11

Red Hat Linux

Programming Languages

Visual Basic

ASP

Foxpro, Foxbase

Power Builder

Engagement Experience

Application Implementations

Application Upgrades

Database Upgrades/Migrations

Platform migrations

Production Support

Architecture Setups

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps DBA

Responsibilities:

• Routine DBA tasks such as Analyzing, apply application and database patches.
• Backup/restore using obacktrack.
• Veritas Active/Passive cluster.
• Helping in architect, design & Implement Oracle Data Guard.
• Cloning (single & Multi-node architecture) R12 environments on shared application tops.
• Code Migrations among different instance manually and through ‘Stat 5.6.3’.
• Helping Developers in performance/tuning custom objects.
• Performance tuning.
• Implemented Oracle Label Security (OLS) for Sensitive Data in Development environment.
• Helped in implementing shared Application Top on 3 middle tier and DMZ DEV servers for offshore technical team.

Confidential

Oracle Apps DBA

Responsibilities:

• Implemented GRC with WebLogic.
• Routine DBA tasks such as Analyzing and apply application and database patches.
• Cloning the R12 environments on shared application tops.
• Code Migrations among different instance using SVN.
• Implementation, Production Support for ODI, BPEL on Fusion Middleware (SOA architecture).
• Code deployments on Fusion Middleware.
• Applied PSU patches on ASM databases.
• Helping Developers in performance/tuning custom objects.
• Performance tuning the production.
• Helped in implementing shared Application Top on 3 internal and 2 external nodes.

Confidential

Database architect/Oracle Apps DBA

Responsibilities:

• Architected the Reporting Database in highly secured zones with Reverse Proxy servers.
• Provide DBA support to production and QA databases.
• Application, Database & PSU Patches.
• Architect, Design and Installed 11gR2 Databases.
• Upgrade 10gR2 and 11gR1 databases to 11gR2.
• Create Empty Databases, Create tablespaces and Export/Import various Schemas and partitions.
• Managing Partitions, LOBs, and partition indexes.
• Routine DBA tasks such as performance tuning, code migrations, tablespace managements etc…

Confidential

Oracle Application DBA Lead

Responsibilities:

• Helped customer to implement EBS application (R12) in 44 countries.
• Performed Upgrades for 11i and R12 instances.
• Upgraded Oracle Release 11i to Oracle R12.
• Lead production support DBA for several customers running various Oracle products. Served the role of DBA lead and has been customer’s primary contact for DBA and Application support customers. I played a key role in all phases of the project - requirements, analysis, scoping, technical design, documentation, implementation, transition and production support.
• Worked as DBA lead for several Apps Implementation, Migration, production support, Upgrade projects. The projects range in duration from few weeks to multiple years. I have been customer’s main point of contact for all escalations both business and technical. Has moderated weekly conference calls and has been the key tracker of project schedule and assignments.
• Implemented 10gAS with OID on RAC, SSO, portal & Discoverer with 11i application.
• Managed multiple implementations and migrations that involve 11g RAC, 10g RAC, 9iRAC, Data guard (standby database), and hardware load balancer.
• Led a team of many DBAs to provide 24x7 supports to multiple customers on different platform and different architectures. These customers have implemented RAC, Data Guard, Parallel Concurrent Processing, Load Balancing, Shared Appl tops, RAW file system etc.
• Implemented DMZ servers for various clients using various technologies such as Reverse-Proxy.
• Implemented Active DataGuard so that it can be used as Reporting Server.
• Lead a team of multiple DBAs to Upgrade databases from different versions like 8i to 9i and from 9i to 10g or 11g.
• Upgraded Application from 11.5.x to higher version of 11i (e.g. 11.5.9 &11.5.10.2) and R12
• Migrated application from one platform to other. (e.g Soalris to Linux etc).
• Helped customer to upgrade their Unix servers.
• Helped customer to implement Shared Appltops and shared applications for different releases (11.5.9 and 11.5.10.2)
• Rebuild Data Guard instance, enabled it as Standby DB then switch over & switch back.
• Routine DBA tasks such as patching, cloning, production monitoring, performance tuning, RMAN & NetApp backups, restore etc.

Confidential

Sr. Oracle Application DBA

Responsibilities:

• Implemented 11.5.10.2 application with ASM, Oracle Portal, Discoverer, OID, SSO along with Data Guard, PCP on 4 node RAC and 3-node load balancing.
• Implemented Shared Appl top for 3 admin nodes and 3 forms node. Database was on 4-node RAC.
• Installed cluster services and upgrade it to 10.2.0.3
• Created ASM instances for production and development instances.
• Upgraded the RAC databases to 10.2.0.3. Tested and Documented Database FAIL-OVER and FAIL-BACK steps in a 4-node RAC environment. Database is Flashback enabled and storing the archive logs to FRA.
• Implemented Parallel Concurrent Processing (PCP) on a 3 node admin node. Tested and documented the Concurrent manager FAIL-OVER and FAIL-BACK steps.
• Implemented hardware load balancing on 3 nodes.
• Implemented 10gAS. Worked on OID, SSO and E-Business 11i integration. OID provisioning was from OID -> E-Business.
• Configured Data Guard in maximum performance mode. Tested and documented DB Switch-over, DB Switch-back, DB Fail-Over and Application Fail-Over for Data Guard.
• Configured isupplier on DMZ server. To setup isupplier, used ichain server as a proxy server.
• Migrated Oracle 11i jinitiator to JAVA.
• Extensible worked on RMAN for backup, duplicate for cloning, standby database creation and point-in-time recovery along with Daily backup activities.
• Created and Implemented Database and application monitoring scripts to monitor space issues, DB alerts, DB performances, DB and application services etc…
• Extensible worked on cloning, patching and other Daily DBA activities.
• Worked on 10g & 11g grid control.
• Implemented Centralized ASCP instance in production for customer’s daily, weekly and yearly planning.
• This implementation also included various 3rd party product such as Clear Orbit, Feith, Autotime, Hyperian.

Confidential

Sr. Oracle Application DBA

Responsibilities:

• Upgraded 11i instances to R12.0.4 and then R12.0.6.
• Installed CRS and database on 4 node RAC on 11gR1.
• Shared Application Top, Parallel Concurrent Processing (PCP) implemented on 4 node.
• Installed 11g Grid to monitor database & application and to send alerts.
• Used 11g Grid to check database performance and fine tuning the long running jobs using Tuning advisor.
• Routine DBA tasks such as patching, cloning, performance tuning, Code migrations.
• Technology lead for key consulting offerings in advanced technologies like 10g, 11i applications or Release R12, RAC, ASM, MAA (Maximum Availability Architecture) and Data guard.
• DBA lead in configuring Data Guard, Fail-over, Switch-over DB & Application, Switch-back DB & application in a 4-node RAC, 3 node PCP configuration.
• Lead several architectural and sizing assessment assignments for customer applications environments. Developed Technical Architectures for Oracle Applications and very large database environments. These comprise of recommendations on clustered systems, DR configurations, multi-tier architecture, server, memory and network configurations based on volume, scalability and disaster recovery requirements.
• I have excellent database design, development and integration skills. I have in-depth development skills in database, UNIX and web development platforms. I have wide exposure to different flavors of UNIX, nuances of various database platforms and features of different technologies offered by application servers.
• Lead and successfully implemented 11.5.10.2 with Oracle 10gR3 RAC and Dataguard, shared appl-top, PCP, load balancing.
• Installed, configured, Upgraded and migrated production environment to 11.5.9 on Linux platform. Later, Upgraded and migrated of their production instances to OATM, 11.5.10.2, 10gR2 and Red Hat 4.0.
• I have extensive experience in coordinating activity in Blended Delivery/Off-shore model.
• Developed & implemented process and methodology for coordinating activities around shift systems.
• Has been responsible for providing 24x7coverage to all customers.
• Working with Offshore team on major tasks for different clients such as Upgrade, migration, implementation, cloning etc.