Senior Database Developer (Oracle & PostgreSQL)

Mactores • Bachelor's Degree • SQL • Java • 7 months ago
Apply now
Save
368,634open jobs
9,437companies
50,578added this week
Browse all
Salary
≈ $27k – $66k per year (Estimated)
Location
Remote (India)
Seniority
Senior · 5+ years exp
Employment
Full-Time
Overview
Company
Impact
Profile match

Mactores

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.
mactores.com • HQ: Seattle, United States • AI Agents

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.
368,634 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
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

Similar stack
Same company
Mumbai
Cloud Engineer (AWS) 6 hours ago
In office • Full-Time • 5+ years exp • Bachelor's Degree • Dalian
Python
DevOps
AWS
CI/CD
CloudFormation
Docker
FinOps
GitHub Actions
Kubernetes
Terraform
GitHub
Apply
$68k – $85k per year • In office • Full-Time • Master's Degree • San Jose
Python
AI/ML
AI Agents
DevOps
Amazon EC2
AWS
AWS Lambda
Bitbucket
CI/CD
CloudFormation
Docker
Git
Kubernetes
Terraform
Amazon S3
IAM
HPC
Cybersecurity
Least Privilege
Apply
$185k – $260k per year • Remote • Full-Time • 8+ years exp • Bachelor's Degree
DevOps
AWS
CI/CD
GCP
Kubernetes
GitHub
Cybersecurity
Clair
Dependabot
OWASP Top 10
OWASP ZAP
Snyk
Trivy
Apply
≈ $19k – $47k per year (Estimated) • Remote • Full-Time • Perm
C#
C#
ASP.NET Core
Dapper
Entity Framework Core
Databases
Apache Kafka
ClickHouse
ElasticSearch
PostgreSQL
RabbitMQ
Redis
DevOps
CI/CD
Docker
Docker Compose
GitHub Actions
Kubernetes
TeamCity
GitHub
GitLab
Apply
≈ $17k – $43k per year (Estimated) • In office • Full-Time • Tomsk
C#
Java
Python
DevOps
CI/CD
Docker
Git
Grafana
Graylog
Kubernetes
Prometheus
Splunk
Apply
Remote • Internship • India
Databases
Snowflake
DevOps
Ansible
AWS
Azure
Chef
Configuration Management
GCP
Puppet
Apply
≈ $31k – $75k per year (Estimated) • Remote • Full-Time • 2+ years exp • Mumbai
Databases
Databricks
Snowflake
AI/ML
Anthropic
OpenAI
DevOps
AWS
Management
Draw.io
Apply
≈ $19k – $52k per year (Estimated) • Remote • Full-Time • 3+ years exp • Bachelor's Degree • Mumbai
SQL
Java
Java
Flyway
Liquibase
Databases
Amazon Aurora
MS SQL
Oracle
PostgreSQL
DevOps
Ansible
AWS
CloudFormation
Terraform
Amazon CloudWatch
IAM
Apply
≈ $16k – $45k per year (Estimated) • Remote • Full-Time • 4+ years exp • Mumbai
AI/ML
ElevenLabs
Kling
Runway
DevOps
AWS
Design
Adobe After Effects
Figma
Apply
≈ $26k – $69k per year (Estimated) • Remote • Full-Time • 8+ years exp • Mumbai
SQL
Databases
Amazon Aurora
MS SQL
Oracle
PostgreSQL
DevOps
AWS
Apply
≈ $16k – $34k per year (Estimated) • Remote/Hybrid • Full-Time • 2+ years exp • Bachelor's Degree • Mumbai • Bengaluru
JavaScript
PowerShell
SQL
C#
C#
.NET
Databases
Azure SQL Database
MS SQL
DevOps
Azure
Rest API
Cybersecurity
Microsoft Entra ID
QA
Postman
Swagger
Apply
≈ $20k – $50k per year (Estimated) • Remote • Full-Time • 5+ years exp • Mumbai
QA
BrowserStack
Apply
≈ $16k – $36k per year (Estimated) • In office • Full-Time • 2+ years exp • Bachelor's Degree • Mumbai
Apply
≈ $47k – $102k per year (Estimated) • In office • Full-Time • 12+ years exp • Mumbai
Apply
≈ $35k – $79k per year (Estimated) • In office • Full-Time • 12+ years exp • Mumbai
Management
ServiceNow
Apply
See all jobs
This is one of many
368,634 more open roles from verified company boards, updated every day.
Browse all jobs Get matched roles