Engineering Skills Guide¶
Dmytro Chernenko's personal guide to the engineering universe — a fast-navigation reference across SRE, Platform Engineering, DBRE, Messaging, and Architecture.
Browse the rendered site → diamonce.github.io/guide¶
Domains¶
| Domain | Focus | Entry Point |
|---|---|---|
| SRE | Reliability, observability, incident response | sre/README.md |
| Platform Engineering | Terraform, Kubernetes, CI/CD, cloud infra | platform/README.md |
| DBRE | Database reliability, performance, scaling | dbre/README.md |
| Messaging | Kafka, RabbitMQ, SQS/SNS, Pulsar, NATS | messaging/README.md |
| Architecture | Well-Architected, landing zones, blast radius, least privilege | architecture/README.md |
SRE¶
- Fundamentals & Concepts
- SLOs / SLIs / SLAs
- Observability
- OpenTelemetry & Tracing
- Incident Management
- On-Call & Runbooks
- Scalability
- Case Studies — Airbnb, Booking.com, Capital One, Dropbox, eBay, Etsy, GitHub, Google, Pinterest, Shopify, Slack, Spotify, Stripe, Twitter, Uber (real links, no hallucinations)
Platform Engineering¶
- Terraform & IaC
- Kubernetes
- CI/CD Pipelines
- Cloud Infrastructure
- Security & Hardening
- Practice & Interview Prep — 2,600+ exercises
- External Links — GitHub Well-Architected governance
DBRE¶
- Database Landscape — PostgreSQL, MySQL, Oracle, MongoDB, Redis, Cassandra, ClickHouse, Aurora, DynamoDB, Spanner, Cosmos DB, CockroachDB, PlanetScale
- Fundamentals
- SQL Best Practices
- Anti-Patterns
- Best Practices — Do's and Don'ts — schema design, queries, indexing, naming, tools
- Performance Tuning
- Migrations & Schema Changes
- Backup & Recovery
- Scaling Databases
- Lab Runbook — Docker lab: MySQL replication + HAProxy + ProxySQL + backups + failover
- External Links — official docs for 15 databases, PostgreSQL Don't Do This, sqlblog
Messaging¶
- Overview & System Comparison — Kafka vs RabbitMQ vs SQS/SNS vs Pulsar vs NATS vs Redis Streams; broker selection table; all fan-out patterns
- Kafka Deep Dive — partitions, consumer groups, exactly-once, schema registry, consumer lag, KRaft, Kafka Streams
- Best Practices — do's/don'ts for Kafka, RabbitMQ, SQS/SNS; pre-deploy checklist
- External Links — official docs, free O'Reilly books, Jay Kreps' foundational log essay
Architecture¶
- Overview & Core Principles
- Well-Architected — AWS / GCP / Azure 6 pillars, availability table, checklists
- Landing Zones — multi-account org design, SCPs, GCP org policies, account vending, hub-and-spoke Transit Gateway
- Best Practices — blast radius (cell architecture, bulkheads, circuit breakers, canary), least privilege (IRSA, permission boundaries, JIT), scalability (CQRS, queue leveling, caching layers)
- External Links — official frameworks, system design books, reference architectures
Resource Library¶
The repos below are checked-out copies of open-source projects vendored here for offline browsing and cross-linking. All content rights belong to the original authors. See each repo's license for details.
| Repo | Domain | Description |
|---|---|---|
| awesome-sre | SRE | Curated SRE resources, tools, books |
| howtheysre | SRE | How 60+ real companies do SRE — blog posts, talks, incident reports |
| sre-collection | SRE | SRE job/interview collection |
| devops-exercises | Platform/SRE | 2,600+ practice Q&A across DevOps topics |
| devops-collection | Platform | DevOps tools and resources |
| book-of-secret-knowledge | Platform/Security | CLI tools, one-liners, cheatsheets |
| github-well-architected | Platform | GitHub Well-Architected — reliability, security, governance |
| awesome-scalability | Architecture | System design & scalability patterns from real companies |
| system-design-primer | Architecture | The most comprehensive system design reference on GitHub |
| awesome-system-design | Architecture | Curated system design resources, papers, implementations |
| awesome-chaos-engineering | Architecture/SRE | Chaos engineering tools, books, papers, and game days |
| percona-toolkit | DBRE | MySQL/PostgreSQL DBA toolkit (pt-osc, pt-query-digest, pt-table-checksum) |
| sqlcheck | DBRE | SQL anti-pattern detection — run in CI |
| sql-tips-and-tricks | DBRE | Practical SQL tips and tricks |
| sqlstyle-guide | DBRE | SQL style guide for consistent formatting |
| awesome-mysql | DBRE | MySQL queries, commands and snippets |
| awesome-postgres | DBRE | PostgreSQL resources, tools, extensions |
| awesome-mongodb | DBRE | MongoDB resources and tools |
| awesome-redis | DBRE | Redis resources, patterns, tooling |
| awesome-nosql-guides | DBRE | NoSQL patterns, guides, comparisons |
| awesome-kafka | Messaging | Kafka tools, clients, libraries, resources |
| data-engineer-handbook | DBRE/Data | Data engineering roadmap & resources |
| sql-guide | DBRE | SQL interview Q&A |
Contributing¶
Found something wrong, outdated, or missing? Pull requests are welcome. This is a living document — if a pattern clicked for you or you know a better source, open a PR.