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

Online Transaction Processing (OLTP)
UK
6 months to
25 Feb 2018
Same period 2017 Same period 2016
Rank 948 860 929
Rank change year-on-year -88 +69 -73
Permanent jobs citing OLTP 233 318 374
As % of all permanent IT jobs advertised in the UK 0.13% 0.18% 0.18%
As % of the Database & Business Intelligence category 0.44% 0.61% 0.56%
Number of salaries quoted 192 232 275
UK median annual salary £50,000 £52,500 £55,000
Median salary % change year-on-year -4.76% -4.55% +10.00%
10th Percentile £32,500 £36,300 £35,200
90th Percentile £83,375 £78,750 £76,500
UK excluding London median annual salary £50,000 £52,500 £50,000
% change year-on-year -4.76% +5.00% +17.65%

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 53,225 52,463 66,882
As % of all permanent IT jobs advertised in the UK 30.57% 30.06% 31.74%
Number of salaries quoted 44,469 44,763 56,497
UK median annual salary £49,000 £47,500 £45,500
Median salary % change year-on-year +3.16% +4.40% +1.11%
10th Percentile £30,000 £29,750 £28,750
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £41,500
% change year-on-year - +2.41% +3.75%

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

Salary histogram for OLTP in the UK

OLTP
Top 13 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 25 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
England -64 219 £50,000 -6.54% 32
UK excluding London -48 133 £50,000 -4.76% 10
London -43 95 £55,000 -15.38% 23
Midlands +39 49 £50,000 +25.00% 2
East Midlands +30 39 £50,000 +35.14% 2
South East -56 32 £45,000 -14.29% 3
East of England -17 23 £45,000 -10.00% 1
North of England +14 18 £55,000 +12.82% 1
North West -1 12 £55,000 +10.00% 1
West Midlands +11 10 £34,000 -35.24%
Scotland -24 9 £60,000 +30.43% 1
Yorkshire +20 6 £55,000 +29.41%
South West +9 2 £41,250 -17.50% 2

For the 6 months to 25 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 with a requirement for OLTP.

