How do you manage database schema changes and migrations in a production environment?

Sample answer preview

Managing schema changes in production is one of the most risk-sensitive tasks a DBA performs. A poorly executed schema change can cause downtime, data loss, or application errors. Having a disciplined migration process is essential for maintaining database reliability.