Set up database backup and restore strategy

[yashdev9274]

Description

Implement a database backup and restore process for disaster recovery.

Expected Deliverables

• Create backup script using Prisma or pg_dump
• Set up automated daily backups (GitHub Actions)
• Create restore script and documentation
• Store backups in cloud storage (AWS S3, GCS, etc.)
• Document recovery procedures

Areas to Consider

• Backup retention policy
• Incremental vs full backups
• Testing restore process
• Encryption for sensitive data