Manager Oracle

Sahil Thapar

Sr. Oracle ERP Apps DBA / Performance DBA. Email :

************@*****.*** Ph : +1-484-***-****

Professional Summary

Highly skilled and versatile Oracle DBA with proven skills in performance

tuning, RAC/ ASM installation & troubleshooting, Oracle application 11i /

R12 administration and Exadata. Oracle certified DBA with 11 years of

progressive experience in Oracle technologies. Possess strong analytical

and complex problem solving skills, with a passion to learn and update my

knowledge to keep current on new technologies. Have been a key member on

two complete R12 upgrade projects.

Skills

Apps 11i/ R12 install / patch Expertise in 10g/11g RAC/ASM

/administration / cloning administration

Expertise in 11i to R12 upgrade tuning /clone/troubleshooting

Single Node to RAC-ASM migration

Concurrent manager/workflow

troubleshooting RDBMS upgrade / patching / RMAN

EBS/OLTP/OBIEE/DW Performance tuning, Strong Unix skills working on

AIX, Solaris, Linux

EXADATA sizing and migration Shell Perl CGI Scripting, awk,

Golgengate administration sed

Project management of small size task Lead/Co-ordinate onsite-offshore

based projects DBA production support team

Certifications:

. Oracle Exadata 11g Certified Implementation Specialist

. Oracle Database 11g Performance Tuning Certified Expert

. Oracle Database 11g Administrator Certified Associate

. Oracle EBS R12 Applications Database Administrator Certified

Professional

. RHCT -Linux8 (REDHAT Certified Technician)

