Career as database designer

Question

i am working as software developer in small company..but i found a interest in database as we have written entire logic in stored procedures...please suggest me is database is best area or application development or can be both