Vijaykumar Patil

Mobile: - 888-***-****/ 776-***-**** Address – Mayur Plaza,shivraj nagar

Email: - adcmp0@r.postjobfree.com Rahatni Pune 411017

PROFILE: -

A professional Oracle Database Administrator with 12 Years of experience with expertise in Infrastructure Operations. Also, have 3+Years of Good experience in MongoDB administration.

EXPERIENCE SUMMARY: - : MongoDB Administrator – 3 Years 6 Months

•Database Software Installation, Upgrades and Patching.

•Database Instance Creation, Configuration, and Changes

•User and Access Control/Security Administration and Maintenance.

•Experience in MongoDB Replication.

• Experience Replica Sets Configuration

•Experience in upgrading various version of mongo databases

•Experience in deploying managing mongodb cluster.

•MongoDB Shading and Shard Configuration.

•Experienced in Installation of Mangodb and 3 node replication configuration.

•Backup and restore Mongo databases

Oracle Database Administrator – 11 Years 5 Months

•11 Years of Oracle database administration experience supporting multiple Oracle’s telecom

•Cross platform migration of database with different versions from 11.2.0.1 to 11.2.0.4 and Expertise in Database performance solution for multiple costumers across the Europe and Middle East Asia, for consulting solutions of multiple applications and products used.

•Experience with Oracle 10g/11gR2 (Standalone/RAC 10g and 11g R2), 12c (Multitenant) end to end solution design, implementation, troubleshoot and administration.

•Database Performance Tuning Expertise.

•Expertise in Backup, recovery and cloning of the databases with Manual and RMAN methods, backup methods used as HOT backup, BCV Split, RMAN.

KEY SKILLS [ORACLE]: -

•ORACLE 10g/9i/11g R2, 12c (Multitenant) installation and Administration.

•ORACLE 11g RAC implementation and Administration with ASM and NON ASM Storage.

•Database cross platform migration.

•Oracle Performance tuning and analysis for 11g R2 database.

TRAININGS:

Big data Hadoop Training, Oracle New Features 12c, Oracle 11g performance tuning.

CERTIFICATION: -

Oracle 10g OCA and MongoDB administration.

ONSITE (Outside India) EXPOSURE: -

Role

Organization

Durations

Country

Vodafone Transition

Vodafone India

15-Jan-2018 to 30-Jan-2018

QATAR

Experience Summary

Organization

Role

Duration

Vodafone India service Pvt ltd

SME (oracle +Mongo dB + Hadoop Admin )

Jun 2014 – Till Date

IBM India Pvt Ltd

Sr. (L3) - DBA

Feb 2011 - Jun-2014

Wipro

Sr. Data Base Administrator

May 2010 - Feb 2011

TCS

Database Administrator

Jan 2010 – May 2010

Softenger India pvt ltd

Database Administrator

OCT 2006 - Jan 2010

ROLES AND RESPONSIBILITIES: -

Vodafone India Limited - Manager (From Jun-2014 to till date)

Client –Vodafone Qatar (From Oct-2017 to Till Date)

Responsibilities:

•Team lead and Technical consultant for Oracle Database Administration.

•Specialization in Performance tuning of BRM, SIEBEL, AIA, OSM databases.

•Exadata X4-2 monitoring.

•Golden gate Configuration and monitoring.

•Installation of Mangodb and 3 node replication configuration.

•Backup and restore Mongo databases.

•Identify the security gaps and develop a solution to bridge them.

•Monitoring database performance using OEM 13c.

Client - Vodafone UK and Europe –Deputy Manager (From Jun-2014 to Oct-2017)

Responsibilities:

•Team lead and Technical consultant for Oracle Database Administration.

•Working Knowledge of configuring Data Guard Physical Standby Database / Logical Standby database, using offline backup, RMAN, Active database.

•Prepare Clustered Physical standby database on ORACLE 12c.

•Database up-gradation and patching of Oracle software.

• Installation MongoDB 3.4 database on Linux.

•Storage and space management including table spaces and data files.

•Monitoring database performance using OEM 12c.

•Database SQL tuning- Analysis of SQLTRPT, ADDM report, AWR report, explain plan based analysis using with AUTOTRACE feature of Oracle. using SQL Profile and SQL Tuning sets.

•Solution design of cloning of DR site from Physical standby database to reduce the backup load on primary.