1 164 (70.39%) SQL
2 131 (56.22%) SQL Server
3 115 (49.36%) OLAP
4 111 (47.64%) Business Intelligence
5 105 (45.06%) SQL Server Integration Services
6 96 (41.20%) Microsoft
7 95 (40.77%) SQL Server Reporting Services
8 93 (39.91%) Data Warehouse
9 86 (36.91%) T-SQL
10 85 (36.48%) ETL
11 83 (35.62%) SQL Server Analysis Services
12 68 (29.18%) Finance
13 65 (27.90%) Oracle
14 64 (27.47%) Java
15 62 (26.61%) C#
16 61 (26.18%) Agile Software Development
17 55 (23.61%) Power BI
18 54 (23.18%) MySQL
19 53 (22.75%) .NET
19 53 (22.75%) Microsoft Azure
20 45 (19.31%) Advertising
20 45 (19.31%) Data Modelling
20 45 (19.31%) NoSQL
21 43 (18.45%) Performance Tuning
22 41 (17.60%) Banking
22 41 (17.60%) Computer Science
23 39 (16.74%) MongoDB
24 37 (15.88%) Linux
25 36 (15.45%) Windows
25 36 (15.45%) Degree

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 32 (13.73%) Elasticsearch
2 5 (2.15%) SharePoint
3 4 (1.72%) Apache
3 4 (1.72%) Apache Spark
3 4 (1.72%) SharePoint 2013
4 3 (1.29%) Apache Solr
4 3 (1.29%) JBoss
4 3 (1.29%) Oracle Application Server
5 2 (0.86%) Tomcat
6 1 (0.43%) IIS
6 1 (0.43%) SAS
6 1 (0.43%) WebLogic
Applications
1 9 (3.86%) Microsoft Excel
2 7 (3.00%) MS Visio
3 4 (1.72%) Microsoft PowerPoint
4 2 (0.86%) Microsoft Office
5 1 (0.43%) S-PLUS
Business Applications
1 3 (1.29%) Adobe Campaign
2 2 (0.86%) Dynamics AX
2 2 (0.86%) Remedy ITSM
3 1 (0.43%) Oracle Applications
Cloud Services
1 53 (22.75%) Microsoft Azure
2 30 (12.88%) Amazon AWS
3 7 (3.00%) SaaS
4 1 (0.43%) Amazon EMR
4 1 (0.43%) Amazon S3
4 1 (0.43%) GitHub
4 1 (0.43%) Office 365
Communications & Networking
1 12 (5.15%) Wireless
2 4 (1.72%) Firewall
2 4 (1.72%) Internet
3 3 (1.29%) DNS
3 3 (1.29%) HTTP
3 3 (1.29%) SSL
4 2 (0.86%) MPLS
4 2 (0.86%) NAS
4 2 (0.86%) SAN
4 2 (0.86%) SMS
4 2 (0.86%) VPLS
Database & Business Intelligence
1 131 (56.22%) SQL Server
2 115 (49.36%) OLAP
3 105 (45.06%) SQL Server Integration Services
4 95 (40.77%) SQL Server Reporting Services
5 93 (39.91%) Data Warehouse
6 83 (35.62%) SQL Server Analysis Services
7 55 (23.61%) Power BI
8 54 (23.18%) MySQL
9 45 (19.31%) NoSQL
10 39 (16.74%) MongoDB
11 35 (15.02%) Apache Cassandra
12 30 (12.88%) Oracle Database
12 30 (12.88%) Oracle OLAP
13 26 (11.16%) Relational Database
14 19 (8.15%) SQL Server 2008
15 16 (6.87%) SQL Server 2016
16 15 (6.44%) SQL Server 2012
17 12 (5.15%) DB2
17 12 (5.15%) Snowflake Schema
18 11 (4.72%) SQL Server 2014
Development Applications
1 32 (13.73%) SQL Server Management Studio (SSMS)
2 18 (7.73%) Team Foundation Server
3 12 (5.15%) Oracle Forms
4 11 (4.72%) ERwin
5 9 (3.86%) Git (software)
6 7 (3.00%) Jenkins
7 3 (1.29%) JIRA
7 3 (1.29%) TeamCity
7 3 (1.29%) Visual Studio
8 2 (0.86%) Visual Studio Team System
9 1 (0.43%) tSQLt
General
1 68 (29.18%) Finance
2 45 (19.31%) Advertising
3 41 (17.60%) Banking
4 16 (6.87%) Retail
5 14 (6.01%) Pharmaceutical
6 13 (5.58%) Retail Banking
7 7 (3.00%) Investment Banking
7 7 (3.00%) Law
8 5 (2.15%) Billing
9 4 (1.72%) Marketing
10 3 (1.29%) Back Office
10 3 (1.29%) Telecoms
11 2 (0.86%) Financial Institution
11 2 (0.86%) Front Office
11 2 (0.86%) General Ledger
11 2 (0.86%) Retail Finance
12 1 (0.43%) Electronics
12 1 (0.43%) Games
12 1 (0.43%) International Banking
12 1 (0.43%) Publishing
Job Titles
1 116 (49.79%) Developer
2 50 (21.46%) SQL Developer
3 41 (17.60%) DBA
4 35 (15.02%) Architect
5 26 (11.16%) SQL DBA
6 25 (10.73%) Business Intelligence Developer
7 21 (9.01%) Data Architect
8 20 (8.58%) Java Developer
9 18 (7.73%) SQL Server Developer
10 16 (6.87%) Analyst
10 16 (6.87%) Senior Developer
11 15 (6.44%) C# Developer
11 15 (6.44%) Junior
12 13 (5.58%) Machine Learning Developer
12 13 (5.58%) Oracle Developer
13 12 (5.15%) Administrator
13 12 (5.15%) C# Software Developer
13 12 (5.15%) Database Developer
13 12 (5.15%) SQL BI Developer
14 11 (4.72%) Oracle Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 53 (22.75%) .NET
2 33 (14.16%) WPF
3 26 (11.16%) Web Services
4 25 (10.73%) XML
5 20 (8.58%) ASP.NET
6 14 (6.01%) Oracle GoldenGate
7 13 (5.58%) ASP.NET MVC
8 12 (5.15%) WinForms
9 11 (4.72%) COM
9 11 (4.72%) MDX
10 10 (4.29%) HTML
10 10 (4.29%) REST
11 8 (3.43%) AngularJS
11 8 (3.43%) JSON
12 6 (2.58%) SOAP
12 6 (2.58%) STL
13 5 (2.15%) ASP.NET Web API
14 4 (1.72%) Middleware
15 3 (1.29%) LDAP
16 2 (0.86%) WCF
Miscellaneous
1 41 (17.60%) Computer Science
2 26 (11.16%) Replication
3 19 (8.15%) Analytical Skills
4 15 (6.44%) Clustering
5 13 (5.58%) Fintech
6 12 (5.15%) Life Science
6 12 (5.15%) PDA
7 9 (3.86%) N-Tier
8 7 (3.00%) Data Structures
9 6 (2.58%) Hybrid Cloud
9 6 (2.58%) Taxonomies
10 5 (2.15%) Mainframe
11 4 (1.72%) Data Centre
11 4 (1.72%) HACMP
11 4 (1.72%) Management Information System
12 3 (1.29%) Blog
12 3 (1.29%) Contactless
12 3 (1.29%) EMV
12 3 (1.29%) EPoS
12 3 (1.29%) Public Cloud
Operating Systems
1 37 (15.88%) Linux
2 36 (15.45%) Windows
3 23 (9.87%) Unix
4 8 (3.43%) Windows Server
5 7 (3.00%) CentOS
5 7 (3.00%) Red Hat Enterprise Linux
5 7 (3.00%) Solaris
5 7 (3.00%) Ubuntu
6 4 (1.72%) AIX
7 3 (1.29%) Debian
8 1 (0.43%) Windows 7
8 1 (0.43%) Windows Server 2008
Processes & Methodologies
1 111 (47.64%) Business Intelligence
2 85 (36.48%) ETL
3 61 (26.18%) Agile Software Development
4 45 (19.31%) Data Modelling
5 43 (18.45%) Performance Tuning
6 31 (13.30%) High Availability
7 27 (11.59%) Software Engineering
8 23 (9.87%) Database Tuning
9 22 (9.44%) Scrum
9 22 (9.44%) SDLC
10 21 (9.01%) Kimball Methodology
10 21 (9.01%) Logical Data Model
11 20 (8.58%) ETL Development
11 20 (8.58%) Machine Learning
12 17 (7.30%) Dimensional Modelling
12 17 (7.30%) Disaster Recovery
13 16 (6.87%) Data Integration
13 16 (6.87%) MVC
14 15 (6.44%) Data Architecture
14 15 (6.44%) Workflow
Programming Languages
1 164 (70.39%) SQL
2 86 (36.91%) T-SQL
3 64 (27.47%) Java
4 62 (26.61%) C#
5 26 (11.16%) PowerShell
6 21 (9.01%) C++
7 19 (8.15%) JavaScript
8 17 (7.30%) PL/SQL
9 14 (6.01%) VB
10 11 (4.72%) Python
10 11 (4.72%) VB6
11 8 (3.43%) Shell Script
12 6 (2.58%) Perl
12 6 (2.58%) VBA
13 5 (2.15%) Bash Shell
13 5 (2.15%) C
14 4 (1.72%) Korn
15 3 (1.29%) PHP
15 3 (1.29%) Ruby
16 2 (0.86%) Groovy
Qualifications
1 36 (15.45%) Degree
2 32 (13.73%) Computer Science Degree
3 1 (0.43%) Master's Degree
3 1 (0.43%) OCP
3 1 (0.43%) Oracle Certification
3 1 (0.43%) PhD
Quality Assurance & Compliance
1 9 (3.86%) Data Quality
2 8 (3.43%) GDPR
3 4 (1.72%) PMO
3 4 (1.72%) QA
4 3 (1.29%) PCI DSS
4 3 (1.29%) PSD2
System Software
1 7 (3.00%) Docker
2 5 (2.15%) VMware Infrastructure
3 4 (1.72%) GPFS
3 4 (1.72%) Oracle RAC
3 4 (1.72%) Virtual Machines
4 1 (0.43%) Active Directory
4 1 (0.43%) Apache Flume
4 1 (0.43%) HDFS
4 1 (0.43%) Microsoft App-V
Systems Management
1 9 (3.86%) Ansible
2 8 (3.43%) Puppet
3 6 (2.58%) Opscode Chef
4 4 (1.72%) Failover Clustering
5 3 (1.29%) Galera Cluster
5 3 (1.29%) Salt
6 2 (0.86%) Kubernetes
6 2 (0.86%) Microsoft Clustering
6 2 (0.86%) Netcool
6 2 (0.86%) Perfmon
6 2 (0.86%) Terraform
7 1 (0.43%) Hadoop YARN
7 1 (0.43%) OpenView
7 1 (0.43%) SCCM
7 1 (0.43%) Systems Management Server (SMS)
7 1 (0.43%) Tivoli
Vendors
1 96 (41.20%) Microsoft
2 65 (27.90%) Oracle
3 14 (6.01%) Tableau
4 6 (2.58%) NetApp
4 6 (2.58%) Red Hat
5 5 (2.15%) VMware
6 4 (1.72%) EXASOL
6 4 (1.72%) Intel
7 3 (1.29%) Adobe
7 3 (1.29%) Apple
7 3 (1.29%) CA
7 3 (1.29%) Cisco
7 3 (1.29%) IBM
7 3 (1.29%) PayPal
7 3 (1.29%) Percona
7 3 (1.29%) Teradata
8 2 (0.86%) MetaSolv
8 2 (0.86%) Remedy
8 2 (0.86%) Sun
8 2 (0.86%) TSYS