Period
to 22 February 2018

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

Online Transaction Processing (OLTP)
UK > England
6 months to
22 Feb 2018
Same period 2017 Same period 2016
Rank 946 855 902
Rank change year-on-year -91 +47 -47
Permanent jobs citing OLTP 222 311 362
As % of all permanent IT jobs advertised in England 0.13% 0.19% 0.18%
As % of the Database & Business Intelligence category 0.44% 0.63% 0.58%
Number of salaries quoted 185 228 269
England median annual salary £50,000 £52,500 £55,000
Median salary % change year-on-year -4.76% -4.55% +10.00%
10th Percentile £32,200 £36,600 £35,500
90th Percentile £80,000 £78,750 £77,500
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 50,516 49,541 62,725
As % of all permanent IT jobs advertised in England 30.66% 29.90% 31.78%
Number of salaries quoted 42,485 42,640 53,578
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £30,500 £30,000 £28,750
90th Percentile £78,750 £77,500 £75,000
UK median annual salary £49,000 £47,500 £45,500
% change year-on-year +3.16% +4.40% +1.11%

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 22 February 2018.

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 22 February 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
London -35 98 £56,250 -13.46% 22
Midlands +32 49 £50,000 +25.00% 3
East Midlands +34 39 £50,000 +35.14% 2
South East -64 32 £45,000 -14.29% 3
East of England -6 23 £45,000 -10.00% 1
North of England +7 18 £55,000 +12.82% 1
North West +2 12 £55,000 +10.00% 1
West Midlands +19 10 £34,000 -35.24% 1
Yorkshire +23 6 £55,000 +29.41%
South West -3 2 £41,250 -17.50% 1
OLTP
UK

For the 6 months to 22 February 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 across the England region with a requirement for OLTP.

