Ambasa - Oracle DBA Trainer in Navi Mumbai, India

Ambasa

Oracle DBA Trainer in Navi Mumbai

Location

Navi Mumbai, India

Trainer Since

January, 2005

Database

Oracle DBA

PostgreSQL Database Administration

MySQL Database Administration

Oracle Database Performance Tuning

AWS Solutions Architect

Oracle Dataguard Administration

Oracle GoldenGate

Oracle Exadata

Oracle cloud infrastructure

Location

Navi Mumbai, India

Trainer Since

January, 2005

Database

Oracle DBA

PostgreSQL Database Administration

MySQL Database Administration

Oracle Database Performance Tuning

AWS Solutions Architect

Oracle Dataguard Administration

Oracle GoldenGate

Oracle Exadata

Oracle cloud infrastructure

Ambasa

About

Oracle DBA Trainer in Navi Mumbai

About Ambasa

Ambasa is a seasoned Oracle/PostgreSQL/MySQL Database Administrator (DBA) and Corporate Trainer with an illustrious career spanning over 19 years. His expertise encompasses a wide array of critical areas within the realm of database management, including Oracle RAC, Oracle Data Guard, Oracle Goldengate, Oracle Exadata, Oracle Database Performance Tuning, PostgreSQL Database Administration, MySQL Database Administration, AWS Solution Architect Associate, and Oracle Cloud Infrastructure Architect Associate training.

Throughout his career, Ambasa has honed his skills in planning, installation, implementation, management, and tuning Oracle/PostgreSQL/MySQL databases, positioning him as a trusted authority in the field. Currently serving as an Oracle/PostgreSQL/MySQL DBA Support Consultant and Corporate Trainer, Ambasa brings a wealth of practical knowledge and hands-on experience to his training endeavors.

Ambasa's proficiency extends beyond traditional database management, deeply understanding cloud platforms such as AWS, Azure, Google Cloud Platform (GCP), and Oracle Cloud Infrastructure (OCI). He possesses a strong track record in Migration from On-premises to Cloud environments and excels in Cross-Cloud Configuration and Migration strategies.

One of Ambasa's notable strengths is his expertise in data replication techniques, including Data Guard, GoldenGate, PostgreSQL repmgr, and MySQL Group Replication with MariaDB Galera Cluster/MySQL InnoDB Cluster. His experience working on production support projects using ITIL processes underscores his ability to navigate complex operational environments with precision and efficiency.

Ambasa's technical proficiency is underscored by his extensive experience in implementing various Oracle RAC configurations (9i/10g/11gR1/R2/12c/18c/19c) with ASM/OCFS2/VCFS/RAW and Data Guard (Physical and Logical Standby Databases) utilizing DGMGRL. This breadth of experience positions Ambasa as a sought-after expert capable of delivering unparalleled insights and guidance in the dynamic landscape of database administration and cloud infrastructure management.

Ambasa is a Corporate Trainer For

Database

Training Since:

January, 2005

Oracle DBA

Training Since:

January, 2005

PostgreSQL Database Administration

Training Since:

March, 2005

MySQL Database Administration

Training Since:

March, 2005

Oracle Database Performance Tuning

Training Since:

May, 2005

AWS Solutions Architect

Training Since:

May, 2005

Oracle Dataguard Administration

Training Since:

June, 2005

Oracle GoldenGate

Training Since:

March, 2005

Oracle Exadata

Training Since:

May, 2005

Oracle cloud infrastructure

Training Since:

November, 2005

Work Experience

Support Engineer

Computer and Information Technology (IT):

January, 2005 - April, 2006

Roles & Responsibilities

Installed and supported Oracle on Linux platforms, ensuring seamless integration and functionality within the infrastructure
Designed and deployed databases based on specific requirements and resource availability, ensuring optimal performance and scalability
Administered database objects, including indexes, tables, views, and constraints, by entity relationship models, maintaining data integrity and accessibility
Created and managed user accounts, assigning appropriate quotas to ensure efficient utilization of resources and access control
Conducted daily hot and weekly cold backups of databases, implementing robust data protection measures to safeguard against potential data loss or corruption
Provided ongoing support and troubleshooting assistance to users, resolving database-related issues promptly to minimize downtime and optimize system performance

Associate Consultant DBA

Computer and Information Technology (IT):

April, 2006 - April, 2008

Roles & Responsibilities

Regularly monitored databases to ensure optimal performance and identify potential issues
Troubleshoot errors promptly, implementing effective solutions to minimize downtime and maintain data integrity
Conducted database patching activities, ensuring all patches were applied promptly to enhance security and performance
Executed cloning activities for databases, proficiently using RMAN, exp/imp, and cold backup methods to replicate production environments in testing settings
Configured and maintained RAC (Real Application Clusters) and Data Guard setups across Linux, Solaris, and Windows platforms, ensuring high availability and disaster recovery readiness
Collaborated with cross-functional teams to implement best practices and optimize database configurations for improved efficiency and reliability

Technical Officer (Oracle DBA)

Computer and Information Technology (IT):

April, 2008 - February, 2010

Roles & Responsibilities

