Ragavendran R

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

: adohvh@r.postjobfree.com

OBJECTIVE

Seeking an opportunity in the information technology field that utilizes my experience as an Oracle DATABASE ADMINISTRATOR. This position will provide opportunity to creatively exploit my educational background and technical knowledge.

SUMMARY

Having 6 years of experience as an Oracle Database Administrator with hands on experience in administering oracle Database in Windows and Linux.

Having good knowledge in installation, administration, production support, backup and recovery, Database Migration, upgradation and support application of patch and other wide range of database activities.

Working on Exacc environment with multitenant databases.

Domain – Construction, Oil & Petroleum Gas, Banking, Insurance & Financial Services

CAREER EXPERIENCE

Oracle Database Administration

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

Creation of database using DBCA utility and Manual Method

Good experience on User management, Roles and Profiles creation

Restore & recover the database using PITR in RMAN

Monitoring the growth of the database and resize the tablespaces accordingly

Involved on Implementation of Tablespace Encryption (TDE)

Backup on Tables, Schema and Database level using datapump Utility

Creating DB links on databases

Handling Partitioning on tables

Performing Backup and Recovery Using RMAN

Cloning database from production to testing using RMAN Backup

Experience in Upgrade database (11gR2 to 12cR2)

Experience in Migration database Oracle 12cR2 to PostgreSQL 9.6

Applying Patches such as one-off patches to bug fixes and PSU patches on quarterly basis

Analyzing the SQL queries using explain plan or auto trace to sort out performance issue underlying the queries

Handling performance tuning using AWR report, ADDM report & SQL Tuning Advisor

Installation of RAC/ASM and managing RAC Environment efficiently

Creating ASM disk group using ASMCA

Migrated Non-ASM Instance to ASM Instance

Dataguard setup with DGMGRL configuration

Periodically switchover the databases between primary and standby

Involves in code & package deployment in Acceptance & Production database.

Creating Materialized View to remote table for accessing with better performance

Analyze, gather stats to table level / schema level

Working experience in Exacc architecture databases

Having a knowledge of Oracle Golden Gate architecture and practical experience in table level replication on homogeneous database.

Knowledge in Linux OS

Installation and Configuration of Redhat Servers 5.0/6.0 in VMware

Install, update and upgrade the packages using with rpm and yum tools

Configuration of Remote Access utilities, providing user access control on services like telnet, ftp and ssh.

Monitoring the Servers performance using with performance monitoring tools like top and ps etc

Configuring and Maintaining the Disk Quotas and ACLs (Access Control Lists) for users

Configuring ssh key-based authentication to connect remote server

Configuring the LVM (Logical Volume Manager) and extended the logical volumes online

Creating and Managing the File Systems

Creating disk partition

Installation and configurations of Samba,NFS and FTP

Responsible for creating, modifying and deleting users, groups and assigning the permissions to users and groups

Knowledge on Log rotate utility

EMPLOYMENT HISTORY

Years Company Location

Dec 2019 – Present Mphasis Limited Chennai

Sep 2018 – Dec 2019 Cognizant Technology Solutions Chennai

Oct 2014 - Sep 2018 Markone Technologies Chennai

Jul 2012 – Jul 2014 Chye Joo Construction Pte Ltd Singapore

EDUCATION

Pursuing - M. Sc (Information Technology) from University of Madras, Chennai

B. Sc (Information Technology) from NPR Arts & Science College, Dindigul, in 2011 with Aggregate

[7.6 CGPA]

Higher Secondary from PariVallal Matric. Hr Sec School, Singampunari in 2008 with 64%

SSLC from Pari Vallal Matric. Hr Sec School, Singampunari in 2006 with 64%

TECHNICAL SKILLS

Operating System

OEL 6, RHEL 6 & 7 and Windows

Cloud Computing

AWS Cloud (EC2, S3, RDS, AMI, VPC,etc)

Databases

Oracle 11g, 12c & Postgres 9.6, SQL Server 2014

Tools / Utilities

Putty, WinSCP, Xming, SQL Developer, Toad 12.1,

PG_Admin 3.9, Ora2Pg, Tortoise SVN, Metricbeat, VMware,

BMC Server Automation, UAC (Stone Branch),

Ticketing Tools

Service Now, JIRA

Monitoring tools

Metricbeat, Nagios, OEM 13C

Web Server

Apache, Tomcat

Scripting Languages

Shell Scripting & PL/SQL (Basic)

Personal Details

Gender : Male

Marital Status : Married

Nationality : Indian

Date of Birth : 02-Nov-1989

Language Known : Tamil, English

Passport Number : U5726197

Passport Expire on : 08/07/2030

Contact this candidate