Summary
Overview
Work History
Education
Skills
Technical Summary
Professional Development
Certification
Accomplishments
Work Availability
Timeline
Generic

Ravindra Tayi

DBA
North Brunswick,NJ

Summary

Accomplished and highly motivated Senior Oracle/SQL Server/PostgreSQL DBA with AWS cloud migration experience, specializing in Oracle database management and performance tuning. Proven track record in implementing RAC, DataGuard and RMAN for robust backup and HA/DR solutions. Adept at collaborating with cross-functional teams, demonstrating strong communication skills while enhancing database efficiency and reliability. Proven track record of success working as a DBA at companies like Oracle Corporation, UBS, State of NJ - DHS to name a few.

Overview

15
15

PLUS years of professional experience

Work History

Sr. Oracle/SQL Server/PostgreSQL DBA

Theradex Systems Inc
Princeton, NJ
08.2022 - 03.2025
  • As a Senior level Oracle DBA, my responsibilities include installation of Oracle 19c RAC 19.24 on RHEL 8.6, 7.9, DB upgrade from Oracle 10g/11g/12c to Oracle 19c.
  • Apply quarterly CPU patches, setup auditing, data and code migration and Performance tuning of SQL/PLSQL and database instance.
  • Responsible for setting up Oracle 19c production database environment for the Oracle upgrade project.
  • All legacy Oracle applications were upgraded from Oracle 10g and Oracle 11g to Oracle 19c with latest security patches.
  • Managed a PostgreSQL 17.x database environment for homegrown CDR application.
  • Improved the performance of many nightly batch jobs by tuning poorly performing SQLs identified in each of the batch jobs using sql profiles and SPB.
  • Implemented Oracle restart by installing Grid Infrastructure for a stand alone server.
  • Currently working on redesign of legacy systems in oracle 19c using multi tenant architecture with pluggable databases and grid infrastructure for a stand alone server.
  • Implementation of cloning and refreshing pluggable databases, migrating pluggable databases from one container database to another within the same server or remote database.
  • Used Erwin Data Modeler 2022 R2 to document the logical and physical design for CDR.
  • Setup of Unified auditing and policies.
  • Implemented daily backups of Oracle databases using RMAN including the archive logs.
  • Also worked on converting SQL server table definitions to Oracle format.
  • Daily Monitoring of databases for errors, using OEM 13.5 cloud control for administration and monitoring database metrics.
  • Redesign of indexes for tables used in SQL and PLSQL code to get better SQL execution performance for nightly load processes.
  • Archival and purge of historical data from large tables.
  • Perform a proof of concept to migrate on premise databases to AWS Cloud infrastructure.
  • Create Oracle database in AWS RDS and migrate data from on premise databases to AWS.
  • Setup Disaster recovery solution for existing on premise Theradex Web Reporting production databases in AWS RDS Oracle.
  • Currently working as DevOps team member to define, deploy and manage AWS RDS Oracle in the AWS Cloud using Terraform for infrastructure as code IaC.
  • Have knowledge on MariaDB and MySQL and can quickly get up speed on being hands on.

Sr. Oracle/SQL DBA

Mitchel Martin, Client: NECA
Morristown, NJ
05.2022 - 08.2022
  • As a Senior level Oracle DBA, my responsibilities include upgrade of Oracle 12c databases to Oracle 19c RAC on RHEL7x, and applying quarterly CPU patches, data and code migration and Performance tuning of SQL/PLSQL and database instance.
  • Refresh Test database with datapump and RMAN backups.
  • Monitoring databases for errors in alert.log and listener.log, use OEM 13c express for monitoring database metrics.
  • Review indexes for tables used in SQL and PLSQL code.
  • Maintain HR systems that uses MS SQL Server 2019, SSIS for ETL.

Sr. Oracle/SQL DBA

