dataiotech Labs
dbaguide/academy
MODERN DBA ACADEMY · ENGINEERING ACADEMY

Modern Database Engineering & Reliability Academy

A production-grounded, free engineering academy bridging core database theory with mission-critical operational reality across 12 modules, 4 learning paths, and one-command Docker drills.

Share Academy with peers:
12
Specialized Modules
39
Active Lessons
4
Learning Paths
261
Production Assets
100%
Free & Open Access
FEATURED TECHNICAL ASSETS

Verified Production Guides & Labs

View all 38 active syllabus lessons
CAREER ARCHITECTURE

Curated Learning Paths

Role-based specialization pathways guiding the transition from traditional administration to SRE, HA architecture, and AI vector platforms.

Career & Certification Hub
Advanced40 Hours
4 Modules

Core DBA to Production SRE / DBRE

A comprehensive engineering path for professionals advancing from traditional administration into modern Database Reliability Engineering (DBRE), combining storage physics, wait statistics, disaster drills, and SLO telemetry.

Target Engineering Role:
Database Reliability Engineer (DBRE) / Senior Production DBA
Capstone Docker Lab
Multi-Table Disaster Recovery Under Simulated SEV-1 Outage

Execution of the 10-stage isolated Docker recovery procedure under simulated failure, repairing missing roles and completing checksum verification within target RTO.

$ npm run test:drill
Expert45 Hours
4 Modules

High Availability & Disaster Recovery Architect

Architectural mastery for engineers designing zero data loss (RPO=0) and near-instant failover (RTO<30s) clustering topographies using distributed consensus and replication routing.

Target Engineering Role:
High Availability Infrastructure Architect / Principal DBA
Capstone Docker Lab
Split-Brain Mitigation & Fencing in a 3-Node Patroni Cluster

Simulating network partitions to test quorum loss behavior, node fencing, and transparent HAProxy traffic rerouting.

Advanced35 Hours
4 Modules

Cloud & Platform Database Engineer

For platform engineers migrating on-premises workloads to managed cloud engines, orchestrating Kubernetes database operators (CloudNativePG), and optimizing multi-region cloud TCO.

Target Engineering Role:
Cloud Database Platform Engineer / Data Infrastructure Lead
Capstone Docker Lab
Declarative CloudNativePG Cluster Orchestration on Kubernetes

Deploying a 3-instance PostgreSQL cluster with Barman object storage backups and anti-affinity scheduling.

Expert30 Hours
4 Modules

AI & Vector Data Architect

For architects turning enterprise relational databases into high-throughput vector stores for GenAI and LLM retrieval: pgvector HNSW indexing, memory profiling, and hybrid lexical/dense search.

Target Engineering Role:
AI Data Architect / Vector Database Specialist
Capstone Docker Lab
1536-Dimensional pgvector HNSW vs. IVFFlat Recall & Memory Drill

Benchmarking 1536-dim vector embeddings across HNSW and IVFFlat indexes to measure latency curves and RAM footprint.

$ python labs/vec-003/run.py
MASTER CURRICULUM

12 Core Specialized Modules

The complete curriculum is visible from day one. Published lessons are instantly accessible, and upcoming syllabus items roll out continuously.

Engine:
Level:
MDBA-FUND

1. Database Fundamentals & Storage Engines

Relational engine physics, disk page layout, ACID durability, and MVCC

Core Competencies:
  • ✓ACID principles at disk and WAL/redo log boundary
  • ✓B-Tree index page splits vs. LSM-Tree compaction mechanics
6 Active
View Syllabus
MDBA-PERF

2. Performance Engineering & Tuning

Query execution plans, memory allocation, lock contention, and bloat reduction

Core Competencies:
  • ✓Kernel Page Cache, Dirty Page Flushing, and Checkpoint sizing
  • ✓Autovacuum cost model, table bloat mitigation, and XID wraparound protection
7 Active
View Syllabus
MDBA-RELI

3. Reliability & Disaster Recovery (HA/DR)

Patroni HA, InnoDB Cluster, Always On, replication lag, and verifiable PITR

Core Competencies:
  • ✓PostgreSQL Patroni + etcd + HAProxy zero-downtime automatic failover
  • ✓MySQL InnoDB Cluster + Group Replication + MySQL Router topologies
8 Active
View Syllabus
MDBA-SECU

4. Database Security & Hardening

Authentication, RBAC/ABAC privileges, TDE encryption, and CIS benchmarks

Core Competencies:
  • ✓pg_hba.conf, SCRAM-SHA-256, and mandatory SSL/TLS connection hardening
  • ✓Principle of Least Privilege and dynamic role segregation
