AWS Data Migration Consultant

About This Role

Lead the design, migration, and optimization of scalable database solutions in the AWS cloud, focusing on modernizing on-premises database systems for clients. This role involves architecting high-performance, secure, and reliable AWS-hosted solutions and collaborating with data engineers, cloud architects, and business stakeholders.

Responsibilities

• Design and optimize database solutions on AWS, including Amazon RDS, EC2-hosted instances, and advanced configurations like SQL Server Always On or Oracle RAC (Real Application Clusters)
• Lead and execute cloud database migrations using AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), and custom automation tools
• Architect high-performance database schemas, indexing strategies, partitioning models, and query optimization techniques
• Optimize complex SQL queries, stored procedures, functions, and views to ensure performance and scalability in the cloud
• Implement high-availability and disaster recovery (HA/DR) strategies including Always-On, Failover Clusters, Log Shipping, and Replication, tailored to each RDBMS
• Ensure security best practices are followed including IAM-based access control, encryption, and compliance with industry standards
• Collaborate with DevOps teams to implement Infrastructure-as-Code (IaC) using tools like Terraform, CloudFormation, or AWS CDK
• Monitor performance using tools such as AWS CloudWatch, Performance Insights, Query Store, Dynamic Management Views (DMVs), or Oracle-native tools
• Work with software engineers and data teams to integrate cloud databases into enterprise applications and analytics platforms

Requirements

• 5+ years of experience in database architecture, design, and administration with SQL Server, Oracle, or DB2
• Expertise in Microsoft SQL Server, Oracle, or DB2
• Hands-on experience with AWS database services (RDS, EC2-hosted databases)
• Strong understanding of HA/DR solutions and cloud database design patterns
• Experience with ETL development and data integration, using tools such as SSIS, AWS Glue, or custom solutions
• Familiarity with AWS networking components (VPCs, security groups) and hybrid cloud connectivity
• Strong troubleshooting and analytical skills to resolve complex database and performance issues
• Ability to work independently and lead database modernization initiatives

Qualifications

• 5+ years of experience in database architecture, design, and administration with SQL Server, Oracle, or DB2

Nice to Have

• AWS certifications such as AWS Certified Database – Specialty or AWS Certified Solutions Architect – Professional
• Experience with NoSQL databases or hybrid data architectures
• Knowledge of analytics and big data tools (e.g., Snowflake, Redshift, Athena, Power BI, Tableau)
• Familiarity with containerization (Docker, Kubernetes) and serverless technologies (AWS Lambda, Fargate)
• Experience with DB2 on-premise or cloud-hosted environments

Skills

* Required skills

Benefits