RemoteLeaf Logo
Log in Sign up

Database Migration Engineer

3 weeks, 2 days 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 33

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

Pinterest

Senior Software Engineer

Pinterest 1K-5K Internet Software & Services

Pinterest is hiring a backend engineer to build and evolve large-scale, distributed systems that support user-facing applications and improve the end-to-end product experience.

United States Full-time Senior Software Engineer
$252k-$320k
Apache Airflow Apache Spark AWS C++ CI/CD Docker Elasticsearch Flink Grafana Java Kafka Kubernetes Memcached MySQL Node.js PostgreSQL Python Redis
15 hours, 52 minutes ago
G

Senior Software Development Engineer

GoDaddy 5001-10000 Technology, Information and Internet

GoDaddy is hiring a remote Growth team engineer in Colombia to build and operate production AI agent systems and full-stack applications that support customers at scale.

Colombia Full-time Senior Software Engineer
AWS Azure CI/CD Docker Elasticsearch Go Kubernetes LLM Microservices MongoDB Node.js PostgreSQL Python React Redis SQL Vue.js
16 hours, 7 minutes ago
Scale AI

SWE Fellow - Human Frontier Collective (UK)

Scale AI 251-1K Diversified Consumer Services

The Human Frontier Collective Fellowship at Scale is a fully remote contract role supporting AI research by designing, evaluating, and interpreting advanced generative AI systems with interdisciplinary experts and partner labs.

United Kingdom Contract Senior AI (Artificial Intelligence) Software Engineer
C++ Generative AI Java JavaScript Machine Learning Python Rust Swift
16 hours, 7 minutes ago
Avo

Integrations Engineer

Avo 11-50 Internet Software & Services

Avo is hiring an Integrations Engineer to build and maintain hospital EHR integrations that power clinical AI workflows inside production healthcare environments.

United States Full-time Mid Level Software Engineer
$160k-$185k
AWS Azure Celery Django Docker GitHub Actions HIPAA JavaScript LLM PostgreSQL Python React Redis REST API Tailwind CSS Terraform TypeScript
16 hours, 22 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