Ravindranath Reddy G Email:ravindranathreddy.45@gmail.

com
Mobile: +91- 7989802180

Professional Summary

 Having 10+ years of experience in Oracle Database Administration with OCA certification in 11g.

Roles and Responsibilities as a Database Administrator with TCS

 Working in 24 x 7 environments to maintain and support multiple Oracle Databases in Production

(RAC & Non-RAC) and Non-Production environments
 Leading a DBA team of size 6

Oracle CORE DBA

 Have good understanding of Oracle database Architecture.

 Experience in Oracle 10g, 11g, 12c & 19c Database Administration, installation and configuration of
databases.
 Performed Database migrations, Upgrades ( Manual and DBUA )
 Database SOX Auditing
 Expertise in Vulnerability and Remediation to fix the security related issues.
 Exporting and importing at database level, schema level and object level using Data pump and
traditional Exp & Imp utilities.
 Managing Control files, Online Redo logs and Archive Redo logs.
 Experience in Configuring and Maintenance of Network services (Listener and TNS Configuration).
 Hands on experience in implementing complete Backup and recovery strategies using RMAN,
Hot/Cold Backups, Logical (Import/Export, Datapump utilities) and Physical backup strategies.
 Experience in Cloning the databases and Restorations from Production to Test & QA environments
using Hot, Cold and RMAN backups (both consistent and inconsistent backups).
 Applying PSU patches and Bug patches to fix the bugs using Opatch utility.
 Experience in Replication (Db links and Materialized views).
 Good Experience in Data guard Disaster Recovery (standby testing) and Configuration of Standby
Databases (Data guard) and Snapshot.
 Performed Standby Rebuild activity using RMAN.
 Proficient in Performance Tuning using Explain Plan, TKPROF, ADDM and AWR, Memory Tuning using
ASMM (Automatic shared memory Management) and OEM.
 Monitoring/interpreting alert log and trace files for database performance.

Oracle RAC DBA

 Having good understanding of Oracle RAC Architecture.

 Expertise in Administration of Oracle Real Application Cluster 10g, 11g (R1&R2) & 12c in Linux/Unix
environment.
 Installation and Configuration of Oracle 11g Real Application Clusters (RAC) databases on Linux/Unix
operating system.
 Configuring the Load balancing at the server side & Client Side and TAF (Transparent Application
failover) for RAC database.
 Involved in Rolling Patch for 2-node RAC databases.
 Monitoring the ASM disk group and adding the disk to the disk group when required.
 Experience in Migrating database from Non-ASM to ASM.
 Creating the disk group like External, Normal, and High according to requirement.
 Experience in RAC to Non-RAC cloning.
 Troubleshooting the cluster database using command line utilities CRSCTL and SRVCTL utilities.
 Performed backup creation tasks of OCR (OLR) and VOTING (GPNP) disks.

Oracle Goldengate

 Knowledge in Golden gate architecture and installation.

 Performed One-way replication and knowledge on Bio-directional replication.
 Configure and build Golden Gate Extracts/replicate for multiple databases.
 Manage, deploy and install Oracle Golden Gate in uni-directional and bi-directional modes.
 Troubleshooting the Process failures, Trail-file issues, Synchronization problems.
 Troubleshooting the failures using command line utilities GGSCI utilities.
 Configure error handling for restart, logging, production support and status reporting in Golden Gate. 

Other Replication Tools

 Very good knowledge and Hands-on experience in Realtime CDC (change data capture) tool Attunity
Replicate.

RPA Tools

 Have hands on experience on RPA UiPath tool

MYSQL DBA

 Configured MYSQL server

 Created MYSQL database and configured Standby database
 Configured Primary and Standby synchronization monitoring mechanism
 Worked on few Standby synchronization issues
 Configured Backup Strategy
 Performed backup restoration on various occasions

Actian Vectorwise DBA

 Have hands-on experience in working on Vectorwise database

Professional Experience

Working as Assistant Consultant with TCS Hyderabad, India from Dec 2010 to till date.
Technical Skills

Operating Systems : RHEL AS 4, Sun Solaris 9, 10 and Windows 2000/XP.

Languages : SQL, PL/SQL, Unix-Shell
Databases : Oracle 10g and 11g, 12c/19c
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
Tools & Utilities : RMAN, EXP/IMP, Data pump.

Education Profile

 Bachelor of Engineering (B.E) in Computer Science from New Horizon College of Engineering - VTU
(Visvesvaraya Technological University), Bangalore, India.

Project Experience:

PROJECT 1:

Designation : Database Administrator

Duration : Mar 2011 - Apr 2016
Operating System : Solaris, Linux, Windows.
Database : Oracle 10g, 11g & 12c.
Tools : Putty, RMAN, Toad, Data pump and OEM 13c.

Xerox Corporation
Role: Oracle DBA

 Enhance database administration by automating administration tasks, for e.g. developing scripts for
