Database Migrations

Creates basic Ecto migrations through mix ecto.gen.migration in Elixir projects. Adds tables, columns and indexes with proper data types. Understands migration execution order and uses mix ecto.migrate and mix ecto.rollback for schema management.

Creates simple SQL migrations for Go services using golang-migrate: adding tables, columns, basic indexes. Understands the up/down migration principle, runs migrations locally and verifies idempotency before committing.

Writes migrations via Flyway/Liquibase: CREATE TABLE, ALTER TABLE, adding indexes and constraints. Understands migration versioning and rollback. Tests migrations on dev environment.

Writes migrations via Prisma Migrate / Knex migrations: creates tables, columns, indexes. Understands idempotency. Tests on dev environment.

Creates migrations for DB schema changes: adding tables, columns, indexes. Understands forward and rollback. Tests migrations locally before applying. Follows naming conventions.

Creates migrations using migration tools. Understands forward and rollback. Adds columns and tables. Tests migrations locally.

Creates basic migrations for Rust projects through refinery or sqlx migrate, understanding schema versioning principles. Writes idempotent UP/DOWN migrations, adds tables and columns with proper data types and constraints.

Understands database migration fundamentals in Scala: Flyway/Liquibase integration with sbt, versioned SQL migrations, and basic schema changes with type-safe libraries like Slick or Doobie. Follows team patterns for migration scripts and rollback procedures.

Performs data warehouse schema migrations: CREATE/ALTER TABLE through SQL scripts. Understands DDL idempotency. Tests migrations on dev environment before production.

Performs simple migrations: ALTER TABLE for adding columns, Flyway/Liquibase for schema versioning. Follows team runbooks when applying migrations. Understands the importance of backward compatibility.

Creates basic migrations for fullstack applications: adding tables and columns through Prisma Migrate or Knex. Understands migration execution order, writes reversible migrations and coordinates schema changes with API and frontend updates.

Independently designs schemas and optimizes queries with database migrations. Understands indexing and query execution plans. Uses Ecto effectively.

Independently designs schemas and optimizes queries with database migrations. Understands indexing and query execution plans. Uses sqlx/GORM effectively.

Independently designs schemas and optimizes queries with database migrations. Understands indexing and query execution plans. Uses Hibernate/JPA effectively.

Independently designs schemas and optimizes queries with database migrations. Understands indexing and query execution plans. Uses Prisma/TypeORM effectively.

Writes safe migrations for PHP projects: adding columns with defaults, indexes without locking, separating destructive changes into phases. Manages seed data. Ensures rollback capability for each migration. Tests migrations on production data copies.

Writes zero-downtime migrations. Uses expand-contract pattern. Migrates data with backfill. Configures automatic migration execution in CI/CD. Handles migration conflicts.

Independently designs schemas and optimizes queries with database migrations. Understands indexing and query execution plans. Uses diesel/sea-orm effectively.

Independently designs schemas and optimizes queries with Database Migrations. Understands indexing and query execution plans. Uses Slick/Doobie effectively.

Designs schema evolution for data pipelines: backward-compatible migrations, expand-contract for zero-downtime, versioning through Flyway/Alembic. Handles schema drift in sources.

Independently manages database migrations across environments: designs zero-downtime schema changes using online DDL tools (pt-online-schema-change, gh-ost), implements blue-green migration strategies, and validates data integrity with checksums. Automates migration pipelines with CI/CD integration.

Independently designs schemas and optimizes queries with database migrations. Understands indexing and query execution plans. Uses Prisma/SQLAlchemy effectively.

Implements complex Ecto migrations for PostgreSQL: safe column addition with defaults, data migrations through execute/1, concurrent index creation. Applies Ecto.Migration.flush/0 for multi-stage migrations and ensures schema backward compatibility.

Develops safe migrations for production Go services: zero-downtime ALTER via adding new columns, backfill scripts, migrations with locking via pg_advisory_lock. Configures automatic migration execution in CI/CD pipeline.

Designs safe production migrations: online schema changes via pt-online-schema-change/gh-ost, zero-downtime column renames, backfill via batch updates. Automates migrations in CI/CD pipeline.

Designs safe migrations: zero-downtime via expand-contract, data backfill scripts, idempotent migrations. Automates via CI/CD with Prisma migrate deploy.

Designs zero-downtime migrations: expand-contract pattern, online schema changes for large tables. Migrates data without production locking. Automates migration compatibility checks with current code.

