Yes, it is possible to shift your career from a support role to an Oracle DBA Engineer. However, it will need effort, patience, and training. Here are some steps you can follow to make the transition:
Note that changing occupations takes time. If you are interested in pursuing a career with then I would suggest you to take up this oracle rac certification training from Intellipaat. This program help you to become a certified professional with all the required skills.
Along with that have a look at this video on how Intellipaat helped Abhishek to switch his career from support role to oracle dba engineer.