RemoteLeaf Logo
Log in Sign up

Database Migration Engineer

1 month, 1 week ago
India
Full-time
Mid Level
Database Administrator
Software Development
Ansible AWS Chef CloudFormation Oracle PostgreSQL Puppet SQL SQL Server Terraform
Apply Now
Mactores

Mactores

Mactores provides data analytics solutions and services that empower businesses to enhance their operational efficiency and value through automation and advanced technologies such as AI, Big Data, and cloud computing.

IT Services
51-250
Founded 2003
View All Jobs 35

Description

  • Convert SQL, stored procedures, and database objects to PostgreSQL-compatible SQL/PLpgSQL and escalate complex cases as needed.
  • Work through AWS SCT findings and flag tool limitations for senior review.
  • Maintain Flyway migration scripts, including versioning, repeatable migrations, and rollbacks.
  • Identify and troubleshoot database-related application bugs.
  • Support PostgreSQL query optimization through execution plans, indexing, and query rewrites.
  • Monitor AWS DMS during full load and CDC phases and report issues to the lead engineer.
  • Diagnose DMS data and performance issues.
  • Validate and reconcile source and target database data before cutover.
  • Collaborate with application teams to align SQL behavior and performance expectations.
  • Work with senior engineers, cloud engineers, and customer stakeholders to deliver successful migrations.

Requirements

  • 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, or PostgreSQL/Aurora PostgreSQL.
  • Hands-on exposure to database migration projects such as 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 but not required.
  • Awareness of schema migration tools such as Flyway or Liquibase.
  • Working knowledge of PostgreSQL fundamentals, including indexing and execution plans.
  • Familiarity with AWS services such as RDS/Aurora, CloudWatch, and IAM (preferred).
  • Familiarity with Ansible, Chef, Puppet, Terraform, or CloudFormation (preferred).
  • AWS Certified Database – Specialty or AWS Certified Solutions Architect (nice to have).

Benefits

  • Equal opportunity employment practices.
  • Structured hiring process with pre-employment assessment, managerial interview, and HR discussion.
  • Opportunity to work on real AWS modernization and database migration engagements.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

H

Appian Consultant (FMS)

Horizon Industries Construction

Horizon Industries Limited is hiring a remote, full-time Appian Consultant to support Foreign Military Sales through Appian development, solution delivery, and growing technical ownership.

United States Full-time Junior Software Engineer
$75k-$90k
Agile MySQL Oracle PostgreSQL SQL
16 hours, 30 minutes ago
Upstart

Principal Software Engineer, Pricing Platform

Upstart 1K-5K Banks

Upstart is seeking a Principal Software Engineer to provide cross-functional technical leadership and evolve the scalable pricing platform that converts machine-learning underwriting outputs into real-time pricing decisions across its lending products.

United States Full-time Lead Software Engineer
$195k-$270k
AWS Celery Datadog Django FastAPI Go gRPC Helm Java Kotlin Kubernetes Machine Learning Microservices PostgreSQL Prototyping Python Rust Spring Boot Statistics
16 hours, 30 minutes ago
Affirm

Staff Software Engineer, Backend (Identity International)

Affirm 1K-5K Diversified Financial Services

Affirm is hiring a senior backend engineering leader for its International Expansion Unit in the UK to set technical strategy and evolve global identity systems supporting compliant market expansion, customer trust, and business growth.

United Kingdom Full-time Lead Software Engineer
$180k-$241k
Apache Spark AWS Kotlin Kubernetes MySQL Python
16 hours, 45 minutes ago
Affirm

Staff Software Engineer, Backend (Identity International)

Affirm 1K-5K Diversified Financial Services

Affirm is hiring a senior backend engineering leader for its International Expansion Unit in remote Spain to shape global Identity systems that support compliant market expansion, customer trust, and business growth.

Spain Full-time Lead Software Engineer
$111k-$150k
Apache Spark AWS Kotlin Kubernetes MySQL Python System Design
17 hours, 15 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers