Database design is one of the most common topics asked in interviews for application design/development positions. Your answer should mix your design skills with tool experience and cover the database design lifecycle.
“I have hands-on skills and experience in database design and data modeling. In previous jobs I have worked as the technical lead to design large scale database systems in Oracle, Sybase, and Microsoft SQL Server. I have experience in several database design tools such as Oracle Designer, PowerDesigner, and ERWin. Using these tools I collected and documented user requirements, analyzed business rules and entities, created entity relationship diagrams, designed logical database based on the ERD, and generated SQL scripts to build the physical database., and configured the database server and setup the database. I also used database design tools to reverse-engineer existing database when necessary. Database design tools are very helpful for me to automate many tasks through the database design lifecycle, but in many cases I still need to fine-tune the design manually. I also have experience in using design tools to create data repository for meta data management. In one of my jobs I worked as the repository administrator responsible for building and maintaining Oracle data repository in Oracle Designer for our term members to work together in a common data design platform through database design phases. ”
0 Comments.