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.
- Conventional / Investigative
- 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.
- Information structure
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.
- 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.
- 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).
- Integrate ICT data
Combine data from sources to provide unified view of the set of these data.
- 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.
- 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.
- Perform data cleansing
Detect and correct corrupt records from data sets, ensure that the data become and remain structured according to guidelines.
- 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.
- Verify formal ICT specifications
Check capabilities, correctness and efficiency of intended algorithm or system to match certain formal specifications.
- 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.
- 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.
- 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.
Optional knowledge and skillsdb2 systems development life-cycle ca datacom/db sparql objectstore xquery oracle relational database use scripting programming ibm informix ldap oracle warehouse builder write database documentation perform project management execute ict audits pentaho data integration mysql database openedge database n1ql mdx ibm infosphere datastage ibm infosphere information server business intelligence sql server define integration strategy oracle data integrator define data quality criteria filemaker systems theory perform data mining informatica powercenter manage ict semantic integration create solutions to problems teradata database design application interfaces postgresql microsoft access linq apply ict systems theory qlikview expressor sql server integration services sap data services
Common job titles
- Database / python programmer
- Data/database engineer (dbe)
- Data engineer
- Enterprise data architect
- Database administrator job
- Data governance specialist
- Senior data warehouse engineer
- Operations data analyst
- Pl/sql developer
- Database administrator - ts/sci