Database Migration Engineer - MSSQL to Postgres Migration
February 3
Description
• Migrate essential database components, including but not limited to tables, stored procedures, functions, and views from MS SQL Server to PostgreSQL. • Validate and ensure the migrated objects function as intended in the PostgreSQL environment. • Evaluate existing application codebase to identify SQL statements that interact with the MS SQL Server. • Modify and adapt SQL statements within the application code to align with PostgreSQL syntax and functionalities. • Collaborate with application developers to ensure a smooth transition and troubleshoot any code-related issues post-migration. • Analyze and optimize database performance during and post-migration to ensure efficient query execution and system responsiveness. • Maintain comprehensive documentation throughout the migration process, detailing methodologies, challenges, solutions, and outcomes.
Requirements
• Minimum of 3 years of professional experience as a Database Developer or Migration Specialist. • Proven expertise in MS SQL Server and PostgreSQL database platforms. • Strong understanding of database architecture, design principles, and data migration methodologies. • Proficient in SQL scripting, optimization techniques, and performance tuning. • Excellent analytical, problem-solving, and troubleshooting skills. • Ability to work independently, manage multiple tasks, and adapt to changing priorities. • Exceptional communication skills with the ability to convey complex technical information to diverse audiences.
Benefits
• Trusted leader among businesses • Modern data platform solutions • End-to-End Data Solutions • Automation, agility, and security • Strategize, navigate, and accelerate digital transformation • Collaborative and inclusive culture
Apply Now