# Oracle-DBA-Study — START HERE

Integration Engineer 4 (Oracle DBA, RAC/DataGuard/GoldenGate)(CORE) — Chicago IL, hybrid. Power Day: 3–5 back-to-back Zoom rounds — 1–2 technical (DBA scenario + system/design), 1 job-fit/case (business-driven decision), 1 behavioral STAR.

Role essence: enterprise-scale integration lead on Agile teams — design/develop/test/implement/support Oracle HA/DR (RAC, DataGuard, GoldenGate) on the CORE foundational cloud layer (observability, connectivity, resilience, availability), migrating Exadata/on-prem Oracle toward AWS RDS with zero-data-loss RPO and customer-impact-first sev handling.

## One-sentence rule

> Every answer: state the pick, the first data you would pull, and the trap you ruled out — in that order.

## Scoring words (use aloud daily)

Ownership · Excellence · Do the Right Thing · cache fusion · interconnect · quorum/fencing · FSFO · standby redo · CDC/extract-pump-replicat · AWR/ASH/ADDM · RTO/RPO · least privilege · STAR with metric.

## 10-day plan (Nov 5–14)

| Day | Focus | Audio | Lab |
|-----|-------|-------|-----|
| 1 | RAC: cache fusion, interconnect, split-brain/quorum | E1 | Voting-disk failure drill + TAF service failover sim |
| 2 | DataGuard: FSFO, lag/apply, switchover vs failover | E2 | Lag query + switchover runbook walkthrough |
| 3 | GoldenGate: CDC, extract-pump-replicat, conflicts | E3 | Lag monitoring + conflict-resolution design |
| 4 | Perf tuning: AWR/ASH/ADDM drill order, plans | E4 | Top-wait triage on a sample AWR + plan compare |
| 5 | Backup/recovery + patching runbook | E5 | RMAN restore + PITR + patch rollback rehearsal |
| 6 | Exadata: offload, cell, partitioning | E6 | Offload-eligibility check + partition design |
| 7 | HA/DR + sev handling: RTO/RPO, runbooks, comms | E7 | Sev tabletop: customer-impact-first narrative |
| 8 | AWS RDS gap: RDS vs EC2 Oracle, DMS, CloudWatch | E8 | DMS prereqs checklist + CloudWatch alarm map |
| 9 | Compliance + Agile: SOX/PCI, ceremonies, PO delivery | E9 | Audit-trail review + change-control-to-Agile story |
| 10 | Mock loop: scenario + case + behavioral STAR | E10 | Full timed mock, gap list ≤5 with owners |

## Files inventory

| File | What it is |
|------|------------|
| `00_START_HERE.md` | This file: plan, rule, scoring words |
| `STUDY_PLAN.md` | Daily repetition stack + Days 1–10 Focus/Listen/Lab/Say-aloud/Desk/Done-check + BASE-TO-BUILD |
| `CHEAT_SHEET.md` | Triage checklists, drill orders, runbooks, audit lines, STAR index, intro spine (largest file) |
| `RESOURCES.md` | Official Oracle docs links per day + AWS RDS migration links |
| `AGENTS.md` | Project conventions + deploy section |
| `scripts/` `audio/` `video/` `print/` `dist/` `tests/` | Builders, episodes, clips, print-only, mirrors, checks |

Next: open [STUDY_PLAN.md](./STUDY_PLAN.md), then keep [CHEAT_SHEET.md](./CHEAT_SHEET.md) open during every lab.