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

Description

  • Convert SQL, stored procedures, and database objects to PostgreSQL-compatible SQL/PLpgSQL and escalate complex cases as needed.
  • Work through AWS SCT findings and flag tool limitations for senior review.
  • Maintain Flyway migration scripts, including versioning, repeatable migrations, and rollbacks.
  • Identify and troubleshoot database-related application bugs.
  • Support PostgreSQL query optimization through execution plans, indexing, and query rewrites.
  • Monitor AWS DMS during full load and CDC phases and report issues to the lead engineer.
  • Diagnose DMS data and performance issues.
  • Validate and reconcile source and target database data before cutover.
  • Collaborate with application teams to align SQL behavior and performance expectations.
  • Work with senior engineers, cloud engineers, and customer stakeholders to deliver successful migrations.

Requirements

  • Bachelor's degree in Computer Science or a related field.
  • 3–5 years of experience as a database developer/engineer with exposure to migration work.
  • Working experience with at least one of Oracle, Microsoft SQL Server, or PostgreSQL/Aurora PostgreSQL.
  • Hands-on exposure to database migration projects such as Oracle-to-PostgreSQL or SQL Server-to-PostgreSQL.
  • Solid SQL skills and a working understanding of query performance tuning.
  • Familiarity with AWS SCT and AWS DMS; hands-on exposure preferred but not required.
  • Awareness of schema migration tools such as Flyway or Liquibase.
  • Working knowledge of PostgreSQL fundamentals, including indexing and execution plans.
  • Familiarity with AWS services such as RDS/Aurora, CloudWatch, and IAM (preferred).
  • Familiarity with Ansible, Chef, Puppet, Terraform, or CloudFormation (preferred).
  • AWS Certified Database – Specialty or AWS Certified Solutions Architect (nice to have).

Benefits

  • Equal opportunity employment practices.
  • Structured hiring process with pre-employment assessment, managerial interview, and HR discussion.
  • Opportunity to work on real AWS modernization and database migration engagements.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior Software Performance Engineer

May Mobility 251-1K Transportation

May Mobility is hiring a Senior Performance Engineer to optimize the real-time behavior-planning pipeline that powers its autonomous vehicles, ensuring deterministic, high-throughput execution.

C++ CI/CD Linux
12 minutes ago

Senior Software Engineer (Platform team)

Sysdig 251-1K IT Services

Software Engineer at Sysdig designing and operating identity, account, and platform services that support the company’s cloud security products and engineering teams.

AWS Azure Go Java NATS PostgreSQL
12 minutes ago

Database Administrator - Remote US

Smile Digital Health 251-1K IT Services

Smile Digital Health is seeking a Database Administrator to maintain and optimize data stores supporting its FHIR-based healthcare data platform, clients, and partners worldwide.

ActiveMQ Azure Kafka MongoDB NetSuite Oracle PostgreSQL Snowflake SQL SQL Server
23 hours, 42 minutes ago

Staff Software Engineer, Front End

Scout Motors 51-250 Automotive

Scout Motors is hiring a Staff Frontend Engineer for its Sales Engineering team to build and evolve scalable web applications supporting vehicle sales, order management, customer operations, fulfillment, finance, and other core business workflows.

Android AWS Azure CI/CD Cypress GraphQL iOS Node.js Playwright React React Native REST API SEO
23 hours, 42 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