Period
to 13 December 2018

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 13 December 2018 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK
6 months to
13 Dec 2018
Same period 2017 Same period 2016
Rank 946 948 872
Rank change year-on-year +2 -76 -28
Permanent jobs citing OLTP 187 258 363
As % of all permanent IT jobs advertised in the UK 0.12% 0.14% 0.20%
As % of the Database & Business Intelligence category 0.41% 0.47% 0.66%
Number of salaries quoted 139 195 263
UK median annual salary £55,000 £50,000 £51,700
Median salary % change year-on-year +10.00% -3.29% -6.00%
10th Percentile £37,500 £31,250 £33,250
90th Percentile £73,250 £82,000 £73,250
UK excluding London median annual salary £52,000 £45,000 £50,000
% change year-on-year +15.56% -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 45,998 54,445 55,069
As % of all permanent IT jobs advertised in the UK 28.80% 30.30% 29.79%
Number of salaries quoted 37,790 44,893 47,090
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £29,000
90th Percentile £85,000 £77,500 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.25%

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 13 December 2018.

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 13 December 2018. 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 -21 180 £57,500 +15.00% 22
UK excluding London +16 101 £52,000 +15.56% 16
London +28 82 £62,500 +4.17% 9
North of England +59 36 £47,500 -13.64% 5
North West +42 36 £47,500 -5.00% 3
South East +20 26 £55,000 +22.22% 2
Midlands +8 20 £47,750 -4.50% 2
East of England +12 13 £67,500 +68.75% 3
East Midlands -5 13 £48,000 -4.00% 1
West Midlands +16 7 £40,000 +10.34% 1
Scotland +5 5 £40,125 -5.59% 3
South West +7 1 £50,500 +55.38% 1