Protech Solutions, Client: State of New Jersey, Department of Human Services
Hamilton, NJ
02.2015 - 05.2022
  • As a Senior level Oracle DBA, my responsibilities include supporting Oracle and Java/.NET Developers during development, testing and deployment of two state welfare related projects Child Support Service for NJ (NJKIDS) and SNAP/OneTrac systems.
  • Supported Transactional and Data warehouse 4TB size prod databases, architecting and setting up the Oracle Database 12c R2 on IBM P8 AIX 7.1/Linux 7.x, Oracle 12cR2 RAC and Oracle 19c RAC.
  • Have knowledge of Exadata and Golden Gate for replication.
  • Tune/rewrite PLSQL stored procedures that are inefficient, used tkprof, sql trace, dbms profiler and AWR to assist in tuning activities.
  • Proactive monitoring of production database performance, code reviews, application code deployments and tune queries for optimal performance.
  • Extensively used AWR reports to identify problem queries and database wait events.
  • Proactive monitoring using OEM 12c/13c cloud control.
  • Testing migration to Oracle 12cR2 RAC/19c.
  • Also, continuously work with Infrastructure/ Sys. admin team related to architecture planning, migrations and design of production and Disaster Recovery systems.
  • Implemented Oracle Active Data Guard for production databases.
  • Extensively use RMAN for daily backups of databases.
  • Produced Database performance reports regularly to management.
  • Understand and test various features of Oracle 19c Multitenant Architecture.
  • Create standards for development and administration.
  • Wrote Shell scripts in ksh and bash to automate daily routine maintenance tasks.
  • Worked on Incident tickets in JIRA, documented technical tasks, CRs in Confluence.
  • Maintained relational data models using Erwin Datamodeler ver7, 2021.
  • Worked on upgrade planning and phased approach on implementation of Oracle 12cR2 Multitenant for State of NJ and currently engaged in upgrade to oracle 19c.
  • Apply Quarterly patching of CPU and oneoffs.
  • Proficiency in implementation and maintenance of applications in Oracle APEX.
  • Hands-on experience with Oracle APEX 3.2/4.0/4.1/4.2/5.0/5.1/18.1 administration and maintenance.
  • Support and Maintain SQL Server 2012/2014/2019 cluster database for applications in DHS.
  • Performance tuning T-SQL code using SQL Profiler, SolarWinds DPA Software and custom scripts using DMVs.
  • Designed data flows using SSIS.
  • Wrote daily load scripts in Powershell and windows batch scripts.
  • Working on feasibility study to migrate on-premise Oracle databases to Oracle Cloud, Oracle Autonomous DB.
  • Experience in installation and maintenance of Oracle fusion middleware, weblogic, setup Oracle OHS.

Sr. Oracle/SQL Server DBA

Caxton Associates LP
Princeton, NJ
10.2004 - 07.2014
  • As a Senior level Oracle DBA, my responsibilities include supporting Oracle and Java Developers and PeopleSoft HCM & AR/AP application during the design, development and testing phase.
  • Supporting Transactional and Data warehouse 2TB size prod databases, architecting and setting up the Oracle Database 10.2/11g on Solaris/Linux, Oracle 10g/11g RAC, Oracle Streams for development, QA and Production.
  • Have knowledge of Golden Gate for replication.
  • Tune/rewrite PLSQL stored procedures that are inefficient, used tkprof, sql trace, dbms profiler and AWR to assist in tuning activities.
  • Proactive monitoring of production database performance, code reviews, application code deployments and tune queries for optimal performance.
  • Extensively used AWR reports to identify problem queries and database wait events.
  • Administered Low-Latency applications running in Oracle.
  • Proactive monitoring using OEM 12c cloud control and OEM11g grid control.
  • Also, continuously work with Infrastructure/ Sys. admin team related to architecture planning, migrations and design of production and Disaster Recovery systems.
  • Implemented Oracle DataGuard for production databases.
  • Extensively use RMAN for daily backups of databases.
  • Understand and test the new features of Oracle 11g.
  • Create standards for development and administration.
  • Wrote Shell scripts in ksh and bash to automate daily routine maintenance tasks.
  • Also maintained SybaseVer. 11.9 to 12.5 databases for order management system for front–office Trading desk for 4 years.
  • Taking daily backups, restore backups to set up non-prod databases for testing.
  • Monitor SQL performance using Spotlight for Sybase.
  • Installed/maintained SQL Server 2005/2008 on Windows 2003 64 bit server for PeopleTools/PeopleSoft Ver. 9 application.
  • Used SSAS cubes and SSIS for data loading.
  • Designed and Created SQL backup and recovery Procedures, disk storage, best practices for administration and performance monitoring and tuning procedures.
  • Designed a DR solution for SQL Server.
  • Create and maintain Oracle, SQL Server and Sybase database standards, methodologies and Standard operating procedures for development and administration.
  • Replicated Oracle data to MS Sql Server using Oracle GoldenGate.
  • Performed platform migration from Solaris 10 to Oracle Linux 6.1 while upgrading an Oracle database from Oracle 10.2.0.3 to Oracle 11.2.0.3 using Oracle GoldenGate 11g.
  • Also worked on upgrade to Oracle 12c from Oracle 10g/11gR2.
  • Implemented partitioning of CPU resources of the multiple databases in the consolidated multitenant Oracle 12c, tested new features.
  • Completed a new build of Oracle 12c R1 RAC and also tested and documented an upgrade from Oracle 11g R2 RAC to Oracle 12c RAC for final implementation in production.
  • Also performed platform migration from Solaris to OL6.1 using Oracle GoldenGate.

