Table 1Transition record

big data archive librariantodatabase administrator

A big data archive librarian already meets 48% of what the database administrator role asks for. The move turns on 15 required skills not yet in the profile.

From big data archive librarian

48%

Overlap1

To database administrator

33 Skills carried over

15 Required, not held

63.2 Difficulty2

adjacent 0–30

moderate 30–55

substantial 55–75

career change 75–100

this move, 63.2

This move: 63.2 of 100 · substantial

1 Share of the database administrator role’s weighted skill requirement already met by the big data archive librarian 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 33 skills that carry over, these are the ones fewest other occupations ask for. A database administrator role needs them, and most people applying for one will not have them already. This is the part of a big data archive librarian background worth leading with.

Skill the target role also needs Area

already held maintain database performance working with computers
already held design database backup specifications communication, collaboration and creativity
already held maintain database security working with computers
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)

All 33 carried skills, including the 13 the database administrator role treats as required.

Table 3

Table 3 · What you would need to learn

The 34 missing skills fall into 6 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 8 required, 8 supplementary

required, not held administer ICT system required
required, not held balance database resources required
required, not held define database physical structure required
required, not held operate relational database management system required
required, not held use an application-specific interface required
required, not held use scripting programming required
required, not held perform ICT troubleshooting required
required, not held use databases required

optional, not held implement ICT security policies optional
optional, not held implement a firewall optional
optional, not held implement anti-virus software optional
optional, not held use automatic programming optional
optional, not held provide ICT support optional
optional, not held remove computer virus or malware from a computer optional
optional, not held use back-up and recovery tools optional
optional, not held use spreadsheets software optional

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

required, not held data storage required
required, not held distributed computing required
required, not held domain name service required
required, not held system backup best practice required

optional, not held online analytical processing optional
optional, not held data engineering optional

03 information skills 2 required, 3 supplementary

required, not held create data models required
required, not held interpret technical texts required

optional, not held execute ICT audits optional
optional, not held manage cloud data and storage optional
optional, not held estimate duration of work optional

04 assisting and caring 1 required, 1 supplementary

required, not held apply company policies required

optional, not held protect personal data and privacy optional

05 communication, collaboration and creativity 4 supplementary

optional, not held design database in the cloud optional
optional, not held support ICT system users optional
optional, not held provide technical training optional
optional, not held use different communication channels optional

06 business, administration and law 1 supplementary

optional, not held quality assurance methodologies optional

Table 4

Table 4 · Where to start

The 3 entries a database administrator 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 33 skills that carry over

Skill Type

already held data models knowledge
already held data quality assessment knowledge
already held database development tools knowledge
already held database management systems knowledge
already held design database backup specifications skill
already held design database scheme skill
already held information structure knowledge
already held maintain database performance skill
already held maintain database security skill
already held manage database skill
already held perform backups skill
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

19 supplementary skills, helpful but not required

Skill to acquire Tier

optional, not held design database in the cloud optional
optional, not held execute ICT audits optional
optional, not held implement ICT security policies optional
optional, not held implement a firewall optional
optional, not held implement anti-virus software optional
optional, not held manage cloud data and storage optional
optional, not held online analytical processing optional
optional, not held support ICT system users optional
optional, not held use automatic programming optional
optional, not held data engineering optional
optional, not held estimate duration of work optional
optional, not held protect personal data and privacy optional
optional, not held provide ICT support optional
optional, not held provide technical training optional
optional, not held quality assurance methodologies optional
optional, not held remove computer virus or malware from a computer optional
optional, not held use back-up and recovery tools optional
optional, not held use different communication channels optional
optional, not held use spreadsheets software optional

40 held skills the database administrator role does not ask for

Skill Type

not needed by the target role CA Datacom/DB knowledge
not needed by the target role IBM InfoSphere DataStage knowledge
not needed by the target role IBM InfoSphere Information Server knowledge
not needed by the target role Informatica PowerCenter knowledge
not needed by the target role Oracle Data Integrator knowledge
not needed by the target role Oracle Warehouse Builder knowledge
not needed by the target role Pentaho Data Integration knowledge
not needed by the target role QlikView Expressor knowledge
not needed by the target role SAP Data Services knowledge
not needed by the target role SAS Data Management knowledge
not needed by the target role SQL Server Integration Services knowledge
not needed by the target role analyse big data skill
not needed by the target role apply information security policies skill
not needed by the target role comply with legal regulations skill
not needed by the target role creatively use digital technologies skill
not needed by the target role data extraction, transformation and loading tools knowledge
not needed by the target role database knowledge
not needed by the target role develop ICT workflow skill
not needed by the target role digital curation knowledge
not needed by the target role digital data processing skill
not needed by the target role digitise documents skill
not needed by the target role digitization knowledge
not needed by the target role give live presentation skill
not needed by the target role identify technological needs skill
not needed by the target role information confidentiality knowledge
not needed by the target role integrate ICT data skill
not needed by the target role maintain data entry requirements skill
not needed by the target role manage ICT data classification skill
not needed by the target role manage archive users guidelines skill
not needed by the target role manage content metadata skill
not needed by the target role manage data skill
not needed by the target role manage data collection systems skill
not needed by the target role manage digital archives skill
not needed by the target role manage information access aids skill
not needed by the target role migrate existing data skill
not needed by the target role monitor technology trends skill
not needed by the target role normalise data skill
not needed by the target role statistics knowledge
not needed by the target role visual presentation techniques knowledge
not needed by the target role write database documentation skill

7 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 data storage required
required, not held distributed computing required
required, not held domain name service required
required, not held system backup best practice required
optional, not held online analytical processing optional
optional, not held data engineering optional
optional, not held quality assurance methodologies optional

Index

Other moves recorded from big data archive librarian

Full index of moves from big data archive librarian

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.