Database Design

Plan a safe data migration: schema mapping, ETL strategy, dual-write or one-shot, validation, and cutover with rollback.

Migrate a database between engines (SQL Server → Azure SQL or Postgres) with zero or minimal downtime, parity validation, and instant rollback.

Map DB2 for i schemas (with multi-member files, logical files, journaling, DDS extensions) to a modern relational database — Postgres, SQL Server, or Azure SQL.

Design a denormalized MongoDB schema with proper indexes, embedded vs referenced choices, and validation rules.

Pre-configured Postgres MCP server for Claude Code — schema inspection and read-only queries to make database work safer and faster.

Design a normalized PostgreSQL schema with indexes, constraints, and migration files.

Implement SCD Type 1, 2, 3, and 6 patterns in PySpark with Delta Lake MERGE — for dimensional modeling in modern data platforms.

Translate SQL Server schemas to modernized SQL Server (Azure SQL) or Postgres, handling type differences, constraints, and stored procedure migration.

Map mainframe data structures (VSAM, IMS, IDMS, flat files) to a normalized relational schema, preserving keys, relationships, and access patterns.