Database Migration Engineer

Job not on LinkedIn

🔥 0 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Mactores

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2008

🏢 Enterprise

Enterprise • Data

Mactores is a company that provides end-to-end data platform solutions aimed at accelerating business value through automation. Since 2008, Mactores has been helping businesses with digital transformation, offering services like Enterprise Data Lakes, Scalable Databases, Modern Data Warehouses, Automated DataOps, MLOps, and Generative AI solutions. They focus on enabling faster and cost-effective migrations and modernizations in data analytics, partnering with leading platforms to drive innovation and success. Mactores works alongside tech teams to strategize and implement the right data solutions timely and efficiently.

📋 Description

• Convert SQL, stored procedures, and database objects to PostgreSQL-compatible SQL/PLpgSQL, escalating complex or ambiguous cases to a senior engineer. • Work through AWS SCT (Schema Conversion Tool) findings, flagging limitations that need senior review. • Maintain the Flyway migration codebase: versioned scripts, repeatable migrations, rollbacks. • Identify and troubleshoot database-related application bugs, with support on the harder cases. • Support query optimization for PostgreSQL: execution plans, indexing, query rewrites. • Monitor AWS DMS during full load and CDC phases and flag issues to the lead engineer. • Assist in diagnosing DMS data and performance issues. • Validate and reconcile data between source and target databases, proof, not confidence. • Work with application teams to align SQL behavior and performance expectations before cutover.

🎯 Requirements

• A Bachelor's degree in Computer Science or a related field. • 3–5 years of experience as a database developer/engineer, with exposure to migration work. • Working experience with at least one of: Oracle, Microsoft SQL Server, and PostgreSQL / Aurora PostgreSQL. • Some hands-on exposure to database migration projects (Oracle-to-PostgreSQL or SQL Server-to-PostgreSQL). • Solid SQL skills and a working understanding of query performance tuning. • Familiarity with AWS SCT and AWS DMS (hands-on exposure preferred, not required). • Awareness of schema migration tools such as Flyway or Liquibase. • Working knowledge of PostgreSQL fundamentals: indexing, execution plans.

🏖️ Benefits

• Mactores provides equal opportunities in all employment practices. • You have the opportunity to discuss the offer and next steps with a member of the HR team during HR discussion.