Description

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

Key Skills

Education

Any Graduate