Period
to 7 December 2019

The following table provides summary statistics for permanent job vacancies with a requirement for OLTP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLTP over the 6 months to 7 December 2019 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK
6 months to
7 Dec 2019
Same period 2018 Same period 2017
Rank 921 963 963
Rank change year-on-year +42 0 -100
Permanent jobs citing OLTP 136 187 255
As % of all permanent IT jobs advertised in the UK 0.10% 0.12% 0.14%
As % of the Database & Business Intelligence category 0.38% 0.40% 0.47%
Number of salaries quoted 121 140 192
UK median annual salary £70,000 £56,250 £50,000
Median salary % change year-on-year +24.44% +12.50% -
10th Percentile £36,575 £37,500 £31,250
90th Percentile £81,250 £72,875 £82,375
UK excluding London median annual salary £52,500 £52,250 £45,000
% change year-on-year +0.48% +16.11% -10.00%

OLTP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 35,691 46,312 54,087
As % of all permanent IT jobs advertised in the UK 26.85% 28.84% 30.22%
Number of salaries quoted 29,477 38,126 44,580
UK median annual salary £52,500 £50,000 £48,000
Median salary % change year-on-year +5.00% +4.17% +1.05%
10th Percentile £31,750 £31,250 £30,000
90th Percentile £87,500 £85,000 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

OLTP
Job Vacancy Trend

Job postings citing OLTP as a percentage of all IT jobs advertised.

Job vacancy trend for OLTP in the UK

OLTP
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP.

Salary trend for OLTP in the UK

OLTP
Salary Histogram

The salary distribution of IT jobs citing OLTP over the 6 months to 7 December 2019.

Salary histogram for OLTP in the UK

OLTP
Top 12 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK over the 6 months to 7 December 2019. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +54 125 £72,000 +25.22% 18
UK excluding London +59 69 £52,500 +0.48% 13
London +61 64 £75,000 +20.00% 9
East of England +79 26 £75,000 +12.36% 2
South East +41 18 £57,500 +4.55% 5
Midlands +19 15 £37,426 -21.62%
Scotland +21 8 £52,500 +30.84% 5
West Midlands +18 8 £37,050 -7.38%
East Midlands +19 7 £92,500 +92.71%
North of England +22 1 - -
South West +8 1 £67,500 +33.66% 1
North West -2 1 - -

For the 6 months to 7 December 2019, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for OLTP.

1 104 (76.47%) SQL Server
2 99 (72.79%) SQL
3 85 (62.50%) Microsoft
4 76 (55.88%) Data Warehouse
5 70 (51.47%) AWS
6 67 (49.26%) Azure
7 62 (45.59%) T-SQL
8 59 (43.38%) Agile Software Development
9 47 (34.56%) Business Intelligence
10 46 (33.82%) OLAP
11 41 (30.15%) ETL
12 39 (28.68%) Finance
12 39 (28.68%) PostgreSQL
13 34 (25.00%) SQL Server Integration Services
14 30 (22.06%) Data Modelling
14 30 (22.06%) Analytical Skills
15 29 (21.32%) SQL Server Reporting Services
16 28 (20.59%) Linux
16 28 (20.59%) SDLC
17 27 (19.85%) Big Data
18 26 (19.12%) Data Integration
19 24 (17.65%) Python
19 24 (17.65%) E-Commerce
19 24 (17.65%) Unix
19 24 (17.65%) Relational Database
19 24 (17.65%) Power BI
19 24 (17.65%) Amazon Aurora
19 24 (17.65%) Power Platform
20 23 (16.91%) SQL Server Analysis Services
21 21 (15.44%) Oracle

