Must have worked on little bit on design (not mandatory)but should have created store procedures and tables from scratch. Must be aware about basic SQL queries which are used on day to day basis. Must be aware about Importing\exporting data from SQL Server (ETL activities),reporting can be advantage.