I think it's mostly been answered. Between editing the Administrator usergroup, and the things Lynne mentioned, that's what you have control over. You don't have to worry about the database because an admin won't have access to that unless you give it explicitly in the config.php (unless the site is in debug mode, then they might have access, I'm not sure).

The problem is that the permissions aren't as fine grained as you want. For example, I think to keep an admin from seeing any ips or emails, you probably need to take away "Can Administer Users" (and even then I'm not 100% sure there isn't some other place to see it). As for not permanently deleting anything, you might have to take away "Can Administer Threads" and "Can Administer Forums", which will take away a lot of other things as well. Also you'd want "Can Administer Plugins" to be No, for obvious reasons.

Really sounds like you want a super moderator, not an administrator.

can he see IP addresses and manage plugins?

IP's: only if you give him permission to, via moderator permissions
No plugins.