Career Overlap Transition record Edition 1 · ESCO v1.2.1
Table 1Transition record

database designertosoftware architect

A database designer already meets 54% of what the software architect role asks for. The move turns on 13 required skills not yet in the profile.

From database designer
54%
Overlap1
To software architect
56 Skills carried over
13 Required, not held
58.9 Difficulty2
adjacent 0–30
moderate 30–55
substantial 55–75
career change 75–100
this move, 58.9

This move: 58.9 of 100 · substantial

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

Skill the target role also needs Area
  • already held systems theory information and communication technologies (icts)
  • already held apply ICT systems theory working with computers
  • already held design database scheme communication, collaboration and creativity
  • already held design database in the cloud communication, collaboration and creativity
  • already held create software design communication, collaboration and creativity
  • already held web programming information and communication technologies (icts)

All 56 carried skills, including the 6 the software architect role treats as required.

Table 3

Table 3 · What you would need to learn

The 33 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 information and communication technologies (icts) 4 required, 9 supplementary
  • required, not held object-oriented modelling required
  • required, not held system design required
  • required, not held tools for software configuration management required
  • required, not held unified modelling language required
  • optional, not held Ansible optional
  • optional, not held Apache Maven optional
  • optional, not held Jenkins (tools for software configuration management) optional
  • optional, not held Puppet (tools for software configuration management) optional
  • optional, not held SPARK optional
  • optional, not held STAF optional
  • optional, not held Salt (tools for software configuration management) optional
  • optional, not held WildFly optional
  • optional, not held task algorithmisation optional
02 working with computers 3 required, 6 supplementary
  • required, not held align software with system architectures required
  • required, not held analyse software specifications required
  • required, not held use an application-specific interface required
  • optional, not held develop software prototype optional
  • optional, not held do cloud refactoring optional
  • optional, not held implement data warehousing techniques optional
  • optional, not held use query languages optional
  • optional, not held utilise computer-aided software engineering tools optional
  • optional, not held perform ICT troubleshooting optional
03 communication, collaboration and creativity 3 required, 2 supplementary
  • required, not held define software architecture required
  • required, not held create flowchart diagram required
  • required, not held design process required
  • optional, not held design cloud architecture optional
  • optional, not held provide ICT consulting advice optional
04 information skills 2 required, 1 supplementary
  • required, not held collect customer feedback on applications required
  • required, not held provide cost benefit analysis reports required
  • optional, not held perform risk analysis optional
05 management skills 1 required, 1 supplementary
  • required, not held oversee development of software required
  • optional, not held manage staff optional
06 engineering, manufacturing and construction 1 supplementary
  • optional, not held security engineering optional
Table 4

Table 4 · Where to start

The 3 entries a software architect 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 56 skills that carry over
Skill Type
  • already held analyse business requirements skill
  • already held build business relationships skill
  • already held business process modelling knowledge
  • already held create software design skill
  • already held define technical requirements skill
  • already held systems development life-cycle knowledge
  • already held ABAP knowledge
  • already held AJAX knowledge
  • already held APL knowledge
  • already held ASP.NET knowledge
  • already held Agile project management knowledge
  • already held Assembly (computer programming) knowledge
  • already held C# knowledge
  • already held C++ knowledge
  • already held COBOL knowledge
  • already held CoffeeScript knowledge
  • already held Common Lisp knowledge
  • already held Erlang knowledge
  • already held Groovy knowledge
  • already held Haskell knowledge
  • already held ICT project management methodologies knowledge
  • already held ICT security legislation knowledge
  • already held Java (computer programming) knowledge
  • already held JavaScript knowledge
  • already held Lisp knowledge
  • already held MATLAB knowledge
  • already held ML (computer programming) knowledge
  • already held Microsoft Visual C++ knowledge
  • already held Objective-C knowledge
  • already held OpenEdge Advanced Business Language knowledge
  • already held PHP knowledge
  • already held Pascal (computer programming) knowledge
  • already held Perl knowledge
  • already held Process-based management knowledge
  • already held Prolog (computer programming) knowledge
  • already held Python (computer programming) knowledge
  • already held R knowledge
  • already held Ruby (computer programming) knowledge
  • already held SAP R3 knowledge
  • already held SAS language knowledge
  • already held Scala knowledge
  • already held Scratch (computer programming) knowledge
  • already held Smalltalk (computer programming) knowledge
  • already held Swift (computer programming) knowledge
  • already held TypeScript knowledge
  • already held VBScript knowledge
  • already held Visual Basic knowledge
  • already held apply ICT systems theory skill
  • already held computer programming knowledge
  • already held design database in the cloud skill
  • already held design database scheme skill
  • already held lean project management knowledge
  • already held perform resource planning skill
  • already held systems theory knowledge
  • already held use markup languages skill
  • already held web programming knowledge