Sr. Oracle DBA

UBS Financial Services
Weehawken, NJ
07.2001 - 10.2004
  • Involved in design and development of Financial Advisor application for UBS, design and development of a web-enabled Investment Products Platform for UBS Europe.
  • As a Lead DBA in the Database Engineering group, my responsibilities include architecting the Oracle Database Ver 10g, 9.2 on Solaris/AIX platforms for development, QA and Production, creating best practices for Junior DBAs, capacity planning, assist in data modeling of data warehousing applications, implement the physical data model and generate DDL scripts, interact with the business users to finalize the data model and changes in the database, write stored procedures, packages and database triggers in PL/SQL.
  • Also involved in System Architecture and design of Database tier and Application tiers with the System Administrators.
  • Developed standards and procedures, performed code review with all the developers to identify and fix performance related issues.
  • Tuning the database and the application code by following the standard performance tuning guidelines.
  • Proficient in all aspects of Backup/recovery planning using RMAN, media management, data loads using SQL Loader, Export/Import techniques.
  • Also supported various versions of Oracle databases in Production environment.
  • Involved in benchmarking Physical/Logical Data guard, Data guard Broker, Oracle Streams replication, GoldenGate and Oracle 9i / 10g RAC.
  • Also working on designing, modeling and creating an Enterprise Data Warehouse solution, consolidating all the functional Data marts into the enterprise model.
  • Design and develop ETL processes using Informatica Power Center and Power Exchange.

Sr. Principal Consultant (DBA – DB Architecture and Administration)

Oracle Corporation
Iselin, NJ
02.1999 - 07.2001
  • Oracle Database Administrator. Expert in all aspects of database administration functions like physical database design and implementation, RDBMS installation, configuration, migrations and upgrades on SUN SOLARIS, HP-UX, NT and VAX-VMS, database tuning, space management, security, Data warehousing, Oracle Parallel server, High Availability using standby DB and backup and recovery techniques.
  • Oracle Database Architect. Actively involved in systems analysis and design of database/data warehousing applications, understand business rules of telecom billing systems, pharmaceutical and manufacturing industry applications, conducted user interviews and brain storming sessions, collect and document system requirements, logical and physical data modeling using database tools like Oracle CASE, Designer 2000 and Erwin CASE tools.
  • Rich experience in writing program specifications and test cases for programmers.
  • Capacity planning and sizing production/DR DBs.
  • Performance Tuning. OS level tuning on Sun Solaris, HP-UX platforms, kernel configuration and memory requirements, database level tuning, setting init.ora parameters for optimal performance, SQL statement level tuning using TKPROF, SQL Trace and explain plan analysis.
  • Team Player. Always been a very proactive and result-oriented person with good communication skills and a good listener.

Education

M.S. - Production Technology

Indian Institute of Technology
Madras, India

B.S. - Mechanical Engineering

Anna University – College of Engineering
India

Skills

  • SQL and PL/SQL
  • UNIX and Linux systems
  • Shell scripting (Ksh, Bash)
  • Windows and PowerShell
  • Oracle database management
  • DataGuard and RMAN
  • Informatica PowerCenter
  • Oracle APEX and Toad
  • PeopleSoft HCM and PeopleTools
  • SQL Server (2005-2019)
  • Sybase database management
  • Veritas and Sun Clusters
  • EMC VMAX and IBM XIV SAN
  • Exadata knowledge

