Database Migration Consultant Remote FastWater Staffing

Location

Fully Remote (Maryland, U.S.)

Contract

Immediate

TBD – based on skills and experience

• Due to client and clearance requirements, candidates must be U.S. Citizens or U.S. Permanent Residents (Green Card holders) and able to work in the United States without current or future visa sponsorship.
• Undergo fingerprinting as part of the onboarding process.
• Successfully complete a government background investigation (CJIS-type clearance).

We are seeking a Database Migration Consultant – Staff to support a large-scale SQL Server to PostgreSQL modernization initiative. This role will serve as a core contributor within the database migration workstream, focusing on database object conversion, remediation of migration findings, and validation of converted workloads.

The successful candidate will be responsible for converting database code objects, addressing compatibility issues identified during migration assessments, and supporting testing activities to ensure data integrity, functionality, and performance within the PostgreSQL environment.

• Convert SQL Server database objects to PostgreSQL-compatible implementations, including:
  • Stored Procedures
  • Functions
  • Triggers
  • Views
• Analyze and remediate migration findings identified through assessment and conversion tools.
• Address SSIS (.dtsx) and SSRS (.rdl) compatibility and conversion issues.
• Interpret AWS Schema Conversion Tool (SCT) output and implement required manual remediation.
• Execute functional validation and testing of converted database objects.
• Support performance testing and tuning efforts.
• Validate data synchronization and migration accuracy.
• Collaborate with database architects, migration leads, and application modernization teams.
• Document conversion decisions, remediation approaches, and testing outcomes.
• Contribute to migration runbooks and technical documentation.

• Core Database Migration Experience
  • 3 years of SQL development experience.
  • Strong hands‑on experience with:
    • T‑SQL
    • Stored Procedures
    • Functions
    • Triggers
    • Views
• PostgreSQL & Migration Expertise
  • Experience developing and supporting PostgreSQL databases.
  • Working knowledge of PL/pgSQL.
  • Familiarity with common SQL Server to PostgreSQL conversion patterns, including:
    • TOP vs. LIMIT
    • ISNULL vs. COALESCE
    • GETDATE() vs. now()
    • Temporary table differences
    • Sequences vs. Identity columns
  • Ability to review, interpret, and remediate AWS SCT‑generated action items.
• Testing & Validation
  • Experience performing:
    • Functional testing
    • Data validation
    • Performance validation
    • Database migration verification
  • Strong troubleshooting and debugging skills.

• AWS Database Migration Service (DMS) execution and validation.
• SSIS package development and migration concepts.
• SSRS report development and migration concepts.
• ETL migration and modernization initiatives.
• Exposure to AWS Glue or similar cloud‑based ETL platforms.
• Data‑type mapping between SQL Server and PostgreSQL.
• Basic PostgreSQL performance tuning and query optimization.

• Prior experience migrating SQL Server environments to PostgreSQL.
• Experience supporting enterprise database modernization initiatives.
• AWS cloud experience, particularly database migration services.
• Familiarity with large‑scale database assessment and conversion projects.
• Experience working within cloud transformation or modernization programs.

The ideal candidate is a hands‑on database professional with experience converting SQL Server workloads to PostgreSQL and resolving migration‑related compatibility challenges. They are comfortable working through database object remediation, testing converted solutions, and ensuring functional and performance parity throughout the migration lifecycle.