It may be less popular for new projects, but every single project/product/service that's using Oracle DB is gonna continue to use, and hire, Oracle DBA for the foreseeable future.

Sure, if you're learning SQL or a technology to market yourself, Oracle DB might not be the best time investment. However, if you're already an expert in that, you shouldn't have trouble finding a role somewhere.