Profession database integrator

Database integrators perform integration among different databases. They maintain integration and ensure interoperability.

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

  • Conventional / Investigative

Related professions databases

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

Knowledge

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

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

  • ICT debugging tools

    The ICT tools used to test and debug programs and software code, such as GNU Debugger (GDB), Intel Debugger (IDB), Microsoft Visual Studio Debugger, Valgrind and WinDbg.

  • Query languages

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

  • Database management systems

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

  • Information structure

    The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.

Skills

  • Perform data cleansing

    Detect and correct corrupt records from data sets, ensure that the data become and remain structured according to guidelines.

  • Execute integration testing

    Perform testing of system or software components grouped in multiple ways to evaluate their ability to interconnect, their interface and their ability to provide global functionality.

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

  • Verify formal ICT specifications

    Check capabilities, correctness and efficiency of intended algorithm or system to match certain formal specifications.

  • Implement data warehousing techniques

    Apply models and tools such as online analytical processing (OLAP) and Online transaction processing (OLTP), to integrate structured or unstructured data from sources, in order to create a central depository of historical and current data.

  • Use interface description language

    Utilise specification language for describing interface connection among software components or programs in a programming-language-independent way. The languages which support this method are among others CORBA and WSDL.

  • Create database diagrams

    Develop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes.

  • Manage ICT legacy implication

    Oversee the transfer process from a legacy (an outdated system) to a current system by mapping, interfacing, migrating, documenting and transforming data.

  • Manage data

    Administer all types of data resources through their lifecycle by performing data profiling, parsing, standardisation, identity resolution, cleansing, enhancement and auditing. Ensure the data is fit for purpose, using specialised ICT tools to fulfil the data quality criteria.

  • Integrate ICT data

    Combine data from sources to provide unified view of the set of these data.

Optional knowledge and skills

ibm informix openedge database pentaho data integration create solutions to problems microsoft access ldap apply ict systems theory design application interfaces objectstore n1ql ibm infosphere datastage sql server systems theory write database documentation linq db2 systems development life-cycle execute ict audits manage ict semantic integration mysql perform data mining oracle warehouse builder informatica powercenter postgresql sap data services qlikview expressor xquery ca datacom/db oracle relational database business intelligence filemaker (database management systems) sql server integration services database ibm infosphere information server define integration strategy define data quality criteria sparql oracle data integrator teradata database use scripting programming mdx perform project management