Period
to 12 December 2017

The following table provides summary statistics for permanent job vacancies advertised in England 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 12 December 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK > England
6 months to
12 Dec 2017
Same period 2016 Same period 2015
Rank 921 834 836
Rank change year-on-year -87 +2 -24
Permanent jobs citing OLTP 250 353 457
As % of all permanent IT jobs advertised in England 0.15% 0.20% 0.23%
As % of the Database & Business Intelligence category 0.49% 0.68% 0.72%
Number of salaries quoted 190 262 328
England median annual salary £50,000 £52,500 £55,000
Median salary % change year-on-year -4.76% -4.55% +10.00%
10th Percentile £31,250 £33,750 £36,900
90th Percentile £82,625 £73,500 £76,625
UK median annual salary £50,000 £52,500 £55,000
% change year-on-year -4.76% -4.55% +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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 50811 52269 63440
As % of all permanent IT jobs advertised in England 30.24% 29.73% 31.51%
Number of salaries quoted 42262 45104 54145
England median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £30,000 £29,685 £28,750
90th Percentile £77,500 £77,500 £75,000
UK median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% +2.27%

OLTP
Job Vacancy Trend in England

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

Job vacancy trend for OLTP in England

OLTP
Salary Trend in England

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

Salary trend for OLTP in England

OLTP
Salary Histogram in England

The salary distribution of IT jobs citing OLTP in England over the 6 months to 12 December 2017.

Salary histogram for OLTP in England

OLTP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the England region over the 6 months to 12 December 2017. 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
London -21 118 £60,000 - 10
Midlands +34 49 £50,000 +33.33% 2
East Midlands +31 39 £50,000 +49.25% 1
East of England +3 31 £40,000 -20.00% 2
South East -38 26 £45,000 -14.29%
North of England -1 17 £55,000 +4.76% 2
North West -14 11 £50,000 -4.76%
West Midlands +24 10 £36,250 -27.50% 1
South West -15 8 £32,500 -35.00% 1
Yorkshire +22 6 £67,500 -15.63% 2
OLTP
UK

For the 6 months to 12 December 2017, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the England region with a requirement for OLTP.

1 183 (73.20%) SQL
2 158 (63.20%) SQL Server
3 120 (48.00%) OLAP
4 106 (42.40%) ETL
5 104 (41.60%) Data Warehouse
6 100 (40.00%) Oracle
7 99 (39.60%) Microsoft
8 86 (34.40%) Business Intelligence
9 79 (31.60%) SQL Server Integration Services
9 79 (31.60%) Performance Tuning
10 78 (31.20%) T-SQL
11 77 (30.80%) MySQL
12 70 (28.00%) SQL Server Analysis Services
12 70 (28.00%) SQL Server Reporting Services
13 69 (27.60%) Finance
13 69 (27.60%) Java
14 66 (26.40%) Agile Software Development
15 57 (22.80%) C#
16 56 (22.40%) Oracle Database
17 51 (20.40%) .NET
18 48 (19.20%) PL/SQL
18 48 (19.20%) Linux
19 47 (18.80%) Degree
19 47 (18.80%) MongoDB
20 45 (18.00%) NoSQL
21 44 (17.60%) Oracle OLAP
22 42 (16.80%) Amazon AWS
22 42 (16.80%) Kimball Methodology
23 40 (16.00%) Microsoft Azure
24 38 (15.20%) Data Modelling

