Training Instructor Back ground

A 10-Hour Webinar Series

With 25+ years navigating five major platform shifts, Cherian D now leads enterprise AI adoption as a Principal Cloud, Identity, and AI Architect — driving Microsoft 365 Copilot implementation, AI governance, and agentic AI solutions using AWS Bedrock.

His career spans systems engineering, virtualization, and multi-region cloud (AWS/Azure) at organizations including HP, Unilever, Merrill Lynch, BlackRock, and a leading NJ-based insurer. Today, he serves as a trusted SME and strategist to C-level leadership, architecting secure, scalable AI ecosystems for regulated industries.

Join this in-depth, 10-hour session to learn directly from someone who has led enterprise technology through every major shift — and is now doing the same for AI.

Principal Oracle Database Administrator 11g/12c   (SYSTEM DBA-I) Duration 30-35 Hours

Exploring the Oracle Database Architecture                           

• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures

Preparing the Database Environment            

• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI)

Creating an Oracle Database

• Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance 

• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment

• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture

Managing Database Storage Structures

• Overview of tablespace and datafiles
• Create and manage tablespaces
• Space management in tablespaces

Administering User Security

• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles

Managing Data and Concurrency

• Monitor and resolve locking conflicts

Managing Undo Data

• Overview of Undo
• Transactions and undo data
• Managing undo

Implementing Oracle Database Security

• Database Security and Principle of Least Privilege
• Work with Standard Database Auditing

Database Maintenance

• Use and manage optimizer statistics
• Use and manage Automatic Workload Repository (AWR)
• Use advisory framework
• Manage Alerts and Thresholds

Performance Management

• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects

Backup and Recovery Concepts

• Identify the types of failure that can occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Overview of flash recovery area
• Configure ARCHIVELOG mode

Performing Database Backups

• Create consistent database backups
• Back up your database without shutting it down
• Create incremental backups
• Automate database backups
• Manage backups, view backup reports and monitor the flash recovery area

Moving Data

• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases

Advanced Oracle Technologies & Role of Active DBA

• High availability , Oracle RAC and Clustering —Introduction
• Disaster Recovery : Oracle Datagurad—–Introduction
• Cloud computing& DBaaS,Amazon RDS introduction
• Oracle Replication Technologies—–Oracle Streams, Oracle Golden Gate Introduction

Expert Oracle 11g/12c Database Administration: (SYSTEM DBA-II)   Duration 35-40 Hours

             Grid Infrastructure: Clusterware and ASM

Oracle Grid Infrastructure

• Explain the principles and purposes of clusters
• Describe Cluster hardware best practices
• Understand Oracle Clusterware Architecture
• Describe how Grid Plug and Play affects Clusterware
• Describe ASM architecture and components

Grid Infrastructure Installation

• Perform pre-install tasks for Grid Infrastructure
• Install Grid Infrastructure
• Verify the installation
• Configure ASM disk groups
• Configure ASM volumes
• Make ASM cluster file system
• Mount ACFS volumes

Administering Oracle Clusterware

• Display Clusterware management proficiency
• Demonstrate OCR backup and recovery techniques
• Managing Network Settings

Managing Clusterware

• Perform prerequisite steps for extending a cluster
• Use Oracle Universal Installer (OUI) to add a node to an Oracle Clusterware home
• Use OUI to remove a node from an Oracle Clusterware home

Making Applications Highly Available With Oracle

• Describe the High Availability components of Oracle Clusterware
• Contrast Policy-Managed and Administration Managed databases
• Describe the functionality of server pools
• Describe application placement policies
• Create an application Virtual IP (VIP)
• Manage application resources

Troubleshooting Oracle Clusterware

• Locate Oracle Clusterware log files
• Gather all log files using diagcollection.pl
• Enable resource debugging
• Enable component-level debugging
• Enable tracing for Java-based tools
• Troubleshoot the Oracle Cluster Registry (OCR) file

Administering ASM Instances

• Understand and apply ASM initialization parameters
• Manage ASM instances and associated processes
• Monitor ASM using the V$ASM dynamic performance views

Administering ASM Disk Groups

• Create and delete ASM disk groups
• Set the attributes of an existing ASM disk group
• Perform ongoing maintenance tasks on ASM disk groups
• Explain key performance and scalability considerations for ASM disk groups

Administering ASM Files, Directories, and Templates

• Use different client tools to access ASM files
• Describe the format of a fully qualified ASM file name
• Explain how ASM files, directories and aliases are created and managed
• Understand and manage disk group templates

Section 2 – Real Application Clusters

Real Application Clusters Database Installation

• Install the Oracle database software
• Create a cluster database
• Perform post-database creation tasks
• Perform a single instance to RAC conversion

RAC Database Administration

• Use Enterprise Manager cluster database pages
• Define redo log files in a RAC environment
• Define undo tablespaces in a RAC environment
• Start and stop RAC databases and instances
• Modify initialization parameters in a RAC environment

Use Enterprise Manager cluster database pages

• Define redo log files in a RAC environment
• Define undo tablespaces in a RAC environment
• Start and stop RAC databases and instances
• Modify initialization parameters in a RAC environment

Managing Backup and Recovery for RAC

• Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
• Recover from media failure and instance failures
• Tune instance recovery in RAC
• Configure RMAN for the RAC environment

RAC DB Monitoring and Tuning

• Determine RAC-specific tuning components
• Determine RAC-specific wait events, global enqueues, and system statistics
• Implement the most common RAC tuning tips
• Use the Cluster Database Performance pages
• Use the Automatic Workload Repository (AWR) in RAC
• Use Automatic Database Diagnostic Monitor (ADDM) in RAC

Services

• Configure and manage services in a RAC environment
• Use services with client applications
• Use services with the Database Resource Manager and scheduler
• Configure services aggregation and tracing

High Availability Connections

• Configure client-side, connect-time load balancing and connect-time failover
• Configure server-side, connect-time load balancing
• Use the Load Balancing Advisory (LBA)
• Describe the benefits of Fast Application Notification (FAN)
• Configure server-side callouts
• Configure Transparent Application Failover (TAF)

Design for High Availability

• Design a Maximum Availability Architecture in your environment
• Determine the best RAC and Data Guard topologies for your environment
• Configure the Data Guard Broker configuration files in a RAC environment
• Patch your RAC system in a rolling fashion

Cloud Computing & Database Cloud Technologies

• Introduction to Cloud computing, Database Cloud
• Configuring the Database in AWS
• Data loads/Migration from on premise to Amazon and Azure clouds.
• Introduction to BigData Technologies, appliances, Open Source Tools

Minimal down Time database Migration/ upgrades

• Golden Gate Installation and setup
• Database Migration, upgrades and pre-setup Design.

Database Appliances Introduction and General administration

• Introduction to various Database appliances ,technologies
• Oracle Data Appliances architecture and configuration.
• Oracle Exadata architecture, administration and configuration.