Database design and structure

Main responsibilities are:

Define the overall structure of the database.
Create all the tables in sql server that needs to be used for storing data
Create all stored procedures for CRUD.
SQL jobs for cleaning database by removing junk data e.g. logs