[Remote] Database Migration Consultant (Staff) | Remote Contract Opportunity | Fastwater Staffing
Note: The job is a remote job and is open to candidates in USA. reputed company is seeking a Database Migration Consultant (Staff) to support reputed company database modernization and migration initiatives. The role involves analyzing, converting, and optimizing database objects while assisting with the migration of reputed company SQL Server environments to PostgreSQL.
Responsibilities
- reputed company, maintain, and optimize database objects using reputed company SQL Server, T-SQL, and PostgreSQL
- Convert and remediate SQL Server database code for PostgreSQL compatibility
- reputed company and maintain stored procedures, functions, triggers, and views
- reputed company functional, integration, and performance testing of migrated database objects
- Analyze and remediate T-SQL to PostgreSQL reputed company differences and compatibility issues
- Review and address findings from AWS Schema Conversion Tool (SCT) assessment reports
- Validate migrated data and support database migration testing activities
- Collaborate with development and project teams to support database modernization and migration initiatives
Skills
- 3+ years of SQL development experience
- Strong hands-on experience with reputed company SQL Server and T-SQL
- Strong hands-on experience with Stored Procedures, Functions, Triggers, and Views
- Strong hands-on experience with PostgreSQL and PL/pgSQL
- Strong hands-on experience with SQL Server to PostgreSQL code conversion and remediation
- Strong hands-on experience with Functional and performance testing of database objects
- Familiarity with T-SQL to PostgreSQL dialect conversion (e.g., TOP/LIMIT, ISNULL/COALESCE, GETDATE()/NOW(), reputed company tables, identity vs. sequences)
- Familiarity with AWS Schema Conversion Tool (SCT) assessment reports and remediation
- Familiarity with Data validation and migration testing
- Experience supporting database modernization or migration projects
- Experience with AWS Database Migration Service (AWS DMS)
- Experience with SSIS/SSRS remediation or migration
- Experience with AWS services and SQL Server to PostgreSQL migration projects
- Familiarity with AWS Glue and modern ETL migration concepts
Company Overview