Easy applyno account needed

Senior Database Migration Engineer (Oracle & PostgreSQL)

Mactores • Cloud Consulting & Migration • Data Engineering & Migration Services • Bachelor's Degree • Java • SQL • 9 months ago
Smart Apply
Similar jobs
1,783,176open jobs
103,722companies
265,518added this week
Browse all
Salary
≈ $21k – $42k per year (Estimated)
Location
Remote (India)
Seniority
Senior · 5+ years exp
Employment
Full-Time

Confirmed on the employer's own hiring board on Oct 16, 2026. First seen by Alion on Jan 19, 2026. Mactores scores D on the Alion truth index.

Overview
Company
Impact
Profile match

Mactores

Mactores is a data and cloud consulting firm that helps businesses build and modernise data platforms, with services covering data strategy assessments, data lake and warehouse migration, analytics, machine learning and process automation, largely on Amazon Web Services. Founded in 2008, it serves enterprise clients in the United States and runs a large delivery team in Mumbai, India. The company is headquartered in Seattle, Washington, United States.
mactores.com • HQ: Seattle, United States • Cloud Consulting & Migration • Data Engineering & Migration Services • 201-500 employees • Est. 2008
Tech stack of Mactores

We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post-go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.

What you will do?

  • Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
  • Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
  • Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
  • Identify, troubleshoot, and fix database-related application bugs.
  • Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
  • Support and monitor AWS DMS during full load and CDC phases.
  • Diagnose and resolve DMS data and performance issues.
  • Perform data validation and reconciliation between Oracle and PostgreSQL.
  • Collaborate with application teams to align SQL behavior and performance expectations.

What are we looking for?

  • Bachelor's degree in Computer Science or a related field.
  • 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
  • Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL.
  • Hands-on expertise in Oracle to PostgreSQL migration.
  • Advanced SQL and query performance tuning skills.
  • Experience with AWS SCT and AWS DMS.
  • Knowledge of Flyway/Liquibase or similar schema migration tools.
  • PostgreSQL internals: indexing, statistics, execution plans.
  • AWS services: RDS/Aurora, CloudWatch, IAM (preferred).

