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.