Database Migration Engineer (Developer) (MSSQL to Postgres Migration)

February 3

Apply Now
Logo of Mactores

Mactores

Mactores is a trusted leader among businesses in providing modern data platform solutions.

Big Data • Machine Learning • Consulting • Research • Internet of Things

51 - 200

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
Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or lior@remoterocketship.com