Training Instructor Back ground

Mr. Nukala Multifaceted, proactive database technology leader ,Oracle RAC Certified Database Expert,BigData Architect with more than 15 years of experience in managing, planning and administrating various Database Technologies.Strong experience in providing and managing database infrastructure services while new systems implementations, Migrations, upgrades, development, production support, maintenance operations for prominent Fortune ~500 Global companies in Banking, Transportation and Telecommunication business verticals.

Established and executed the leadership roles, during company’s mergers and acquisitions by building strong database teams globally to provide cost effective database services. Trained the fellow database administrators to improve the business processes for providing effective database support Services.  Excel in Capacity planning, establishing database standards, security policies, leveraging emerging technologies to align with the business needs for achieving best customer experience and satisfaction.

 

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.