It really depends on your income requirements and your ability to be flexible. Any position in IT, now, needs to have two or three main skill sets, and a smattering of three to five more.
What are your interests?
You hit in on it. Any IT professional must have a solid “knowledge portfolio.”
Knowledge of Oracle, MySql, C++, Java and Microsoft .NET are the “blue-chip” skills. But you must also keep up with emerging technologies, like Ruby on Rails, or Functional languages like Erlang or Scala, that may or may not take off, but could provide a nice return. I always go to the Manning and OReilly web sites to see what are the upcoming titles for their books, that gives a good hint as to what is “hot” out there.