AWS DMS Data Migration Architect / AWS Database Migration Engineer

Job Title: AWS DMS Data Migration Architect / AWS Database Migration Engineer

Location: Connecticut (Onsite/Hybrid)
Duration: Long Term
Employment Type: Contract

Job Description

We are seeking an experiencedAWS DMS Data Migration Engineer/Architect with strong expertise inAWS Database Migration Service (AWS DMS), PostgreSQL, and Microsoft SQL Server. The ideal candidate will have hands-on experience designing and implementing secure, scalable, and high-performance database migration and synchronization solutions usingChange Data Capture (CDC) andAWS EventBridge.

The candidate should be capable of leading migration strategy discussions, designing data synchronization architectures, and collaborating with cross-functional teams to deliver reliable data integration solutions.

Key Responsibilities

• Design, develop, and implement database migration solutions usingAWS Database Migration Service (AWS DMS).
• Architect and implementreal-time data synchronization betweenPostgreSQL andMicrosoft SQL Server usingChange Data Capture (CDC).
• Configure and integrateAWS EventBridge for event-driven data migration and synchronization workflows.
• Develop comprehensivedata migration strategies, including assessment, planning, execution, validation, and rollback procedures.
• Analyze existing database environments and recommend optimal migration approaches.
• Perform database schema design,table normalization, indexing, and performance optimization.
• Ensure data integrity, consistency, and minimal downtime during migration activities.
• Troubleshoot migration failures, replication latency, and performance bottlenecks.
• Collaborate with application, infrastructure, and DevOps teams throughout migration projects.
• Create technical documentation, migration runbooks, and architectural diagrams.
• Participate in solution design discussions and proactively recommend best practices.

Required Skills

• 8+ years of experience in database administration, migration, or data engineering.
• Strong hands-on experience withAWS Database Migration Service (AWS DMS).
• Expertise inPostgreSQL andMicrosoft SQL Server administration and development.
• Experience implementingChange Data Capture (CDC) for real-time replication.
• Strong knowledge ofAWS EventBridge and event-driven architectures.
• Extensive experience indatabase migration strategy, planning, execution, and validation.
• Strong understanding ofdatabase architecture, schema design, andtable normalization.
• Experience with SQL performance tuning, query optimization, indexing, and partitioning.
• Knowledge of AWS networking, IAM, security, and monitoring services.
• Excellent troubleshooting and analytical skills.
• Strong communication and solution design capabilities.

Preferred Skills

• Experience with AWS services such asRDS,EC2,Lambda,CloudWatch,SNS,SQS,Secrets Manager, andCloudFormation.
• Experience with Infrastructure as Code (Terraform or CloudFormation).
• Familiarity with CI/CD pipelines and DevOps practices.
• AWS Certification (AWS Solutions Architect, AWS Database Specialty, or AWS Developer Associate) is preferred.
• Experience working in enterprise-scale cloud migration projects.

Nice to Have

• Experience with large-scale database modernization initiatives.
• Knowledge of data warehousing and ETL tools.
• Experience with high-availability and disaster recovery solutions.
• Prior experience leading cloud migration or modernization projects.

Required Technologies

• AWS Database Migration Service (AWS DMS)
• PostgreSQL
• Microsoft SQL Server
• Change Data Capture (CDC)
• AWS EventBridge
• SQL Performance Tuning
• Database Design & Table Normalization
• Data Migration Strategy
• AWS Cloud Services
• Database Architecture
• Data Replication
• Schema Design