Summary
Overview
Work History
Education
Skills
Websites
Certification
Interests
Timeline
Generic

Ambarish Rao

Columbia Station,OH

Summary

Results-driven Oracle Database Administrator with over 13 years of experience in database management, PL/SQL development, and data governance. Successfully migrated databases to Exadata servers, enhancing performance, security, and compliance with governance standards. Optimized backup efficiency through automated scripts and implemented governance-aligned policies for user access, roles, and data classification. Proficient in Oracle 10g/11g/12c/19c with expertise in installations, upgrades, and capacity planning across Linux and HP-UX platforms. Bringing a robust technical skill set, governance awareness, and a commitment to ensuring database reliability, security, and regulatory compliance.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Oracle Applications Database Lead

Travel Centers of America
Westlake, OH
04.2017 - Current
  • Defined and enforced governance policies for enterprise databases, including data ownership models, classification (sensitive/confidential/public), and retention standards in compliance with SOX, GDPR, and PCI DSS.
  • Implemented security controls in Oracle databases by designing role-based access, least-privilege models, and auditing mechanisms to minimize insider threats.
  • Lead Team and was responsible for migration of Oracle Databases from IBM physical Linux servers to VM Servers.
  • Primary technical resources to upgrade Oracle Databases from 11g to 12c in Oracle Standard Edition.
  • Maintain and Support Oracle databases 11g R1/11g R2/12c Oracle Linux platform.
  • Upgrading Oracle Database version from 11.2.0.1 to 12.1.0.1 and 11.2.0.2 to 12.2.0.2 and also configured Transparent Data Encryption (TDE) for protection of sensitive data for one of financial application.
  • Responsible for migration of Oracle Databases from VM Servers to Exadata Servers.
  • Wrote Datapump Scripts (Expdp/Impdp) for taking the backup of the databases and also used those scripts extensively in Migration Project.
  • Working closely with 3rd Vendor Parties for Installation and Configuration of Exadata Databases.
  • Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 11g/12c.
  • Led analysis and migration planning for enterprise databases from Oracle Standard Edition to Oracle 12c, ensuring applications-maintained performance, compliance, and governance standards.
  • Evaluated database features and governance controls (data classification, access roles, retention policies) during migration to align with SOX and internal audit requirements.
  • Collaborated with application and compliance teams to validate that critical governance and security requirements were enforced in the new 12c environment
  • Monitor and maintain security by managing roles/privileges for users of the databases.
  • Performed non-rac to rac cloning and refresh of databases from higher to lower environments.
  • Manually created Materialized views and closing worked on snapshots creation.
  • Performed database cloning to setup test and development database.
  • Upgrading production and development databases from Oracle 11g to Oracle 12c.
  • Developed and maintained courteous and effective working relationships.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Self-motivated, with a strong sense of personal responsibility.

Sr. Oracle DBA(Migration Specialist)

United Health Group
Greater Minneapolis-st Paul Area, MN
08.2015 - 04.2017
  • Led migration analysis and execution from Oracle Standard Edition to Oracle 12c for enterprise applications, ensuring minimal downtime and full compliance with SOX and internal audit requirements.
  • Implemented data governance policies during migration, including data ownership mapping, classification (sensitive, confidential, public), and retention rules.
  • Migration of Oracle Databases from IBM physical Linux servers to Exadata server and then performed encryption and compression.
  • Primary technical resources to upgrade Oracle Databases from 11g to 12c in Exadata machine environment design.
  • I was involved in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Duplicate all the non-production databases on Exadata server according the Data Warehouse development project’s requirement. Help to compress large volume data by Compression techniques.
  • Provide database administration on Production, testing and development database servers.
  • Migrated Oracle databases from Solaris Servers to Linux Servers.
  • Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
  • Install, configure and administer of databases for applications on Red Hat Linux systems in various environments.
  • Applied Oracle Applications and database patches.
  • Replication using Golden Gate.
  • Monitor and maintain security by managing roles/privileges for users of the databases.
  • Apply the PSU patches and Rman patches to the binaries as well as to the databases.
  • Replication and Extracting data and applying on production using Golden Gate.
  • Conduct Pre-patch analysis for different types of patches as requested by customer.
  • Set up boxes and install required software and prepare operation guides for the same.
  • Work closely with application teams in troubleshooting issues, support root cause analysis and resolve issues.
  • Frequently tested and updated development databases to production as well as used database cloning.
  • Actively involved in security administration adopting the principle of least privilege, managing default user accounts, implemented standard password security features, auditing database activity, and registering & applying security updates and Advanced Oracle security
  • Performed and maintained database backups using Enterprise Manager or RMAN as well as OS utilities.
  • Analyzing and troubleshooting both critical and non-critical situations.
  • Providing 24x7 remote and onsite support for customers.

