Cloud Database Migration Engineer (AWS)

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.