Database Migration Engineer (Administrator) (Oracle to PostgreSQL Migration)

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.

Mactores is looking for a highly skilled and experienced Database Migration Engineer (Administrator) to lead and execute the migration project from Oracle to PostgreSQL Migration. The ideal candidate will lead hands-on execution of migrating database tables, schema, and data from Oracle to PostgreSQL Migration. The candidate will also be responsible for performing DBA tasks on the PostgreSQL database post-migration.

What you will do?

• Migrate databases from Oracle to PostgreSQL, focusing on tables, schema, and data migration (one-time and ongoing changes).
• Actively participate in the hands-on execution of the migration process, ensuring accuracy, efficiency, and minimal downtime.
• Undertake Database Administration tasks on the PostgreSQL database post-migration, including performance tuning, monitoring, and troubleshooting.
• Work closely with cross-functional teams, including developers, database administrators, and project managers, to ensure a coordinated and successful migration.
• Create comprehensive documentation for the migration process, including procedures, guidelines, and best practices. Maintain documentation for post-migration DBA tasks.
• Identify and implement performance optimization strategies for the PostgreSQL database, ensuring responsiveness and reliability.

What are we looking for?

• 3+ years of hands-on experience as a Database Migration Engineer (Administrator) with a focus on Oracle to PostgreSQL migration projects.
• Extensive expertise in MS SQL Server and PostgreSQL database management, including migration tools, techniques, and best practices.
• Strong proficiency in SQL, database design, performance tuning, and optimization.
• Excellent problem-solving skills with a keen attention to detail and a results-driven mindset.
• Exceptional communication, collaboration, and interpersonal skills, with the ability to work effectively in a fast-paced, dynamic environment.

You will be preferred If

• If you are a highly skilled and motivated Database Migration Engineer with expertise in Oracle to PostgreSQL migration projects, we invite you to apply. Join our dynamic team at Mactores and contribute to the success of this critical initiative.

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 .

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.