In my experience outside of enterprise oracle type places it's just a label. You still work on service level code, you also work on architecture, you also do infrastructure and monitoring and really all the stuff. From the places I've worked that aren't red tape bound the title really just means "we need someone who we can give a business problem to and they will solve it in an efficient way without needing a full team or re inventing wheels, and we need to be sure it's going to keep making money for us with stability". All the other rigor is just job description fluff to attract talent.