DATABASE MIGRATION CONSULTANT (STAFF) FOR FASTWATER STAFFING
recruiting
Contractmid
Job description
Must-Have Screening Requirements:
• U.S. Citizen or Green Card (Permanent Resident) holder ONLY.
• No visa holders or temporary-status individuals.
• Must be willing to undergo fingerprinting and a government background check (CJIS-type).
• LinkedIn profile required; all resumes will be verified against LinkedIn.
Requirements:
• 3+ years of SQL development experience.
• Strong hands-on experience with:
• Microsoft SQL Server and T-SQL
• Stored Procedures, Functions, Triggers, and Views
• PostgreSQL and PL/pgSQL
• SQL Server to PostgreSQL code conversion and remediation
• Functional and performance testing of database objects
• Familiarity with:
• T-SQL to PostgreSQL dialect conversion (TOP/LIMIT, ISNULL/COALESCE, GETDATE()/NOW(), temp tables, identity vs. sequences)
• AWS Schema Conversion Tool (SCT) assessment reports and remediation
• Data validation and migration testing
• Experience supporting database modernization or migration projects.
Preferred:
• AWS DMS experience.
• SSIS/SSRS remediation or migration experience.
• AWS exposure and SQL Server to PostgreSQL migration experience.
• Familiarity with AWS Glue and ETL modernization concepts.