Oracle Manager

Shyam Kishor Agarwal

Pune

Mobile: +91-735*******

Email: **********@*****.***

Objectives

In quest of position that would utilize my current skill set and challenge my various abilities in Database Administration as well as various field of Computer Application. Seeking for an organization that offers career growth and chance to achieve goals through persistence and hard work.

Professional Synopsis

5.1 years of comprehensive experience in the areas of: Oracle Database Administration

Currently associated with Veritas Technologies Pune since June 2017.

Good Experience in Oracle Golden Gate.

Having good knowledge on AWS Cloud Web Service Infrastructure like EC2, RDS, Redshift, S3 and others.

Managed more than 1850 databases for UBS (UK, USA & APAC region).

Handled more than 750 databases for Kraft Foods (UK & USA) including (PROD, PRE-PROD, STG, and DEV) environments.

Experience in designing, implementation, maintenance of a production database with good communication and interpersonal skills.

Employment Details:

Company: Veritas Technologies Pune June 2017 – till date

Company: UBS Pune April 2016 – May 2017

Database Administrator with Oracle 10g/11g/12c

Company: UBS Singapore October 2015 – April 2016

Database Administrator with Oracle 10g/11g/12c

Company: Amdocs May 2015 – October 2015

Database Administrator with Oracle 11g/12c (L2)

Company: Mphasis- An HP Company June 2013 - April 2015

Database Administrator with Oracle 10g/11g (L1)

Roles:

Currently providing L2 24*7 support for Production and Development Databases in Veritas Technologies.

Chief responsibilities encompass:

Database Upgrade.

Full database and Schema refresh.

DR Maintenance/Synchronization/Re-build.

Database Cloning.

Database creation and maintenance in DBaaS.

Installation, creation and configuration of oracle database.

Encryption using Database Vault and Wallet.

Hot backup of our database, logical backup on daily basis using Simpana.

Configuring the Oracle instance using the Initialization parameters.

Setting Up Static and Dynamic Parameters.

Resolving gaps in Golden Gate.

Working on database performance issues on daily basis.

Space Management (management of tablespaces and data files).

Chief responsibilities encompass:

Oracle Installation &Database creation

Schema refresh& Database refresh.

User management and accessibility.

Management of logical and physical structure.

Hot backup of our database, logical backup on daily basis.

Chief responsibilities encompass:

Schema refresh& Database refresh.

Handled administration of 24*7 Production and Development Databases

DB migration in Oracle 11g using Data pump.

Manual and Silent Oracle Client Installation on different Platform for Application users.

Upgrade the single instance database from 10.2.0.1 to 11.2.0.3

DR Maintenance/Synchronization/Re-build.

Space reclaim where required across the databases.

User management and accessibility.

Management of logical and physical structure.

Applying Oracle patches quarterly using opatch utility.

Maintenance of Database using RMAN

Performing recovery using logical backup, physical backup & RMAN backup.

Tracking of User trace file and Alert log file.

Areas of Expertise:

Technical:

Clear Understanding of Oracle 10g/11g Database, Data guard, RMAN, Data Pump, Golden Gate and RAC

Upgrade Oracle Database from 10.2.x to 11.2.x.

Installation of oracle software & oracle client on UNIX and Window platform.

Clear Understanding of Oracle Database Architecture.

Excellent troubleshooting skills to identify root cause and resolve problems related to application and systems functionality.

Good knowledge on RAC & Golden Gate.

Physical and logical standby database.

Resolved various issues related to Physical standby databases like resolving the gap between Primary and Standby etc.

REAL APPLICATION CLUSTER - 11gR2

Real Application Cluster Installation (Multiple Instances).

CRS manage with crsctl and server control (srvctl).

Good understanding of Oracle Cluster ware software.

Node application services such as VIP, SCAN IP, and HAIP.

Good Knowledge of Oracle Cluster Registry (OCR), Oracle Local registry (OLR) and Voting Disk.

TAF (transparent application failover) Setting for client.

How to maintain GRD (Global resource directory) by different nodes.

GOLDEN GATE – 11g/12c

Implemented High availability using Golden Gate Replication

Implemented Uni-directional and Bi-directional replication using various versions of Golden gate.

Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.

Implemented classic Golden gate replication as well as integrated replication. Implementing and maintaining database security

Installed and implemented Golden gate to replicate data between databases.

Golden Gate refresh after Database refresh.

Patching GG Home.

AWS Web Services:

Aws (Amazon web services): EC2, VPC, IAM, S3, CLOUD WATCH, GLACIER, RDS CONFIG, ROUTE 53, SNS, SQS, BASIC CONCEPT OF ELASTIC CATCHE

MAINLY CONCENTRATED IN EC2 (ELASTIC LOAD BALANCE, AUTO SCAING, EBS), VPC, S3, IAM

Utilized Cloud Watch to monitor resources such as EC2, CPU memory, Amazon RDS DB services

Setup and managed security groups, VPC’s specific to environment.

Platform:

Operating System : Windows, UNIX (HP-UX), Linux, Solaris

RDBMS : oracle 10g/11G/12C

Oracle tools/ Utilities:

SQL*PLUS

Database Configuration Assistant

Oracle Net Manager

Recovery Manager (RMAN)

Oracle Enterprise Manager (OEM)

AWR/ADDM

Srvctl

Crsctl

Education:

Passed Bachelor of Engineering in Information Technology from PUNE University in 2012.

Passed XII board from Nowrosjee Wadia College (Board: HSC, Pune) in 2008.

Passed X board from DAV Kapildev School (Board: CBSE,New Delhi) in 2006

Personal Details:

Date of Birth : 30th October, 1989

Marital Status : Married

Nationality : Indian

Languages known : English, Hindi

Date: (Shyam Kishor Agarwal)

Contact this candidate