•Installation, Upgradation, and configuration of Golden-Gate.

• Experience on Mongo dB administration.

• Experienced in Installation of MongoDB and 3 node replication configuration.

• Backup and restore Mongo databases.

• Patching Standalone and RAC databases with multiple node environments.

• Database refresh from production environment using Active database, database cloning, cold / hot backup restoration and Export/Import

IBM India Pvt ltd . - Senior DBA (May 2011 to 1 Jun 2014)

Client : - IDEA Cellular LTD (largest Telecommunications Service Provider).

Responsibilities

Working as a L3 DBA and I am the owner of 100+ productions databases including Production, UAT, DEV and TEST environments

For any application change release, as an Oracle L3 DBA, I need to analysis of the changes and impact on production database due to changes

For any new query, we need to check execution plan and elapsed time for query and accordingly suggest the user for any changes

Meeting with Ops and development team for any release and impact analysis for any changes.

Planning for any maintenance activities and making checklist and guiding for junior DBA team members

Partitions addition for one full year on Daily, weekly and monthly partitions tables.

Oracle 10g NON-RAC database Upgraded to Oracle 11g RAC

Oracle 11g database storage migration from Old storage to New Storage.

Proactive database tuning analysis and suggestions to Ops team.

Working on DR and BCV of database, Patch Management

Closely monitoring Backup and working on problematic part

Handling INC (Incidents) and RFC (Request for changes) tickets.

Interacting with clients if any issues occurs

Participating on RCA meeting with Incident management team.

Wipro InfoTech ltd - Senior DBA (May 2010 to Feb 2011)

Client: Mattel Oracle Database Production Support

Responsibilities

Transition of oracle database from Third party to current company.

Working on BMC Remedy Ticket System.

Configuration of databases in OEM grid control.

Working on Backup failure

DR Configuration and monitoring DR

Oracle Patching/Installation, Database creation.

Working with Metal ink on Issues

Refresh The Test/Development Database.

User management and Space management..

TCS Mumbai - System Engineer (Jan-2010 to May 2010)

Client:- Genworth Finance –Corporate (USA)

Role Team Member – Oracle DBA Team (Production Support)

Responsibilities

Installation and configuration of Oracle 9i/10g server and creation of databases.

Installed, upgraded and patched Oracle software.

Creating clone database for Testing Purpose.

Maintenance and monitoring of different clients databases (table spaces, data files)

Implement and maintain database security (create and maintain users and roles, assign privileges)

Schemas replication through import /export

Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron, creation of users, schemas, tablespaces and other database objects.

Softenger india pvt ltd. - Backup Engineer and Oracle DBA (Oct 2006 – Jan 2010)

Client :- Idea cellular ltd.

Responsibilities:-

Alert Monitoring through OEM grid control.

Working with 200 GB to 21 TB of databases, more than 900 databases.

Installing Oracle server and client software’s

Creating new databases as per application requirements.

Scheduling cron jobs (Exports, Mview Refresh, Analyze Tables and RMAN Backups).

Utilizing backup strategies with RMAN and EXPORT

Managing Archive Log files, taking backup and free up the space.

Creating Materialized views and refreshing them daily, fast or complete.

Checking growth of tablespaces, adding datafiles, resizing existing datafiles.

Apply CPU patches on quarterly basis.

Creating new schema, profiles, granting privileges as per user request.

Creating Database Links (Public & Private).

Month end activities, creation of new tablespaces, partitioned tables etc.

Familiar with process of working with oracle such as raising tar

Automated scripts for database space monitoring.

Working on Backup failure

DR Configuration and Montoring DR

Working with Metalink on Issues

Participation in Oracle Technical Presentation

Refresh The Test/Development Database.

Experience in DATA mirror tool.

Professional Qualifications

Certifications: OCA10g

Trainings on Exadata machine X4-2 from Oracle.

Certification: Mongodba.

Awards and Recognitions

Received performance award for completing capacity planning for the year of 2008.

Received an appreciation from Onsite manager in Dec 2015 for provisioning & configuring a database

Environment 12c and Test case POC.

Received recognition Jul-15 to apr 2016 for contributions throughout the year.

Academic Qualification: -

B. E ( Electronics and Telecommunication ) from SGGS Nanded

Personal Details

Date of Birth

10/02/1983

Passport No

H4218684

Status

Married

Contact this candidate