技能档案

Backup & Disaster Recovery

pg_dump, WAL archiving, PITR, pgBackRest, logical replication, restore strategies

Database Management Database Administration

角色数

4

包含此技能的角色

级别数

5

结构化成长路径

必要要求

14

其余 6 个可选

领域

Database Management

skills.group

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.

社区

👁 关注 ✏️ 建议修改 登录以建议修改
📋 提案
暂无提案 Backup & Disaster Recovery
正在加载评论...