Database Migration Engineer (Developer)

Mactores is looking for a highly skilled and experienced Database Developer to lead and execute the migration project from MS SQL Server to PostgreSQL. The ideal candidate will lead hands-on execution of migrating database objects such as tables, stored procedures, functions, and views from MS SQL Server to PostgreSQL. The candidate will also be responsible for migrating the SQL statements within the application code to facilitate the migration.  Responsibilities: 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. If you are a Database Migration Engineer with a passion for executing complex migration projects and have a solid background in MSSQL and Postgres, we encourage you to apply and be a key contributor to the success of this migration initiative at Mactores.