I have 10+ years of experience working with relational SQL databases. My work would normally include working closely with clients to get pretty good picture of what exactly they want to get, what areas are potential performance hits, what is their business process like. Once I get the idea I would normally start with database design: creating tables, indexes, stored procedures, views, functions to meet the development specifications