Technical Lead – AWS Cloud DMS

RxLogix Corporation; Dadri; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A technology solutions provider in Dadri, India is seeking an experienced AWS Cloud DMS Specialist to lead complex database migration and replication initiatives. The ideal candidate will have 5–8 years of experience with AWS services and PostgreSQL, ensuring minimal downtime during migrations. Candidates must possess strong automation skills using AWS Lambda and Python, and familiarity with compliance standards. This role offers an opportunity to work in a dynamic environment with a focus on technological advancement.

Qualifications

• 5–8 years of experience in database migration, replication, and automation.
• Experience with zero-downtime migration strategies.
• Familiarity with Terraform and CI/CD pipelines.

Responsibilities

• Lead complex database migration and replication initiatives.
• Design and execute migrations using AWS Database Migration Service (DMS).
• Automate migration workflows using AWS Lambda and Python.

Skills

AWS DMS

PostgreSQL

AWS Lambda

Python scripting

AWS CloudFormation

Automation

Linux shell scripting

Tools

AWS Schema Conversion Tool (SCT)

pg_dump/pg_restore utilities

Job description

Experience

5–8 years in database migration, replication, and automation.

Role Overview

We are seeking a highly skilled AWS Cloud DMS Specialist to lead complex database migration and replication initiatives. The ideal candidate will have deep expertise in AWS services, PostgreSQL, and cross-platform migrations, combined with strong automation and DevOps capabilities.

Key Responsibilities

• Database Administration – Migration & Replication
  • Design, plan, and execute migrations using AWS Database Migration Service (DMS).
  • Perform cross-platform migrations (e.g., Oracle → PostgreSQL, SQL Server → PostgreSQL).
  • Troubleshoot replication lag, data inconsistencies, and performance issues.
  • Manage schema design, performance tuning, query optimization, and troubleshooting.
  • Handle installation, upgrades, patching, backup, and recovery operations.
  • Configure roles, privileges, and security policies
  • Review PL/SQL code, optimize performance, and assist in schema design.
• Automation & Infrastructure
  • Automate migration workflows using AWS Lambda and Python (Boto3).
  • Build Infrastructure as Code (IaC) with AWS CloudFormation for DMS, networking, IAM, and database resources.
  • Integrate DMS with AWS services like CloudWatch, SNS, S3, Secrets Manager.
• Work closely with application, database, and DevOps teams to ensure minimal downtime.
• Maintain detailed documentation for migration strategies, runbooks, and operational processes.
• Compliance & Support
  • Ensure adherence to GxP and CFR 21 Part 11 standards.
  • Provide 24×7 support for critical migration activities.

Technical Skills Required

• AWS DMS: Setup, tuning, troubleshooting, and monitoring.
• AWS CloudFormation: Develop and maintain IaC templates.
• PostgreSQL: Advanced SQL, schema conversion, performance optimization.
• Automation: AWS Lambda, Python scripting for migration and monitoring.
• AWS Services: RDS, Aurora PostgreSQL, S3, IAM, CloudWatch, Secrets Manager.
• Tools: AWS Schema Conversion Tool (SCT), pg_dump/pg_restore utilities.
• Other: Linux shell scripting, network configuration, TLS/SSL connectivity.

Preferred Qualifications

• 5–8 years of experience as DBA
• Experience with zero-downtime migration strategies.
• Familiarity with Terraform, CloudFormation, CI/CD pipelines for database deployments.
• Expertise in data validation and reconciliation using Python.
• Knowledge of cost optimization and scalability best practices on AWS.

Soft Skills

• Strong technical leadership and problem-solving abilities.
• Excellent communication and customer orientation.
• Effective escalation management and collaboration skills.