About The Position
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.
Requirements
- 3+ years of SQL development experience
- Strong hands-on experience with: T-SQL, Stored Procedures, Functions, Triggers, Views
- 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
- Experience performing: Functional testing, Data validation, Performance validation, Database migration verification
- Strong troubleshooting and debugging skills
- 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)
Nice To Haves
- 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
Responsibilities
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Mid Level
Education Level
No Education Listed
