Period
to 20 October 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 20 October 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK > England
6 months to
20 Oct 2017
Same period 2016 Same period 2015
Rank 900 845 829
Rank change year-on-year -55 -16 -40
Permanent jobs citing OLTP 251 366 474
As % of all permanent IT jobs advertised in England 0.15% 0.20% 0.23%
As % of the Database & Business Intelligence category 0.51% 0.69% 0.73%
Number of salaries quoted 179 260 324
England median annual salary £50,000 £50,000 £55,000
Median salary % change year-on-year - -9.09% +10.00%
10th Percentile £31,000 £33,750 £35,000
90th Percentile £82,750 £76,250 £74,625
UK median annual salary £50,000 £50,000 £54,500
% change year-on-year - -8.26% +9.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 49622 53327 65280
As % of all permanent IT jobs advertised in England 30.36% 29.60% 31.64%
Number of salaries quoted 41158 45907 55528
England median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £30,000 £28,750 £28,063
90th Percentile £77,500 £76,750 £75,000
UK median annual salary £48,000 £47,500 £45,000
% change year-on-year +1.05% +5.56% -

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 20 October 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 20 October 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 -4 118 £62,500 +13.64% 6
Midlands +41 44 £35,500 -5.33% 5
East of England +17 36 £40,000 -13.51% 1
East Midlands +38 34 £35,500 +5.97% 3
South East -24 24 £50,000 - 1
North of England -7 16 £55,000 +4.76%
South West 0 11 £32,500 -35.00%
West Midlands +24 10 £43,750 -7.89% 2
North West -19 9 £52,500 -
Yorkshire +28 7 £67,500 -15.63%
OLTP
UK