20 supplementary skills, helpful but not required
Skill to acquire Tier
  • optional, not held Ansible optional
  • optional, not held Apache Maven optional
  • optional, not held Jenkins (tools for software configuration management) optional
  • optional, not held Puppet (tools for software configuration management) optional
  • optional, not held SPARK optional
  • optional, not held STAF optional
  • optional, not held Salt (tools for software configuration management) optional
  • optional, not held WildFly optional
  • optional, not held design cloud architecture optional
  • optional, not held develop software prototype optional
  • optional, not held do cloud refactoring optional
  • optional, not held implement data warehousing techniques optional
  • optional, not held provide ICT consulting advice optional
  • optional, not held use query languages optional
  • optional, not held utilise computer-aided software engineering tools optional
  • optional, not held manage staff optional
  • optional, not held perform ICT troubleshooting optional
  • optional, not held perform risk analysis optional
  • optional, not held security engineering optional
  • optional, not held task algorithmisation optional
47 held skills the software architect role does not ask for
Skill Type
  • not needed by the target role CA Datacom/DB knowledge
  • not needed by the target role DB2 knowledge
  • not needed by the target role Filemaker (database management systems) knowledge
  • not needed by the target role IBM Informix knowledge
  • not needed by the target role LDAP knowledge
  • not needed by the target role LINQ knowledge
  • not needed by the target role MDX knowledge
  • not needed by the target role MarkLogic knowledge
  • not needed by the target role Microsoft Access knowledge
  • not needed by the target role MySQL knowledge
  • not needed by the target role N1QL knowledge
  • not needed by the target role ObjectStore knowledge
  • not needed by the target role OpenEdge Database knowledge
  • not needed by the target role Oracle Relational Database knowledge
  • not needed by the target role Oracle WebLogic knowledge
  • not needed by the target role PostgreSQL knowledge
  • not needed by the target role SPARQL knowledge
  • not needed by the target role SQL Server knowledge
  • not needed by the target role Teradata Database knowledge
  • not needed by the target role TripleStore knowledge
  • not needed by the target role XQuery knowledge
  • not needed by the target role apply technical communication skills skill
  • not needed by the target role assess ICT knowledge skill
  • not needed by the target role create data sets skill
  • not needed by the target role create database diagrams skill
  • not needed by the target role data engineering knowledge
  • not needed by the target role data models knowledge
  • not needed by the target role data science knowledge
  • not needed by the target role database knowledge
  • not needed by the target role database development tools knowledge
  • not needed by the target role database management systems 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 develop automated migration methods skill
  • not needed by the target role information structure knowledge
  • not needed by the target role manage cloud data and storage skill
  • not needed by the target role manage database skill
  • not needed by the target role manage standards for data exchange skill
  • not needed by the target role migrate existing data skill
  • not needed by the target role operate relational database management system skill

7 further entries not listed here

14 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 object-oriented modelling required
  • required, not held system design required
  • required, not held tools for software configuration management required
  • required, not held unified modelling language required
  • optional, not held Ansible optional
  • optional, not held Apache Maven optional
  • optional, not held Jenkins (tools for software configuration management) optional
  • optional, not held Puppet (tools for software configuration management) optional
  • optional, not held SPARK optional
  • optional, not held STAF optional
  • optional, not held Salt (tools for software configuration management) optional
  • optional, not held WildFly optional
  • optional, not held security engineering optional
  • optional, not held task algorithmisation optional
Index
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.