- 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
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
Plymouth, 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
San Ramon, CA
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, PA
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
Framingham, MA
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, VA08.2012
Bachelor of Science - Electrical & Electronics Engineering
Jawaharlal Nehru Technological University
INDIA05.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
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
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