Database Migration Consultant (Staff)
New
H
HIKINEXDatabase Modernization
Maryland, U.S.ContractStaff
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 3+ years
- Required Skills
- PostgreSQLSQLMicrosoft SQL Server
Requirements
- 3+ years of SQL development experience.
- Strong hands-on experience with Microsoft SQL Server and T-SQL.
- Experience with Stored Procedures, Functions, Triggers, and Views.
- Strong experience with PostgreSQL and PL/pgSQL.
- Proven experience with SQL Server to PostgreSQL code conversion and remediation.
- Functional and performance testing of database objects.
- Familiarity with T-SQL to PostgreSQL dialect conversion (e.g., TOP/LIMIT, ISNULL/COALESCE, GETDATE()/NOW(), temp tables, identity vs. sequences).
- Experience with AWS Schema Conversion Tool (SCT) assessment reports and remediation.
- Experience with data validation and migration testing.
- Experience supporting database modernization or migration projects.
Responsibilities
- Develop, maintain, and optimize database objects using Microsoft SQL Server, T-SQL, and PostgreSQL.
- Convert and remediate SQL Server database code for PostgreSQL compatibility.
- Develop and maintain stored procedures, functions, triggers, and views.
- Perform functional, integration, and performance testing of migrated database objects.
- Analyze and remediate T-SQL to PostgreSQL syntax 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.
View Full Description & ApplyYou'll be redirected to the employer's site
