AWS Data Migration Consultant-Delhi

You'll own heterogeneous database migrations end to end for enterprise customers moving off Oracle and SQL Server onto PostgreSQL and Aurora PostgreSQL. That means running the AWS DMS and SCT toolchain, then doing the part the tools can't: rebuilding procedural business logic in PL/pgSQL when SCT flags a gap it can't close on its own. You ship the runbook, you run the cutover, you validate the result. 

What you'll do?

• Lead end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
• Design, configure, and manage AWS DMS and SCT environments while ensuring migration quality, performance, and reliability.
• Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
• Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
• Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
• Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
• Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
• Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.

What we're looking for?

• 8–12 years of professional experience in database architecture and migration delivery
• Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations
• Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization
• Proven background in delivering heterogeneous database migrations across on-premises, cloud, and AWS environments
• Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing
• Skills in authoring and executing migration runbooks, validation plans, cutover procedures, rollback strategies, and post-migration stabilization activities
• Strong understanding of AWS database services, migration best practices, and integration with broader cloud migration programs
• Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes
• Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent
• Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing.

You'll be preferred if you

• Have tuned production database performance, backup and restore strategy, and failover testing in high-stakes environments.
• Have led migration teams or mentored engineers through complex conversions.
• Bring experience with broader AWS cloud migration programs beyond the database layer.

We are looking for an AWS Data Engineer to build reliable, scalable data pipelines on AWS.

Responsibilities

• Build ETL and ELT pipelines with AWS Glue and dbt
• Model and optimise data warehouses in Redshift and Snowflake
• Orchestrate workflows with Apache Airflow
• Build streaming ingestion with Amazon Kinesis
• Ensure data quality, monitoring and cost efficiency

Requirements

• 2+ years of data engineering on AWS
• Hands-on with Glue, Redshift or Snowflake, and Airflow
• Strong data modelling and warehousing skills

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.

We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.

What you will do?

• Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
• Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
• Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
• Identify, troubleshoot, and fix database-related application bugs.
• Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
• Support and monitor AWS DMS during full load and CDC phases.
• Diagnose and resolve DMS data and performance issues.
• Perform data validation and reconciliation between Oracle and PostgreSQL.
• Collaborate with application teams to align SQL behavior and performance expectations.

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.
• Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL.
• Hands-on expertise in Oracle to PostgreSQL migration.
• Advanced SQL and query performance tuning skills.
• Experience with AWS SCT and AWS DMS.
• Knowledge of Flyway/Liquibase or similar schema migration tools.
• PostgreSQL internals: indexing, statistics, execution plans.
• AWS services: RDS/Aurora, CloudWatch, IAM (preferred).

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.

Job Summary

We are looking for an experienced AWS Cloud Engineer with strong expertise in AWS infrastructure, deployment, migration, and cloud operations. The candidate should have hands-on experience managing AWS services such as EC2, EBS, S3, EFS, and FSx, along with infrastructure provisioning, migration, troubleshooting, and optimization.

Key Responsibilities

• Design, deploy, configure, and manage AWS infrastructure environments.
• Perform application and infrastructure migration to AWS.
• Provision and manage EC2 instances, including configuration, scaling, patching, and troubleshooting.
• Manage EBS volumes, snapshots, backups, and storage performance.
• Configure and administer S3 buckets, storage policies, lifecycle management, and access controls.
• Manage EFS for scalable shared file storage.
• Implement and manage Amazon FSx file systems based on application requirements.
• Monitor AWS infrastructure performance, availability, and capacity.
• Troubleshoot infrastructure, networking, storage, and deployment-related issues.
• Implement security best practices including IAM, security groups, encryption, and access controls.
• Support backup, disaster recovery, high availability, and business continuity requirements.
• Optimize AWS resources for performance, scalability, reliability, and cost.

Mandatory Skills