OLTP
Co-occurring IT Skills in England 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 26 (10.40%) Elasticsearch
2 6 (2.40%) Apache Spark
3 5 (2.00%) SharePoint
4 4 (1.60%) Apache
4 4 (1.60%) SharePoint 2013
5 1 (0.40%) IIS
5 1 (0.40%) JBoss
5 1 (0.40%) Oracle SOA Suite
5 1 (0.40%) Tomcat
5 1 (0.40%) WebLogic
Applications
1 13 (5.20%) MS Visio
2 10 (4.00%) Microsoft Excel
3 4 (1.60%) Microsoft PowerPoint
4 1 (0.40%) S-PLUS
Business Applications
1 1 (0.40%) Adobe Campaign
1 1 (0.40%) Dynamics CRM
1 1 (0.40%) Oracle Applications
1 1 (0.40%) Remedy ITSM
Cloud Services
1 42 (16.80%) Amazon AWS
2 40 (16.00%) Microsoft Azure
3 7 (2.80%) GitHub
4 2 (0.80%) Amazon EMR
4 2 (0.80%) Amazon S3
4 2 (0.80%) Google Cloud Platform
5 1 (0.40%) Office 365
5 1 (0.40%) Slack
Communications & Networking
1 20 (8.00%) Wireless
2 5 (2.00%) DNS
2 5 (2.00%) Firewall
2 5 (2.00%) SAN
3 4 (1.60%) Extranet
3 4 (1.60%) HTTP
3 4 (1.60%) Internet
3 4 (1.60%) Intranet
4 2 (0.80%) MPLS
4 2 (0.80%) SMS
4 2 (0.80%) VPLS
5 1 (0.40%) NAS
Database & Business Intelligence
1 158 (63.20%) SQL Server
2 120 (48.00%) OLAP
3 104 (41.60%) Data Warehouse
4 79 (31.60%) SQL Server Integration Services
5 77 (30.80%) MySQL
6 70 (28.00%) SQL Server Analysis Services
6 70 (28.00%) SQL Server Reporting Services
7 56 (22.40%) Oracle Database
8 47 (18.80%) MongoDB
9 45 (18.00%) NoSQL
10 44 (17.60%) Oracle OLAP
11 36 (14.40%) Relational Database
12 33 (13.20%) SQL Server 2008
13 32 (12.80%) Apache Cassandra
14 30 (12.00%) DB2
14 30 (12.00%) Power BI
15 27 (10.80%) SQL Server 2014
16 24 (9.60%) Oracle ODI
17 20 (8.00%) OLAP Cube
17 20 (8.00%) SQL Server 2016
Development Applications
1 23 (9.20%) Team Foundation Server
2 20 (8.00%) Oracle Forms
3 18 (7.20%) SQL Server Management Studio (SSMS)
4 15 (6.00%) Git (software)
4 15 (6.00%) Jenkins
5 11 (4.40%) JIRA
6 7 (2.80%) Octopus Deploy
7 6 (2.40%) tSQLt
7 6 (2.40%) Visual Studio
8 2 (0.80%) ERwin
8 2 (0.80%) Talend Open Studio
9 1 (0.40%) TeamCity
General
1 69 (27.60%) Finance
2 36 (14.40%) Banking
3 33 (13.20%) Advertising
4 21 (8.40%) Pharmaceutical
5 18 (7.20%) Retail
6 15 (6.00%) Retail Banking
7 13 (5.20%) Investment Banking
8 6 (2.40%) Law
9 2 (0.80%) General Ledger
9 2 (0.80%) Marketing
9 2 (0.80%) Retail Finance
9 2 (0.80%) Telecoms
10 1 (0.40%) Electronics
10 1 (0.40%) International Banking
10 1 (0.40%) Legal
Job Titles
1 127 (50.80%) Developer
2 47 (18.80%) SQL Developer
3 45 (18.00%) DBA
4 28 (11.20%) Business Intelligence Developer
4 28 (11.20%) SQL DBA
5 27 (10.80%) Oracle Developer
6 22 (8.80%) Architect
6 22 (8.80%) Data Warehouse Developer
6 22 (8.80%) Oracle Data Warehouse Developer
7 21 (8.40%) C# Developer
8 20 (8.00%) SQL Server DBA
9 19 (7.60%) Administrator
10 17 (6.80%) C# Software Developer
11 16 (6.40%) ETL Developer
12 15 (6.00%) Analyst
13 13 (5.20%) SQL Server Developer
14 12 (4.80%) Junior
14 12 (4.80%) MySQL DBA
15 11 (4.40%) SQL BI Developer
16 10 (4.00%) SSIS Developer
Libraries, Frameworks & Software Standards
1 51 (20.40%) .NET
2 37 (14.80%) Web Services
3 33 (13.20%) XML
4 28 (11.20%) Oracle GoldenGate
5 27 (10.80%) ASP.NET
6 23 (9.20%) ASP.NET MVC
7 21 (8.40%) WinForms
8 19 (7.60%) WPF
9 18 (7.20%) COM
9 18 (7.20%) MDX
10 15 (6.00%) HTML
11 10 (4.00%) JSON
12 8 (3.20%) AngularJS
13 7 (2.80%) STL
14 5 (2.00%) RESTful
15 4 (1.60%) Kafka
16 2 (0.80%) ASP.NET Web API
16 2 (0.80%) REST
16 2 (0.80%) Velocity
16 2 (0.80%) WCF
Miscellaneous
1 37 (14.80%) Computer Science
1 37 (14.80%) Replication
2 24 (9.60%) Analytical Skills
3 20 (8.00%) PDA
4 13 (5.20%) Fintech
4 13 (5.20%) Life Science
5 7 (2.80%) Clustering
6 5 (2.00%) Foreign Exchange (FX)
6 5 (2.00%) Mainframe
6 5 (2.00%) N-Tier
7 4 (1.60%) Data Centre
7 4 (1.60%) HACMP
8 2 (0.80%) Data Protection Act
8 2 (0.80%) Data Structures
8 2 (0.80%) Derivative
8 2 (0.80%) Linux Command Line
8 2 (0.80%) OTC Derivatives
8 2 (0.80%) Reference Data
9 1 (0.40%) PKI
9 1 (0.40%) Taxonomies
Operating Systems
1 48 (19.20%) Linux
2 36 (14.40%) Windows
3 34 (13.60%) Unix
4 7 (2.80%) Red Hat Enterprise Linux
4 7 (2.80%) Solaris
5 4 (1.60%) AIX
5 4 (1.60%) Ubuntu
5 4 (1.60%) Windows Server
6 1 (0.40%) Windows 7
6 1 (0.40%) Windows Server 2008
Processes & Methodologies
1 106 (42.40%) ETL
2 86 (34.40%) Business Intelligence
3 79 (31.60%) Performance Tuning
4 66 (26.40%) Agile Software Development
5 42 (16.80%) Kimball Methodology
6 38 (15.20%) Data Modelling
7 35 (14.00%) ETL Development
7 35 (14.00%) Software Engineering
8 33 (13.20%) Dimensional Modelling
9 31 (12.40%) Database Tuning
10 27 (10.80%) Data Transformation
11 24 (9.60%) Disaster Recovery
11 24 (9.60%) High Availability
12 23 (9.20%) ITIL
12 23 (9.20%) MVC
13 22 (8.80%) Scrum
14 19 (7.60%) Machine Learning
15 17 (6.80%) DevOps
16 16 (6.40%) Logical Data Model
16 16 (6.40%) SDLC
Programming Languages
1 183 (73.20%) SQL
2 78 (31.20%) T-SQL
3 69 (27.60%) Java
4 57 (22.80%) C#
5 48 (19.20%) PL/SQL
6 24 (9.60%) JavaScript
7 22 (8.80%) C++
8 20 (8.00%) PowerShell
9 19 (7.60%) VB
10 18 (7.20%) VB6
11 12 (4.80%) Python
12 10 (4.00%) Shell Script
13 8 (3.20%) Data Analysis Expressions (DAX)
14 5 (2.00%) VB.NET
14 5 (2.00%) VBScript
15 3 (1.20%) Bash Shell
15 3 (1.20%) C
15 3 (1.20%) VBA
16 2 (0.80%) PHP
17 1 (0.40%) Perl
Qualifications
1 47 (18.80%) Degree
2 30 (12.00%) Computer Science Degree
3 12 (4.80%) Microsoft Certification
4 7 (2.80%) MCITP
4 7 (2.80%) MCSE
5 6 (2.40%) Oracle Certification
6 2 (0.80%) Linux+ Certification
7 1 (0.40%) OCP
7 1 (0.40%) PhD
Quality Assurance & Compliance
1 12 (4.80%) QA
2 11 (4.40%) Data Quality
3 4 (1.60%) PMO
4 2 (0.80%) GDPR
4 2 (0.80%) SLA
System Software
1 12 (4.80%) Oracle RAC
2 5 (2.00%) VMware Infrastructure
3 4 (1.60%) Apache Flume
3 4 (1.60%) GPFS
4 2 (0.80%) Active Directory
4 2 (0.80%) HDFS
4 2 (0.80%) Virtual Machines
5 1 (0.40%) Docker
5 1 (0.40%) Microsoft App-V
Systems Management
1 16 (6.40%) Ansible
2 8 (3.20%) Perfmon
3 4 (1.60%) Failover Clustering
4 3 (1.20%) NetBackup
4 3 (1.20%) Red Hat Satellite
5 2 (0.80%) Galera Cluster
5 2 (0.80%) Hadoop YARN
5 2 (0.80%) Microsoft Clustering
5 2 (0.80%) Oracle Enterprise Manager
5 2 (0.80%) Oracle RMAN
5 2 (0.80%) Systems Management Server (SMS)
6 1 (0.40%) Kubernetes
6 1 (0.40%) Netcool
6 1 (0.40%) OpenView
6 1 (0.40%) Opscode Chef
6 1 (0.40%) SCCM
6 1 (0.40%) Tivoli
Vendors
1 100 (40.00%) Oracle
2 99 (39.60%) Microsoft
3 13 (5.20%) RedGate
4 9 (3.60%) Tableau
5 5 (2.00%) NetApp
5 5 (2.00%) Red Hat
5 5 (2.00%) VMware
6 4 (1.60%) EXASOL
6 4 (1.60%) Intel
7 3 (1.20%) Teradata
7 3 (1.20%) Veritas
8 2 (0.80%) Cloudera
8 2 (0.80%) Google
8 2 (0.80%) IBM
8 2 (0.80%) Informatica
8 2 (0.80%) Percona
8 2 (0.80%) Sun
8 2 (0.80%) Talend
8 2 (0.80%) TSYS
9 1 (0.40%) Remedy