"Our MongoDB dataset is far bigger than our relational data, weighing in at 400 GB and constantly growing."

MongoDB keeps indexes in RAM IIRC. How much RAM does your server have? :-)