Senior Database Developer, Oracle, PostgreSQL

🕒 January 19

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

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

Upload Resume

Mactores

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2008

🏢 Enterprise

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