Manager Oracle
Resume:
Oracle Applications and Oracle Ph No. +91-987*******
core DBA
Jatin Gandotra
*****.********@*****.***
Summary
Working as Oracle Applications DBA (Release 11.5.10.2-R12) and Oracle DBA
for 4+ years on Production environment and have extensive experience in
Financials/Manufacturing/WMS/HRMS operations. Have a good knowledge of
the oracle RDBMS 9i/10g/11g.Currently working with Stryker Global
Technology Centre for Europe and U.S divisions.
Professional Expertise
. Oracle E-business Suite 11.5.10.2 and R12 (Single Node & Multi Node) and
Database 9i/10g/11g Installation on UNIX (Solaris, AIX etc)/Linux
Operating Systems.
. Specialist in Baseline upgrade, bug fixing, troubleshooting, migration,
Security, tuning of Oracle Database/Applications, Patching, Cloning and
Maintenance.
. Oracle High Availability (HA/MAA) solutions such as Real Application
Clusters (RAC) 9i/10g/11g, Data Guard 10g/11g, Oracle Flashback and
Oracle RMAN.
. Application Server (WebLogic, Oracle AS 9i/10g), Identity Management
(OAM, SSO, OID, OVD and OIM) and Fusion Middleware (SOA suite).
. Undergone the Oracle RAC 11g training from Oracle University.
. Providing Support and coordinate activities with other teams Like
Development, Functional and UNIX. Also, covered On-site support during
the Projects Roll-out/Implementation phases. Provided the On-site support
for projects in Switzerland, France, Spain, Belgium, Luxembourg,
Netherland, Nordics Regions and Portugal.
. Monitoring solutions like Oracle Enterprise Manager Grid Control with
Oracle AMP.
. Proficient in SQL, PL/SQL and Shell scripting.
. One of the Top performers in Stryker for the year 2009 and 2010.
. Bagged the "Stryker Team of the year (India)" and "BES Apps DBA
(Switzerland)" Awards 2009.
Projects
Organization Stryker Global Technology Centre
:
Client Stryker Europe
:
Project Program ONE
:
Duration August,2008 - Till Date
:
Role Applications DBA
:
Team 9 (4 Off-shore and 5 On-site)
:
Environment Oracle E-business suite 11.5.10.2 and R12 (NLS),
: IBM AIX 5L, 10.2.0.4 RDBMS, 10.2.0.4 Clusterware,
GPFS, Shared APPL_TOP (11i) and EMC snapshot
backup
Responsibili :
ties
. Oracle E-business suite 11.5.10.2 and R12 Installation on Single Node and
Multi Node Environments.
. Oracle E-Business Suite R12 Upgrade.
. Administering Multi-node environments comprising of 5 nodes shared
application tier and 4 nodes db tier (RAC).
. Oracle Applications Cloning from multi-node to multi-node (Including RAC)
and multi-node to single node during the Testing, Area Build and
Integration Phases.
. Patching the Production and Non-production Environments during their
respective maintenance windows.
. Daily Sanity Checks of the production and non-production instances before
releasing to Users.
. PCP Setup for concurrent processing distribution and fail over.
. Unix Shell Scripting to automate daily cloning procedure and monitoring.
. Risk and impact analysis of the new patches and discussion with the
functional team.
. Developed RMAN script for non-production apps database backup and
cloning.
. Performance tuning of Concurrent Requests, Forms and database using
statspack, AWR, ADDM, sql profiling and tuning advisor.
. Daily CPU Graphs and weekly database growth monitoring graphs generation.
. Oracle Applications System Administrator tasks like adding or disabling
the Concurrent Managers for different countries with proper workshifts
(Day or Night), Specialization Rules and processes to ensure that the
specific requests go to specific manager at right time with no impact on
Applications Performance. Also, setup of conflict domains and all other
tasks as required.
Projects
Organization Stryker Global Technology Centre
:
Client Stryker U.S
:
Project Oracle RAC 10.2.0.4/11g Installation, Node
: addition and Administration Support
Duration September,2008 - Till Date
:
Role Applications DBA
:
Team 2
:
Environment Oracle RDBMS 10.2.0.4, Oracle Clusterware
: 10.2.0.4, GPFS
Responsibili :
ties
. Installation of Oracle RAC 10.2.0.4/11.1.0.6 on GPFS and ASM for pre-
production application instance.
. Adding or Removing Nodes, database and Instances into the Clusterware
10.2.0.4 configuration.
. Cluster managed services setup for Oracle Applications.
. Other administration tasks like backup, adding, deleting, restoring,
replacing, repairing etc of OCR and Voting Disks whenever required.
. Setting up of the Cluster ready services with proper CLB Goals for Load
Balancing of the cluster according to the System Load.
. Resolving Hang Issues in RAC during heavy load.
. Enable tracing in RAC for troubleshooting the issues in Clusterware.
. Creation of the shell script for hot backup of the RAC Database and
compressing Archive Logs regularly.
. Monitoring Clusterware logs.
. Giving RAC training to new joiners in the team.
Projects
Organization Stryker Global Technology Centre
:
Client Stryker Europe
:
Project Oracle Dataguard 10.2.0.4 Installation and Support
:
Duration September,2008 - Till Date
:
Role Applications DBA
:
Team 2
:
Environment Oracle RDBMS 10.2.0.4 and UNIX
:
Responsibili :
ties
. Oracle 10.2.0.4 physical standby database setup with optimum mode.
. One full successful PRD switch to Disaster Recovery site to estimate the
total impact on the Business Activities and preparation for DR Switch.
. Physical Standby of Production to be used as a Read Only Reporting
Instance to isolate the Business Intelligence Reports away from
Production instance and thus avoiding any performance impact on
Production due to running of heavy reports.
. Created UNIX shell scripts for the automatic synchronization of the
Reporting DB with that of Production in the no business hours.
. Installed Oracle Dataguard 11.2.0.1 with Active Dataguard for testing
purposes.
Projects
Organization Stryker Global Technology Centre
:
Client Stryker Europe
:
Project Oracle Enterprise Manager Grid Control 10.2.0.5.2
: Installation and Administration
Duration October,2008 - Till Date
:
Role Applications DBA
:
Team 7 (3 Off-shore and 4 On-site)
:
Environment Oracle Enterprise Manager Grid Control 10.2.0.5.2
: IBM AIX 5L (64-Bit System)
Responsibili :
ties
. Installation of Oracle Enterprise Manager Grid Control 10.2.0.1 and its
upgrade to 10.2.0.5 with Repository Database upgrade from 10.1.0.4 to
10.2.0.4.
. Install Oracle Applications Management packs 2.0/3.0 to administer Oracle
Applications also using single Grid Console.
. Integrating SMS alert and email alerts with OEM GC 10g to pro actively
solve any Issues in the Production like sudden stop of any Oracle
Applications Component, Blocking Sessions, space issues in hosts etc.
. Custom Metrics and Jobs to automate the regular DBA tasks. Monitoring
Performance of RAC PRD instances using the OEM console and take necessary
actions if any issue in the performance.
. Enabling Blackouts for scheduled downtimes.
. Resolving Blocking sessions or orphan forms processes using OEM GC.
. Creation of the Tuning Sets for a heavy DML operation and take necessary
actions like Index Creation on the base tables, Rules enforcing etc
accordingly.
. Generation of AWR Reports and ADDM for performance issues analysis and
estimation of the Workload in the Production.
Projects
Organization Simplex Software Solutions Pvt. Ltd.
:
Client Microhouse.net (South Africa)
:
Project 11i Oracle Applications installation and
: Maintenance
Duration June,2007 - August,2008
:
Role Consultant (APPS DBA)
:
Team 5
:
Environment Oracle Applications 11.5.10.2, 10.2.0.2 RDBMS,
: Red-Hat Enterprise AS 4.0
Responsibili :
ties
. Upgrade of Oracle Applications (11.5.10.2) Database Version 9.2.0.6.0 to
10.2.0.2.0.
. Maintenance of Application using AD utilities.
. Applied maintenance pack, mini packs and critical patches for Rel
11.5.10.2.
. Applied CPU RDBMS patches using opatch.
. Cloning the instances for making the respective instance for Testing as
well as for Backup.
. Administering the Concurrent Managers, Managing Concurrent Programs and
Reports, Purging the concurrent requests historical data during high
activities as per the company norms.
. Troubleshooting Applications issues raised by users on a day-to-day
basis.
. Monitoring of Application using Oracle Application Manager (OAM).
. Coordination with Oracle Support for Service Requests.
Projects
Organization Simplex Software Solutions Pvt. Ltd.
:
Client Trading International(U.S.A)
:
Project FOREX Application
:
Duration October,2007 to August,2008
:
Role Consultant (APPS DBA)
:
Team 5
:
Environment Oracle Applications 11.5.10, Oracle Database
: 10.2.0.2.0, Red-Hat Enterprise Linux Server
Release 5.2 (Database), Centos 5.0(Application).
Responsibili :
ties
. Installation and Configuration of Oracle Application 11i with client's
custom Forex Application.
. Installation of Real Application Cluster and Data Guard (Physical
Standby) to provide Maximum Availability Architecture.
. Transparent Database Encryption to secure the crucial Data.
. Resolving Users Issues due to increase in the number of Online Users.
. Gathering Table and Index Stats for Query Optimization.
. Troubleshooting Database issues raised by Application Developers on a day-
to-day basis.
. Regular password change of production and development instance.
. Guiding the Application Developer in writing well tuned SQL and PL/SQL
code.
. Implemented multiple shell scripts, which reduced lot of manual work.
Projects
Also worked on other projects for Stryker U.S: Oracle Application Server
10g, Weblogic 11g, SOA 10g/11g, OID 11g and SSO/OAM 10g Installation and
Administration.
Educational Qualification
. Bachelor of Engineering in Computer Science (First Class) from Mumbai
University (Year 2007).
Personal Details:
Name Jatin Gandotra
:
Date of March 16,1984
Birth :
Passport G9572996 (Valid up to 2018)
:
Marital Unmarried
Status :
Nationality INDIAN
:
Contact this candidate