Senior Database Migration Engineer

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.

We are seeking a highly experienced Senior Database Migration Engineer with strong expertise in both database administration and development across Oracle and PostgreSQL. The ideal candidate will have extensive hands-on experience migrating enterprise applications from licensed databases such as Oracle and Microsoft SQL Server to open-source engines like Amazon Aurora PostgreSQL or RDS. A minimum of 5+ years of DBA and Developer experience and a proven track record of successfully delivering 2 or more end-to-end database migration projects is required.

What you will do

• Design and implement database migration plans from licensed databases like Oracle and MSSQL to open-source databases like Aurora PostgreSQL on AWS
• Analyze existing database architectures and define optimal migration strategies
• Convert schemas, stored procedures, functions, packages and database logic (PL/SQL to PL/pgSQL)
• Optimize database performance through indexing, query tuning, and execution plan analysis
• Troubleshoot complex database issues and implement robust backup/recovery and HA/DR solutions
• Develop automation scripts for database operations and monitoring
• Implement CI/CD best practices for database deployments, including automated schema versioning, testing, and rollout processes
• Collaborate with cross-functional teams and document migration processes
• Assess application-level dependencies and ensure compatibility during database migration
• Implement database security best practices, including access control, auditing, and encryption in AWS

What are we looking for

• Bachelor's degree in Computer Science or a related field
• 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
• Experience with AWS database migration tools and services such as AWS DMS and SCT/Ora2Pg
• Proven delivery of 2 or more database migration projects
• Strong hands-on skills in PL/SQL, PL/pgSQL, schema conversion, and performance tuning
• Experience with AWS DMS, SCT, RDS, Aurora, and related AWS services
• Strong SQL, scripting (Shell/Python), troubleshooting, and documentation skills
• Excellent problem-solving skills with the ability to identify and resolve complex issues
• Strong communication and collaboration skills
• Ability to work independently with minimal supervision

You will be preferred if:

• Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet
• Familiarity with IAAC tools such as Terraform, CloudFormation
• Familiarity with CI/CD implementation tools like Liquibase/Flyway
• AWS Certified Database Specialty
• AWS Certified Solutions Architect