Managed EMEA and WHEM BAU Database (Production, UAT, Dev.) Support, including handling P1/S1/S2/S3, P2 tickets, and addressing issues promptly
Executed ECM (Change Management) and SR (Service Request) processes effectively to ensure seamless operation of Oracle databases
Built RAC (Real Application Clusters) Databases from scratch, overseeing everything from installation to configuration
Installed and configured Oracle RAC databases, ensuring optimal performance and high availability
Applied Patch set 10.2.0.4.0 to maintain the security and stability of Oracle databases while conducting export/import operations from old single instances to new RAC databases
Refreshed RAC Databases through RMAN (Recovery Manager) to keep the databases up-to-date and synchronized with the latest dat

IT Infrastructure Lead

Banking, Financial Services and Insurance:

February, 2010 - December, 2011

Roles & Responsibilities

Led the construction and oversight of databases, including Oracle10g/11g, with proficiency in Data Guard implementation for both Physical and Logical Standby Databases, alongside DGMGRL Configuration
Managed the installation and creation of databases, ensuring seamless operation through the application of Interim, CPU/PSU patches, and Database Patch sets
Orchestrated database cloning via RMAN and export/import processes and facilitated the deployment of Release Scripts, ensuring efficient database replication
Crafted comprehensive Database Build Guides, offering clear and structured instructions for database setup and maintenance procedures
Successfully tackled numerous database recovery issues, applying adept problem-solving skills to restore functionality promptly
Acted as the Incident Manager for all Development, UAT, and VPT databases, establishing incident/change management protocols and creating rotas for the Incident/Change Team
Provided mentorship and technical guidance to team members, fostering a collaborative environment and aiding in resolving technical challenges as they arose

Systems Engineer - Oracle DBA

Computer and Information Technology (IT):

April, 2012 - May, 2014

Roles & Responsibilities

Led technical initiatives as a Systems Engineer—Oracle DBA, overseeing the Ingram Project and ensuring the seamless patching and upgradation of both RAC and non-RAC databases
Conducted comprehensive performance-tuning efforts to optimize database efficiency and responsiveness, contributing significantly to project success
Executed complex database cloning activities from Production to Test environments utilizing various methods, including RMAN, export/import, BCV, and cold backup, ensuring data integrity and consistency
Provided expert support for 10gR2/11gR2 RAC databases and Oracle Dataguard, resolving issues promptly to maintain system stability and availability
Directed technical operations as a Technical Lead for the Marsh Project, orchestrating the deployment of scripts and diligent monitoring of backups and alerts
Managed database refresh activities using exp/imp and Data Pump Utility, applied PSU patches and conducted quarterly database restores utilizing RMAN backups to uphold data resilience and disaster recovery readiness

Corporate Trainer

Computer and Information Technology (IT):

March, 2005 - present

Roles & Responsibilities

Create comprehensive training materials tailored to the specific needs of learners, covering topics such as Oracle DBA, RAC, DataGuard, GoldenGate, Exadata, and database performance tuning, as well as PostgreSQL, MySQL, AWS Solution Architect Associate, and Oracle Cloud Infrastructure Architect Associate
Facilitate engaging and interactive in-person and virtual training sessions, ensuring participants gain a deep understanding of Oracle and other database technologies, as well as cloud platforms like AWS and Oracle Cloud Infrastructure
Adapt training programs to accommodate various skill levels and learning styles, offering beginner—to advanced-level courses in Oracle technologies and related areas such as PostgreSQL, MySQL, AWS, and Oracle Cloud Infrastructure
Develop hands-on exercises and lab activities to reinforce theoretical concepts, allowing participants to gain practical experience in Oracle DBA tasks, RAC configuration, DataGuard setup, GoldenGate replication, Exadata management, and database performance tuning
Evaluate the effectiveness of training programs through assessments and feedback mechanisms, ensuring that participants grasp the core concepts of Oracle and other database technologies and cloud architecture principles
Continuously research and stay updated with the latest advancements in Oracle technologies, database administration, and cloud computing, integrating new knowledge into training materials and sessions to provide learners with the most relevant and up-to-date information

Skills

Oracle

Linux

AIX

Red Hat Linux

Unix

Solaris

Databases

Team Management

Performance Tuning

Oracle RAC

RMAN

Database Design

Shell Scripting

Data Migration

Database Administration

SQL Tuning

GoldenGate

Education

Karnatak University

Mathematics:

2001-2004

Projects

Posts

Courses

Database

Oracle DBA

PostgreSQL Database Administration

MySQL Database Administration

Oracle Database Performance Tuning

AWS Solutions Architect

Oracle Dataguard Administration

Oracle GoldenGate

Oracle Exadata

Oracle cloud infrastructure

Want Ambasa for your next training?

Request a Demo

Other Trainers

Rohit

Bangalore, India

Training Since

January, 2007

Team Building

Conflict Management

Oracle DBA Trainer in Navi Mumbai

About Ambasa

Ambasa is a Corporate Trainer For

Database

Oracle DBA

PostgreSQL Database Administration

MySQL Database Administration

Oracle Database Performance Tuning

AWS Solutions Architect

Oracle Dataguard Administration

Oracle GoldenGate

Oracle Exadata

Oracle cloud infrastructure

Work Experience

Support Engineer

Roles & Responsibilities

Associate Consultant DBA

Roles & Responsibilities

Technical Officer (Oracle DBA)

Roles & Responsibilities

IT Infrastructure Lead

Roles & Responsibilities

Systems Engineer - Oracle DBA

Roles & Responsibilities

Corporate Trainer

Roles & Responsibilities

Skills

Education

Karnatak University

Projects

Posts

Courses

Want Ambasa for your next training?

Other Trainers

More Corporate Training Programs