Technical Summary

  • SQL
  • PL/SQL
  • AIX5-7x UNIX
  • Solaris UNIX
  • HP UNIX
  • OEL5,6,7,8x/RHEL 5 - 9x Linux
  • Ksh
  • Bash
  • Windows batch scripting
  • Powershell scripting, Python scripting
  • Oracle 6.x – Oracle 19c
  • Oracle Parallel Server / 9i RAC
  • Oracle RAC 19c, 10gR2,11gR2 & 12cR1
  • ASM
  • ACFS
  • AWR
  • ASH
  • ADDM
  • Oracle DataGuard
  • DataGuard broker
  • RMAN
  • Datapump
  • OEM 13c Cloud control
  • OEM 11g/12c Grid Control
  • Informatica Power Center 7.x, 8.x
  • Oracle APEX
  • Toad Xpert
  • Erwin datamodeler
  • PeopleSoft HCM 9.x
  • Peopletools
  • SQL Server 2005/2008/2012,2019
  • SSAS
  • SSIS
  • SSRS
  • Sybase 11.x – 12.x
  • Veritas cluster
  • Sun Cluster
  • EMC VMAX
  • IBM XIV SAN Storage
  • Exadata V2 knowledge
  • ODI Toolset
  • Oracle GoldenGate 12x
  • PostgreSQL 17

Professional Development

  • Oracle 8i Sizing and Tuning
  • Oracle Parallel Server Implementation
  • Oracle 9i Release 2 New Features for DBAs
  • Oracle 11g R2 Performance Tuning
  • SQL Server Training
  • Maintaining a Microsoft SQL Server 2005/2008/2012 & 2019 Database
  • Designing High Availability Database Solutions Using Microsoft SQL Server 2005/2008/2012
  • Sybase Training
  • System and Database Administration: ASE 12.5

Certification

Oracle Certified Professional OCP 9i,10g,12c

Oracle Database Cloud Administrator 2021 Certified Professional

Oracle Cloud Database Migration and Integration 2021 Certified Specialist

Oracle Autonomous Database Cloud 2021 Certified Specialist.

Accomplishments

Migrated on-premise Oracle and SQL Server databases to AWS Cloud services.

Automated the deployment of resources in the cloud using Terraform.

Efficiently designed the backup and recovery process using RMAN on disk and tape media.

Automated database cloning for development and testing using shell and python scripts.

Successfully implemented data archival process to purge and archive historical data to low tier storage systems to save costs.

Continuous and proactive monitoring of database perfomance using daily performance reports and implement fixes using SQL profiles and SQL plan Baselines.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Sr. Oracle/SQL Server/PostgreSQL DBA

Theradex Systems Inc
08.2022 - 03.2025

Sr. Oracle/SQL DBA

Mitchel Martin, Client: NECA
05.2022 - 08.2022

Sr. Oracle/SQL DBA

Protech Solutions, Client: State of New Jersey, Department of Human Services
02.2015 - 05.2022

Sr. Oracle/SQL Server DBA

Caxton Associates LP
10.2004 - 07.2014

Sr. Oracle DBA

UBS Financial Services
07.2001 - 10.2004

Sr. Principal Consultant (DBA – DB Architecture and Administration)

Oracle Corporation
02.1999 - 07.2001

M.S. - Production Technology

Indian Institute of Technology

B.S. - Mechanical Engineering

Anna University – College of Engineering

Similar Profiles

  • Nathan Gott

    Nathan GottNathan Gott

    Material Planner Senior at BAE Systems - Space and Mission SystemsMaterial Planner Senior at BAE Systems - Space and Mission Systems

  • Barbara Vogt

    Barbara VogtBarbara Vogt

    Office Manager at Residential Waste Systems & Residential Fuel SystemsOffice Manager at Residential Waste Systems & Residential Fuel Systems

  • Venu Gopal Bollepalli

    Venu Gopal BollepalliVenu Gopal Bollepalli

    Associate Team Lead at CAMP Systems Pvt. Ltd. (MOTOR Information Systems)Associate Team Lead at CAMP Systems Pvt. Ltd. (MOTOR Information Systems)

  • Nikhil Desai

    Nikhil DesaiNikhil Desai

    MV Scientist 1 at Tris PharmaMV Scientist 1 at Tris Pharma

  • Preya Crawford

    Preya CrawfordPreya Crawford

    Kindergarten Dual Language Teacher at North Brunswick Public SchoolsKindergarten Dual Language Teacher at North Brunswick Public Schools

CREATE PROFILE