Oracle Technical Support

AJAY KUMAR GODBOLE

Email ID: ajay.**d@gmailcom

Contact No. : 630-***-****

OBJECTIVE:

Looking for a challenging assignment as an ORACLE DATABASE ADMINSTRATOR

Experience Summary:

Around 10 years of experience as an Oracle DBA. Experienced in Oracle 7/8i/9i/10g/11g/12c Database administration with OEM, ASM,RAC & Oracle Exadata experience.

Expertise in installing, implementing and maintaining Oracle Databases with Unix,windows,AIX, Exadata platform

Worked on performance tuning across various environments

Upgraded databases from 9i to 10g, 10g to 11g,11g to 12c version

Worked on installation, upgrade, patching and other maintenance activities of 12c grid and databases as well

Worked on 12c Flex ASM

Expertise in Oracle 11g database cross platform migration like from Solaris to Linux.

Expertise in database encryption and data compression

Expertise in Oracle database backup and recovery

Resolved multiple data corruption and data loss issues

Expertise in Data guard including physical and Active DG

Worked on Unix shell scripting, Windows scripting

Worked on Automation of database admin activities like backups, monitoring

Implemented Oracle Database backup and refresh using export and import utilities

Implemented dataload procedures using sqlldr, external tables.

Performed Disaster Recover and Failover of Oracle in multiple production environments

Expertise on installing, configuring, maintaining and upgrading Oracle Exadata firmware including cell storage, compute nodes, IB switches.

Worked on X2, X3, X4 Exadata machines with quarter, half, full rack nodes

Expertise in configuring zfs/zba backup for Exadata systems.

Expertise in configuring and maintaining replications through Oracle dataguard, streams, golden gate.

Worked on storage expansion for existing 16 node Exadata system.

Performed installation, upgrade, cloning on Oracle E-business suite application 11i, R12.

Proficient in database performance tuning using STATSPACK, AWR, Explain plan, TKPROF & performance views

Sound knowledge on Architecture, backup and recovery strategies for Oracle RAC

Provided on-call Production Oracle Database support

Installation and maintaining of 10g/11g Application Server.

Analyzing and Applying patches in Oracle Apps for both application and Database including CPUs

Applied localization patches, language enabling patches on Oracle Apps

Worked on various tools like PVCS, Kintana, MWA, Site scope, HP Open view, Oracle Warehouse builder, Discoverer, Guardium, Tripwire, GSM

Worked on other DBMS like Sybase, MS SQL server, Postgres

Flair for taking up challenges and desire to work in a demanding environment

Technical Expertise:

Operating System

Solaris, HP-UNIX, AIX, Linux,Exadata Engineered System- X2-2,X3-2,X4-2,X5-2

Database:

Oracle 7, 8i, 9i, 10g, 11g, 12c

Language

Shell scripting, Windows scripting, PL/SQL

Modules:

Oracle System Administration

Oracle Applications :

Oracle Applications 11.5.9, 11.5.10 and R12

Application Server

10g AS, 11g AS,SSL

GUI

Oracle Applications, Exadata iLOM, OEM 11g, 12c

Tools

SQL plus, Export, Import, RMAN, OEM, TOAD

H/W platform

Sun Sparc, HP

PROFESSIONAL EXPERIENCE:

Client: MasterCard, O’Fallon, MO

Position: Oracle Exadata DBA -Lead

Period: November 2012 – Till date

Environment: Oracle Applications 11.5.10.2 and R12.1.3, Oracle 11g, 12c, Sun Solaris, IBM AIX, RHEL, Oracle 11g ASM, Oracle Discoverer 11g, SQL*plus, Oracle Exadata, Oracle Golden Gate, Oracle streams, ZFS/ ZBA backups, Exadata, Exalytics, OEM, ASR

Responsibilities

Install, upgrade and maintain various Exadata platforms

Supported the maintenance of hardware failures in Exadata

Install, upgrade and migrate Oracle E-Business Suite applications, Oracle databases

Successfully upgraded Oracle E Business Suite Application from 11.5.10.2 to R12.1.3

Configuration of replication features such as Data Guard, Golden GateGate

Supporting High availability applications like – ASM, RAC, Exadata

Application and Database performance monitoring and tuning to optimize response times

Enforce and maintain database audit and security per PCI standards

Plan and implement backup, recovery and contingency solutions for supported databases

Providing technical support to application development and production support teams and users

Liaise between onsite and offshore

On-call Production support

Client: British Petroleum

Position: Oracle DBA Lead

Period: Sept 2009 – Oct 2012

Environment: Oracle database 7, 8i, 9i,10g, 11g, Sun Solaris, Windows, Sybase,SQL Server

Responsibilities

Install, upgrade and migrate Oracle databases

Worked on 10g AS, 11g AS

Configuration of replication features such as Data Guard

Supporting High availability applications like – ASM, RAC

Application and Database performance monitoring and tuning to optimize response times

Enforce and maintain database audit and security per SOX standards

Plan and implement backup, recovery and contingency solutions for supported databases

Liaise between onsite and offshore

Client: Emerson

Position: Oracle DBA

Period: Dec 2006 – Sept 2009

Environment: Oracle 9i,10g Database Administration, Oracle Applications 11.5.10.2

Responsibilities

Oracle Apps 11.5.10.2 installation

Oracle database installation, upgrade, patching, maintenance, dataguard setup

Monitoring and support with Oracle SR updates

Perform regular Oracle Production Database performance monitoring

Automated Oracle apps cloning

Manage Work Order/Change Order services requests through HP Openview

Plan and implement backup, recovery and contingency solutions for supported databases

Education:

Degree/Qualification

Institution Name

Master of Software Engineering

BITS, Pilani, INDIA

Contact this candidate