BHAVESH R. VARODIA

Mumbai, Maharashtra, India

Mobile: +91-900******* E-Mail: ac8q0p@r.postjobfree.com Best time to call: Anytime

Skype Id: ac8q0p@r.postjobfree.com

A professional with Oracle experience, seeking a position where able to provide a strategic database direction for the organization

SUMMARY

An ORACLE Database Administrator/ITIL certified professional with 7 years of experience and knowledge in migrating code, database changes, data and menus through the various stages of the development lifecycle

Currently, associated with ATOS GLOBAL as an Oracle Database Administrator

Adept in creating and maintaining all databases required for development, testing, education and production usage

Deft in performing the capacity planning required to create and maintain the databases

Proficient in handling daily database activities like backup, data growth, log shipping and recovery of archive log at DR server etc.

Conversant in performing ongoing tuning of the database instances and Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database

Well versed in planning and implementing backup, recovering, implementing and enforcing security for all of the Oracle Databases

Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems

Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively use Data Guard Broker utility for the switchover activities.

Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle

Hands on experience in performing database reorganizations as required to assist performance and ensure maximum uptime of the database

SKILL SET

DR test Support

Database Security

Team Management

Performance Tuning

Upgrades/Migration

Backup and Recovery

Requirements Gathering

Real Application Clusters

Physical Standby/Data guard

Golden Gate Administration

Oracle Installation Configuration

Server and Database Level Security

TECHNICAL SKILLS

Database:

Oracle 9i,10g,11g,ORACLE RAC 11G, ORACLE 12C

Database Tools:

TOAD,RMAN,SQL*PLUS, MICROSOFT SQL SERVER (INSTALLATION,BACKUP,CREATING DATABASE AND USERS)

Operating Systems:

Red hat Linux (ES/AS),Unix,SUN Solaris,OPEN VMS, IBM-AIX & Windows family

EDUCATION

Bachelor of Engineering (Electronics), Vivekananda Education Society of Institute and Technology (University of Mumbai), Chamber, Mumbai - 2008

LANGUAGE SKILLS

Proficient in English

GLOBAL EXPOSURE

Deputed to France and Saudi Arabia for Onsite Projects, Working for clients in North America like ASHLAND, VALVOLINE, MONSANTO, HUNTSMAN, VENATOR, CSM BAKERY, NYBC,AIRBUS, SIEMENS.

CERTIFICATION

ITIL V3 Foundation Certified – 2013

Oracle PL/SQL Developer Certified Associate (2008)

AVAILABILITY

Willing to relocate immediately`

EXPERIENCE

ATOS GLOBAL Oracle Database Administrator Oct 2014 - Present

Clients:- AIRBUS(FRANCE), ASHLAND, VALVOLINE, MONSANTO, HUNTSMAN, VENATOR, NYBC, CSM Bakrey,SIEMENS

Responsibilities:

Handling daily database activities like backup, data growth, log shipping and recovery of archive log at DR servers

Managing and maintaining databases on 11g RAC with ASM instance

Installing Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC

Processed Onsite Project Transition and database switchover from physical to standby mode and vice versa, and database up gradations

Working on tools like SEMAPHORE, MANGHAS, REMEDY and CONTROL-M (backup tool)

Extensively using DBA Utilities, RMAN, Oracle Enterprise Manager, SQL*Loader, and Export/Import, Performance Monitoring, Backup & Recovery Basic activities

Creating and managing the Database Objects and Schemas

Working on Data Guard (Physical and Logical Standby Databases)

Cloning, Schema, and database refreshing activity

Managing Oracle database and oracle client installation

Monitoring backup jobs via control M tool

Managing the All DBA related daily basis activities

Administrating, tuning, monitoring, disk space management ensuring data security and access control

Following the ITIL process and adhering to customer's SLA's with good understanding of the business

ROLTA India Limited Oracle Database Administrator Oct 2012 – Oct 2014

Responsibilities:

Handled daily database activities like backup, data growth, log shipping and recovery of archive log at DR server etc.

Managed Configuration of Database, Database cloning, Schema refreshing activity

Solved oracle related issues for various applications like SPF, SP3D, P&ID and SPO

Generated AWR and STATSPACK report depending on oracle edition

Worked on exp/imp and data pump

Pro-actively monitored Database, Version Upgrades

Implemented logical and physical backups

Maintained production database

Migrated Database & patching

Monitored and created standby database

NH INFOMEDIA (Client-Hewlett Packard) Oracle Database Administrator

July 2011 – Oct 2012

Responsibilities:

Reorganized tables and handled database switchover from physical to standby mode and vice versa and database up gradations

Managed physical and logical structures and moved data files to other mount points

Managed database availability and implemented backup strategy (hot as well as cold) for production and other database taking backup of MS SQL database

Exported/imported schemas and analyzed table’s schema refreshing activity, shifting ATM from one database to other

Handled Database performance monitoring and monitoring of production and standby database

Supervised DC-DR health/status and generated AWR reports

Handled daily database activities like backup, data growth, log shipping and recovery of archive log at DR server etc.

Monitored the database utilization by checking the queries and taking high resources in database

Extended support with Finacle frontend application

Secure backup of MS-SQL database enabled and disabled restore job on SQL server

PROJECTS HANDLED

On-site Project (ATOS) - France (AIRBUS)

Single handily handling the project transition for the AIRBUS

Communicating with client and previous service provider, and understanding and implementing their SLA (DBA perspective) to ATOS

Providing knowledge transfer on REMEDY, MANAGHAS, CONTROL +M and SEMAPHORE tool to ATOS DBA team

Participating in incident management and execute problem/change management

As Database admin, finalizing the parameters that need to be monitored for databases and backing up the policies which need to be implemented

Maintaining the repository databases of ticketing system and transition to Support team, post implementation

Studied the process to find the loopholes of the process and provide quality customer service

On-site Project (ROLTA) - Sadaf Plant, Saudi Arabia (Dammam)

Installation of Oracle and migration of old databases

Creation of schema and raising backup

Maintenance of production database

Managing Database users, Database Security, Maintenance of database during data loading

Gather stats and Index rebuilding

Solving performance related issues

References available upon request

Contact this candidate