Database Migration Engineer

About This Opportunity

We are representing a confidential AWS modernization consulting firm seeking a Database Migration Engineer to join their Application & Database Modernization practice. This is a remote position open to candidates anywhere.

Our client specializes in production database migrations—Oracle-to-PostgreSQL/Aurora and SQL Server-to-PostgreSQL—with a focus on shipping systems that perform, reconcile, and hold up after go-live. They use automation tooling to handle repeatable conversion and validation work, while engineers focus on conversion judgment, reconciliation, and the procedural-code gaps that require human expertise.

In this role, you'll work through SQL conversion, testing, and data validation tasks, collaborating with senior engineers on complex schema conversion findings and performance edge cases. You'll support migration work across engagements, working with application teams, cloud engineers, and customer stakeholders under the guidance of a lead engineer.

Responsibilities

• Convert SQL, stored procedures, and database objects to PostgreSQL-compatible SQL/PLpgSQL, escalating complex or ambiguous cases to senior team members
• Work through AWS Schema Conversion Tool findings, flagging limitations that need senior review
• Maintain Flyway migration codebase: versioned scripts, repeatable migrations, rollbacks
• Identify and troubleshoot database-related application bugs with support on more challenging cases
• Support query optimization for PostgreSQL: execution plans, indexing, query rewrites
• Monitor AWS Database Migration Service during full load and change data capture phases, flagging issues to the lead engineer
• Assist in diagnosing data and performance issues during migrations
• Validate and reconcile data between source and target databases with proof-based verification
• Work with application teams to align SQL behavior and performance expectations before cutover

What We're Looking For

Required qualifications:

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

Preferred qualifications:

• Familiarity with AWS services: RDS/Aurora, CloudWatch, IAM
• Familiarity with automation and configuration tools such as Ansible, Chef, or Puppet
• Familiarity with infrastructure-as-code tools such as Terraform or CloudFormation
• AWS Certified Database – Specialty or AWS Certified Solutions Architect

How We Work with You

Candidates apply directly through Get A Job.ai. Our recruiting team will conduct an initial screening to assess your technical background and fit for the role. Qualified candidates are then submitted to our client for consideration.

Please do not contact the client directly. All communication and coordination will be managed through our talent team to ensure a smooth process for everyone involved.

The client's interview process typically includes a pre-employment technical assessment, multiple managerial interviews covering technical skills and experience, and a final HR discussion to review offer details and next steps.

Pay

Compensation details will be discussed during the screening process with our recruiting team.

Equal Employment Opportunity: Get A Job.ai provides equal employment opportunities to all qualified candidates without regard to race, color, religion, sex, national origin, age, disability, or any other characteristic protected by law.