Principal Data Architect: SQL Server to PostgreSQL Migration

Methodhub; Houston (TX); On-site; USD 180,000 - 240,000; Full time

Job summary

MethodHub seeks a Principal Data Engineer/Architect to lead SQL Server to PostgreSQL or Amazon Aurora PostgreSQL migrations in complex enterprise environments. Location is Houston, with in-person interviews and a 12+ month contract.

You will define enterprise data architectures, model data conceptually and physically, oversee migration planning, data movement, CDC, cutover, and validation, and drive standards for automation, security, and performance.

Qualifications

• Extensive experience in enterprise data architecture and large-scale modernization.
• Proven experience leading SQL Server to PostgreSQL or Amazon Aurora PostgreSQL migrations in complex environments.
• Advanced data modeling skills with conceptual, logical, and physical models.
• Deep knowledge of SQL Server and PostgreSQL internals, indexing, and performance tuning.
• Experience with migration assessment, schema conversion, CDC, cutover, and validation.

Responsibilities

• Define and maintain enterprise data and database strategy including architecture and cost optimization.
• Own data models aligned to business capabilities and target-state architecture.
• Lead SQL Server discovery, assessment, and migration planning across schemas, procedures, and data quality.
• Own data movement, CDC, reconciliation, cutover, rollback, and post-migration validation.
• Define database engineering standards for IaC, schema-as-code, and release management.
• Partner with application/platform teams to improve maintainability and performance.
• Lead, mentor, and coordinate cross-functional delivery and document key decisions.

Skills

SQL Server

PostgreSQL

Data modeling

Migration planning

ER/Studio

AWS DMS

Aurora PostgreSQL

Leadership

Architecture

Tools

ER/Studio

Job description

MethodHub seeks a Principal Data Engineer/Architect to lead SQL Server to PostgreSQL or Amazon Aurora PostgreSQL migrations in complex enterprise environments. Location is Houston, with in-person interviews and a 12+ month contract.

You will define enterprise data architectures, model data conceptually and physically, oversee migration planning, data movement, CDC, cutover, and validation, and drive standards for automation, security, and performance.