Database Migration Consultant (Staff) for Fastwater Staffing
Please mention DailyRemote when applying
AI Summary
The consultant will lead the conversion and remediation of database code from SQL Server to PostgreSQL. This includes performing functional and performance testing of database objects and supporting overall database modernization projects.
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.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