Designs migration strategy for the service. Performs complex schema changes (splitting tables, changing types). Automates rollback. Migrates between database engines.

Develops complex migrations for Rust services: zero-downtime ALTER through adding nullable columns, backfill scripts in Rust through SQLx, separating migrations into deploy-safe and post-deploy. Ensures backward compatibility between schema and application versions.

Designs database migration architecture for Scala applications: implements expand-contract pattern for zero-downtime migrations, designs type-safe migration frameworks with Flyway callbacks and Slick code generation, and automates migration testing in CI/CD pipelines. Mentors team on safe schema evolution.

Designs migration strategy: zero-downtime migrations for data warehouse, schema evolution in Parquet/Avro, backward compatibility in data contracts. Automates through CI/CD.

Designs zero-downtime migrations: online DDL, pt-online-schema-change/gh-ost for MySQL, logical replication for PostgreSQL. Plans rollback strategy for each migration. Automates migration testing in staging.

Implements complex migrations for fullstack applications: zero-downtime schema changes, data migrations with transformation, expand-contract scenarios. Coordinates migration deployment with backend and frontend updates, ensuring API backward compatibility.

Designs migration strategy for the Elixir platform with zero-downtime deployments. Implements two-phase migrations (expand/contract), configures CI safety checks through Excellent Migrations. Defines schema versioning policy and rollback procedures for all services.

Designs migration strategy for Go microservices: naming standards, migration review process, rollback policies. Implements automated migration testing on production data copies and ALTER operation duration monitoring.

Defines team migration standards: Flyway vs Liquibase, schema change review process, rollback strategies. Implements automatic migration testing on production data copies.

Defines migration standards: Prisma Migrate vs Knex vs raw SQL, review process, rollback strategies. Tests on staging with production data copy.

Defines migration process for the team: migration reviews, automated rollback testing, staged deployment. Plans complex migrations with phased breakdown.

Defines migration strategy for the organization. Standardizes zero-downtime approaches. Implements migration review process. Plans large-scale migrations.

Designs migration strategy for Rust microservice platform: unified tooling (refinery vs sqlx migrate vs diesel_migrations), migration testing in CI. Develops workflow for coordinating schema changes between teams with automated backward compatibility verification.

Defines product-level data strategy. Establishes Database Migration standards. Conducts data schema and scaling strategy reviews.

Defines migration standards: review process for schema changes, rollback strategies, compatibility matrix. Coordinates migrations between upstream producers and downstream consumers.

Defines migration standards: review process for DDL changes, automated backward compatibility check, approval workflow. Coordinates large migrations (sharding, engine changes) across teams with minimal impact.

Designs migration process for the fullstack platform: CI/CD automation, review of dangerous operations (DROP, ALTER TYPE), rollback strategy. Defines team standards: naming, migration testing, coordination with frontend releases.

Defines platform database schema management standards for the Elixir ecosystem. Develops automation for backward compatibility migration checks, designs migration strategy for sharded and multi-tenant systems with Ecto prefix and Triplex.

Defines organizational database migration policy: zero-downtime migration standards, schema versioning automation, blue-green deployment integration. Develops platform tools for safe migration execution with automatic rollback.

Designs platform migration strategy: coordinating schema changes between services, database-per-service migration, data versioning. Defines backward compatibility policy.

Designs platform migration strategy: coordination between services, backward compatibility policy, data versioning. Defines schema evolution governance.

Designs schema evolution strategy at platform level: cross-service schema changes, database versioning strategy, automated migration validation pipeline.

Shapes database evolution strategy. Designs cross-service migration orchestration. Defines tooling and automation.

Defines organizational database schema management policy: naming standards, mandatory review process for migrations, automated rollback strategies. Shapes multi-tenant migration architecture, schema-per-service isolation and disaster recovery procedures for migration failures.

Shapes database schema management strategy for the entire Scala platform: zero-downtime migration standards through Flyway, backward compatibility policies, emergency rollback processes. Defines schema evolution approaches in multi-service environments — shared database vs database-per-service for Scala microservices.

Designs schema management platform: schema registry, versioned data contracts, automated compatibility checking. Defines governance for schema evolution in data mesh.

Shapes organizational migration strategy: tooling standards (gh-ost vs pt-osc vs native), cross-database migration patterns, automated migration risk assessment. Defines governance for schema changes across the entire data platform.

Defines organizational database schema management strategy: automated migration safety checks, blue-green for schema changes, API versioning during model changes. Designs tooling for safe production migrations.