Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Personal Information
Languages
Timeline
Generic

RAMPRABU S

Bangalore

Summary

Highly skilled Database Administrator with 13+ years of experience in designing, implementing, managing and optimizing high-performance Oracle databases, particularly within the OCI environment. Proven track record of ensuring data integrity and optimizing database performance. Proven track record of improving database performance by more than 50%, implementing robust backup and recovery strategies, and ensuring data security in OCI environments. Skilled in cloud migration, automation, and orchestration using OCI console and scripts. Proven ability to lead and manage large-scale database migration projects with zero downtime.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Principal Database Administrator

Oracle India Private limited
07.2019 - Current
  • Deploying database environment in Oracle Cloud Infrastructure.
  • Defining cloud migration strategy from on premises to Oracle Cloud Infrastructure.
  • Creating the new databases and manage the database services in OCI database servers.
  • Configuring the monitoring of the database through OEM as well as through other monitoring tool like Prometheus.
  • Schedule the jobs for database operations like cleanup, log sync, statistics gathering to function database efficiently.
  • Configure and monitor the dataguard setup between different OCI location to make sure the data is available whenever the primary database is not available.
  • Configure and monitor RMAN backups. Restore the data from the backup whenever needed.
  • Cloning the data from the production to the Test/Development periodically also based on the request.
  • Managing and executing sql scripts during the maintenance as well as whenever needed.
  • Plan and apply patches for database as well in Operating systems during every release of the quarter.
  • Automate the database jobs based on the conditions and which are all repetitive.
  • Managing tablespace by appropriate actions like resizing or adding datafiles and capacity planning.
  • Databases consolidation and upgradation.

Senior Database Administrator

HCL TECH
07.2017 - 06.2019
  • Installation and Creation of Oracle 11g Databases on various environments.
  • Configuring RMAN backup and maintenance.
  • Cloning the data from the production to the Test/Development.
  • Administering users, roles and privileges according to the environment.
  • Managing tablespace by appropriate actions like resizing or adding datafiles and capacity planning in order to be ready for space requirements.
  • Applying customized patches on production and non-prod environments.
  • Databases consolidation and upgradation.

Oracle DBA/Architect/ Chennai Operations lead

TCS
02.2014 - 06.2017
  • Installing oracle software and building new databases on LINUX OS.
  • Storage and space management including table spaces and data files.
  • Creation of database users, roles and implementing security features.
  • Ensure potential problems such as performance degradation, reliability and security issues are addressed proactively.
  • Troubleshooting the issues on ASM (Automatic Storage Management), Non ASM environment and Cluster file system.
  • Oracle Database Backup and Recovery using RMAN (Recovery Manager).
  • Refreshing the database periodically using backup-based duplicate as well as datapump.
  • Managing the Standby databases and resolving the log sync gap issue with Primary databases.
  • Database monitoring like checking the memory utilization, status of the data files and log files & act on those alerts if the action required.
  • Analyzing the AWR report for Top resource consuming queries and taking necessary action to optimize the problematic area.

Database Administrator/ Architect

TCS
07.2011 - 06.2017
  • Installation and Creation of Oracle 11g databases on various environments.
  • Configuring RMAN backup and maintenance.
  • Cloning of Oracle databases from the production to the Test/Development.
  • Managing tablespace by appropriate actions like resizing or adding datafiles.
  • Performed capacity planning in order to be ready for space requirements.
  • Applying periodic patches on production and non-prod environments.

Education

Under Graduate - Mechanical Engineering

Thiagarajar College of Engineering
Madurai

Skills

  • RMAN
  • Datapump
  • Oracle Enterprise Manager
  • DBCA
  • AWR
  • ADDM
  • TKPROF
  • SQL developer
  • Exacheck
  • OsWatcher
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 19c
  • Linux
  • Windows Server
  • Windows 7
  • Windows 10
  • VMware
  • VirtualBox
  • Oracle Cloud Infrastructure
  • Shell
  • Prometheus
  • OEM
  • Jira
  • BMC Remedy
  • Service Now
  • VERITAS Net backup
  • Rsync
  • WinVNC
  • Terminal Server
  • Oracle database administration
  • Cloud migration strategy
  • Database backup management
  • Performance monitoring
  • Patch management
  • Effective communication
  • Database analysis
  • Database monitoring
  • Performance tuning
  • Data migration
  • Database backup
  • Database administration
  • Backup and recovery
  • Disaster recovery
  • Job automation
  • Team collaboration
  • Problem solving
  • Linux operating system
  • Capacity planning
  • Root-cause analysis
  • Replication management
  • Database troubleshooting
  • Data cloning techniques

Certification

  • Oracle Exadata Database Machine X9M OCS
  • Oracle Cloud Infrastructure 2019 Certified Architect Associate
  • Oracle Autonomous Database Cloud 2019
  • Oracle Certified Professional 12C
  • Oracle Certified Associate 11g

Accomplishments

  • Build the database and setup the database services like backup, dataguard in OCI.
  • Migrating the data from non-OCI environment to OCI environment.
  • Recovering the lost data in production database which is of size 4 TB.
  • Restored the test database from production standby backup.
  • Importing the schema of size 1 TB.
  • Reclaimed 1 TB storage space using reorganization.
  • Improved the performance of SQL using dynamic sampling hint.
  • Deep analysis on parameter parallel_degree_policy that reduces the process count which hits the database.
  • Deep dive on memory alerts which reduces error counts significantly.
  • Rectification of corrupted blocks in the database.
  • Analysing the query which are not using bind variables with help of parameters force_matching_signature and exact_matching_signature and optimizing that query.

Personal Information

  • Passport Number: Y7053851
  • Passport Date Of Issue: 09/21/23
  • Passport Place Of Issue: Coimbatore, INDIA

Languages

English
First Language

Timeline

Principal Database Administrator

Oracle India Private limited
07.2019 - Current

Senior Database Administrator

HCL TECH
07.2017 - 06.2019

Oracle DBA/Architect/ Chennai Operations lead

TCS
02.2014 - 06.2017

Database Administrator/ Architect

TCS
07.2011 - 06.2017

Under Graduate - Mechanical Engineering

Thiagarajar College of Engineering

Similar Profiles

CREATE PROFILE
RAMPRABU S