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
Database Migration Engineer (Developer) (MSSQL to Postgres Migration)
February 3
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
• Be one step ahead • Deliver the best • Be bold • Pay attention to the detail • Enjoy the challenge • Be curious and take action • Take leadership • Own it • Deliver value • Be collaborative
Apply Now