Key is optimization experience and compiling experience
Queries - Must know how queries run and how to compile
Stores procedures - Must have experience with optimizing stored procedures and views.
Both Data Modeling and Database Modeling experience
The contractor will be under the guidance and trained by the Developer, who is skilled in the DB. They have slow running processes, where queries/sub queries need to be optimizes. They have slow changing tables, reference tables, tables that are snapshots and multiple lower environment databases. It is a production environment with three databases, which includes staging, integration / data transformation into tables and a consumption database.
This job and many more are available through The Judge Group. Find us on the web at www.judge.com