database instance availability, listener availability, check alert log files for error messages, clean up old
log files before log destination gets filled.
 Involved in tuning of database using Explain Plan, SQL Trace etc.
 Interacting with Oracle Corporation for technical support through metal ink.
 Proficient use of Oracle Enterprise Manager (OEM 13c) (Grid control) for managing and monitoring
Oracle database.
 Database health check-ups and monitoring.
 Applying PSU patches and Bug patches to fix the bugs through cloud control OEM 13c.
 Managing database objects like tables, views, and indexes and Gathering statistics, Rebuilding indexes
to improve query performance.
 Experience in cloning the databases from Production to Test & QA environments through Hot/Cold
backup using RMAN utility.
 Scheduling jobs using crontab and OEM 13c.
 Oracle Networking: Configuring Servers & clients with listener & alias
 Good knowledge on Performance tuning, Database cloning, Flashback, ASM & Data guard
technologies.
 Good understanding on RAC Architecture
 Troubleshooting of RAC environment when node eviction occurs.
 Applying PSU patch in RAC environment using rolling and Non-Rolling method.
 Managing Database Performance using (AWR, ADDM and ASH)
 Refreshing development databases from PROD using RMAN and data pump.
 Handling and managing Oracle physical standby databases (Data guard) manual/DGMGRL.
 Experience in Storage level activities like creating Volumes, adding/mapping LUNs at data center and
creating disk partitions at OS level.
 Experience in Upgrading the Databases from 11g to 12c.
 Administering database security with restricted access by creating users, grant/revoke roles,
privileges, creating and assigning profiles to the users.
 Manage, deploy and install Oracle Golden Gate in uni-directional and bi-directional modes.
 Troubleshooting the Process failures, Trail-file issues, Synchronization problems.
 Database schema replication between two databases using oracle Golden gate.

PROJECT 2:

Designation : Database Administrator

Duration : May 2016 - Jan 2020
Operating System : Solaris, Linux, Windows.
Database : Oracle 10g and 11g, 12c/19c and MYSQL database
Tools : Putty, RMAN, Toad, Data pump, IBM Maximo and SQL Developer

Maxis Telecommunications
Role: Oracle DBA

 Performing Database Reorg.

 Regular DBA activities like Undo segments, Rollback segments, space management, Tablespace
management, database issues, locking, managing user groups and tuning.
 Backup & Recovery from RMAN and with other utilities. Planned backup strategies for database based
on business requirements.
 Troubleshooting and maintenance of Oracle Database.
 Building New Databases and Migrating Databases.
 Creating Users, Table Spaces.
 Adding Data files, altering the Users, Table Spaces.
 Cold Backup, hot backup and RMAN backup and recovery.
 Schema Refreshes for DEV and UAT, User management, Backup and Recovery.
 Monitoring on all the File Systems.
 User Mgmt, Space Mgmt, Application Support.
 Involved in tuning few Performance Issues.
 Created and configured new Kenan (Billing system) databases & Database patching.
 Building New Databases and Migrating Databases.
 Creating Users, Table Spaces.
 Adding Data files, altering the Users, Table Spaces.
 Cold Backup, hot backup and RMAN backup and recovery.
 Optimization and tuning SQL queries using TRACEFILE, TKPROF, EXPLAINPLAN.
 Having Good knowledge on tuning concurrent request and wait events
 Gather statistics for Database, Schema objects tables and indexes using DBMS_Stats package.
 Creating and Managing schemas, Roles, Privileges.
 Checking CRON Jobs and rescheduling process and monitoring
 Created roles and managed security.
 Added and removed users with authentication and time restrictions.
 Setup backup recovery procedures using RMAN. Performed hot and cold backups using RMAN.
 Scheduled jobs using cron utility.
 Created Database initialization parameters.
 Added and removed users with authentication and time restrictions.
 Used SQL*PLUS for issuing commands to the backend.
 Created tables, indexes, back-end triggers, stored procedures, and functions.
 Checking of Alert log and Trace files to monitor the database on daily basis.
 Monitoring load on the server, memory usage, disk space etc.

PROJECT 3:

Designation : Database Administrator and RPA UiPath Developer

Duration : Feb 2020 – Till Date
Operating System : Solaris, Linux, Windows.
Database : Oracle 10g and 11g, 12c/19c
Tools : Putty, RMAN, Toad, Data pump and OEM 13c.

Xerox Corporation
Role: Oracle DBA

 Migration of 11g and 12c databases to 19c

 Standby setup of 19c databases
 Upgradation of 12c to 19c
 Conversion of non ASM instance to ASM
 Database schema replication between two databases using oracle Golden gate.
 Performance tuning of database using Explain Plan, SQL Trace etc.
 Interacting with Oracle Corporation for technical support through metal ink.

Role: RPA UiPath Developer

 UiPath production support and minor development activities

I hereby declare that the details and information given above are complete and true to the best of my
knowledge

(Ravindranath Reddy G)