Mactores
Enterprise • Data
Mactores is a company that provides end-to-end data platform solutions aimed at accelerating business value through automation. Since 2008, Mactores has been helping businesses with digital transformation, offering services like Enterprise Data Lakes, Scalable Databases, Modern Data Warehouses, Automated DataOps, MLOps, and Generative AI solutions. They focus on enabling faster and cost-effective migrations and modernizations in data analytics, partnering with leading platforms to drive innovation and success. Mactores works alongside tech teams to strategize and implement the right data solutions timely and efficiently.
Senior Database Migration Engineer, Oracle, PostgreSQL
Job not on LinkedIn
November 20
Mactores
Enterprise • Data
Mactores is a company that provides end-to-end data platform solutions aimed at accelerating business value through automation. Since 2008, Mactores has been helping businesses with digital transformation, offering services like Enterprise Data Lakes, Scalable Databases, Modern Data Warehouses, Automated DataOps, MLOps, and Generative AI solutions. They focus on enabling faster and cost-effective migrations and modernizations in data analytics, partnering with leading platforms to drive innovation and success. Mactores works alongside tech teams to strategize and implement the right data solutions timely and efficiently.
📋 Description
• 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
🎯 Requirements
• 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
Apply NowSimilar Jobs
November 20
SharePoint Engineer responsible for designing and maintaining SharePoint solutions for clients. Collaborating with teams to drive business transformation and ensure high-performing Microsoft 365 solutions.
Azure
JavaScript
Node.js
React
SCSS
TypeScript
Webpack
November 17
Civil Project Engineer overseeing the full project lifecycle from planning to handover for hospitality and retail projects. Collaborating with various stakeholders and ensuring compliance with safety standards in India.
November 17
Relay Protection Engineer focusing on protection systems, relay testing, and system reliability. Join a team ensuring safe and efficient operation of electrical networks through modern engineering practices.
November 14
Team Lead managing a team of Forward Deployed Engineers for Bluecore's ecommerce personalization platform. Leading technical efforts and enhancing client solutions through cloud-based technologies.
Cloud
JavaScript
Python
SOAP
SQL
November 14
SharePoint Engineer designing, developing, and maintaining SharePoint solutions for business transformation. Collaborates with clients for scalable and secure Microsoft 365 solutions.
Azure
JavaScript
Node.js
React
SCSS
TypeScript
Webpack