Well, it does depend company to company, but in a lot of places the role is or includes coming up with innovative ideas and to be smart in choosing which ones to implement.
Did someone say innovative database? PG-Strom with PostgreSQL under the hood (what else?) exists since over 4 years: https://github.com/heterodb/pg-strom
