Profession database developer

  • Shutterstock.com
    database developer

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

Would you like to know what kind of career and professions suit you best? Take our free Holland code career test and find out.

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

  • 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.

  • 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.

  • Query languages

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

  • 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.

  • 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.

Skills

  • Test ICT queries

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

  • 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.

  • 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.

  • 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.

  • 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.

  • Apply information security policies

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

  • 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.

  • 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.

  • 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.

  • 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.

Optional knowledge and skills

javascript assembly (computer programming) pentaho data integration matlab qlikview expressor db2 python (computer programming) sap data services create solutions to problems cobol ict power consumption execute integration testing r oracle relational database address problems critically mysql objectstore visual studio .net oracle warehouse builder abap oracle data integrator informatica powercenter common lisp ibm informix asp.net use software design patterns sql server microsoft visual c++ c# ajax ml (computer programming) ruby (computer programming) php execute software tests haskell ca datacom/db sas language sql server integration services mdx vbscript computer programming filemaker (database management systems) scratch (computer programming) smalltalk (computer programming) perl postgresql sparql execute analytical mathematical calculations scala apl integrate system components linq execute ict audits microsoft access c++ verify formal ict specifications pascal (computer programming) ict infrastructure teradata database objective-c coffeescript groovy n1ql ldap hardware architectures sap r3 ibm infosphere information server typescript xquery prolog (computer programming) openedge advanced business language openedge database manage business knowledge perform data mining identify ict security risks java (computer programming) swift (computer programming) erlang ibm infosphere datastage lisp