1 157 (70.72%) SQL
2 129 (58.11%) SQL Server
3 109 (49.10%) OLAP
4 102 (45.95%) Business Intelligence
5 100 (45.05%) SQL Server Integration Services
6 93 (41.89%) Microsoft
7 90 (40.54%) SQL Server Reporting Services
8 89 (40.09%) Data Warehouse
9 82 (36.94%) ETL
9 82 (36.94%) SQL Server Analysis Services
10 81 (36.49%) T-SQL
11 66 (29.73%) Finance
12 64 (28.83%) Oracle
13 62 (27.93%) C#
14 61 (27.48%) Java
15 60 (27.03%) Agile Software Development
16 53 (23.87%) .NET
16 53 (23.87%) Power BI
17 52 (23.42%) MySQL
18 51 (22.97%) Microsoft Azure
19 47 (21.17%) NoSQL
20 45 (20.27%) Performance Tuning
20 45 (20.27%) Data Modelling
21 43 (19.37%) Advertising
22 41 (18.47%) Banking
23 38 (17.12%) Computer Science
23 38 (17.12%) MongoDB
24 36 (16.22%) Apache Cassandra
24 36 (16.22%) Degree
25 35 (15.77%) Linux

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 32 (14.41%) Elasticsearch
2 5 (2.25%) SharePoint
3 4 (1.80%) Apache
3 4 (1.80%) Apache Spark
3 4 (1.80%) SharePoint 2013
4 3 (1.35%) Apache Solr
4 3 (1.35%) JBoss
4 3 (1.35%) Oracle Application Server
5 2 (0.90%) Tomcat
6 1 (0.45%) IIS
6 1 (0.45%) SAS
6 1 (0.45%) WebLogic
Applications
1 9 (4.05%) Microsoft Excel
2 7 (3.15%) MS Visio
3 4 (1.80%) Microsoft PowerPoint
4 2 (0.90%) Microsoft Office
5 1 (0.45%) S-PLUS
Business Applications
1 3 (1.35%) Adobe Campaign
2 2 (0.90%) Remedy ITSM
3 1 (0.45%) Oracle Applications
Cloud Services
1 51 (22.97%) Microsoft Azure
2 29 (13.06%) Amazon AWS
3 3 (1.35%) SaaS
4 1 (0.45%) Amazon EMR
4 1 (0.45%) Amazon S3
4 1 (0.45%) GitHub
4 1 (0.45%) Office 365
Communications & Networking
1 12 (5.41%) Wireless
2 4 (1.80%) Firewall
2 4 (1.80%) Internet
3 3 (1.35%) DNS
3 3 (1.35%) HTTP
3 3 (1.35%) SSL
4 2 (0.90%) MPLS
4 2 (0.90%) SMS
4 2 (0.90%) VPLS
5 1 (0.45%) NAS
5 1 (0.45%) SAN
Database & Business Intelligence
1 129 (58.11%) SQL Server
2 109 (49.10%) OLAP
3 100 (45.05%) SQL Server Integration Services
4 90 (40.54%) SQL Server Reporting Services
5 89 (40.09%) Data Warehouse
6 82 (36.94%) SQL Server Analysis Services
7 53 (23.87%) Power BI
8 52 (23.42%) MySQL
9 47 (21.17%) NoSQL
10 38 (17.12%) MongoDB
11 36 (16.22%) Apache Cassandra
12 30 (13.51%) Oracle Database
12 30 (13.51%) Oracle OLAP
13 23 (10.36%) Relational Database
14 21 (9.46%) SQL Server 2008
15 16 (7.21%) SQL Server 2016
16 15 (6.76%) SQL Server 2012
17 12 (5.41%) DB2
17 12 (5.41%) Snowflake Schema
17 12 (5.41%) SQL Server 2014
Development Applications
1 32 (14.41%) SQL Server Management Studio (SSMS)
2 19 (8.56%) Team Foundation Server
3 12 (5.41%) Oracle Forms
4 11 (4.95%) ERwin
5 10 (4.50%) Git (software)
6 8 (3.60%) Jenkins
7 4 (1.80%) TeamCity
8 3 (1.35%) JIRA
8 3 (1.35%) Visual Studio
9 2 (0.90%) Visual Studio Team System
10 1 (0.45%) tSQLt
General
1 66 (29.73%) Finance
2 43 (19.37%) Advertising
3 41 (18.47%) Banking
4 16 (7.21%) Retail
5 14 (6.31%) Pharmaceutical
6 13 (5.86%) Retail Banking
7 7 (3.15%) Investment Banking
7 7 (3.15%) Law
8 5 (2.25%) Billing
9 4 (1.80%) Marketing
10 3 (1.35%) Back Office
10 3 (1.35%) Telecoms
11 2 (0.90%) Financial Institution
11 2 (0.90%) Front Office
11 2 (0.90%) General Ledger
11 2 (0.90%) Retail Finance
12 1 (0.45%) Electronics
12 1 (0.45%) Games
12 1 (0.45%) International Banking
12 1 (0.45%) Publishing
Job Titles
1 117 (52.70%) Developer
2 51 (22.97%) SQL Developer
3 40 (18.02%) DBA
4 35 (15.77%) Architect
5 25 (11.26%) Business Intelligence Developer
5 25 (11.26%) SQL DBA
6 21 (9.46%) Data Architect
7 20 (9.01%) Java Developer
8 18 (8.11%) SQL Server Developer
9 16 (7.21%) Senior Developer
10 15 (6.76%) C# Developer
10 15 (6.76%) Junior
11 14 (6.31%) Analyst
12 13 (5.86%) Machine Learning Developer
12 13 (5.86%) Oracle Developer
13 12 (5.41%) Administrator
13 12 (5.41%) C# Software Developer
13 12 (5.41%) Database Developer
13 12 (5.41%) SQL BI Developer
13 12 (5.41%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 53 (23.87%) .NET
2 33 (14.86%) WPF
3 26 (11.71%) Web Services
4 25 (11.26%) XML
5 20 (9.01%) ASP.NET
6 14 (6.31%) Oracle GoldenGate
7 13 (5.86%) ASP.NET MVC
8 12 (5.41%) WinForms
9 11 (4.95%) COM
10 10 (4.50%) HTML
10 10 (4.50%) MDX
10 10 (4.50%) REST
11 8 (3.60%) AngularJS
11 8 (3.60%) JSON
12 6 (2.70%) SOAP
12 6 (2.70%) STL
13 5 (2.25%) ASP.NET Web API
14 4 (1.80%) Middleware
15 2 (0.90%) WCF
16 1 (0.45%) SAML
Miscellaneous
1 38 (17.12%) Computer Science
2 23 (10.36%) Replication
3 19 (8.56%) Analytical Skills
4 14 (6.31%) Clustering
5 12 (5.41%) Life Science
5 12 (5.41%) PDA
6 10 (4.50%) Fintech
7 9 (4.05%) N-Tier
8 7 (3.15%) Data Structures
9 6 (2.70%) Hybrid Cloud
9 6 (2.70%) Taxonomies
10 5 (2.25%) Mainframe
11 4 (1.80%) Data Centre
11 4 (1.80%) HACMP
12 3 (1.35%) Contactless
12 3 (1.35%) EMV
12 3 (1.35%) EPoS
13 1 (0.45%) Client/Server
13 1 (0.45%) Enterprise Software
13 1 (0.45%) PKI
Operating Systems
1 35 (15.77%) Linux
2 33 (14.86%) Windows
3 23 (10.36%) Unix
4 8 (3.60%) Windows Server
5 7 (3.15%) Red Hat Enterprise Linux
5 7 (3.15%) Solaris
6 4 (1.80%) AIX
6 4 (1.80%) CentOS
6 4 (1.80%) Ubuntu
7 1 (0.45%) Windows 7
7 1 (0.45%) Windows Server 2008
Processes & Methodologies
1 102 (45.95%) Business Intelligence
2 82 (36.94%) ETL
3 60 (27.03%) Agile Software Development
4 45 (20.27%) Data Modelling
4 45 (20.27%) Performance Tuning
5 27 (12.16%) High Availability
5 27 (12.16%) Software Engineering
6 22 (9.91%) Kimball Methodology
6 22 (9.91%) Scrum
7 21 (9.46%) Logical Data Model
8 20 (9.01%) Database Tuning
8 20 (9.01%) ETL Development
8 20 (9.01%) Machine Learning
8 20 (9.01%) SDLC
9 17 (7.66%) Dimensional Modelling
10 16 (7.21%) Data Integration
10 16 (7.21%) MVC
11 15 (6.76%) Data Architecture
12 14 (6.31%) Master Data Management
12 14 (6.31%) Physical Data Model
Programming Languages
1 157 (70.72%) SQL
2 81 (36.49%) T-SQL
3 62 (27.93%) C#
4 61 (27.48%) Java
5 27 (12.16%) PowerShell
6 19 (8.56%) JavaScript
7 18 (8.11%) C++
8 16 (7.21%) PL/SQL
9 14 (6.31%) VB
10 11 (4.95%) VB6
11 8 (3.60%) Python
11 8 (3.60%) Shell Script
12 6 (2.70%) VBA
13 3 (1.35%) Perl
14 2 (0.90%) Bash Shell
14 2 (0.90%) C
14 2 (0.90%) Groovy
15 1 (0.45%) Data Analysis Expressions (DAX)
15 1 (0.45%) Korn
15 1 (0.45%) VBScript
Qualifications
1 36 (16.22%) Degree
2 32 (14.41%) Computer Science Degree
3 1 (0.45%) Master's Degree
3 1 (0.45%) OCP
3 1 (0.45%) Oracle Certification
3 1 (0.45%) PhD
Quality Assurance & Compliance
1 9 (4.05%) Data Quality
2 4 (1.80%) GDPR
2 4 (1.80%) PMO
2 4 (1.80%) QA
3 3 (1.35%) PCI DSS
3 3 (1.35%) PSD2
System Software
1 6 (2.70%) Docker
2 5 (2.25%) VMware Infrastructure
3 4 (1.80%) GPFS
3 4 (1.80%) Oracle RAC
4 1 (0.45%) Active Directory
4 1 (0.45%) Apache Flume
4 1 (0.45%) HDFS
4 1 (0.45%) Microsoft App-V
4 1 (0.45%) Virtual Machines
Systems Management
1 7 (3.15%) Ansible
2 5 (2.25%) Puppet
3 4 (1.80%) Failover Clustering
4 3 (1.35%) Galera Cluster
4 3 (1.35%) Opscode Chef
5 2 (0.90%) Netcool
5 2 (0.90%) Perfmon
5 2 (0.90%) Terraform
6 1 (0.45%) Hadoop YARN
6 1 (0.45%) Kubernetes
6 1 (0.45%) Microsoft Clustering
6 1 (0.45%) OpenView
6 1 (0.45%) SCCM
6 1 (0.45%) Systems Management Server (SMS)
6 1 (0.45%) Tivoli
Vendors
1 93 (41.89%) Microsoft
2 64 (28.83%) Oracle
3 12 (5.41%) Tableau
4 5 (2.25%) NetApp
4 5 (2.25%) VMware
5 4 (1.80%) EXASOL
5 4 (1.80%) Intel
6 3 (1.35%) Adobe
6 3 (1.35%) Apple
6 3 (1.35%) CA
6 3 (1.35%) Cisco
6 3 (1.35%) IBM
6 3 (1.35%) PayPal
6 3 (1.35%) Percona
6 3 (1.35%) Red Hat
6 3 (1.35%) Teradata
7 2 (0.90%) EMC
7 2 (0.90%) MetaSolv
7 2 (0.90%) Remedy
7 2 (0.90%) Sun