Being the person who everyone turns to for database/query issues is a decent niche. If you work with Postgres it's pleasant for the most part as well. I don't think the type of places hiring a "DBA" are typically high caliber employers, it tends to be a lot of enterprise type stuff, so I'd focus on being a software engineer/architect that just happens to lean heavily on the use of database features to accomplish your job rather than trying to specialize.
> If you work with Postgres it's pleasant for the most part as well.
I’ve schemed and schemed for years and still those Postgres-central jobs elude my grasp. Still dreaming. In my current job I go back and re-cast the solution in Postgres or SQLite in my spare time (typically really easy btw) but management isn’t interested in non-microsoft/non-oracle solutions.
