I've been working in IT, largely as a software developer, for the past 20 years. Much of that time has also been with SQL Server and/or Oracle (I'm preferential to SQL). I've used SQL Server since version 7.0, and currently work with SQL Server 2012.
As I get older, I'm finding it hard to maintain the creative energy needed to be a good programmer, constantly trying to find interest all the trendy language features, concepts, design patterns, etc., most of which doesn't allow me to do anything that much better/easier than I could have years ago.
Having said that, I'm interested in making a transition to a DBA of some sort. Most DBA's I've known usually do things like handling stored procedures for the programmers, and the general dirty work of maintenance (i.e., backups, etc.), installations, etc., with some doing ad-hoc reporting and what-not.
Another example, are things like 'clustering', setting up log shipping, etc., that are a bit of a mystery to me. But I know T-SQL and can write some mean sprocs like nobody's business!
I live in the Dallas area and make in the 90k range a year. I'm curious if a DBA job would pay more-or-less the same (assuming when I qualified for a job), what kinds of certifications I should get (if any) to help make me more attractive to employers, and any other advice you might offer?
Appreciate your kind guidance.