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

Associate Database Administrator

BHG Financial 1K-5K Diversified Financial Services

BHG Financial is hiring an early-career Database Administrator to support SQL Server databases across on-premises and Azure environments, maintaining reliable, secure, and high-performing systems for a financial services organization.

Azure PowerShell SQL SQL Server
2 hours, 37 minutes ago

[Job-31961] Data Developer Sênior - Cloud DB Specialist, Brazil

CI&T 5K-10K Internet Software & Services

A CI&T busca um Cloud Data Developer Sênior para liderar a arquitetura e execução da migração de bancos de dados on-premises para o Azure em um projeto estratégico de modernização de infraestrutura para um cliente do setor de saúde.

Agile Azure CI/CD Kanban Microservices Scrum
2 hours, 37 minutes ago

Senior Software Developer

Aspire Software 251-1K Internet Software & Services

Vocantas, part of Fluent Software Group, is seeking a Senior Software Developer to build secure, reliable workforce communication and scheduling products through hands-on full-stack development with a backend focus.

Angular C# JavaScript Microservices .NET REST API TypeScript Vue.js
3 hours, 37 minutes ago

Software Engineer (Mid-Senior)

Aether Aerospace 501-1000 aviation & aerospace

Aether Aerospace is hiring a full-time Mid-Senior Software Engineer to develop C/C++ real-time software and Angular interfaces for U.S. Department of Defense programs, working remotely with 50% travel to Hollywood, Maryland.

Agile Angular C C++
3 hours, 37 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