OLTP
Co-occurring IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 13 (9.56%) Apache Spark
2 2 (1.47%) Apache Pig
3 1 (0.74%) SharePoint
Applications
1 4 (2.94%) Microsoft Excel
Business Applications
1 3 (2.21%) OPENHousing
2 2 (1.47%) Oracle Applications
3 1 (0.74%) Oracle EBS
3 1 (0.74%) Oracle Financials
Cloud Services
1 70 (51.47%) AWS
2 67 (49.26%) Azure
3 24 (17.65%) Power Platform
4 15 (11.03%) Azure Data Factory
5 11 (8.09%) GCP
6 5 (3.68%) Azure Stack
6 5 (3.68%) PaaS
7 2 (1.47%) IaaS
8 1 (0.74%) Amazon S3
8 1 (0.74%) Cloud Computing
8 1 (0.74%) SaaS
8 1 (0.74%) Serverless
Communications & Networking
1 5 (3.68%) Internet
2 2 (1.47%) LAN
2 2 (1.47%) SAN
2 2 (1.47%) WAN
3 1 (0.74%) DMZ
3 1 (0.74%) DNS
3 1 (0.74%) Kerberos
Database & Business Intelligence
1 104 (76.47%) SQL Server
2 76 (55.88%) Data Warehouse
3 46 (33.82%) OLAP
4 39 (28.68%) PostgreSQL
5 34 (25.00%) SQL Server Integration Services
6 29 (21.32%) SQL Server Reporting Services
7 27 (19.85%) Big Data
8 24 (17.65%) Amazon Aurora
8 24 (17.65%) Power BI
8 24 (17.65%) Relational Database
9 23 (16.91%) SQL Server Analysis Services
10 20 (14.71%) Amazon RDS
10 20 (14.71%) SQL Server 2016
11 19 (13.97%) Enterprise Data Warehouse
11 19 (13.97%) Hadoop
12 16 (11.76%) NoSQL
13 13 (9.56%) Apache Hive
13 13 (9.56%) RDBMS
14 12 (8.82%) Data Lake
14 12 (8.82%) Impala
Development Applications
1 11 (8.09%) ERwin
1 11 (8.09%) PowerDesigner
2 10 (7.35%) ER Studio
3 6 (4.41%) Visual Studio
4 2 (1.47%) Oracle Forms
5 1 (0.74%) JIRA
5 1 (0.74%) SQL Server Management Studio (SSMS)
5 1 (0.74%) Team Foundation Server
General
1 39 (28.68%) Finance
2 8 (5.88%) Advertising
3 6 (4.41%) Retail
4 3 (2.21%) Automotive
4 3 (2.21%) Banking
4 3 (2.21%) Social Housing
5 2 (1.47%) Law
5 2 (1.47%) Legal
6 1 (0.74%) Games
6 1 (0.74%) Investment Banking
6 1 (0.74%) Public Sector
Job Titles
1 56 (41.18%) DBA
2 33 (24.26%) SQL DBA
3 29 (21.32%) Developer
4 26 (19.12%) Administrator
5 24 (17.65%) Architect
6 14 (10.29%) Business Intelligence Developer
7 13 (9.56%) Data Architect
8 12 (8.82%) SQL Developer
8 12 (8.82%) SQL Server DBA
9 11 (8.09%) Database Engineer
10 10 (7.35%) Hadoop Architect
10 10 (7.35%) Senior Developer
11 8 (5.88%) Senior Business Intelligence Developer
12 7 (5.15%) Business Developer
12 7 (5.15%) Technical Architect
13 6 (4.41%) Data Engineer
14 5 (3.68%) AWS Administrator
14 5 (3.68%) Azure Administrator
14 5 (3.68%) Cloud Architect
14 5 (3.68%) Consultant
Libraries, Frameworks & Software Standards
1 15 (11.03%) Web Services
2 13 (9.56%) Kafka
3 10 (7.35%) .NET
4 2 (1.47%) ASP.NET Web API
4 2 (1.47%) JSON
4 2 (1.47%) MDX
4 2 (1.47%) XML
5 1 (0.74%) Apache Beam
5 1 (0.74%) COM
5 1 (0.74%) FIX Protocol
5 1 (0.74%) Pandas
5 1 (0.74%) SciPy
Miscellaneous
1 30 (22.06%) Analytical Skills
2 17 (12.50%) Replication
3 6 (4.41%) Greenfield Project
4 5 (3.68%) Clustering
4 5 (3.68%) Data Centre
5 4 (2.94%) Cloud Native
5 4 (2.94%) Data Structures
5 4 (2.94%) Public Cloud
5 4 (2.94%) Self-Motivation
6 2 (1.47%) Management Information System
7 1 (0.74%) CMDB
7 1 (0.74%) Driving Licence
7 1 (0.74%) Foreign Exchange (FX)
7 1 (0.74%) Online Games
7 1 (0.74%) Reference Data
Operating Systems
1 28 (20.59%) Linux
2 24 (17.65%) Unix
3 11 (8.09%) Windows
4 3 (2.21%) Solaris
5 2 (1.47%) Windows Server
Processes & Methodologies
1 59 (43.38%) Agile Software Development
2 47 (34.56%) Business Intelligence
3 41 (30.15%) ETL
4 30 (22.06%) Data Modelling
5 28 (20.59%) SDLC
6 26 (19.12%) Data Integration
7 24 (17.65%) E-Commerce
8 21 (15.44%) Disaster Recovery
9 18 (13.24%) Analytics
9 18 (13.24%) Data Engineering
9 18 (13.24%) Performance Tuning
9 18 (13.24%) Problem-Solving
9 18 (13.24%) Statistics
10 15 (11.03%) Data Protection
10 15 (11.03%) ITIL
10 15 (11.03%) Performance Optimisation
10 15 (11.03%) Problem Management
10 15 (11.03%) Root Cause Analysis
10 15 (11.03%) Task Automation
11 14 (10.29%) Visualisation
Programming Languages
1 99 (72.79%) SQL
2 62 (45.59%) T-SQL
3 24 (17.65%) Python
4 14 (10.29%) Shell Script
5 7 (5.15%) PL/SQL
6 6 (4.41%) Java
7 4 (2.94%) C#
8 3 (2.21%) Data Analysis Expressions (DAX)
8 3 (2.21%) PowerShell
9 1 (0.74%) R
9 1 (0.74%) Scala
Qualifications
1 12 (8.82%) Degree
2 4 (2.94%) Computer Science Degree
3 3 (2.21%) Microsoft Certification
4 1 (0.74%) AWS Certification
4 1 (0.74%) Master's Degree
4 1 (0.74%) Security Cleared
Quality Assurance & Compliance
1 16 (11.76%) SLA
2 8 (5.88%) GDPR
3 6 (4.41%) Data Quality
4 3 (2.21%) QA
4 3 (2.21%) Sarbanes-Oxley
System Software
1 14 (10.29%) Apache Flume
2 10 (7.35%) HDFS
3 3 (2.21%) Docker
3 3 (2.21%) Hyper-V
3 3 (2.21%) VMware Infrastructure
4 1 (0.74%) Active Directory
4 1 (0.74%) Oracle Clusterware
4 1 (0.74%) Oracle RAC
Systems Management
1 15 (11.03%) Foglight
1 15 (11.03%) LiteSpeed
2 12 (8.82%) Oozie
3 10 (7.35%) SCOM
4 3 (2.21%) Kubernetes
4 3 (2.21%) NetBackup
5 1 (0.74%) Data Guard
5 1 (0.74%) Oracle RMAN
Vendors
1 85 (62.50%) Microsoft
2 21 (15.44%) Oracle
3 14 (10.29%) Google
4 7 (5.15%) Databricks
4 7 (5.15%) Tableau
5 5 (3.68%) Cloudera
5 5 (3.68%) MuleSoft
6 3 (2.21%) Capita
6 3 (2.21%) Sun
6 3 (2.21%) Teradata
6 3 (2.21%) VMware
7 1 (0.74%) Informatica
7 1 (0.74%) NetApp
7 1 (0.74%) RedGate