I will rephrase then since for some weird reason you are stuck to relational DBs, which btw IKNOW (and don't believe) are slower than time series DBs when it comes to tick data for example, and NoSQL DBs are faster for trade positions.
If the development environment is in Java, do you have experience with a NoSQL or timeseries DB? If yes, which one would you recommend and why?