Cloud Database Migration Engineer Ml Solutions

Role: Cloud Database Migration Engineer / ML Solutions Engineer

Location: Remote (US)

Duration: 6+ Months

Job Summary

We are seeking a Cloud Database Migration Engineer with strong Python/ML engineering skills. This role will work alongside the Principal Data & AI SME and CFT team engineer to build and deploy AI-powered agents that automate the migration of legacy databases (Sybase ASE, DB2) to Amazon Aurora PostgreSQL.

The successful candidate will contribute to designing, developing, and testing autonomous AI agents orchestrated through a multi-phase workflow covering extraction, translation, validation, and migration coordination.

Key Responsibilities

• Agent Development (60%)
  • Design and implement AI agents for database migration workflow:
    • Discovery Agent - Extract metadata from CMDB, inventory database objects
    • Schema Extraction Agent - Pull DDL from Sybase/DB2 source databases
    • Schema Translation Agent - Convert DDL to PostgreSQL syntax
    • Code Translation Agent - Convert stored procedures, functions, triggers (T-SQL/SQL PL PL/pgSQL)
    • Validation Agent - Schema comparison, data validation, lockstep test coordination
    • Reporting Agent - Dashboard generation, Go/No-Go reports
  • Integrate RAG (Retrieval-Augmented Generation) patterns for translation rulebook retrieval
  • Implement Human-in-the-Loop (HITL) routing for low-confidence translations
  • Tune LLM prompts and translation quality based on evaluation corpus
• Orchestration & Integration (25%)
  • Contribute to Orchestrator Agent development for end-to-end workflow coordination
  • Implement state management, checkpoint/resume capability for long-running migrations
  • Integrate with AWS DMS for data migration coordination (not data movement execution)
  • Coordinate with CFOSS team on LangGraph orchestrator integration
• Validation & Testing (15%)
  • Develop and expand test corpus for translation quality evaluation
  • Integrate with existing Lockstep testing framework for functional validation
  • Implement schema comparison and data validation agents
  • Track and report on translation quality metrics (target: 80-90% pass rates)

Required Technical Skills (Must Have)

• Technical Skills
  • AWS DMS - 2+ years hands-on experience REQUIRED
    • Task configuration and management (full load, CDC, full load + CDC modes)