Oracle DBA / Senior PL/SQL Developer

AT&T
06.2014 - 08.2015
  • Designed, developed, and optimized PL/SQL stored procedures, functions, triggers, and packages to support critical business applications.
  • Tuned complex SQL queries and PL/SQL code to improve system performance and reduce processing times.
  • Administered Oracle databases (11g/12c) including installation, configuration, patching, backup/recovery, and performance tuning.
  • Supported large-scale production databases ensuring high availability, scalability, and security.
  • Implemented data partitioning, indexing strategies, and materialized views to handle high-volume transactional workloads.
  • Provide database administration on Production, testing and development database servers.
  • Build the environment from scratch for database migration from 10g standalone to 11gR2 RAC servers.
  • Monitor and maintain security by managing roles/privileges for users of the databases.
  • Performed non-rac to rac and rac to non-rac cloning.
  • Performance tuning of Oracle Database, applications and queries
  • Conduct Pre-patch analysis for different types of patches as requested by customer.
  • Set up boxes and install required software and prepare operation guides for the same.
  • Work closely with application teams in troubleshooting issues, support root cause analysis and resolve issues.
  • Frequently tested and updated development databases to production as well as used database cloning.
  • Automated repetitive DBA tasks using shell scripting and PL/SQL jobs, reducing manual effort and downtime.
  • Performed database migrations, upgrades, and platform consolidations, ensuring minimal downtime.
  • Collaborated with application teams to design efficient data models, schema structures, and integration solutions.
  • Mentored junior DBAs and developers, sharing best practices for Oracle development and administration.

Sr. Oracle DBA

Ditech Mortgage
Fort Washington, Pennsylvania
07.2013 - 05.2014
  • Responsible for moving data using Cross-Platform Transportable Tablespaces (TTS) migration and also for same platform migration.
  • Provide database administration on Production, testing and development database servers.
  • Build the environment from scratch for database migration from 10g standalone to 11gR2 RAC servers.
  • Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
  • Monitored and enforced data governance policies by managing database roles, privileges, and user access in alignment with SOX and HIPAA compliance requirements.
  • Apply the PSU patches and Rman patches to the binaries as well as to the databases.
  • Performance tuning of Oracle Database, applications and queries.
  • Conduct Pre-patch analysis for different types of patches as requested by customer.
  • Set up boxes and install required software and prepare operation guides for the same.
  • Work closely with application teams in troubleshooting issues, support root cause analysis and resolve issues.
  • Frequently tested and updated development databases to production as well as used database cloning.
  • Performed and maintained database backups using Enterprise Manager or RMAN as well as OS utilities.
  • Configured and utilized Recovery Manager Catalog.
  • Used Oracle Scheduler, UNIX shell scripting /CRON jobs for automating various tasks.
  • Developed RMAN scripts and for database backups.
  • Perform troubleshooting and fixing of day-to-day problems of application databases in production as well as lower level environments.
  • Perform Database duplication using rman.
  • 24x7 Production database and applications support.
  • Setup DR (Dataguard) for production environments.
  • Optimizing downtime for maintenance by coordinating with different application teams.
  • Strictly followed change control/change management procedures as laid down by organization in highly qualified environment.
  • Responsible for Transparent data encryption (TDE) . Used TDE with data pump.
  • Manually created Materialized views and closing worked on snapshots creation.
  • Working with hundreds of databases ranging from 50 GB to 3TB.
  • Responsible for setting up network ACLs in database.
  • Performed complete database recovery in staging environments.
  • Logical and physical database design.
  • Clear documentation was prepared on all process like program specification, bugs fixing. Logs and change requests for future reference.
  • Administered Oracle databases, ensuring optimal performance and availability for critical applications.

