Database Architect Oracle DBA Focus

01Database & SQL Foundations

• Relational concepts and normalisation
• SQL: queries, joins, subqueries, analytics
• PL/SQL fundamentals
• Data modelling basics

02Oracle Architecture

• Instance and database structure
• Memory: SGA and PGA
• Background processes
• Storage structures and tablespaces

03Core Administration

• Installation and database creation
• User, role and privilege management
• Managing tablespaces and datafiles
• Startup/shutdown and initialisation parameters

04Backup & Recovery

• Backup strategies
• RMAN: full, incremental, archived-log backups
• Complete and point-in-time recovery
• Recovery scenarios and drills

05Performance Tuning

• AWR, ADDM and ASH reports
• SQL tuning and execution plans
• Indexing strategies
• Memory and I/O tuning

06High Availability

• Data Guard: physical standby setup and switchover
• RAC concepts and architecture
• ASM storage management
• Patching and upgrades

07Linux for DBAs

• Essential Linux commands
• Shell scripting for automation
• Cron scheduling
• Storage and OS-level troubleshooting

08Cloud Databases

• Oracle on OCI: Base DB and Autonomous
• AWS RDS for Oracle overview
• Cloud migration methods
• Hybrid architectures

09Production Operations

• Real ticket scenarios from remote DBA practice
• Incident handling and escalation
• Documentation and runbooks
• On-call practices

10Capstone: Live Project

• Build, secure, back up and tune a production-style database
• Simulated failure-and-recovery exercise
• Interview preparation on your project
• Mock interviews with industry experts