• Strong hands-on experience in AWS Cloud Infrastructure.
• Expertise in EC2, EBS, S3, EFS, and FSx.
• Experience in AWS deployment and migration projects.
• Strong knowledge of AWS networking concepts such as VPC, Subnets, Route Tables, Security Groups, and Load Balancers.
• Experience with IAM and AWS security best practices.
• Good knowledge of AWS monitoring and troubleshooting.
• Experience with cloud infrastructure automation using Terraform or CloudFormation is preferred.
• Strong Linux administration and troubleshooting skills.
• Good understanding of backup, disaster recovery, and high-availability concepts

Data Engineer

Location: Bengaluru, India (Hybrid)

Employment Type: Full-time

Experience: 3-5 years

Role Overview  

What We’re Looking For:

• Bachelor’s degree in Computer Science/Engineering or equivalent experience required.
• Experience designing and shipping cloud services products.
• Experience driving and managing technical and architectural dependencies on AWS Cloud.
• A firm understanding of system architecture, cloud computing, PaaS/SaaS design principles, S3, DynamoDB, RDS mandatory.
• Experience in building or maintaining ETL processes and tools, i.e., AWS Glue or any open-source tool.
• Proven system-level design contribution to a current “Live” (in production / under daily high load) multi-region SaaS or PaaS offering.
• Proven experience with S3, DynamoDB, SQL, and AWS RDS services.
• Proficiency in programming languages such as Python.
• Strong analytical and problem-solving skills.
• 
  

Required Skills & Experience

• Experience with Python, SQL, and data visualization/exploration tools.
• Familiarity with the AWS ecosystem, specifically S3, DynamoDB, and RDS.
• Communication skills, especially for explaining technical concepts to nontechnical business leaders.
• Ability to work on a dynamic, research-oriented team that has concurrent projects.
• Experience in AWS cost optimization (Savings Plans, Reserved Instances, Spot Instances) and governance frameworks.
• Experience developing solutions using infrastructure orchestration tools (SSM, automation account, Ansible, etc.).
• Excellent leadership, stakeholder management, and communication skills.

What We Offer

• Work with some of the brightest minds in the emerging EV industry.
• Make a tangible impact in reducing carbon emissions and enabling sustainable energy.
• Freedom to suggest, implement, and innovate on systems, processes, and technologies.
• Daily ownership in a high-growth, challenging environment.
• Flexible work environment with hybrid schedules and virtualization options.
• Competitive pay and benefits including health coverage, innovative PTO program, and performance bonuses.

Key Responsibilities

• Lead end-to-end data migration initiatives, including assessment, planning, mapping, transformation, validation, and reconciliation.
• Define and implement data governance frameworks, standards, policies, and processes.
• Design and manage data solutions using Microsoft Azure Data Services.
• Lead development of BI dashboards, reports, KPIs, and analytics solutions.
• Work with business and technical stakeholders to understand reporting and data requirements.
• Develop and maintain data models, data pipelines, ETL/ELT processes, and reporting architecture.
• Ensure data quality, consistency, integrity, security, and compliance throughout migration and reporting processes.
• Identify data risks, dependencies, gaps, and migration challenges and drive their resolution.
• Establish data validation and reconciliation mechanisms to ensure migration accuracy.
• Provide technical leadership and guidance to data engineers, BI developers, and other project team members.
• Collaborate with application, cloud, infrastructure, and business teams during project implementation.
• Monitor data migration and BI deliverables against project timelines, quality standards, and business objectives.
• Prepare technical documentation, data dictionaries, mapping documents, governance guidelines, and project reports.

Required Skills & Experience

• 7+ years of experience in data, migration, BI, or related technology roles.
• Strong experience working on software/IT projects and managing data-related workstreams.
• Hands-on experience with Microsoft Azure Data Services.
• Strong understanding of data migration methodologies, ETL/ELT, data transformation, and reconciliation.
• Experience in Data Governance, Data Quality, Master Data, Metadata Management, and Data Security.
• Strong experience with BI reporting and dashboard development.
• Good understanding of SQL and relational databases.
• Experience with Power BI and data visualization is highly desirable.
• Knowledge of Azure services such as Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure SQL Database, or equivalent.
• Strong understanding of data architecture and data lifecycle management.
• Excellent stakeholder management, communication, analytical, and problem-solving skills.