Senior Database Migration Engineer (Oracle & PostgreSQL) (Freelancer)

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

Life at Mactores

We care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.

1. Be one step ahead
2. Deliver the best
3. Be bold
4. Pay attention to the detail
5. Enjoy the challenge
6. Be curious and take action
7. Take leadership
8. Own it
9. Deliver value
10. Be collaborative

We would like you to read more details about the work culture on https://mactores.com/careers

The Path to Joining the Mactores Team
At Mactores, our recruitment process is structured around three distinct stages:

Pre-Employment Assessment:
You will be invited to participate in a series of pre-employment evaluations to assess your technical proficiency and suitability for the role.

Managerial Interview: The hiring manager will engage with you in multiple discussions, lasting anywhere from 30 minutes to an hour, to assess your technical skills, hands-on experience, leadership potential, and communication abilities.

HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.

At Mactores, we are committed to providing equal opportunities in all of our employment practices, and we do not discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This policy extends to all aspects of the employment relationship, including recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs. All employment decisions will be made in compliance with these principles.

Note: Please answer as many questions as possible with this application to accelerate the hiring process.