Hello Hiren,
I am SQL SERVER DBA Architect . Check my profile for my client feedback and my core competencies
I understand your requirement thoroughly , so all you need is to replicate the data to dedicated sql server as soon as it is committed on your primary database on AWS EC2 instance . I have worked on such type of configurations n number of times in my career. Please reach me we will discuss and i can give you more option and solutions .
100% best work and post implementation support guranteed .just ping me in chat .
Thanks