Postgres data migration specialist

POSTGRES DATA MIGRATION SPECIALIST
(Enum drift, historical data, ORM crash prevention)
Job Title
PostgreSQL + Alembic Data Migration Specialist (Enum Drift Remediation)
Overview
We require a database specialist to repair enum drift and historical data inconsistencies in a PostgreSQL-backed FastAPI application.
Current issue:
Multiple enum types contain uppercase historical values
Python enums expect lowercase .value
ORM reads fail on legacy rows
Some enum labels do not match 1:1 lowercase transformations (mapping required)
Required Experience
Advanced PostgreSQL enum management
Alembic data migrations
SQLAlchemy ORM behavior with enums
Production-safe migration planning
Reversible migrations
Writing CASE-based migration logic
Scope
Produce enum drift matrix (DB vs Python)
Write Alembic schema + data migrations
Normalize historical data using mapping logic
Validate ORM reads after migration
Provide rollback-safe migrat...