DataBase Developer (DBD)

Definition

Professional who designs and implements the databases of a software product

Competences developed

  • Ability to apply specific techniques of data processing, storage and administration
  • Ability to propose and evaluate different technological alternatives in order to solve a specific data management problem
  • Ability to work in a team

Activities performed

  • Appropriately carried out the stages of the database design process to obtain an efficient and high quality implementation
  • Applied the foundations of conceptual database design to appropriately represent the data models of the application with UML or ER diagrams based on the agreed requirements
  • Transformed the conceptual model of a DB design into a relational model in order to determine a normalized and relational logical design for DB building, according to the standards, and performed design and building with non-relational models
  • Appropriately interpreted and evaluated the physical structure for data storage of different DBMS
  • Adapted the logical design of a DB to a physical design for a specific DBMS
  • Determined the necessary and suitable indexes of the DB tables to improve the performance of the applications which use the DB
  • Used the mechanisms for query processing and optimisation of a DBMS
  • Used the views as external design elements to improve the global design of the DB
  • Appropriately interpreted the security mechanisms of a DBMS
  • Fluently used SQL language, programming connectors, database design and development tools, and also used other languages for DB building