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