This is a very company specific job role. The companies using the Oracles services like KPMG, Accenture etc will have this kind of job roles.
Taking about the role they play in such company would be :
They are responsible for designing the architecture of the application using the Oracle Cloud.
They build the application and maintain the work flow of the application.
They are also responsible for configuring the applications to meet the business needs.