For the 6 months to 13 December 2018, 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 145 (77.54%) SQL
2 117 (62.57%) SQL Server
3 103 (55.08%) Data Warehouse
4 87 (46.52%) SQL Server Integration Services
5 71 (37.97%) Microsoft
6 70 (37.43%) T-SQL
7 61 (32.62%) Business Intelligence
8 57 (30.48%) SQL Server Reporting Services
8 57 (30.48%) Relational Database
9 56 (29.95%) Agile Software Development
10 53 (28.34%) OLAP
11 52 (27.81%) Performance Tuning
12 50 (26.74%) Degree
13 49 (26.20%) Oracle
14 45 (24.06%) ETL
15 43 (22.99%) Data Modelling
15 43 (22.99%) MongoDB
16 39 (20.86%) NoSQL
17 38 (20.32%) Finance
18 37 (19.79%) SQL Server 2008
19 34 (18.18%) Java
19 34 (18.18%) SQL Server 2012
20 32 (17.11%) SQL Server Analysis Services
21 31 (16.58%) ITIL
21 31 (16.58%) Big Data
22 30 (16.04%) Microsoft Azure
22 30 (16.04%) SQL Server 2014
22 30 (16.04%) IT Strategy
23 28 (14.97%) MySQL
24 27 (14.44%) PL/SQL

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 23 (12.30%) Apache Spark
2 10 (5.35%) Apache
3 7 (3.74%) Apache Pig
3 7 (3.74%) SharePoint
4 5 (2.67%) SAS
4 5 (2.67%) Tomcat
5 4 (2.14%) Oracle Application Server
6 3 (1.60%) Oracle Workflow
6 3 (1.60%) WebLogic
7 2 (1.07%) Cloud Foundry
7 2 (1.07%) GemFire
7 2 (1.07%) IIS
8 1 (0.53%) Apache Solr
8 1 (0.53%) Jupyter
8 1 (0.53%) OpenStack
Applications
1 17 (9.09%) Microsoft Excel
2 8 (4.28%) MS Visio
3 4 (2.14%) Microsoft PowerPoint
4 1 (0.53%) Microsoft Office
4 1 (0.53%) SPSS
Business Applications
1 6 (3.21%) Oracle EBS
1 6 (3.21%) Oracle Retail
2 2 (1.07%) SAP Business One
3 1 (0.53%) Oracle AML
Cloud Services
1 30 (16.04%) Microsoft Azure
2 14 (7.49%) PaaS
3 11 (5.88%) Amazon AWS
4 10 (5.35%) SaaS
5 7 (3.74%) GitHub
6 4 (2.14%) Azure Data Factory
7 3 (1.60%) IaaS
7 3 (1.60%) Office 365
8 1 (0.53%) Apigee
8 1 (0.53%) Azure Active Directory
8 1 (0.53%) Azure Machine Learning
8 1 (0.53%) Boomi
8 1 (0.53%) Data Lake Analytics
8 1 (0.53%) iPaaS
Communications & Networking
1 12 (6.42%) Firewall
2 11 (5.88%) Internet
3 5 (2.67%) SAN
4 1 (0.53%) DNS
Database & Business Intelligence
1 117 (62.57%) SQL Server
2 103 (55.08%) Data Warehouse
3 87 (46.52%) SQL Server Integration Services
4 57 (30.48%) Relational Database
4 57 (30.48%) SQL Server Reporting Services
5 53 (28.34%) OLAP
6 43 (22.99%) MongoDB
7 39 (20.86%) NoSQL
8 37 (19.79%) SQL Server 2008
9 34 (18.18%) SQL Server 2012
10 32 (17.11%) SQL Server Analysis Services
11 31 (16.58%) Big Data
12 30 (16.04%) SQL Server 2014
13 28 (14.97%) MySQL
14 26 (13.90%) Hadoop
14 26 (13.90%) Power BI
15 23 (12.30%) Oracle Database
15 23 (12.30%) Oracle OLAP
16 22 (11.76%) Snowflake Schema
17 21 (11.23%) Apache Hive
Development Applications
1 13 (6.95%) Gradle
2 11 (5.88%) Cucumber
3 10 (5.35%) Git (software)
4 9 (4.81%) ERwin
5 6 (3.21%) Oracle APEX
5 6 (3.21%) PVCS
5 6 (3.21%) Toad
6 4 (2.14%) JIRA
7 3 (1.60%) Jenkins
8 2 (1.07%) Eclipse
8 2 (1.07%) ER Studio
8 2 (1.07%) JUnit
8 2 (1.07%) SQL Server Management Studio (SSMS)
8 2 (1.07%) Subversion
9 1 (0.53%) Maven
9 1 (0.53%) Visual Studio
9 1 (0.53%) Visual Studio Team System
General
1 38 (20.32%) Finance
2 15 (8.02%) Retail
3 13 (6.95%) Banking
4 10 (5.35%) Retail Banking
5 9 (4.81%) Games
6 8 (4.28%) Marketing
7 6 (3.21%) Advertising
7 6 (3.21%) Publishing
8 5 (2.67%) Back Office
8 5 (2.67%) Corporate Banking
8 5 (2.67%) Financial Institution
9 4 (2.14%) Investment Banking
10 3 (1.60%) Law
11 2 (1.07%) Billing
11 2 (1.07%) Spanish Language
Job Titles
1 51 (27.27%) DBA
2 50 (26.74%) Developer
3 37 (19.79%) SQL DBA
4 26 (13.90%) Administrator
5 24 (12.83%) Architect
6 19 (10.16%) Data Architect
7 16 (8.56%) Analyst
8 15 (8.02%) Software Engineer
9 13 (6.95%) Data Warehouse Developer
10 11 (5.88%) Disaster Recovery Analyst
10 11 (5.88%) Oracle Developer
10 11 (5.88%) SQL Developer
11 10 (5.35%) Consultant
11 10 (5.35%) Senior Developer
12 9 (4.81%) Business Intelligence Architect
12 9 (4.81%) Oracle Data Warehouse Developer
13 8 (4.28%) SQL Server DBA
14 7 (3.74%) Business Intelligence Consultant
14 7 (3.74%) Java Engineer
14 7 (3.74%) Microsoft Consultant
Libraries, Frameworks & Software Standards
1 22 (11.76%) Kafka
2 21 (11.23%) Web Services
3 18 (9.63%) XML
4 16 (8.56%) .NET
5 14 (7.49%) JSON
5 14 (7.49%) Spring Boot
6 11 (5.88%) RESTful
7 9 (4.81%) Oracle GoldenGate
8 8 (4.28%) Spark Streaming
9 6 (3.21%) Spring
10 5 (2.67%) J2EE
10 5 (2.67%) RabbitMQ
11 3 (1.60%) ASP.NET
11 3 (1.60%) HTML
12 2 (1.07%) MDX
12 2 (1.07%) Middleware
12 2 (1.07%) Spring Batch
12 2 (1.07%) Spring Integration
13 1 (0.53%) D3.js
13 1 (0.53%) OAuth
Miscellaneous
1 17 (9.09%) Greenfield Project
2 15 (8.02%) N-Tier
3 14 (7.49%) Analytical Skills
4 13 (6.95%) Data Centre
5 12 (6.42%) Clustering
6 10 (5.35%) Replication
7 7 (3.74%) HACMP
8 6 (3.21%) Enterprise Software
8 6 (3.21%) Management Information System
9 5 (2.67%) Reference Data
10 4 (2.14%) Hybrid Cloud
10 4 (2.14%) Online Games
10 4 (2.14%) Tandem
11 3 (1.60%) Data Structures
11 3 (1.60%) Fintech
11 3 (1.60%) Mainframe
11 3 (1.60%) Public Cloud
11 3 (1.60%) User Experience
11 3 (1.60%) Virtual Team
12 2 (1.07%) Derivative
Operating Systems
1 24 (12.83%) Linux
1 24 (12.83%) Unix
1 24 (12.83%) Windows
2 23 (12.30%) Windows Server
3 10 (5.35%) Red Hat Enterprise Linux
4 8 (4.28%) AIX
5 7 (3.74%) Solaris
6 1 (0.53%) CentOS
6 1 (0.53%) Debian
6 1 (0.53%) Oracle Linux
6 1 (0.53%) SUSE
Processes & Methodologies
1 61 (32.62%) Business Intelligence
2 56 (29.95%) Agile Software Development
3 52 (27.81%) Performance Tuning
4 45 (24.06%) ETL
5 43 (22.99%) Data Modelling
6 31 (16.58%) ITIL
7 30 (16.04%) IT Strategy
8 25 (13.37%) Server Building
9 23 (12.30%) Dimensional Modelling
10 22 (11.76%) Data Management
10 22 (11.76%) Technical Leadership
11 21 (11.23%) Scrum
11 21 (11.23%) Software Engineering
12 19 (10.16%) ETL Development
12 19 (10.16%) Microservices
12 19 (10.16%) Problem-Solving
13 17 (9.09%) Analytics
13 17 (9.09%) Kimball Methodology
13 17 (9.09%) Visualisation
14 16 (8.56%) Data Integration
Programming Languages
1 145 (77.54%) SQL
2 70 (37.43%) T-SQL
3 34 (18.18%) Java
4 27 (14.44%) PL/SQL
5 19 (10.16%) Python
6 16 (8.56%) PowerShell
7 12 (6.42%) C#
7 12 (6.42%) Shell Script
8 9 (4.81%) R
9 6 (3.21%) Scala
10 2 (1.07%) Bash Shell
11 1 (0.53%) C++
11 1 (0.53%) Java 8
11 1 (0.53%) JavaScript
11 1 (0.53%) Perl
11 1 (0.53%) PHP
11 1 (0.53%) Ruby
Qualifications
1 50 (26.74%) Degree
2 26 (13.90%) Microsoft Certification
3 8 (4.28%) Security Cleared
4 1 (0.53%) CEH
4 1 (0.53%) MCITP
4 1 (0.53%) MCSE
4 1 (0.53%) PMI Certification
4 1 (0.53%) RHCE
4 1 (0.53%) RHCSA
4 1 (0.53%) SC Cleared
4 1 (0.53%) TOGAF Certification
Quality Assurance & Compliance
1 10 (5.35%) QA
2 4 (2.14%) Data Quality
2 4 (2.14%) PMO
System Software
1 13 (6.95%) Docker
2 12 (6.42%) HDFS
2 12 (6.42%) Virtual Machines
3 10 (5.35%) Apache Flume
4 8 (4.28%) Apache ZooKeeper
4 8 (4.28%) VMware Infrastructure
5 7 (3.74%) GPFS
6 2 (1.07%) Oracle RAC
7 1 (0.53%) Active Directory
Systems Management
1 4 (2.14%) Data Guard
1 4 (2.14%) Oozie
2 3 (1.60%) Terraform
3 2 (1.07%) Ansible
3 2 (1.07%) Consul
3 2 (1.07%) Kubernetes
3 2 (1.07%) Puppet
4 1 (0.53%) Ambari
4 1 (0.53%) Nagios
4 1 (0.53%) Opscode Chef
4 1 (0.53%) Oracle Enterprise Manager
4 1 (0.53%) Salt
Vendors
1 71 (37.97%) Microsoft
2 49 (26.20%) Oracle
3 25 (13.37%) Tableau
4 11 (5.88%) Intel
5 10 (5.35%) SAP
6 8 (4.28%) VMware
7 7 (3.74%) NetApp
8 6 (3.21%) Cloudera
8 6 (3.21%) Hortonworks
8 6 (3.21%) MapR
9 5 (2.67%) EXASOL
9 5 (2.67%) Red Hat
9 5 (2.67%) Teradata
10 4 (2.14%) Informatica
11 3 (1.60%) Alteryx
12 2 (1.07%) Google
13 1 (0.53%) Axway
13 1 (0.53%) Percona
13 1 (0.53%) Serena
13 1 (0.53%) TIBCO