You will be preferred if:

  • Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet.
  • Familiarity with IAAC tools such as Terraform, CloudFormation.
  • Familiarity with CI/CD implementation tools like Liquibase/Flyway.
  • AWS Certified Database - Specialty.
  • AWS Certified Solutions Architect.
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
1,783,176 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Backend
Similar stack
Same company
Mumbai
≈ $84k – $211k per year (Estimated) • Remote (United States) • Full-Time
JavaScript
Java
TypeScript
SQL
C#
Java
Spring Boot
Hibernate
JOOQ
C#
.NET
Databases
MySQL
PostgreSQL
RabbitMQ
ActiveMQ
AI/ML
Copilot
Cursor
Claude Code
Frontend
Angular
DevOps
Rest API
Terraform
GitHub Actions
CI/CD
GitOps
AWS
Amazon EC2
Amazon S3
Amazon ECS
Cybersecurity
PCI DSS
Apply
Remote (Brazil) • Contractor • Brazil
JavaScript
TypeScript
SQL
C#
C#
ASP.NET Core
Entity Framework Core
Databases
PostgreSQL
RabbitMQ
Apache Kafka
Frontend
RxJS
Angular
DevOps
Rest API
CI/CD
Git
Apply
≈ $139k – $241k per year (Estimated) • Remote (United States) • 5+ years exp • Bachelor's Degree • United States
Go
Databases
Apache Kafka
DevOps
AWS
Apply
≈ $21k – $42k per year (Estimated) • Remote (EAEU) • Full-Time • 3+ years exp • Moscow
Java
SQL
Java
Spring Framework
Maven
Databases
PostgreSQL
HBase
Cassandra
RabbitMQ
Apache Kafka
AI/ML
Flink
DevOps
Rest API
gRPC
GitLab CI
CI/CD
Git
Apply
≈ $146k – $278k per year (Estimated) • Remote (location not specified) • 8+ years exp • Bachelor's Degree
SQL
Databases
Snowflake
AI/ML
AI Agents
LLM Guardrails
DevOps
Datadog
Azure
CI/CD
Cybersecurity
SOC 2
HIPAA
Management
Agile
Apply
$11k – $21k per year • Remote (India, UTC-8 – UTC-5 hours) • Full-Time • 1+ year exp
Python
SQL
Python
Django
Databases
PostgreSQL
Frontend
GraphQL
DevOps
Rest API
CI/CD
AWS
Docker
Analytics
ETL/ELT
Apply
$20k – $40k per year • Remote (India) • Full-Time • 3+ years exp
Python
Python
Django
Celery
Databases
PostgreSQL
Frontend
GraphQL
DevOps
AWS
Docker
AWS Lambda
Amazon EC2
Amazon S3
Apply
$210k – $250k per year • In office • Full-Time • New York
Python
JavaScript
TypeScript
Databases
PostgreSQL
AI/ML
LangChain
AI Agents
Frontend
React.js
DevOps
AWS
Analytics
ETL/ELT
Apply
≈ $40k – $110k per year (Estimated) • In office • Full-Time • 3+ years exp • Singapore
Python
SQL
R
Analytics
Power BI
Management
Microsoft Office
Apply
$70k – $105k per year • Remote (United States) • 4+ years exp • Bachelor's Degree
SQL
Analytics
Metabase
Apply
≈ $21k – $42k per year (Estimated) • Remote (India) • Freelance • 5+ years exp • Mumbai
Java
Java
Flyway
Liquibase
Databases
PostgreSQL
Oracle
Amazon Aurora
DevOps
Terraform
Puppet
Ansible
Chef
CloudFormation
CI/CD
AWS
Configuration Management
Amazon CloudWatch
Cybersecurity
Least Privilege
Apply
≈ $21k – $43k per year (Estimated) • Remote (India) • Freelance • 3+ years exp • Bachelor's Degree • Mumbai
Python
SQL
Python
pySpark
Databases
Snowflake
Presto
Amazon Redshift
AI/ML
Spark
DevOps
AWS
Management
Agile
Apply
≈ $115k – $208k per year (Estimated) • Remote (United States) • Full-Time • 3+ years exp • Bachelor's Degree • Seattle
Python
SQL
Python
pySpark
Databases
Snowflake
Presto
Amazon Redshift
AI/ML
Spark
DevOps
AWS
Management
Agile
Apply
≈ $74k – $162k per year (Estimated) • Remote (United States) • Full-Time • 2+ years exp • Seattle
Python
SQL
Python
pySpark
Databases
Amazon Redshift
AI/ML
Spark
Airflow
DevOps
AWS
Analytics
ETL/ELT
Apply
Remote (India) • Internship • Mumbai
Python
SQL
Python
pySpark
Databases
Snowflake
AI/ML
Spark
Airflow
DevOps
Azure
AWS
Analytics
ETL/ELT
Apply
≈ $19k – $43k per year (Estimated) • Hybrid • Full-Time • 5+ years exp • Bachelor's Degree • Mumbai
TypeScript
SQL
C#
C#
.NET
AI/ML
Copilot
Prompt Engineering
Gemini
LLM
RAG
OpenAI
Mobile
Clean Architecture
DevOps
Rest API
gRPC
GCP
CI/CD
Kubernetes
Bitbucket
Google GKE
Google Cloud Run
Management
Agile
Scrum
QA
Jest
Apply
≈ $22k – $44k per year (Estimated) • Hybrid • Full-Time • 5+ years exp • Mumbai
Analytics
Looker
Master Data Management
Apply
≈ $12k – $28k per year (Estimated) • In office • Full-Time • Mumbai
Apply
≈ $18k – $43k per year (Estimated) • In office • Full-Time • 8+ years exp • Master's Degree • Mumbai
Apply
≈ $9k – $20k per year (Estimated) • In office • 3+ years exp • Mumbai
Apply
See all jobs
This is one of many
1,783,176 more open roles from verified company boards, updated every day.
Browse all jobs Get matched roles