. SCSA -Unix 8(Sun Certified System Administrator

Educational Qualifications:

BE in Computer Engineering, Mumbai University

2001

Professional Experience:

Sr. Database Administrator - Performance Tuning and EBS Apps DBA

Nov 2010 - Present ASAP Consultant at AT&T Mobility

Plano, TX

. Key member of core Oracle Performance Tuning team for AT&T's Oracle

Applications R12 SCM / OLTP / OBIEE databases and worked as Oracle

Applications DBA 11i/R12

. As member of R12 upgrade performance tuning team worked on reducing

the upgrade time from 160 hours down to 36 hours tuning various

oracle scripts to reduce the elapsed runtime. For the task received

client appreciation certificate as well.

. Strong feature knowledge of Oracle EXADATA X2/X3 - working on proof

of concept project to evaluate EXADATA X3 for current OBIEE database

and working with vendor team on sizing and migration requirements.

. Working on daily performance issues and performance tuning on call

support. Have handled more than 70 sql tuning issues independently

reducing buffer gets in some cases from 10 billion/per day to 2K

per/day

. Strong experience in Oracle systems performance evaluation, AWR / ASH

/ ADDM / SQLTXPLAN and SQL performance analyser usage

. Worked on SQL performance analyzer to test database upgrades impacts

from 10g to 11g to reduce post upgrade production performance issues

. Worked on Golden Gate performance issues causing replicat lags

. Worked on oracle resource manager implementation to control parallel

slaves usage (DBRM)

. Worked on couple of OBIEE ETL performance issues to improve the load

time

. Worked on BI report performance issues reducing runtime of some key

month end jobs from 11 hours to less than 40 mins

. Worked on implementing best practices for Standby/active data guard

databases and trouble shoot apply lag performance issues

. Worked on RDBMS upgrade from 10g to 11gR2 and expertise in RDBMS

patch evaluation and application.

. Apps 11i / R12 cloning, troubleshooting Oracle Applications frontend

issues and Oracle Workflow issues

. Expertise in ad utilities like ad patch

. Concurrent Manager troubleshooting /Monitoring / Tuning / PCP

troubleshooting, JVM performance tuning

. Support Oracle ASM 11g RAC databases and troubleshoot RAC issues like

node eviction, cluster wait events, and database hung scenarios.

. Evaluate init parameters with respect to 11g RAC config and

performance parameters

. Handling stats collection process for R12 production environment

. Developed strong understanding of UNIX top, vmstat, iostat, mpstat,pstack,truss commands and oswatcher utilities

. LINUX System Administration, shell/ knowledge of Perl scripting and

PL/SQL programming needed to perform DBA/SYSADMIN tasks

Environment:

Hardware: Sun Enterprise M5000, M9000, 25000

O/S: Sun Solaris 5.8,9,10, Linux, HP

RDBMS: Oracle 11g RAC/ASM, 10g,11i - 11.5.10,R12(12.1.3)

Oracle Applications: Financials, Manufacturing, Supply Chain, ODP.

Other: Shadow Image, BCV, OEM 12c

Assistant Consultant - Oracle Applications DBA Performance Tuning

Jun 2010 - Oct 2010 TCS Consultant at

Ingersoll Rand

Mumbai, India

. Mainly performing Oracle Applications DBA role

. RAC administration/ cloning/ monitoring / tuning

. OTM application DBA support

. Apps 11i / R12 Cloning using OEM and RMAN

. Patching - one off patches; ATG family patches

. File system management

. Database administration / management / ASSM table space management

. Concurrent Manager troubleshooting / Monitoring / Tuning

. User Maintaince

. Printer Administration

. Migrated System Maintaince by setting up monitoring Tools to use

shell scripts

. System capacity evaluation and setting up migration strategies to

manage the system landscape

. Supporting database / performance issues post 11gR2 database upgrade

. Troubleshooting Oracle Workflow issues

. Worked on typical performance issues

Assistant Consultant - Sr. Apps DBA / R12 Upgrade Consultant

Oct 2007 - Jun 2010 TCS

Consultant at Ricoh America - Ikon Office Solutions

Malvern, PA

. Key member of the core R12 upgrade DBA Team from start of 11.5.9 to

R12 12.0.6 project kick off till go live and 2 months of post-

production support.

. Developed sound understanding of complete Oracle apps upgrade and

made some significant contributions in recommending u driver changes,

database setups pertaining to upgrade to improve the upgrade runtime.

. Worked on reducing the upgrade downtime from 110 hours to 36 hours;

received client appreciation letter for the same

. Performed all R12 upgrade DBA related activity of patch analysis,

preparing DBA run book steps, co-ordinating with development and

functional teams

. Performed over 30 R12 upgrade timing runs to stabilize the process.

. Worked on Rapid install setup for R12 upgrade, integrated

customizations in Apps R12 file system, worked on 11i to R12 cloning,

PCP setup and upgrade/ autoconfig related changes to setup a 3 node

EBS RAC and scripted the complete process

. Independently worked on single node to 10g RAC-ASM migration of SSO

(Single sing on ) database

. OID/SSO Single Sign on instance management / troubleshooting user

login issues

. RAC administration /cloning / monitoring / tuning

. Patching - one off patches; ATG family patches

. File system and Database administration / management

. Concurrent Manager troubleshooting/Monitoring/Tuning

. Developed couple of system Maintaince / monitoring Tools

. Troubleshooting Oracle Workflow issues

. Worked as onsite team lead handling DBA team activities, project

deliverables and team schedule/offshore coordination.

Assistant Consultant - Apps 11i System Administration

May 2004 - Oct 2007 TCS

Consultant at GE Healthcare

Mumbai, India

. Integrations of New Technologies as Proof Of Concept Team member and

managing new technologies implementation and creating support

structure till go-live.

. Worked on 11.5.9,11.5.10.2, ClearOrbit, Interconnect, Optio, iHUB.

. Developed sound grounding on managing System Administration

. Concurrent Manager Monitoring/Tuning

. User Maintaince

. Printer Administration, pasta configuration

. Implemented Oracle 10gAS Integration Interconnect

. System Maintaince / monitoring Tools

. Troubleshooting Oracle Workflow issues

. Worked on typical performance issues

Database Administrator - Oracle Apps DBA

March 2003 - Apr 2004

Oracle India

Hyderabad, India

. Patching (Application of minipacks, Maintaince packs, standalone

patches)

. Cloning environment using manual / methods described in Oracle

Whitepaper and Oracle Internal cloning methods.

. Bug fixing / troubleshooting for product teams relating to

configuration of environment

. Involved into Concurrent Manager tuning on need basis

. Bug fixing / troubleshooting for product teams relating to

configuration of environment

. Monitoring, troubleshooting Oracle 9iAS issues especially Apache

issues.

. Certifying product minipacks like AK, EC, FND, and FWK etc.

. Documenting of patching, backup etc. procedures based on the

instruction provided by Sr. DBA's.

. Refreshing environments from backups

. Performing database recoveries to recover from disk failures, loss of

data files etc.

. Shell scripting of repetitive processes

. Checking for errors in alert files, trace files on a daily basis

. Handling backup / recovery of applications environment

. Cross platform migration using internal tools

. Monitor table space usage and add data files as needed

. Monitor rollback segments and tune them

. Handling availability and manageability of development environments

Systems Engineer - SAP BASIS Consultant

Feb 2002 - March 2003

Siemens Information Systems Ltd - OfficeMax, USA

Mumbai, India

. Giving 24 x 7 support to the client and sorting out problem

conditions on SAP 4.6c,Sun Solaris, Oracle 8i

. Application of support packages

. Handling transport request and imports

. Start-up and shutdown of systems

. Performing database copies to refresh systems in landscape

. Monitoring performance of system and ensure good health of system

. Performing day to day administration of database

. Carrying out table reorganization

. Monitoring backups

. Tuning the database system for optimal performance and sort out

bottlenecks in database operation

. Shell scripted the procedure to automate the database refresh

procedure and recover the database after renaming the database.

Career Profile

Dates Organization Client Role

Nov-10 to ASAP Staffing LLC AT&T Sr. Database Administrator -

Till date Mobility Performance Tuning and EBS Apps

DBA

May-04 to Tata Consultancy Ricoh R12 upgrade Apps DBA /Assistant

Nov 10 Services America Consultant

Ingersoll Apps DBA / Oracle DBA

Rand 11i System Administration

GE

Healthcare

Mar-03 to Oracle India Ltd. Apps DBA/Oracle DBA

Apr -04

Feb-02 to Siemens Information OfficeMAX SAP BASIS

Feb-03 Systems LTD

Training / Continuing Education Summary

Program or Course Coverage Dates

Dynatrace Setup and configuration March-2013

Basics of RAC RAC Concepts Mar-2007

Project Management & PMP Jan-2007

Planning

10gAS Administration Administration Concepts Sep-2005

Oracle Application Fundamentals of Oracle Mar-2004

Concepts Apps

Contact this candidate