In a {{tone}} tone, design a production-grade PostgreSQL database architecture for an HR-tech learning management system (expected volume: 500GB–5TB). Cover these sections: Requirements Analysis, Schema Design, Relationships and Data Integrity, Query Optimization, Scaling Plan, Migration and Evolution, Backup and Recovery. Use Markdown headers (## and ###) with bullet points and bold for key terms. Length: 1200–1800 words.