Overall, No matter what version oracle is, Oracle is not user friendly and not easy to adopt for web development and other apps. Its hard to learn, administer and develop against application. Specially for new comers it would be hell to learn. I think Oracle should focus on how to make things easy for users vs software it self.
Thanks for the information. can you please elaborate on the licencing of 19c . What cost benefit we get if we migrate to 19c PDBs from standalone 12c/11g DB
The direction of Oracle is to move to Multitenant architecture. This means that a single standalone database will just become a PDB. I dont know when this will happen but rumor has it around v21. It would help you prepare for this if you migrate sooner.
I have been an Oracle DBA for over 20 years and I have seen the evolution of Oracle. I can confidently say that the Oracle DBA jobs and responsibility will not go away. However, it will change. You need to be flexible to change and always keep an eye and ear toward evolving technology and Oracle's direction to be successful in the field. I understand where you may have come to that conclusion but you should know the full picture. There are several technologies (Cloud, Autonomous, ASSM, SPM) that lend to automatic self management of many normal DBA tasks but most of them are tedious tasks that most DBAs will tell you "good riddance". DBAs will continue to be needed for database performance tuning especially for Massive databases (terabyte and petabyte sizes). Also, installation, setup, security and backup and recovery. Generally speaking, the DBA tasks and responsibilities may eventually go a way but new DBA tasks and responsibilities will appear in its place. Be agile, don't be stationary, keep learning and keep moving forward is my advise. However that is good advise in any job.