Sec School Database Administrator
Resume:
Ragavendran R
: *.***********@*******.***
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