Cloud Database Migration Engineer (AWS)

Location

Dallas, TX 75201

Employment Type

Full-Time

Interview- F2F at Dallas (Client's Office) post L1 Selection (Locals Preferred)

Role Overview

Migrate on-premises relational databases to AWS using strong database expertise, cloud architecture skills, and AI-accelerated tooling to deliver secure, reliable, low-downtime migrations.

Key Responsibilities

• Assess on-premises workloads and plan homogeneous and heterogeneous migrations.
• Convert schemas, stored procedures, and SQL across database engines.
• Design secure AWS targets (RDS, Aurora, EC2) and execute cutover and rollback plans.
• Automate deployments with Infrastructure as Code and tune performance post-migration.

Required Skills (Core)

Databases

• Oracle, SQL Server, MySQL, PostgreSQL, and Db2.
• Strong SQL and database performance tuning skills.

AWS Migration

• AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), RDS, Aurora, EC2, and S3.

Cloud Foundations

• VPC, IAM, networking, and AWS Well-Architected Framework.

Security

• KMS, SSL/TLS encryption, least-privilege IAM, and compliance requirements (GDPR, HIPAA, PCI-DSS).

Automation

• Terraform/CloudFormation, Python/Bash/PowerShell, and CloudWatch monitoring.

Required Skills (AI)

• Generative AI/LLMs for translating proprietary SQL dialects (e.g., Oracle PL/SQL to PostgreSQL PL/pgSQL).
• AI-assisted coding tools for generating, explaining, and debugging migration scripts and infrastructure code.
• ML-based assessment and discovery tools for workload analysis and target sizing recommendations.
• AI-driven performance monitoring for anomaly detection and post-migration optimization.
• Prompt engineering skills for accurate, context-aware AI assistance.
• A strong validation mindset to catch AI-generated errors, including hallucinations and subtle logic bugs.
• Awareness of downstream AI/ML pipelines, data lakes, and vector databases.

Soft Skills

• Problem-solving.
• Clear communication.
• Project management awareness.

Nice to Have

• AWS Certified Database – Specialty or AWS Certified Solutions Architect.
• Enterprise migration experience.