Do I need to consult an engineer or a geologist before I take down retaining walls on my property?

No, you shouldn't need to consult an engineer or geologist regarding removing retaining walls. You will want to make sure that whoever you hire is licensed/bonded and insuranced just in case they cause any damage.