Piles are usually driven by?

In engeneering a "pile driver" refers to a machine which "drives" or pushes a pile into the ground, e.g. to create the foundation for a building.
A member of the constuction crew who operates the pile-driving machine can also be called a "pile driver".
So, either it's man or machine.