Data Base Administrator

Vishal Varma R

Mobile: +91-739*******

E-mail: **********@*****.***

Objective

To secure a challenging position in a reputable organization to expand my learning, knowledge and skills.

Summary

Having 3 years of experience as an Oracle Database Administrator with hands on experience in administering Oracle Database in Linux.

Having good knowledge in installation, Database creation, administration, production support, backup and recovery and other wide range of database activities. Certification

Oracle Autonomous Database Cloud 2019 Certified Specialist Overall Responsibilities as Database Administrator

Excellent in Installation and configuration of Oracle 11g, 12c in Linux environment.

Creation of database using DBCA utility, Manual Method, Shell script.

Experience in capacity planning, space management.

Good experience on Schema, User management, Space maintenance as per requirement for tablespace and segments.

Monitoring the table fragmentation and rectify by online redefinition of tables.

Experience in Cold backup, hot backup and recovery in RMAN.

Monitoring the growth of the database and initiating appropriate actions.

Analysing the SQL queries using explain plan and creating necessary indexes.

Designing and implementing backup and recovery strategies.

Backup on Tables, Schema and Database level using Expdp/Impdp Utility.

Performing Backup and Recovery Using RMAN.

Cloning database from production to testing using RMAN Backup.

Performance tuning to the SQL query, Analysing AWR report.

Creating and maintaining the physical standby databases and also checking the health of the standby database as per client requirement.

Switchover the database from primary to standby and standby to primary.

Knowledge in ASM and RAC.

Professional Experience

Working as Oracle Database Administrator in Markone Technologies Pvt Ltd from Aug 2018 to Till Now.

Educational Qualification

BE(CSE) from Jaya Engineering College with 65% in the year (2014-2018).

HSC from Motilal Fomra Hr. Sec School, Chennai with 63% in the year 2014.

SSLC Motilal Fomra Hr. Sec School, Chennai with 81% in 2012. Technical Skills

Operating System : Linux

RDBMS : Oracle 11g,12c.

Tools / Utilities : Oracle RMAN, expdp, impdp, putty, DBCA. Languages : SQL,PL/SQL

Project 2:

Client : Zurich Financial services.

Environment : Oracle 12c, Red Hat Enterprise Linux 6.6 Role : L2 support

Duration : Oct 19 to Till Now

Roles and Resposibilites:

Installation of Oracle 12c on Linux platform

Managing & monitoring database growth.

Resolving Tablespace, Archive space issues.

Granting the necessary roles, privileges and profiles to the users.

Managing Tablespaces, Datafiles and Archive files.

Involved in configuring Physical Standby database and tested Switchover.

Checking MRP process which applies the redo data in to standby database.

Performing Logical Backups through Export/Import and Datapump Utility.

Refresh Schema and Database as per requirement.

Creating catalog mode and register the database in RMAN

Performing Backup and Recovery using RMAN.

Cloning the database from production to testing.

Implementing backup strategies – RMAN and User Managed Backups.

Analysing the SQL Query using Explain plan.

Performing Hot Backup and Cold Backup.

Creating users as per requirement and also releases user level locks.

Checking the Data files consistency using DB Verify Utility.

Monitoring the database growth and partition of Tables.

Analysing Tables and Indexes to Rectifying Database Fragmentation. Project 1:

Client : Tesco plc.

Environment : Oracle 11g, Red Hat Enterprise Linux 6.5 Role : L2 support

Duration : Nov 18 to Oct 19

Roles and Responsibilities:

Monitoring the growth of Database, Tablespace and Disk level.

Check Alert Log errors and make necessary steps to rectify them.

Monitoring the database for Memory and I/O utilization.

Creating Schema with quota maintenance and roles and privileges.

Backup on Tables, Tablespaces, Schemas using Exp/Imp and Data Pump.

Loading the data into the Database using SQL Loader.

Monitoring the database growth and partition of Tables.

Analysing Tables and Indexes to Rectifying Database Fragmentation. Personal Details

Father Name : Vishal Varma R

Gender : Male

Marital Status : Single

Nationality : Indian

Date of Birth : 21-SEP-1995

Language Known : English, Hindi, Tamil

Contact this candidate