A financial services company needs to migrate their transaction processing system to AWS. The application requires strict ACID compliance, complex queries with JOIN operations, and the ability to scale read capacity during month-end reporting periods. Which AWS database service should they choose?