RemoteLeaf Logo
Log in Sign up

Senior Database Developer (Oracle & PostgreSQL)

22 hours, 1 minute 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 3

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

dLocal

Senior Cloud Database Administrator (NoSQL & AWS)

dLocal 251-1K Diversified Financial Services

dLocal is hiring a Senior Cloud Database Administrator to own and evolve its NoSQL and AWS cloud data layer, supporting production database services that power payments across emerging markets.

Italy Spain Full-time Senior Cloud Engineer Database Administrator
AWS CloudFormation DynamoDB GitOps Go JavaScript Kafka Microservices MongoDB MySQL PostgreSQL Python Terraform TypeScript
22 hours, 16 minutes ago
Xenon7

Metadata Management Specialist (Colibra)

Xenon7 Internet Software & Services

Xenon7 is hiring a Metadata Management Specialist for a Fortune 500 pharmaceutical client to manage, migrate, and validate metadata across systems using Collibra.

India Contract Senior Database Administrator
Agile
22 hours, 31 minutes ago
HighLevel

Director - Database Engineering & Operations

HighLevel 251-1K Internet Software & Services

HighLevel is seeking a Director of Database Engineering & Operations to lead its data platforms and operations across a large-scale, remote-first SaaS environment.

India Full-time Executive Database Administrator DevOps Engineer
ClickHouse Firestore GCP Microservices PostgreSQL Redis
23 hours, 16 minutes ago
Emburse

Senior BillingPlatform System Administrator

Emburse 251-1K Diversified Financial Services

Emburse is hiring a Senior BillingPlatform System Administrator to own and optimize its billing platform environment and connected revenue systems, ensuring accurate quote-to-cash execution and strong financial controls in a SaaS business.

United States Full-time Senior Accountant Database Administrator
CRM ERP NetSuite Salesforce SOC SQL
23 hours, 16 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