- Hands on experience for Oracle Database 11g, 12c, 19c Administration is required
- DB parameter & Query Performance Tuning
- Oracle RMAN Backup and Recovery
- Efficient with Oracle Export/Import (exp/imp,expdp,impdp)
- Experience on Oracle Single Node, RAC & ASM
- DB Patch & Upgrade
- Oracle DB production Environment refresh in UAT & Preprod environment
- Database Auditing & Security hardening knowledge
- DB Capacity Planning
- PL-SQL, Shell scripting in Linux & Unix environment
- Troubleshoot of Oracle DB issues
- Knowledge of MS-SQL, MySQL, PostgreSQL (At least one) required as secondary skill.
- Professional certification will be added advantage
- Experience of Oracle Database License Optimization
- Experience of Working on Exadata X5-2 Quarter Rack implementation project.
- Experience of Oracle 11g, 12c, 19C RAC deployment on Linux, Unix(AIX) environment.
- Experience of Oracle 11g, 12c Active Dataguard (ADG) configuring specially both on RAC to Single Instance and RAC to RAC db.
- Experience of Database design & Oracle Database installation and maintenance on various platform like as IBM AIX, HP-UX, Sun Solaris, Linux (RHEL, OEL)
- Experience of PL/SQL.
- Advanced Deployment Experience on Oracle Enterprise Manager 12c, 13c (OEM 12c, OEM 13c).
- Oracle Database Replay
- Indexing & Partitioning
- Oracle ASM 11g, 12c, 19C
- Advanced RMAN Backup, Restore & Recovery with disk & tape technology.
- Experience of working on RAC deployment at FUSION CUBE
- Experience of Patching on production environment like RAC, Single Instance and Linux, AIX etc.
- Experience of working on IBM TSM and Semantic Net backup as oracle backup solution.
- Experience of oracle database administration for release 10g, 11g, 12C, 19C.
- Experience of Oracle Audit Vault & Database Firwall (AVDF)
- Experience of shell scripting
- Experience of working on various CBS(Core Banking System) like Finacle, T24(Temenos), Ababil, Bank Ultimus, iSteler etc.
- Experience of Oracle Database Security 12c
- Experience of database migration among same & cross platforms(e.g: Windows to Linux, AIX to Linux).
- Experience of oracle database Up-gradation from 10g/11g/12c to 11g/12c/19c.
- Experience of scaling up database like moving from non-cluster to clustered environment.
- Experience of Oracle Goldengate.
- Experience of Tranzware(C+) Master Card System.
- Experience of working on 24/7 support service environment.
- Experience of Tape Library
Certification:
- Oracle Autonomous Database Cloud 2019 Certified Specialis
- Oracle Database 12c Administrator Certified Professional (OCP)
- Oracle Certified Expert, Oracle RAC 11g and GI Administrator (OCE)
- Oracle Database 11g Administrator Certified Professional (OCP)
- ITIL Foundation Certificate in IT Service Management
Course Outline:
Introduction to SQL/Fundamental SQL
Introduction
Tools used for Develop query: PL/SQL Developer, SQL Developer, Command Line
Install and Configure Standalone Database in Linux and Windows both.
Brief Directory Structure of Oracle Database.
Network Infrastructure
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones
Course Objectives: Oracle 12c Administration Workshop I
By the end of this course students will be able to:
Installing Oracle Software
Creating an Oracle Database Using DBCA
Managing Database instances and ASM instances
Managing and controlling database network environment
Define and devise transaction management, concurrency control, crash recovery components
Managing storage structures
Controlling user security
Designing Database backup and recovery procedures
Take Decisions related with Database Maintenance
Course Outline Short: Oracle 12c Administration Workshop II
Oracle Database Architecture
Database installation and creation. (use DBCA)
Managing Database instances and ASM instances
Oracle Network environment
Database storage structures
User security
Concurrency control
Database auditing
Database maintenance
Crash Recovery
Detailed Course Outline: Administration I
Oracle Linux, Environment Variables and Partitions
Install Oracle Linux
Set Environment Variables
Configure Network
Multipath Configuration
Create user, group and permissions
Installing Oracle Software
Installing Configure Grid
Configure ASM Disk
Install and Configure Database using ASM Disks
Creating an Oracle Database Using DBA
Exploring the Oracle Database Architecture
Connecting to a server
Oracle Database Server Architecture
Instance: Database Configurations
Memory Structures – SGA
Memory structures – Shared Pool
Memory Structures – Buffer Cache
Memory Structures – Redo Log Buffer
Memory Structures – Large Pool
Memory Structures – Java Pool/Streams Pool
Memory Structures – PGA
Memory Structures – Streams Pool
Process Structures
Background Processes – Database Writer Process (DBWn)
Background Processes – Log Writer Process (LGR)
Background Processes – Checkpoint Process (CKPT)
Background Processes – System Monitor Process (SMON)
Background Processes – Process Monitor Process (PMON)
Background Processes – Recoverer Process
Background Processes – Archiver Process (ARCn)
Process Startup Sequence
Database Storage Architecture
Logical and Physical Storage Structures
Segments, Extents and Blocks
Table Space and Data Files
SYSTEM and SYSAUX Table Space
ASM storage components
Interacting with an Oracle Database
Managing Database Instance
Database initialization parameters modification
Stages of database startup
Database shutdown modes and options
Alert log
Using Trace Files
Dynamic performance views
Data Dictionary views
Data dictionary from SQL Expert
Managing ASM instances
Benefits of using ASM
ASM instance processes and parameters
Interaction between database instances and ASM
ASM instance dynamic performance views
ASM system privileges
ASM disk groups
ASM disks
Allocation units
ASM files
Extent Maps
Striping granularity
Fine-Grained Striping
ASM Failure groups
Stripe and mirror example
Failure example
Managing disk groups
Adding disk to disk groups
Alter commands
ASM disk group compatibility
Disk Group Attributes
ASM Fast Mirror Resync Overview
Managing and Controlling Database Network Environment
Creating additional listeners
Creating Oracle Net Service aliases
Configuring connect-time failover
Controlling the Oracle Net Listener
Using tnsping to test Oracle Net connectivity
Shared servers versus dedicated servers
Define and Devise Transaction Management, Concurrency Control, Crash Recovery Components
Transactions
Properties (ACID Rules)
Life Cycle
Concurrency Control
Why do we need concurrency control?
Types of concurrency control mechanisms
Basic samples
Crash Recovery Components
Undo and Redo Operations
Examples for different component behaviors
Deadlocks
Managing Data Concurrency
Locking Mechanism
Oracle data concurrency management
Enque Mechanism
Monitoring and Resolving Locking conflicts Managing Undo Data
DML and Undo data generation
Monitoring and administer undo data and redo data
Configuring undo retention
Undo retention guarantee
Undo advisor
Managing Storage Structures
Storage of table row data in blocks
Oracle-Managed Files (OMF)
Enlarging the database
Controlling User Security
Create and Manage database user accounts:
Authenticate Users
Assign default storage areas (tablespaces)
Administer Authentication
Grant and revoke privileges (system and object privileges)
Create and manage roles
Predefined roles
Create and manage profiles:
Implement standard password security features
Control resource usage by users
Supplied password verification function
Assigning quotas to users
Principle of least privilege
Protect privileged accounts
Implementing Oracle Database Auditing
DBA responsibilities for security and auditing
Standard database auditing
DBA responsibilities for security and auditing
Standard database auditing
Specifying audit options
Audit information
Value-based auditing
Fine-Grained Auditing
FGA Guidelines
SYSDBA Auditing
Maintaining the audit trail
Oracle Audit Vault
Performance Management
Use Enterprise Manager to monitor performance
Use Automatic Memory Management (AMM)
Use the Memory Advisor to size memory buffers
View performance-related dynamic views
Troubleshoot invalid and unusable objects
Designing Database Backup and Recovery Procedures
Backup and Recovery Concepts
Types of failure that can occur in an Oracle database (statement/user process/network/User/Instance failures)
Flashback Technology
Ways to tune instance recovery (Redo Log files/Log Writer)
Using MTTR Advisor
Media failure
Configuring recoverability
Configuring the fast recovery area
Checkpoints, redo log files, and archive log files
Achiever process
Configuring ARCHIVELOG mode
Performing Database Backups
Consistent database backups
Oracle Secure Backup
User Managed Backup
Recovery Manager (RMAN)
Backing Up the Control File to a Trace File
Performing Database Recovery
Opening a Database
Keeping a Database Open
Loss of Control file/Redo Log file/data file /noncritical data file /system _critical data file
Data failure examples
Data recovery advisor
Recovery:
Control File
Redo log File
Data File
Moving Data
Ways to move data
Directory Objects
Using SQL*Loader to load data from a non-Oracle Database (user files)
Using external tables to move data via platform-independent files
General architecture of Oracle Data Pump
Using Data Pump Export and Import to move data between Oracle Databases
Take Decisions Related with Database maintenance
Managing optimizer statistics
Preferences for Gathering Statistics
Managing the Automatic Workload Repository (AWR)
Statistic Levels
Automatic Database Diagnostic Monitor (ADDM)
Advisory framework
Automated Maintenance Tasks
Server-generated alerts
Setting alert thresholds
Reacting to alerts
Alert types and clearing Alerts
Enterprise Manager Support Workbench
My Oracle Support
Log Service Requests (SR)
Manage Patches
Apply a patch
Stage a patch
Oracle Restart
Course Objectives: Administration II
By the end of this course students will be able to:
Advance RMAN Backup and Recovery
Oracle Flashback Technologies
Hands on Advance Performance Tuning
Oracle High Availability Technologies
Oracle Supported Application Servers and REST Data Services
Oracle Replication and Duplication
Course Outline Short: Administration II
Core Concepts and Tools of the Oracle Database
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Settings
Creating Backups with RMAN
Restore and Recovery Task
Using RMAN to Perform Recovery
Monitoring and Tuning RMAN
Diagnosing the Database
Using Flashback Technology I
Using Flashback Technology II
Performing Flashback Database
Managing Memory
Managing Database Performance
Managing Performance by SQL Tuning
Managing Resources
Automating Tasks with the Scheduler
Managing Space in Blocks
Managing Space in Segments
Managing Space for the Database
Duplicating a Database
No comments:
Post a Comment