2 Active+1 Plan
View Syllabus
MDBA-OBSR

5. Observability & SRE

SLO/SLI targets, wait statistics, telemetry, and metric-to-runbook chains

Core Competencies:
  • ✓SRE Triad: Metric (M#) -> Runbook (R#) -> Script (S#) execution flow
  • ✓SQL Server sys.dm_os_wait_stats and Oracle V$SYSTEM_EVENT wait classification
3 Active+1 Plan
View Syllabus
MDBA-DEVO

6. Database Automation & DevOps

Dynamic configuration engines, automated maintenance, and CI/CD migrations

Core Competencies:
  • ✓Dynamic postgresql.conf and my.cnf parameter generator algorithms
  • ✓Automated index fragmentation and bloat maintenance scripting
1 Active+1 Plan
View Syllabus
MDBA-CLOU

7. Cloud & Platform Engineering

AWS Aurora vs. Patroni, Kubernetes operators, and managed DBaaS trade-offs

Core Competencies:
  • ✓AWS Aurora vs. Self-Hosted Patroni: RPO/RTO, SLA, TCO, and operational control
  • ✓Azure DP-300 and GCP Professional Database Engineer exam master guides
1 Active+1 Plan
View Syllabus
MDBA-DINT

8. Data Integration & CDC

WAL internals, logical replication slots, Debezium, and Kafka streaming

Core Competencies:
  • ✓WAL LSN ordering, Full Page Writes (FPW), and logical decoding plugins
  • ✓Active replication slot lag triage and unbounded WAL growth remediation
2 Active
View Syllabus
MDBA-MDAR

9. Modern Data Architecture

HTAP, distributed SQL consensus, sharding topologies, and polyglot storage

Core Competencies:
  • ✓PostgreSQL 17 vs. MySQL 8.4 LTS enterprise architectural decision matrix
  • ✓MongoDB sharded cluster chunk split failures and balancing bottlenecks
1 Active+1 Plan
View Syllabus
MDBA-AIVC

10. AI & Vector Database Engineering

pgvector HNSW, IVFFlat indexing, RAG memory systems, and vector tuning

Core Competencies:
  • ✓Enterprise RAG architecture blueprint design using PostgreSQL and pgvector
  • ✓HNSW (Hierarchical Navigable Small World) m and ef_search tuning
1 Active+1 Plan
View Syllabus
MDBA-GOVC

11. Data Governance & Compliance

GDPR/KVKK compliance, dynamic data masking, Go-Live, and pre-upgrade checklists

Core Competencies:
  • ✓25-point enterprise production Go-Live checklist management
  • ✓20-point major database upgrade compliance and readiness checks
2 Active
View Syllabus
MDBA-STRT

12. Architecture & Technology Strategy

Version lifecycles, TCO models, engineering career roles, and 90-day roadmap

Core Competencies:
  • ✓Authoritative lifecycle analyses for PostgreSQL, MySQL, SQL Server, and Oracle
  • ✓90-day senior DBA & SRE competency roadmap navigation
5 Active
View Syllabus
VERIFIABLE LAB SANDBOX

One-Command Docker Practice Labs

In compliance with dataiotech ADR-0003, all disaster recovery simulations and replication drills launch inside isolated Docker containers via single-command runners.

SEV-1 DRILLPostgreSQL 18

Multi-Table Disaster Recovery Drill

Recover corrupted disk pages, repair missing role privileges, and verify table checksums under strict RTO deadlines.

$ npm run test:drill
REPLICATION LAGPostgreSQL + Patroni

WAL Streaming & Replication Lag Stress

Simulate high transaction spikes to induce standby lag, tuning wal_sender and receiver timeouts under stress.

$ npm run test:lag
MULTI-ENGINEPG, MySQL, SQLS, ORA

Isolated Test Environment & Diagnostics

Spin up the full dbaguide multi-engine sandbox with 100 diagnostic scripts on port 3010 in seconds.

$ npm run test:env
DATAIOTECH ECOSYSTEM

Integrated Data & Engineering Network

Modern DBA Academy integrates directly across the dataiotech platform ecosystem. Theoretical principles learned here connect into live tools, production workflows, and post-mortem archives.

Academy Curriculum Alerts

Get new Modern DBA Academy guides, labs and technical learning resources delivered to your inbox.

Receive instant updates whenever new engineering modules, emergency incident runbooks, diagnostic scripts, and one-command Docker drills are published.

KVKK / GDPR aligned · Zero spam · One-click unsubscribe•