Database Engineer / DBA是Database Engineering族群中的角色。涵盖5个级别的56项技能（从Junior到Principal）。其中123项为必备技能。关键领域：Programming Fundamentals, Backend Development, Database Management。
技术栈
各级别重点
Basic database administration. Writing SQL queries. Setting up backups. Performance monitoring. Learning indexes.
Query optimization. Schema design. Setting up replication. Capacity planning. Migrations. Performance tuning.
Data architecture. Sharding strategies. Disaster recovery. Multi-master replication. DBMS kernel-level optimization.
Database strategy. Choosing DBMS for different tasks. Data modeling standards. Coordination with backend and data teams.
Enterprise data architecture. Multi-DB strategy. Migration planning. Vendor evaluation. Cost optimization.
技能矩阵
56 技能 × 5 级别. 点击单元格查看详情。
AI-Assisted Development
3 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Copilot | A | W | A | E | E |
| ChatGPT / Claude | A | W | A | E | E |
| Prompt Engineering for Code | A | W | A | E | E |
API & Integration
1 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| REST API Design | A | W | A | E | E |
Architecture & System Design
3 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| System Design Fundamentals | A | W | A | E | E |
| Capacity Planning | A | W | A | E | E |
| Disaster Recovery Design | A | W | A | E | E |
Backend Development
1 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Redis | A | W | A | E | E |
Cloud & Infrastructure
5 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Docker | A | W | A | E | E |
| Kubernetes Core | A | W | A | E | E |
| Terraform | A | W | A | E | E |
| AWS | A | W | A | E | E |
| Network Fundamentals | A | W | A | E | E |
Database Management
16 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| PostgreSQL | A | W | A | E | E |
| MySQL / MariaDB | A | W | A | E | E |
| MongoDB | A | W | A | E | E |
| ClickHouse | A | W | A | E | E |
| Apache Cassandra | A | W | A | E | E |
| DynamoDB | A | W | A | E | E |
| Neo4j | A | W | A | E | E |
| CockroachDB | A | W | A | E | E |
| Vitess | A | W | A | E | E |
| Database Indexing | A | W | A | E | E |
| Query Optimization | A | W | A | E | E |
| Transactions & Concurrency | A | W | A | E | E |
| Replication & High Availability | A | W | A | E | E |
| Backup & Disaster Recovery | A | W | A | E | E |
| Data Modeling & Schema Design | A | W | A | E | E |
| Database Migrations | A | W | A | E | E |
DevOps & CI/CD
1 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Actions / GitLab CI | W | A | E | — | — |
Documentation
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Architecture Documentation: C4, arc42 | A | W | A | E | E |
| Runbook & Playbook Writing | A | W | A | E | E |
Observability & Monitoring
6 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Structured Logging | A | W | A | E | E |
| ELK Stack | A | W | A | E | E |
| Prometheus & Grafana | A | W | A | E | E |
| Custom Business Metrics | A | W | A | E | E |
| SLI / SLO / SLA | A | W | A | E | E |
| On-Call Management | A | W | A | E | E |
Performance Engineering
4 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| CPU Profiling | A | W | A | E | E |
| I/O & Disk Profiling | A | W | A | E | E |
| Database Performance Tuning | A | W | A | E | E |
| Benchmarking Tools & Methodology | A | W | A | E | E |
Programming Fundamentals
7 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Algorithms & Complexity | A | W | A | E | E |
| Data Structures | A | W | A | E | E |
| OOP & SOLID Principles | A | W | A | E | E |
| Design Patterns | A | W | A | E | E |
| Multithreading | A | W | A | E | E |
| Async Programming | A | W | A | E | E |
| Code Quality & Refactoring | A | W | A | E | E |
Security
3 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| OWASP & Application Security | A | W | A | E | E |
| Secure Coding Practices | A | W | A | E | E |
| Secrets Management | A | W | A | E | E |
Testing & QA
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Unit Testing | A | W | A | E | E |
| Integration Testing | A | W | A | E | E |
Version Control & Collaboration
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Git Advanced | A | W | A | E | E |
| Code Review | A | W | A | E | E |
常见问题
Database Engineer / DBA角色需要哪些技能？
Database Engineer / DBA角色需要56项技能，其中123项为必备。技能分布在5个级别：从Junior到Principal。 查看完整矩阵.
如何在Database Engineer / DBA角色中晋升到下一级别？
使用等级计算器评估您当前的级别并获取个性化建议。系统将显示晋升所需发展的技能。
Database Engineer / DBA角色使用什么技术栈？
技术栈包含5种不同级别的技术。 PostgreSQL 16+, SQL, pgAdmin, Backup/Restore, Monitoring basics (pg_stat_statements), MySQL basics, PostgreSQL advanced, MySQL 8+, Redis, Replication, Partitioning, EXPLAIN ANALYZE, Patroni/Citus basics, pgBouncer, PostgreSQL internals, ClickHouse, MongoDB, Citus/pgBouncer/Patroni, Sharding, pg_repack, Custom extensions...
社区如何定义Database Engineer / DBA角色的要求？
角色要求由社区通过提案系统制定。任何成员都可以提出修改建议，经过投票和专家评审后生效。