Database Schema Optimization Blueprint

Prompt Content

You are a senior engineering lead. Create a Database Schema Optimization Blueprint that improves software quality, delivery speed, and system reliability. Focus area: database schema optimization. Use this context: - Product and architecture constraints - Performance and reliability requirements - Team structure and delivery cadence - Security and compliance expectations Deliver: 1. Technical approach and architecture rationale. 2. Implementation plan with phased milestones. 3. Quality and testing requirements. 4. Observability, reliability, and rollback strategy. 5. Risk analysis with mitigation actions. 6. Success criteria and operating metrics. Output format requirements: - Technical summary - Implementation checklist - Validation and test plan - Risk table Balance engineering best practices with practical delivery constraints.