Oracle DBA

TJX Industries
08.2012 - 07.2013
  • Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
  • Restoration and Recovery of databases at the times of occurrence of critical failures.
  • Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
  • Applied CPU patches.
  • Installing Oracle Golden Gate for EBS Reporting Databases.
  • Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
  • Performed block recovery using RMAN.
  • Moving data between databases using Data Pump.
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
  • Partitioned large tables for better performance and manageability.
  • Installed and configured Golden Gate for replication.
  • Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
  • Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
  • Responsible for transporting an encrypted table spaces during Migration Project.
  • Implemented transparent data encryption (TDE). Use TDE with encrypted columns and data pump.
  • Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
  • 24x7 Production database and applications support.
  • Worked with Data Pump to take the logical backups of databases.
  • Experienced in performing Point-in-Time Recovery.
  • Performed Capacity Planning and Bench Marking
  • Load and Transform data using SQL
  • Loader and External Tables
  • Logical and Physical Database Design
  • Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Education

Master of Science - Computer Science

Virginia International University
Fairfax, VA
08.2012

Bachelor of Science - Electrical & Electronics Engineering

Jawaharlal Nehru Technological University
INDIA
05.2010

Skills

Database management

  • Oracle 19c
  • Oracle 12c
  • Oracle 11gR2
  • Oracle 10g

LANGUAGES

  • PL/SQL programming
  • SQL data analysis
  • Perl
  • UNIX shell programming

OPERATING SYSTEMS

  • Windows 2000/NT/XP/2003
  • UNIX
  • Enterprise Linux5
  • Sun Solaris 10/9

DATABASE TOOLS

  • Oracle Enterprise Manager, SQL Analyzer
  • PL/SQL developer, TOAD
  • DB Visualizer, Data Modeler
  • Git-bash
  • Eclipse
  • Informatica Power Center
  • Putty

OTHERS

  • Knowledge of HTML programming
  • Internet Technologies
  • MongoDB
  • NoSQL

TOOLS & UTILITIES

  • RMAN
  • Loader
  • Export/Import
  • Data pump
  • Net Backup
  • Data Guard

HA CLUSTERS

  • Exadata Server
  • VERITAS Cluster Server
  • Sun Cluster
  • NetApp Cluster
  • VMware vSphere management

Websites

Certification

  • Oracle Cloud Infrastructure 2019 Certified Architect Associate

Oracle Cloud Infrastructure 2019 Certified Archi... - Credly

  • Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Cloud Infrastructure 2019 Certified Archi... - Credly

  • Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Cloud Infrastructure 2019 Certified Archi... - Credly

  • Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Autonomous Database Cloud 2019 Certified ... - Credly

  • Oracle Cloud Infrastructure Developer 2020 Certified Associate

Oracle Cloud Infrastructure Developer 2020 Certi... - Credly


Interests

  • Passionate about balancing physical health with mental and emotional wellness
  • Exploring famous landmarks, historical sites, and cultural attractions in a new destination
  • Volunteering for community initiatives to give back to local communities and make a positive impact
  • Sharing travel tips, recommendations, and insights with fellow enthusiasts
  • Hiking
  • Artificial Intelligence (AI) and Machine Learning
  • Tech enthusiast, passionate about exploring the latest advancements and innovations
  • Growing herbs, vegetables, or fruits in home gardens
  • Learning new cooking techniques and expanding my culinary skills

Timeline

Oracle Applications Database Lead

Travel Centers of America
04.2017 - Current

Sr. Oracle DBA(Migration Specialist)

United Health Group
08.2015 - 04.2017

Oracle DBA / Senior PL/SQL Developer

AT&T
06.2014 - 08.2015

Sr. Oracle DBA

Ditech Mortgage
07.2013 - 05.2014

Oracle DBA

TJX Industries
08.2012 - 07.2013

Master of Science - Computer Science

Virginia International University

Bachelor of Science - Electrical & Electronics Engineering

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE