Yes. In a fairly large public company I worked at, I remember a DBA on contract got fired because he knew absolutely nothing.
But only a few weeks later he was back, in the same building, but using a different name on a different floor working as a Senior Software Architect.
He got caught because someone in the DB department recognized him, called him by his old name and they pretended they never new him.