Table 1Transition record

database administratortodatabase integrator

A database administrator already meets 42% of what the database integrator role asks for. The move turns on 11 required skills not yet in the profile.

From database administrator

42%

Overlap1

To database integrator

30 Skills carried over

11 Required, not held

67 Difficulty2

adjacent 0–30

moderate 30–55

substantial 55–75

career change 75–100

this move, 67

This move: 67 of 100 · substantial

1 Share of the database integrator role’s weighted skill requirement already met by the database administrator profile. Required skills count in full, supplementary skills at 0.35. Directional: the figure for the reverse move differs. 2 Combines what is missing with how specialised it is, so a gap of general skills scores easier than the same number of narrow ones.

Table 2

Table 2 · What you already bring

Of the 30 skills that carry over, these are the ones fewest other occupations ask for. A database integrator role needs them, and most people applying for one will not have them already. This is the part of a database administrator background worth leading with.

Skill the target role also needs Area

already held balance database resources working with computers
already held domain name service information and communication technologies (icts)
already held MarkLogic information and communication technologies (icts)
already held TripleStore information and communication technologies (icts)
already held Oracle Relational Database information and communication technologies (icts)
already held Filemaker (database management systems) information and communication technologies (icts)

All 30 carried skills, including the 6 the database integrator role treats as required.

Table 3

Table 3 · What you would need to learn

The 37 missing skills fall into 5 areas of the ESCO skill hierarchy, numbered below in the order worth working in: the areas carrying the most required skills come first, and inside each one the required skills sit above the supplementary ones.

Skill to acquire Tier

01 working with computers 6 required, 3 supplementary

required, not held use interface description language required
required, not held execute integration testing required
required, not held implement data warehousing techniques required
required, not held integrate ICT data required
required, not held manage ICT legacy implication required
required, not held perform data cleansing required

optional, not held apply ICT systems theory optional
optional, not held manage ICT semantic integration optional
optional, not held perform data mining optional

02 information and communication technologies (icts) 2 required, 17 supplementary

required, not held ICT debugging tools required
required, not held data extraction, transformation and loading tools required

optional, not held CA Datacom/DB optional
optional, not held IBM InfoSphere DataStage optional
optional, not held IBM InfoSphere Information Server optional
optional, not held Informatica PowerCenter optional
optional, not held Oracle Data Integrator optional
optional, not held Oracle Warehouse Builder optional
optional, not held Pentaho Data Integration optional
optional, not held QlikView Expressor optional
optional, not held SAP Data Services optional
optional, not held SAS Data Management optional
optional, not held SQL Server Integration Services optional
optional, not held inter-organisational middleware system optional
optional, not held system design optional
optional, not held systems theory optional
optional, not held database optional
optional, not held digital systems optional
optional, not held systems development life-cycle optional

03 information skills 2 required

required, not held manage data required
required, not held verify formal ICT specifications required

04 communication, collaboration and creativity 1 required, 4 supplementary

required, not held create database diagrams required

optional, not held define integration strategy optional
optional, not held design application interfaces optional
optional, not held write database documentation optional
optional, not held create solutions to problems optional

05 management skills 2 supplementary

optional, not held define data quality criteria optional
optional, not held perform project management optional

Table 4

Table 4 · Where to start

The 3 entries a database integrator role is least likely to hire without. The ordering is computed from the skill data, not from what pays.

Each entry opens a course search for that skill. Career Overlap earns nothing from these links.

Appendix

Appendix · The rest of the record

All 30 skills that carry over

Skill Type

already held balance database resources skill
already held database management systems knowledge
already held domain name service knowledge
already held information structure knowledge
already held query languages knowledge
already held resource description framework query language knowledge
already held DB2 knowledge
already held Filemaker (database management systems) knowledge
already held IBM Informix knowledge
already held LDAP knowledge
already held LINQ knowledge
already held MDX knowledge
already held MarkLogic knowledge
already held Microsoft Access knowledge
already held MySQL knowledge
already held N1QL knowledge
already held ObjectStore knowledge
already held OpenEdge Database knowledge
already held Oracle Relational Database knowledge
already held PostgreSQL knowledge
already held SPARQL knowledge
already held SQL Server knowledge
already held Teradata Database knowledge
already held TripleStore knowledge
already held XQuery knowledge
already held business intelligence knowledge
already held data engineering knowledge
already held execute ICT audits skill
already held manage cloud data and storage skill
already held use scripting programming skill

