Hiring: Cloud Database Migration Engineer (AWS)

Client: Goldman Sachs
Location: Dallas,Texas (Onsite)
Duration: 6–12 Months Contract

Experience: 12+yrs

Job Summary

We are seeking an experienced Cloud Database Migration Engineer with strong expertise in AWS database migration, relational databases, cloud architecture, and AI-assisted migration tools. The ideal candidate will have hands-on experience migrating on-premises databases to AWS with minimal downtime, ensuring data integrity, security, and performance optimization.

Key Responsibilities

• Assess on-premises database environments and develop homogeneous and heterogeneous migration strategies.

• Migrate databases to AWS RDS, Amazon Aurora, and EC2.

• Use AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for database migration and schema conversion.

• Convert database schemas, stored procedures, and SQL code across platforms, including Oracle PL/SQL to PostgreSQL PL/pgSQL.

• Develop migration, cutover, rollback, and data validation plans to minimize downtime.

• Design secure AWS architectures using VPC, IAM, networking, KMS, and SSL/TLS encryption.

• Automate infrastructure provisioning and migration tasks using Terraform, CloudFormation, Python, Bash, or PowerShell.

• Monitor and optimize database performance using SQL tuning and Amazon CloudWatch.

• Leverage Generative AI, LLMs, and AI-assisted coding tools to accelerate SQL conversion, script development, debugging, and migration assessments.

• Validate AI-generated scripts and code to identify logic errors, hallucinations, and data consistency issues.

• Collaborate with database, cloud infrastructure, security, and application teams throughout the migration lifecycle.

Required Skills

• Strong hands-on experience with AWS database migration and cloud database services.

• Experience with one or more relational databases: Oracle, SQL Server, MySQL, PostgreSQL, and Db2.

• Proficiency in AWS DMS, AWS SCT, RDS, Aurora, EC2, and S3.

• Strong knowledge of SQL, database administration, schema conversion, stored procedures, and performance tuning.

• Experience with AWS VPC, IAM, networking, encryption, and cloud security best practices.

• Hands-on experience with Terraform or AWS CloudFormation and scripting using Python, Bash, or PowerShell.

• Practical experience using Generative AI/LLMs for SQL translation, code generation, debugging, and migration automation.

• Strong data validation, troubleshooting, and post-migration optimization skills.

• Understanding of compliance requirements such as GDPR, HIPAA, and PCI-DSS.

Preferred Qualifications

• AWS Certified Database – Specialty, AWS Solutions Architect, or equivalent certification.

• Experience with enterprise-scale database modernization and migration projects.

• Familiarity with AI-driven workload assessment, anomaly detection, data lakes, vector databases, and downstream AI/ML pipelines.

• Strong communication, analytical, and stakeholder management skills.