The Data Management Specialist plays a central role in governing how MySQL schema changes are designed, validated, deployed, tracked, and recovered, while supporting the accuracy, quality, and security of data across DarwinCX environments. This role exists to eliminate schema drift, unsafe manual changes, and non-repeatable deployments by establishing automated, auditable, and recoverable database change management practices.
Why This Role Exists
DarwinCX operates multiple MySQL production environments supporting client-facing workloads. Without consistent database change management, schema drift, deployment risk, and recovery challenges increase over time. This role ensures MySQL schema changes are predictable, validated, and survivable.
Key Responsibilities
- Own MySQL schema change governance, standards, and workflows
- Define authoritative schema sources and expected state
- Implement schema versioning and drift detection
- Design and operate automated MySQL deployment pipelines
- Enforce pre-execution validation (syntax, dependencies, safety)
- Coordinate schema drift remediation with DBAs
- Define backup, restore, and rollback strategies for schema changes
- Ensure non-production environments match production schema
- Maintain centralized documentation and deployment records
- Maintains metadata, schemas, and data catalogs for transparency and accessibility.
- Partner with Engineering, Platform, and Security teams