Summary
Overview
Work History
Education
Skills
Key Functional Areas
Timeline
Generic
Yuvakumar L R

Yuvakumar L R

Summary

Having 5.3 Years of experience on Oracle 12c/19c as Database Administrator in managing complex database systems, adept in installation, maintenance, and tuning of high-availability Oracle databases. Seeking Oracle Database Administrator position in a challenging environment, where I can make significant contributions towards the company's immediate & future goals.

Overview

5
5
years of professional experience

Work History

Oracle Database Administrator

Cognizant ( Indies Technologies Pvt Ltd)
Bangalore
08.2022 - 07.2024
  • Managing Production, Non-Production, Development and Test database in 24/7 Environment
  • Checking the free space at O/S Level
  • Performing daily database activities like checking alert log, checking backups for errors and issues
  • Performing Daily Health check for Production, Non-Production Databases
  • Monitoring Physical Structure of Oracle Database like Data files, Redo log files, Control files
  • As per project Requirement and Resizing Data files and addition of new database files
  • User Management - Allocating Quota, Managing Profiles and Granting / Revoking privileges.
  • Resolving user's day-to-day issues
  • Implementation of Data Guard (Physical Standby database) and Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it to make sure the Primary and Standby databases are in SYNC
  • Performing DR Rebuilding and performing Switchover Activity
  • Maintaining and managing stand-by databases using Oracle Data Guard
  • Data Guard configuration and Switchover via DGMGRL
  • Worked with oracle support to resolve problem
  • Checking the file systems for threshold limits
  • Implemented ASMM & AMM feature in Memory Tuning
  • Performed Schema refresh and Database Cloning from Production to Test environment
  • Resolved the issues in conflicts between the target and source database in Golden gate
  • Database patching and Applying Rolling Patch on Standalone database
  • Monitoring Space Related Issues of (data files, Table spaces and Disk/Disk Groups)
  • Scheduled and configured cron jobs for backups.

Oracle Database Administrator

PPS Motors Pvt Ltd
Hyderabad, India
03.2019 - 08.2022
  • Installations and configurations of Oracle 12c RAC on Linux
  • Migrating the databases from Non-ASM standalone to ASM
  • Involved in changes of shell scripting as per RAC setup
  • Worked on DB related issues which are faced by the test team and clients
  • Experience on DATAGUARD and Create and maintaining Physical standby database
  • Good experience in Oracle Installations and Oracle database Creation through DBCA,OMF and ASM
  • Creation of ASM databases, ASM instances and administration of ASM Instances and ASM Disk groups on the CORE environment
  • Creating SR with Oracle Support and follow up
  • Applying patches using O Patch utility
  • Implementation of Backup and Recovery Strategies using RMAN
  • Load balancing on both server side and client side
  • Taking backup of OCR and VOTING DISK
  • Experience on DATAGUARD and Create and maintaining Physical standby database
  • Cloning the Oracle home and upgrades
  • Creating health monitoring UNIX shell scripts
  • Experience in cloning the databases through Hot/Cold and RMAN utility and refreshing the databases
  • Configuring networking oracle for managing DB links and materialised views
  • Exporting and Importing database backups using Export & Import
  • Regular monitoring of Alert log file on a day-to-day basis
  • Analytical and able to adapt to new environments and learn new technologies quickly.

Education

Bachelor of Science -

Glocal University
01-2016

Skills

Operating systems: Windows, RHEL, Sun Solaris

Languages: SQL

Databases: Oracle

Scripting: Shell Scripting (korn shell and bash shell)

Tools & Utilities: DATAPUMP, RMAN, SQL LOADER, SQL*PLUS, ORACLE Net CA, OEM

Key Functional Areas

  • Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
  • Good experience in Oracle Installations and Oracle Database Creation through DBCA, Manual, OMF and ASM.
  • Experience in user management, roles and profiles.
  • Creating users with restricted access with required privileges
  • Creating profiles and attaching them with users and monitoring the users.
  • Exporting and Importing database backups using Exp & Imp and EXPDP/IMPDP utilities.
  • Experience in configuring and maintaining ASM Disk Groups & ASM databases.
  • Experience in Configuring and managing backup through RMAN utility.
  • Experience in RMAN configuration using recovery catalog.
  • Experience in Backups and Recovery and Cloning of databases using RMAN.
  • Experience in Upgradation of database from 11g to 12c and 12c to 19c.
  • Experience in Configuring and maintaining Physical standby/Active standby Databases.
  • Experience with RAC to Non RAC cloning and vice versa
  • Experience in Patching the RAC databases in Rollover manger
  • Experience in maintaining the Cluster databases using srvctl and crsctl.
  • Knowledge on Oracle Database performance-tuning services with EXPLAIN PLAN,TKPROF and AUTO TRACE.
  • Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM.
  • Provided end to end administrative support on applications which involves Oracle databases.
  • Experience in Oracle Support processes in logging service requests and other Support Procedures.
  • Deployment of agents and registering databases to OEM.

Timeline

Oracle Database Administrator

Cognizant ( Indies Technologies Pvt Ltd)
08.2022 - 07.2024

Oracle Database Administrator

PPS Motors Pvt Ltd
03.2019 - 08.2022

Bachelor of Science -

Glocal University

Similar Profiles

CREATE PROFILE
Yuvakumar L R