Profession database developer

Database developers program, implement and coordinate changes to computer databases based on their expertise of database management systems.

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

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.

  • Query languages

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

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

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

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

  • Database management systems

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

Skills

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

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

  • Write database documentation

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

  • Interpret technical texts

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

  • Apply information security policies

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

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

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

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

  • Test ICT queries

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

Optional knowledge and skills

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

Common job titles

  • Sql developer/ etl developer
  • Sql developer
  • Junior sql/etl developer
  • Database developer
  • Database developer (intern - fall 2017)
  • Sql developer with c#