For the 6 months to 20 October 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 188 (74.90%) SQL
2 152 (60.56%) SQL Server
3 137 (54.58%) OLAP
4 110 (43.82%) ETL
5 108 (43.03%) Oracle
6 107 (42.63%) Data Warehouse
7 95 (37.85%) Microsoft
8 92 (36.65%) MySQL
9 82 (32.67%) Performance Tuning
10 81 (32.27%) Business Intelligence
11 76 (30.28%) SQL Server Integration Services
12 70 (27.89%) SQL Server Analysis Services
13 68 (27.09%) T-SQL
14 64 (25.50%) SQL Server Reporting Services
14 64 (25.50%) Oracle Database
15 61 (24.30%) Java
15 61 (24.30%) PL/SQL
16 60 (23.90%) Agile Software Development
17 57 (22.71%) Finance
18 55 (21.91%) Linux
19 50 (19.92%) Oracle OLAP
20 48 (19.12%) Degree
20 48 (19.12%) C#
21 43 (17.13%) .NET
22 42 (16.73%) MongoDB
23 41 (16.33%) ETL Development
24 40 (15.94%) Amazon AWS
24 40 (15.94%) Kimball Methodology
25 39 (15.54%) NoSQL
26 38 (15.14%) 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 19 (7.57%) Elasticsearch
2 6 (2.39%) Apache Spark
3 3 (1.20%) Apache
3 3 (1.20%) SharePoint
4 2 (0.80%) SharePoint 2013
5 1 (0.40%) OpenStack
5 1 (0.40%) Oracle SOA Suite
5 1 (0.40%) WebLogic
Applications
1 15 (5.98%) MS Visio
2 13 (5.18%) Microsoft Excel
3 3 (1.20%) Microsoft PowerPoint
4 1 (0.40%) S-PLUS
Business Applications
1 2 (0.80%) Dynamics CRM
2 1 (0.40%) Oracle Applications
Cloud Services
1 40 (15.94%) Amazon AWS
2 37 (14.74%) Microsoft Azure
3 11 (4.38%) GitHub
4 4 (1.59%) Google Cloud Platform
5 2 (0.80%) Slack
6 1 (0.40%) Amazon EMR
6 1 (0.40%) Amazon S3
6 1 (0.40%) Data Lake Analytics
6 1 (0.40%) Datadog
6 1 (0.40%) IaaS
6 1 (0.40%) Office 365
6 1 (0.40%) SaaS
Communications & Networking
1 18 (7.17%) Wireless
2 9 (3.59%) SAN
3 6 (2.39%) Extranet
3 6 (2.39%) Intranet
4 5 (1.99%) DNS
5 4 (1.59%) Fibre Channel
5 4 (1.59%) Firewall
5 4 (1.59%) HTTP
6 3 (1.20%) Internet
7 2 (0.80%) MPLS
7 2 (0.80%) VPLS
8 1 (0.40%) NAS
8 1 (0.40%) SMS
Database & Business Intelligence
1 152 (60.56%) SQL Server
2 137 (54.58%) OLAP
3 107 (42.63%) Data Warehouse
4 92 (36.65%) MySQL
5 76 (30.28%) SQL Server Integration Services
6 70 (27.89%) SQL Server Analysis Services
7 64 (25.50%) Oracle Database
7 64 (25.50%) SQL Server Reporting Services
8 50 (19.92%) Oracle OLAP
9 42 (16.73%) MongoDB
10 39 (15.54%) NoSQL
11 37 (14.74%) DB2
11 37 (14.74%) SQL Server 2008
12 35 (13.94%) Relational Database
13 30 (11.95%) SQL Server 2014
14 27 (10.76%) Oracle ODI
15 25 (9.96%) OLAP Cube
16 24 (9.56%) Apache Cassandra
17 23 (9.16%) SQL Server 2016
18 20 (7.97%) Power BI
Development Applications
1 21 (8.37%) Team Foundation Server
2 18 (7.17%) Oracle Forms
3 17 (6.77%) Git (software)
4 16 (6.37%) Jenkins
5 15 (5.98%) JIRA
6 13 (5.18%) SQL Server Management Studio (SSMS)
7 9 (3.59%) tSQLt
7 9 (3.59%) Visual Studio
8 7 (2.79%) Octopus Deploy
9 1 (0.40%) ERwin
9 1 (0.40%) Talend Open Studio
9 1 (0.40%) TeamCity
General
1 57 (22.71%) Finance
2 26 (10.36%) Banking
3 24 (9.56%) Advertising
4 23 (9.16%) Retail
5 17 (6.77%) Pharmaceutical
6 12 (4.78%) Retail Banking
7 11 (4.38%) Investment Banking
8 4 (1.59%) Law
9 2 (0.80%) Retail Finance
10 1 (0.40%) International Banking
10 1 (0.40%) Legal
Job Titles
1 117 (46.61%) Developer
2 47 (18.73%) SQL Developer
3 46 (18.33%) DBA
4 30 (11.95%) Business Intelligence Developer
4 30 (11.95%) SQL DBA
5 29 (11.55%) Oracle Developer
6 27 (10.76%) SQL Server DBA
7 26 (10.36%) Administrator
8 23 (9.16%) Data Warehouse Developer
9 22 (8.76%) Oracle Data Warehouse Developer
10 21 (8.37%) Analyst
10 21 (8.37%) Architect
11 17 (6.77%) C# Developer
11 17 (6.77%) ETL Developer
12 16 (6.37%) SQL BI Developer
13 13 (5.18%) C# Software Developer
14 12 (4.78%) MySQL DBA
14 12 (4.78%) SQL Server Developer
14 12 (4.78%) SSIS Developer
15 11 (4.38%) SQL Analyst
Libraries, Frameworks & Software Standards
1 43 (17.13%) .NET
2 37 (14.74%) Web Services
3 31 (12.35%) Oracle GoldenGate
4 30 (11.95%) XML
5 24 (9.56%) ASP.NET
6 22 (8.76%) ASP.NET MVC
7 21 (8.37%) MDX
8 20 (7.97%) WinForms
9 19 (7.57%) HTML
10 16 (6.37%) COM
11 11 (4.38%) WPF
12 9 (3.59%) STL
13 8 (3.19%) AngularJS
14 6 (2.39%) JSON
14 6 (2.39%) RESTful
15 3 (1.20%) Kafka
15 3 (1.20%) Velocity
16 2 (0.80%) ASP.NET Web API
16 2 (0.80%) D3.js
16 2 (0.80%) Entity Framework
Miscellaneous
1 36 (14.34%) Computer Science
2 35 (13.94%) Analytical Skills
3 34 (13.55%) Replication
4 18 (7.17%) PDA
5 15 (5.98%) Fintech
6 9 (3.59%) Foreign Exchange (FX)
7 8 (3.19%) Life Science
8 5 (1.99%) Clustering
9 4 (1.59%) EMC VMAX
9 4 (1.59%) Mainframe
10 3 (1.20%) Data Centre
10 3 (1.20%) Data Protection Act
10 3 (1.20%) HACMP
10 3 (1.20%) N-Tier
11 2 (0.80%) Derivative
11 2 (0.80%) Linux Command Line
11 2 (0.80%) OTC Derivatives
11 2 (0.80%) Public Cloud
11 2 (0.80%) Reference Data
12 1 (0.40%) PKI
Operating Systems
1 55 (21.91%) Linux
2 37 (14.74%) Unix
3 34 (13.55%) Windows
4 10 (3.98%) Red Hat Enterprise Linux
5 9 (3.59%) Solaris
6 5 (1.99%) Ubuntu
7 3 (1.20%) AIX
7 3 (1.20%) Windows Server
8 1 (0.40%) Windows 7
8 1 (0.40%) Windows Server 2008
Processes & Methodologies
1 110 (43.82%) ETL
2 82 (32.67%) Performance Tuning
3 81 (32.27%) Business Intelligence
4 60 (23.90%) Agile Software Development
5 41 (16.33%) ETL Development
6 40 (15.94%) Kimball Methodology
7 38 (15.14%) Data Modelling
8 37 (14.74%) Dimensional Modelling
9 36 (14.34%) ITIL
10 31 (12.35%) Disaster Recovery
11 30 (11.95%) Data Transformation
12 29 (11.55%) Database Tuning
13 27 (10.76%) Software Engineering
14 24 (9.56%) High Availability
15 23 (9.16%) E-Commerce
16 22 (8.76%) MVC
17 20 (7.97%) Scrum
18 18 (7.17%) Continuous Improvement
19 17 (6.77%) DevOps
20 16 (6.37%) Logical Data Model
Programming Languages
1 188 (74.90%) SQL
2 68 (27.09%) T-SQL
3 61 (24.30%) Java
3 61 (24.30%) PL/SQL
4 48 (19.12%) C#
5 20 (7.97%) JavaScript
5 20 (7.97%) PowerShell
6 18 (7.17%) C++
7 16 (6.37%) VB
7 16 (6.37%) VB6
8 12 (4.78%) Python
9 9 (3.59%) Shell Script
10 8 (3.19%) Data Analysis Expressions (DAX)
10 8 (3.19%) VB.NET
10 8 (3.19%) VBScript
11 3 (1.20%) Bash Shell
11 3 (1.20%) C
11 3 (1.20%) PHP
12 2 (0.80%) VBA
13 1 (0.40%) R
Qualifications
1 48 (19.12%) Degree
2 21 (8.37%) Computer Science Degree
3 15 (5.98%) Microsoft Certification
4 10 (3.98%) Oracle Certification
5 7 (2.79%) MCITP
5 7 (2.79%) MCSE
6 2 (0.80%) Linux+ Certification
7 1 (0.40%) OCP
Quality Assurance & Compliance
1 17 (6.77%) QA
2 16 (6.37%) Data Quality
3 3 (1.20%) GDPR
3 3 (1.20%) PMO
4 2 (0.80%) SLA
5 1 (0.40%) PCI DSS
5 1 (0.40%) Sarbanes-Oxley
System Software
1 16 (6.37%) Oracle RAC
2 5 (1.99%) VMware Infrastructure
3 4 (1.59%) GlusterFS
3 4 (1.59%) Veritas Cluster Server
3 4 (1.59%) Virtual Machines
4 3 (1.20%) Apache Flume
4 3 (1.20%) GPFS
5 2 (0.80%) Active Directory
6 1 (0.40%) Docker
6 1 (0.40%) HDFS
6 1 (0.40%) KVM
6 1 (0.40%) Microsoft App-V
Systems Management
1 19 (7.57%) Ansible
2 9 (3.59%) Perfmon
3 7 (2.79%) NetBackup
3 7 (2.79%) Red Hat Satellite
4 4 (1.59%) Failover Clustering
4 4 (1.59%) Microsoft Clustering
4 4 (1.59%) Oracle ZFS
4 4 (1.59%) Veritas Storage Foundation
5 2 (0.80%) Opscode Chef
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%) Cobbler
6 1 (0.40%) Kibana
6 1 (0.40%) Nagios
6 1 (0.40%) OpenView
6 1 (0.40%) Puppet
6 1 (0.40%) SCCM
6 1 (0.40%) Tivoli
6 1 (0.40%) ZABBIX
Vendors
1 108 (43.03%) Oracle
2 95 (37.85%) Microsoft
3 16 (6.37%) RedGate
4 8 (3.19%) Red Hat
4 8 (3.19%) Tableau
5 7 (2.79%) Veritas
6 6 (2.39%) Sun
7 5 (1.99%) Brocade
7 5 (1.99%) VMware
8 4 (1.59%) EMC
8 4 (1.59%) Google
8 4 (1.59%) NetApp
8 4 (1.59%) StorageTek
9 3 (1.20%) Intel
10 2 (0.80%) IBM
10 2 (0.80%) TSYS
11 1 (0.40%) BMC
11 1 (0.40%) Informatica
11 1 (0.40%) Juniper
11 1 (0.40%) Teradata