Description

Key Responsibilities

On-Premises to AWS Migration Planning & Execution

• Architect and execute end-to-end migration strategies to move multi-terabyte on-premises MSSQL/MySQL/PostgreSQL/Oracle databases to AWS with near-zero downtime.

• Assess existing on-premises virtual server workloads, compute demands, memory footprints, and disk I/O to define optimal AWS target architectures.

• Configure hybrid connectivity workflows over AWS Direct Connect or IPsec VPNs for secure, low-latency data replication between on-premises data centers and AWS VPCs.

• Execute cutovers using hybrid replication techniques (e.g., AWS Database Migration Service (DMS), or AWS Application Migration Service / AWS MGN).

• Establish comprehensive cutover playbooks, contingency plans, and rollback procedures to eliminate risk during production maintenance windows.

AWS Infrastructure Sizing & Storage Optimization

• Right-size AWS compute instances (e.g., Amazon EC2 memory-optimized instance families based on on-premises NUMA and CPU baseline data.

• Provision and tune AWS storage options specifically Amazon Elastic Block Store (EBS) volume types to achieve target IOPS and throughput requirements.

• Design and implement secure Network Topologies within AWS VPCs, including public/private subnet routing, Security Groups, Network ACLs, and AWS IAM policies.

High Availability, Disaster Recovery & Security

• Design high-availability topologies in AWS utilizing Multi-AZ deployments, MSSQL/MySQL/PostgreSQL/Oracle Cluster, Group Replication

• Implement robust cloud backup and disaster recovery strategies using AWS Backup, EBS Snapshot integration

• Enforce security best practices, including transit encryption (TLS/SSL), storage encryption at rest (AWS KMS / TDE), and least-privilege IAM control.

Performance Tuning & Post-Migration Validation

• Establish baseline benchmarking, workload validation, and performance tests before and after cutover to ensure target AWS performance meets or exceeds on-premises levels.

• Monitor resource utilization, latency, buffer pool efficiency, and query execution using Amazon CloudWatch, Performance Schema, and Slow Query Logs.

• Resolve post-migration bottlenecks, query regressions

Key Skills

Education

Bachelor's degree