Database Migration Engineer
Required Skills: (Core)
- Databases: Oracle, SQL Server, MySQL, PostgreSQL, Db2; strong SQL and tuning.
- AWS Migration: DMS, SCT, RDS, Aurora, EC2, S3.
- Cloud Foundations: VPC, IAM, networking, Well-Architected Framework.
- Security: KMS, SSL/TLS encryption, least-privilege IAM, compliance (GDPR, HIPAA, PCI-DSS).
- Automation: Terraform/Cloud Formation, Python/Bash/PowerShell, CloudWatch monitoring.
Required Skills: (AI)
- Generative AI / LLMs for translating proprietary SQL dialects (e.g., Oracle PL/SQL to PostgreSQLPL/pgSQL).
- AI-assisted coding tools for generating, explaining, and debugging migration scripts andinfrastructure code.
- ML-based assessment and discovery tools for workload analysis and target sizingrecommendations.
- 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 (hallucinations, subtle logic bugs).
- Awareness of downstream AI/ML pipelines, data lakes, and vector databases.