领域
Database Management
技能档案
pg_dump, WAL archiving, PITR, pgBackRest, logical replication, restore strategies
角色数
4
包含此技能的角色
级别数
5
结构化成长路径
必要要求
14
其余 6 个可选
Database Management
Database Administration
2026/3/17
选择当前级别并对比期望。下方卡片显示晋升所需掌握的内容。
表格展示从初级到首席的技能深度变化。点击行查看详情。
| 角色 | 必要性 | 描述 |
|---|---|---|
| 1C Developer | Understands basic backup types (full, differential, incremental) for 1C:Enterprise databases. Follows documented backup schedules and verifies backup integrity. Knows how to restore a database from backup under supervision and maintains backup logs. | |
| Data Engineer | 必要 | Understands backup importance in data pipelines: checkpoint files, intermediate results. Uses snapshots before destructive operations. Knows how to recover data from staging tables. |
| Database Engineer / DBA | Performs routine database backups using native DBMS tools (pg_dump, mysqldump, RMAN). Verifies backup completeness and tests restore procedures in development environments. Follows established backup policies and rotation schedules. Documents backup and recovery steps. | |
| Infrastructure Engineer | Configures scheduled backups for infrastructure components using automation tools (cron, systemd timers). Monitors backup job completion and alerts on failures. Understands storage requirements for backup retention policies and assists with disaster recovery drills. |
| 角色 | 必要性 | 描述 |
|---|---|---|
| 1C Developer | Designs backup strategies for 1C:Enterprise information bases considering RPO/RTO requirements. Configures automated backup pipelines with verification checks. Implements point-in-time recovery procedures and manages backup storage optimization for large 1C databases. | |
| Data Engineer | 必要 | Configures backup for data pipeline artifacts: intermediate data versioning in S3, point-in-time recovery in PostgreSQL. Implements rollback mechanisms for ETL processes. |
| Database Engineer / DBA | Designs comprehensive backup strategies combining full, incremental, and continuous archiving (WAL, binlog). Implements automated backup verification with restore testing. Configures cross-region replication for disaster recovery. Optimizes backup performance and storage costs. | |
| Infrastructure Engineer | Implements infrastructure-level backup solutions using snapshot-based and agent-based approaches. Configures backup orchestration across multiple systems with centralized monitoring. Manages backup storage tiers (hot, warm, cold) and automates disaster recovery runbooks. |
| 角色 | 必要性 | 描述 |
|---|---|---|
| 1C Developer | 必要 | Architects enterprise backup and disaster recovery solutions for distributed 1C:Enterprise clusters. Designs zero-downtime backup strategies for high-load 1C systems. Implements geo-redundant recovery with automated failover and conducts regular DR testing across all environments. |
| Data Engineer | 必要 | Designs disaster recovery for data platform: backup strategies for different storage (HDFS snapshots, S3 versioning, DB dumps). Implements time-travel in Delta Lake/Iceberg for data recovery. |
| Database Engineer / DBA | 必要 | Designs enterprise-grade backup architectures for high-load multi-database environments. Implements automated DR failover with sub-minute RTO targets. Optimizes backup strategies for petabyte-scale databases using parallel backup, compression, and deduplication. Leads DR exercises. |
| Infrastructure Engineer | 必要 | Designs multi-region disaster recovery architectures with automated failover and failback procedures. Implements infrastructure-as-code for backup topology ensuring consistency across environments. Optimizes RTO/RPO targets through tiered backup strategies and conducts chaos engineering for DR validation. |
| 角色 | 必要性 | 描述 |
|---|---|---|
| 1C Developer | 必要 | Defines enterprise data protection strategy for 1C:Enterprise ecosystems across the organization. Establishes backup and recovery standards, SLAs, and compliance requirements. Conducts architecture reviews of DR plans and mentors teams on backup best practices for 1C platforms. |
| Data Engineer | 必要 | Defines DR standards for data platform: RPO/RTO by data tier, retention policies, automated backup verification. Conducts DR drills and recovery testing. |
| Database Engineer / DBA | 必要 | Defines organization-wide database backup and disaster recovery strategy aligned with business continuity objectives. Establishes backup standards, compliance frameworks, and recovery SLAs. Reviews and approves DR architectures across teams. Drives adoption of modern backup technologies. |
| Infrastructure Engineer | 必要 | Defines data management strategy at product level. Establishes Backup and Disaster Recovery standards. Conducts data schema and scaling strategy reviews. |
| 角色 | 必要性 | 描述 |
|---|---|---|
| 1C Developer | 必要 | Defines organizational data strategy. Evaluates and selects database technologies for different use cases. Designs multi-region data architectures. |
| Data Engineer | 必要 | Designs data resilience strategy: multi-region replication, cross-cloud DR, cold/warm/hot backup tiers. Defines governance for data protection and compliance (GDPR right to delete). |
| Database Engineer / DBA | 必要 | Shapes organizational backup/recovery strategy: RPO/RTO by tier, automated backup verification (restore testing), cross-region backup replication. Defines DR playbooks, conducts regular DR drills. Evaluates backup solutions: native vs Percona XtraBackup vs cloud-native. |
| Infrastructure Engineer | 必要 | Defines database backup and recovery strategy at organizational level: RPO/RTO for different data classes, multi-region backup storage, automatic recovery testing. Designs cross-cloud DR architecture and makes decisions on storage cost vs recovery speed. |