Profession database developer

Database designers design, test and implement databases applying knowledge of database management systems, guarding the protection and security of the database.

Personality Type

• Investigative / Conventional

Tasks database developer

• Design database structure (logical data model) to meet user requirements.
• Assess feasibility and costs of the database, e.g. by performing an ICT project study.
• Program databases in computer languages such as Structured Query Language (SQL).
• Provide data for the database.
• Test databases.
• Develop user interfaces, e.g. by programming Internet applications.
• Maintain and adapt existing databases according to new user requirements and following developments in programming techniques.
• Make reports from database data.

Related professions databases

• Database administrator (dba)
• Database or network professional, all other

Knowledge

• Database development tools

  The methodologies and tools used for creating logical and physical structure of databases, such as logical data structures, diagrams, modelling methodologies and entity-relationships.

• Data storage

  The physical and technical concepts of how digital data storage is organised in specific schemes both locally, such as hard-drives and random-access memories (RAM) and remotely, via network, internet or cloud.

• Query languages

  The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.

• Resource description framework query language

  The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).

• Data quality assessment

  The process of revealing data issues using ​quality indicators, measures and metrics in order to plan data cleansing and data enrichment strategies according to data quality criteria.

• Database management systems

  The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.

• Data extraction, transformation and loading tools

  The tools for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure.

Skills

• Estimate duration of work

  Produce accurate calculations on time necessary to fulfil future technical tasks based on past and present information and observations or plan the estimated duration of individual tasks in a given project.

• Create data models

  Use specific techniques and methodologies to analyse the data requirements of an organisation's business processes in order to create models for these data, such as conceptual, logical and physical models. These models have a specific structure and format.

• Report analysis results

  Produce research documents or give presentations to report the results of a conducted research and analysis project, indicating the analysis procedures and methods which led to the results, as well as potential interpretations of the results.

• Test ICT queries

  Assess that developed queries return and execute correct actions and data.

• Interpret technical texts

  Read and understand technical texts that provide information on how to perform a task, usually explained in steps.

• Write database documentation

  Develop documentation containing information about the database that is relevant to end users.

• Identify customer requirements

  Apply techniques and tools, such as surveys, questionnaires, ICT applications, for eliciting, defining, analysing, documenting and maintaining user requirements from system, service or product.

• Collect customer feedback on applications

  Gather a response and analyse data from customers to identify requests or problems in order to improve applications and overall customer satisfaction.

• Perform backups

  Implement backup procedures to backup data and systems to ensure permanent and reliable system operation. Execute data backups in order to secure information by copying and archiving to ensure integrity during system integration and after data loss occurrence.

• Balance database resources

  Stabilise the workload and resources of a database, by controlling the demand of transactions, allocating disk spaces and ensuring reliability of the servers in order to optimise cost and risk ratio.

• Apply information security policies

  Implement policies, methods and regulations for data and information security in order to respect confidentiality, integrity and availability principles.

Optional knowledge and skills

Source: Sisyphus ODB