The Senior Database Migration Engineer designs and implements database migration strategies, optimizes performance, develops automation scripts, and ensures security during migrations from licensed databases to open-source platforms.
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.
Top Skills
Amazon Aurora
Ansible
Aws Dms
Aws Sct
Chef
CloudFormation
Flyway
Liquibase
Oracle
Pl/Pgsql
Pl/Sql
Postgres
Puppet
Python
Rds
Shell
Terraform
Similar Jobs
Artificial Intelligence • Edtech • Mobile • Natural Language Processing • Productivity • Software
Lead and scale QuillBot's AI Engineering & MLOps function by overseeing the full ML lifecycle, optimizing performance, and mentoring a team while collaborating cross-functionally.
Top Skills:
AIGCPKubernetesMlMlopsTensorrtVertex Ai
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Engineering Manager will lead the Linux sensor development team, manage engineers, drive technical strategy, and ensure high code quality for cybersecurity features.
Top Skills:
CC++EbpfKubernetesLinuxUnix
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The role involves software testing, including writing test plans, executing various testing types, and familiarizing with Agile processes and tools.
Top Skills:
AzureJIRAPostmanRest ClientSeleniumTosca
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
