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 solid 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.

- Collaboration & Documentation

- 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.
- Cross-Platform Migration: Oracle, SQL Server, MySQL PostgreSQL.
- 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.

📌 Technical Lead – AWS Cloud DMS (India)
🏢 RxLogix
📍 India