RemoteLeaf Logo
Log in Sign up

Senior Database Developer (Oracle & PostgreSQL)

1 month ago
India
Full-time
Senior
Database Administrator
Software Development
Ansible AWS Chef PostgreSQL Puppet SQL 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 20

Description

  • Refactor and convert Oracle SQL, PL/SQL, and database objects into PostgreSQL-compatible SQL and PL/pgSQL.
  • Analyze and remediate AWS Schema Conversion Tool findings and limitations.
  • Manage Flyway migration scripts, including versioned scripts, repeatable migrations, and rollbacks.
  • Identify, troubleshoot, and resolve database-related application bugs.
  • Optimize PostgreSQL query performance through execution plan analysis, indexing, and query rewrites.
  • Support AWS DMS during full load and CDC phases.
  • Diagnose and resolve DMS data and performance issues.
  • Validate and reconcile data between Oracle and PostgreSQL.
  • Collaborate with application teams to align SQL behavior and performance expectations.

Requirements

  • 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 experience with 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.
  • Understanding of PostgreSQL internals, including indexing, statistics, and execution plans.
  • Experience with AWS services such as RDS/Aurora, CloudWatch, and IAM is preferred.
  • Familiarity with automation and configuration management tools such as Ansible, Chef, or Puppet is preferred.
  • Familiarity with IaC tools such as Terraform or CloudFormation is preferred.
  • Familiarity with CI/CD implementation tools like Liquibase/Flyway is preferred.
  • AWS Certified Database – Specialty is preferred.
  • AWS Certified Solutions Architect is preferred.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Sezzle

Senior Database Reliability Engineer

Sezzle 251-1K Diversified Financial Services

Sezzle is hiring a Senior Database Reliability Engineer to design, build, and scale the shared database platform and reliability controls that support its applications across production and development environments.

Brazil Full-time Senior Database Administrator Site Reliability Engineer (SRE)
$60k-$114k
AWS CI/CD Datadog Elasticsearch Encryption Git Go Grafana Helm Kubernetes Microservices MySQL New Relic OpenTelemetry PostgreSQL Prometheus Python React React Native REST API Secrets Management Terraform TypeScript
2 hours, 28 minutes ago
Metova

Oracle DBA / Data Processing Specialist

Metova 51-250 Internet Software & Services

Oracle DBA / Data Processing Specialist at a marketing data company, responsible for keeping Oracle production environments stable while processing and delivering accurate client data.

Mexico Argentina Costa Rica Ecuador Peru Contract Mid Level Database Administrator
Oracle PostgreSQL Shell Scripting SQL SQL Server
9 hours ago
CDC Foundation

EpiTrax Outbreak and Exposure Enhancements Developer

CDC Foundation 1K-5K Health Care Providers & Services

The CDC Foundation is hiring a remote EpiTrax Outbreak and Exposure Enhancements Developer to improve Utah’s disease surveillance system and support public health response during outbreak events.

United States Full-time Mid Level Database Administrator Software Engineer
$110k-$110k
Agile Git PostgreSQL XML
10 hours, 22 minutes ago
66degrees

Sr. Oracle Database Administrator

66degrees 251-1K IT Services

66degrees is hiring a Senior Oracle DBA to support managed services clients by stabilizing legacy Oracle environments while leading the design, migration, and modernization of future-state database infrastructure.

United States Senior Database Administrator
Ansible AWS Azure EC2 Linux Shell Scripting SQL Terraform Unix
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