26 supplementary skills, helpful but not required

Skill to acquire Tier

optional, not held CA Datacom/DB optional
optional, not held IBM InfoSphere DataStage optional
optional, not held IBM InfoSphere Information Server optional
optional, not held Informatica PowerCenter optional
optional, not held Oracle Data Integrator optional
optional, not held Oracle Warehouse Builder optional
optional, not held Pentaho Data Integration optional
optional, not held QlikView Expressor optional
optional, not held SAP Data Services optional
optional, not held SAS Data Management optional
optional, not held SQL Server Integration Services optional
optional, not held apply ICT systems theory optional
optional, not held define data quality criteria optional
optional, not held define integration strategy optional
optional, not held design application interfaces optional
optional, not held inter-organisational middleware system optional
optional, not held manage ICT semantic integration optional
optional, not held perform data mining optional
optional, not held system design optional
optional, not held systems theory optional
optional, not held write database documentation optional
optional, not held create solutions to problems optional
optional, not held database optional
optional, not held digital systems optional
optional, not held perform project management optional
optional, not held systems development life-cycle optional

37 held skills the database integrator role does not ask for

Skill Type

not needed by the target role administer ICT system skill
not needed by the target role apply company policies skill
not needed by the target role create data models skill
not needed by the target role data models knowledge
not needed by the target role data quality assessment knowledge
not needed by the target role data storage knowledge
not needed by the target role database development tools knowledge
not needed by the target role define database physical structure skill
not needed by the target role design database backup specifications skill
not needed by the target role design database in the cloud skill
not needed by the target role design database scheme skill
not needed by the target role distributed computing knowledge
not needed by the target role estimate duration of work skill
not needed by the target role implement ICT security policies skill
not needed by the target role implement a firewall skill
not needed by the target role implement anti-virus software skill
not needed by the target role interpret technical texts skill
not needed by the target role maintain database performance skill
not needed by the target role maintain database security skill
not needed by the target role manage database skill
not needed by the target role online analytical processing knowledge
not needed by the target role operate relational database management system skill
not needed by the target role perform ICT troubleshooting skill
not needed by the target role perform backups skill
not needed by the target role protect personal data and privacy skill
not needed by the target role provide ICT support skill
not needed by the target role provide technical training skill
not needed by the target role quality assurance methodologies knowledge
not needed by the target role remove computer virus or malware from a computer skill
not needed by the target role support ICT system users skill
not needed by the target role system backup best practice knowledge
not needed by the target role use an application-specific interface skill
not needed by the target role use automatic programming skill
not needed by the target role use back-up and recovery tools skill
not needed by the target role use databases skill
not needed by the target role use different communication channels skill
not needed by the target role use spreadsheets software skill

19 gaps that are knowledge rather than practice

Knowledge gaps usually close through study. Practical skill gaps usually need something you can point at.

Skill to acquire Tier

required, not held ICT debugging tools required
required, not held data extraction, transformation and loading tools required
optional, not held CA Datacom/DB optional
optional, not held IBM InfoSphere DataStage optional
optional, not held IBM InfoSphere Information Server optional
optional, not held Informatica PowerCenter optional
optional, not held Oracle Data Integrator optional
optional, not held Oracle Warehouse Builder optional
optional, not held Pentaho Data Integration optional
optional, not held QlikView Expressor optional
optional, not held SAP Data Services optional
optional, not held SAS Data Management optional
optional, not held SQL Server Integration Services optional
optional, not held inter-organisational middleware system optional
optional, not held system design optional
optional, not held systems theory optional
optional, not held database optional
optional, not held digital systems optional
optional, not held systems development life-cycle optional

Index

Other moves recorded from database administrator

Full index of moves from database administrator

Note

How this record was compiled

Both occupations are taken from ESCO, which lists the skills and knowledge each occupation is expected to have and marks every one required or optional. Nothing here is a prediction about hiring, and nothing here knows that a particular employer wants a particular certificate. Treat Table 3 as a starting point for your own research rather than a syllabus. The full method states what these figures can and cannot tell you.