I think you are correct - there will always be a need for a (or at least one) sysadmin.

But what cloud services allow us to do these days is scale services without the friction of requisitioning new hardware that used to happen in the past.

Of course, your sysadmin needs to be familiar with tools to help them manage large numbers of servers before this really begins to matter.