I've been an Oracle Database Administrator handling databases and exadata, data guard, performance tuning (not so great at it), little bit of Oracle Cloud Infrastructure as well and typical DBA tasks including tablespace reorganization, migrations, etc. for the last 3 years.
Now I'm thinking about transitioning into a Data Engineer/Data Analyst roles as it seems it is having a more lucrative future ahead.
I'm good at doing DBA things but I'm doubtful about this considering the future scope of this as there isn't much a DBA has to do in databases as most of the work is handled by Database itself but I have an interest in it and getting calls from other companies as well for the same role.
Is DBA a really good career option considering the future and the compensation?
Or exploring or gaining skills in data engineering/analyst has more benefit?
Also, what would be the best among Data Engineer/Data Analyst/AI,ML Engineer?