Job Description
ORACLE DBA Week 1: Linux 8.4 for Database Administrators Coverage ILT Duration (Hrs) Assignments Project (OJT) · Linux for Database Administrators 40 6 10 · Linux Directory Structure · File Permissions and Security · Common Linux Commands and Programs Working with Linux Shells · Bash Shell Scripting Preparing Linux for Oracle · Linux Distributions · Verifying the Linux Kernel · Using the /proc System · Setting Kernel Parameters · Managing Packages · Using the oracle-validated RPM · Creating Groups and Users · The nobody User Installing Oracle on Linux · Setting Environment Variables Pre- Installation · Optimal Flexible Architecture · Installing New Releases · Managing Multiple Oracle Versions · Setting Oracle Environment Variables · Performing a Silent or Suppressed Installation · Oracle Patch Utility · Oracle Relink Utility Managing Storage on Linux · Oracle Database Storage Options · Supported Linux I/O Modes · Disks and Partitions · Managing Partitions · Logical Volume Manager Concepts · Attached Storage · Linux and File Systems · Monitoring Disk Usage and Free Space Using Oracle ASM on Linux · Automatic Storage Management Library Driver · Installing and Initializing ASMLib · Configuring Disks · Marking Disks as Automatic Storage Management Disks · Creating an ASM Instance · ASM Installation Best Practices Disk Group Configuration Best Practices Automating Oracle on Linux · Automating Tasks · Linux Startup Sequence · Linux Runlevels · Automating Startup and Shutdown of Oracle Processes · Working with the dbstart and dbshut Scripts · Linux Scheduling Tools Scheduling a Backup with cron Optimizing Linux for Oracle · Standard Linux Measurement Tools · Measuring CPU Activity and Reducing CPU Bottlenecks · Monitoring and Tuning Memory · Monitoring and Tuning Disk I/O · Basic Oracle Database Optimizations · Basic Linux Optimizations · Page Address Extensions for 32-bit Systems · Configuring Hugepages Additional Linux Tips for DBAs · Simple Shell Scripts to Simplify DBA Tasks · Adding Command History to SQLPlus Finding Files with SETUID or SETGID Set · Capturing System Data Using Scripts · Finding Background Processes · Finding Server Processes · Killing Server Processes · Query Output in an Environment Variable Troubleshooting Oracle Issues on Linux · Monitoring alert log with ADRCI · Resolving ORA-600/ORA-7445 Errors · Process Hierarchy · Viewing the Startup Environment for a Process · Viewing the Status of a Process · Recovering from Database Crashes · Debugging a Core Dump Using strace Week 2: Oracle RAC 1+c & ASM Coverage ILT Duration (Hrs) Assignments Project (OJT) Oracle Database 1+c RAC and Grid Infrastructure Administration 10 3 2 · Overview of Oracle RAC · Oracle RAC Features · Oracle RAC Technology Hierarchy · Oracle RAC Capabilities · Oracle RAC Components · Oracle RAC One Node Overview · Benefits of using RAC · Tools for Installing, Configuring and Managing Oracle RAC ORACLE GRID INFRASTRUCTURE OVERVIEW 10 3 2 · Cluster Overview · Flex Cluster Overview · Grid Foundation Components and Architecture · Oracle Clusterware Components and RAC · Oracle Clusterware Software and Storage · Oracle Storage Subsystems · File Types used by a RAC Database · Methods used to Share Database Files across a Cluster · RAC Multitenant Database · An Overview of RAC Services · Perform ACFS Automatic Resizing · Perform ACFS Defragmentation · Perform ACFS Compression Week 3: MySQL for Database Administrators V8 Coverage ILT Duration (Hrs) Assignments Project (OJT) Introduction to MySQL · MySQL overview · MySQL Enterprise Edition · MySQL on the Web · MySQL in the Cloud · The MySQL community 25 Hours 3 4 Installing MySQL · Installing MySQL · Installed Files and Directories · Initial Configuration · Starting and Stopping MySQL · Upgrading MySQL MySQL Architecture · Architectural Overview · How MySQL Transmits Data · How MySQL Processes Requests · How MySQL Stores Data · Tablespaces · Redo and Undo Logs · How MySQL Uses Memory · Plug-in Interface Configuring MySQL · Server Options, Variables, and the Command Line · Option Files · System Variables · Launching Multiple Servers on the Same Host Monitoring MySQL · Monitoring MySQL with Log Files · Monitoring MySQL with Status Variables · Monitoring MySQL with Performance Schema · MySQL Enterprise Audit · MySQL Enterprise Monitor · Monitoring User Activity User Management · MySQL Privilege System · Creating and Modifying User Accounts · Configuring Passwords and Account Expiration · Authentication Plug-Ins · Granting Permissions · Grant Tables · Resetting a Forgotten Root Password MySQL Security · Security Risks · Network Security · Secure Connections · Password Security · Operating System Security · Protecting Against SQL Injections · MySQL Enterprise Firewall · Maintaining a Stable System · Stability · Why Databases Fail · Capacity Planning · Troubleshooting · Identifying the Causes of Server Slowdowns · InnoDB Recovery Optimizing Query Performance · Identifying Slow Queries · The EXPLAIN statement · Working with Indexes · Index Statistics · Backup Strategies · Understanding Backups · Backup Techniques · Creating a Backup Strategy Performing Backups · MySQL Backup Tools · Raw Backup Methods · Techniques that Use the Binary Log Configuring a Replication Topology · Overview of Replication · Replication Conflicts · When to Use Replication · Configuring Replication Administering a Replication Topology · Failover · MySQL Utilities · Replication Threads · Monitoring Replication · Troubleshooting Replication Group Replication · Overview · Single-Primary and Multi-Primary Modes · Configuring Group Replication · Monitoring Group Replication Conclusion · Course Overview · MySQL Curriculum · Course Evaluation · Thank You! · Q&A Session Week 4: Database Security Coverage ILT Duration (Hrs) Assignments Project (OJT) Database Security 25 6 10 · Introduction to Oracle database security · Background on key Oracle database concepts, files, table structures, configurations · Why audit an Oracle database (internal & external threats, abuse of privileged access, DBAs, · bugs, etc.) Security policies, risk assessment & Reconnaissance · Common Oracle database security flaws/vulnerabilities, configuration gaps, segregation of duty · issues, etc. (exploits, attack vectors, SQL injection) · Using Information security policies and best practice standards to drive Oracle database security · (The foundation) Oracle database audit planning & requirement/information gathering · Planning an audit · Information & requirement gathering · Preparing an environment and organizing connections Audit tools and scripts required Audit execution · Logical access controls (user enumeration, password security controls and least privilege · principles) · Segregation of duties, privileges and role base access control (RBAC) · Understanding operating system security for Oracle database (UNIX, Linux & Windows) · File and directory permissions, OS security parameters, data leakage, access control · Auditing Oracle networking files (listener, protocol, TNS, SQLNET) · Auditing Oracle database security configurations (roles, profiles, resources, permission on · objects, privileges, security parameters) · Oracle database audit trail assurance (log access, archiving, Oracle audit facilities & configurations Audit documentation, reporting and process improvement · Audit work programmer (AWP) and test of control (TOC) documentation · Audit findings documentation, reporting and executive summary · Process improvement measures (security policy review and improvement, Oracle database · security baseline documentation, Audit program and checklists · documentation) Coverage ILT Duration (Hrs) Assignments DAYS-5 WebLogic Server Overview · WebLogic Server Architecture · Application Services · Administration Tools · Java Cloud Service 2 4 Day -1 Installing and Patching WebLogic Server · Installing WebLogic Server · Patching WebLogic Server · Zero Downtime Patching 2 1 Week 6: SQL SERVER Coverage ILT Duration (Hrs) Assignments DAYS-5 SQL SERWeek 7: Oracle Database: Performance Management and Tuning Week 8: Project / Presentation / Summery: 35 Hrs
💡 Quick Summary
Seeking a career-building opportunity? The Oracle DBA Trainer position is now open for candidates interested in the Database Administrator sector. This role in Bengaluru offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
