in addition to db administration, now I always use
case tools to model data.then create DB,relations, triggers and procedures
and keep data integrality
I have developed some large database systems which is used in a large site company.