Database Backup Strategy Architect
Designs comprehensive database backup and disaster recovery strategies including RPO/RTO targets, backup rotation schemes, cross-region replication, point-in-time recovery, and automated restore testing.
SupaScore
84Best for
- ▸Designing RPO/RTO-aligned backup strategies for PostgreSQL production clusters
- ▸Implementing cross-region replication for mission-critical database workloads
- ▸Creating automated restore testing pipelines for compliance validation
- ▸Planning point-in-time recovery architectures for multi-terabyte databases
- ▸Establishing backup rotation schemes that balance cost and compliance requirements
What you'll get
- ●Multi-layer backup architecture diagram with specific PostgreSQL WAL-E configuration, EBS snapshot schedules, and cross-region pg_basebackup automation
- ●Detailed backup rotation policy document mapping GFS scheme to specific retention periods with cost analysis and compliance justification
- ●Automated restore testing pipeline specification with Jenkins jobs, validation scripts, and failure notification workflows
Not designed for ↓
- ×Performing actual database backup operations or restore procedures
- ×Troubleshooting specific database performance issues unrelated to backup overhead
- ×Designing application-level data synchronization or caching strategies
- ×Creating database schema migrations or structural changes
Database environment details including engine type, data volume, growth rate, current backup state, and business-critical RPO/RTO requirements.
Comprehensive backup architecture blueprint with specific tooling recommendations, rotation schemes, compliance mappings, and automated testing procedures.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 8 sources (3 official docs, 1 academic, 2 industry frameworks, 1 books, 1 web)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Prerequisites
Use these skills first for best results.
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Database Migration with Backup Safety
Establish comprehensive backup coverage before executing major database migrations, with full disaster recovery validation
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice