@lukepenko
This seems to be a bit out of networking scope but if the device speaks ethernet then the switch should be ok for it. Now, in order to tell you how many interfaces, it would be necessary a topology of the whole system. You mentioned you want to your system, how the data will flow from the system to the ESP32? How will your data base be connected to the ESP32? How are you going to access this?
One interface may be enough or not, it will depend on the topology