There are a number of good schools in Bahrain. Most are located in the Isa Town educational area. At school opening and closing times traffic in this area is a nightmare (Imagine Jakarta at peak hour). School bus, provided by (in most cases) private bus companies, is the best option.
The schools themselves? Depending on your own requirements many options are available: Indian School, British School, St. Christophers, Pakistani School, Al Bayan, Sacred Heart etc. Educational standards are, in general, very good with many expat students having no difficulties on return to their home countries. Children from my own country, for instance, who have spent all of their younger days in Bahrain have had no difficulty at all completing their final two years at home. In fact perhaps an advantage is available in a more complete "world view" than some of their home grown counterparts.
You haven't said who your employer is so just a word of warning. Fees at St. Christopher's (British curriculumn), for instance, are not cheap. If your employer offers an educational allowance it may not cover these fees.
Without knowing your specific requirements it is difficult to offer any more advice. However if you are worried about a move to Bahrain because of your children's education then don't be too concerned. Younger children, particularly, love it here. Teenagers with a good family to support them adapt and can flourish. If you need more info don't hesitate to ask.