Senior Database Developer, Oracle, PostgreSQL

🕒 January 19

Where this job comes from

Posted on Mactores's careers page ↗Mactores's careers page, not through a job board

First seen by Remote Rocketship January 19

Still open on Mactores's site. Checked 6 hours ago.

Apply Now
Logo of Mactores

Mactores

51 - 200 employees

Founded 2008

💼 Consulting

🏢 Enterprise

Consulting • Enterprise • Data

Mactores is a company that provides end-to-end data platform solutions aimed at accelerating business value through automation. Since 2008, Mactores has been helping businesses with digital transformation, offering services like Enterprise Data Lakes, Scalable Databases, Modern Data Warehouses, Automated DataOps, MLOps, and Generative AI solutions. They focus on enabling faster and cost-effective migrations and modernizations in data analytics, partnering with leading platforms to drive innovation and success. Mactores works alongside tech teams to strategize and implement the right data solutions timely and efficiently.

📋 Description

• 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.

🎯 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 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).

Apply Now

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

🕒 January 13

Creative Chaos

201 - 500

💼 Consulting

📣 Marketing

📦 Logistics

Full Stack Engineer responsible for maintaining web applications using Python and React. Collaborating with stakeholders and focusing on clean coding practices and AI solutions.

🕒 January 3

Tarini Consulting (Authorized Zoho Partner)

1 - 10

💼 Consulting

📣 Marketing

☁️ SaaS

Laravel Developer crafting web solutions for Tarini Consulting. Collaborate on Laravel-based applications and integrate with front-end technologies.

🕒 January 3

Tarini Consulting (Authorized Zoho Partner)

1 - 10

💼 Consulting

📣 Marketing

☁️ SaaS

Remote Laravel Developer crafting efficient web solutions for Tarini Consulting, specializing in digital transformation and automation projects.

🕒 December 30, 2025

CC Staffing International Ltd.

11 - 50

💼 Consulting

🏥 Healthcare

📦 Logistics

PHP Developer supporting sophisticated cloud-based applications and dashboards for a Canadian software company. Fully remote work from home in India with established team culture.

🕒 December 16, 2025

Lingaro

1001 - 5000

💼 Consulting

📣 Marketing

📦 Logistics

Lead Backend Developer designing and developing scalable backend applications for various teams. Collaborating with front-end developers and managing junior developers in a remote setup.

Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok