I'm preparing for my Sec401 and I'm wondering what is the real difference between a firewall which filter traffic and a proxy which redirect/forward traffic?
Is there any security gains implementering a proxy server ...let's say for instance if you have a webserver residing in your DMZ, hosting your website with an API which connects to a DB server in your internal network which registers users info inputed on your website? Webserver is connected directly to the firewall (192.168.200.xxx) and the DB server(192.168.222.xxx) resides "behind" the firewall. Not using vlans and the web api from webserver to db server use dynamic ports and http(80)?
I'm arguing with my boss and 3rd party developers firm who are stating that is no security gain implementing a proxy server. I'm thinking that the proxy is "hidding" my 192.168.222.xxx network from beeing seen from the internet...or i'm ...how they (boss+developers) call me: paranoic, overengineering and so on

...?