Period
to 22 January 2019

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

Online Transaction Processing (OLTP)
UK > England
6 months to
22 Jan 2019
Same period 2018 Same period 2017
Rank 897 929 856
Rank change year-on-year +32 -73 +24
Permanent jobs citing OLTP 173 224 323
As % of all permanent IT jobs advertised in England 0.12% 0.14% 0.20%
As % of the Database & Business Intelligence category 0.43% 0.45% 0.66%
Number of salaries quoted 126 184 243
England median annual salary £57,500 £50,000 £52,500
Median salary % change year-on-year +15.00% -4.76% -4.55%
10th Percentile £40,000 £32,000 £35,250
90th Percentile £85,625 £85,000 £71,050
UK median annual salary £57,500 £50,000 £52,500
% change year-on-year +15.00% -4.76% -4.55%

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 40,288 49,729 49,166
As % of all permanent IT jobs advertised in England 28.54% 30.62% 29.84%
Number of salaries quoted 33,349 41,662 42,435
England median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% +3.26%
10th Percentile £31,250 £30,500 £29,750
90th Percentile £85,000 £77,500 £77,500
UK median annual salary £52,500 £48,000 £47,500
% change year-on-year +9.38% +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 22 January 2019.

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 January 2019. 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 +39 89 £62,500 +4.17% 5
North of England +50 28 £48,750 -11.36% 4
North West +46 27 £48,750 -11.36% 4
Midlands +18 24 £48,000 +5.49% 3
South East +42 23 £52,000 +15.56% 3
East Midlands 0 16 £51,500 -1.90% 1
East of England +16 9 £67,500 +50.00% 2
West Midlands +39 8 £43,750 +28.68% 2
Yorkshire +15 1 - -
OLTP
UK

For the 6 months to 22 January 2019, 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 114 (65.90%) SQL
2 113 (65.32%) SQL Server
3 85 (49.13%) Data Warehouse
4 83 (47.98%) SQL Server Integration Services
5 65 (37.57%) Microsoft
5 65 (37.57%) T-SQL
6 58 (33.53%) Business Intelligence
7 57 (32.95%) Agile Software Development
7 57 (32.95%) SQL Server Reporting Services
8 48 (27.75%) Degree
9 47 (27.17%) Performance Tuning
10 44 (25.43%) Microsoft Azure
10 44 (25.43%) NoSQL
11 43 (24.86%) Relational Database
12 42 (24.28%) MongoDB
12 42 (24.28%) Data Modelling
13 39 (22.54%) Finance
13 39 (22.54%) OLAP
14 38 (21.97%) SQL Server 2008
15 36 (20.81%) Oracle
16 34 (19.65%) Java
16 34 (19.65%) ETL
17 33 (19.08%) SQL Server Analysis Services
18 30 (17.34%) Python
18 30 (17.34%) Tableau
18 30 (17.34%) Power BI
19 29 (16.76%) SQL Server 2012
20 27 (15.61%) Big Data
21 26 (15.03%) Kafka
21 26 (15.03%) SQL Server 2014

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 25 (14.45%) Apache Spark
2 12 (6.94%) SharePoint
3 8 (4.62%) Apache
4 7 (4.05%) Apache Pig
5 5 (2.89%) SAS
6 2 (1.16%) Apache Solr
6 2 (1.16%) Cloud Foundry
6 2 (1.16%) Elasticsearch
6 2 (1.16%) GemFire
6 2 (1.16%) Jupyter
6 2 (1.16%) Tomcat
Applications
1 21 (12.14%) Microsoft Excel
2 2 (1.16%) Microsoft PowerPoint
2 2 (1.16%) MS Visio
2 2 (1.16%) SPSS
3 1 (0.58%) Microsoft Office
Business Applications
1 6 (3.47%) Oracle EBS
1 6 (3.47%) Oracle Retail
2 2 (1.16%) SAP Business One
Cloud Services
1 44 (25.43%) Microsoft Azure
2 25 (14.45%) Amazon AWS
3 19 (10.98%) PaaS
4 14 (8.09%) SaaS
5 8 (4.62%) GitHub
6 7 (4.05%) Amazon EMR
6 7 (4.05%) Amazon S3
6 7 (4.05%) Cloud Computing
7 5 (2.89%) Azure Data Factory
8 2 (1.16%) Apigee
8 2 (1.16%) Azure Active Directory
8 2 (1.16%) Azure Machine Learning
8 2 (1.16%) Boomi
8 2 (1.16%) Data Lake Analytics
8 2 (1.16%) IaaS
8 2 (1.16%) iPaaS
8 2 (1.16%) Office 365
Communications & Networking
1 13 (7.51%) Firewall
2 12 (6.94%) Internet
3 2 (1.16%) PPP
Database & Business Intelligence
1 113 (65.32%) SQL Server
2 85 (49.13%) Data Warehouse
3 83 (47.98%) SQL Server Integration Services
4 57 (32.95%) SQL Server Reporting Services
5 44 (25.43%) NoSQL
6 43 (24.86%) Relational Database
7 42 (24.28%) MongoDB
8 39 (22.54%) OLAP
9 38 (21.97%) SQL Server 2008
10 33 (19.08%) SQL Server Analysis Services
11 30 (17.34%) Power BI
12 29 (16.76%) SQL Server 2012
13 27 (15.61%) Big Data
14 26 (15.03%) SQL Server 2014
15 25 (14.45%) Hadoop
16 24 (13.87%) Apache Hive
16 24 (13.87%) MySQL
17 20 (11.56%) Impala
18 18 (10.40%) Snowflake Schema
19 16 (9.25%) HBase
Development Applications
1 15 (8.67%) Gradle
2 13 (7.51%) Cucumber
3 9 (5.20%) Git (software)
4 6 (3.47%) Oracle APEX
4 6 (3.47%) PVCS
4 6 (3.47%) Toad
5 5 (2.89%) ERwin
6 4 (2.31%) Jenkins
7 3 (1.73%) ER Studio
7 3 (1.73%) SQL Server Management Studio (SSMS)
8 2 (1.16%) Eclipse
8 2 (1.16%) JUnit
8 2 (1.16%) Maven
8 2 (1.16%) Subversion
8 2 (1.16%) Visual Studio Team System
General
1 39 (22.54%) Finance
2 25 (14.45%) Retail
3 13 (7.51%) Retail Banking
4 10 (5.78%) Advertising
4 10 (5.78%) Banking
5 8 (4.62%) Marketing
6 6 (3.47%) Publishing
7 5 (2.89%) Back Office
7 5 (2.89%) Corporate Banking
7 5 (2.89%) Financial Institution
8 3 (1.73%) Games
8 3 (1.73%) Spanish Language
9 2 (1.16%) Billing
10 1 (0.58%) Investment Banking
10 1 (0.58%) Pharmaceutical
Job Titles
1 40 (23.12%) DBA
2 39 (22.54%) Developer
3 34 (19.65%) SQL DBA
4 23 (13.29%) Architect
5 19 (10.98%) Administrator
6 18 (10.40%) Analyst
7 17 (9.83%) Data Architect
7 17 (9.83%) Software Engineer
8 12 (6.94%) Business Intelligence Consultant
8 12 (6.94%) Consultant
8 12 (6.94%) Disaster Recovery Analyst
8 12 (6.94%) Microsoft BI Consultant
8 12 (6.94%) Microsoft Consultant
9 10 (5.78%) Business Intelligence Developer
9 10 (5.78%) SQL Developer
10 9 (5.20%) Data Engineer
11 8 (4.62%) Senior Data Engineer
11 8 (4.62%) SQL Server DBA
12 7 (4.05%) Data Warehouse Developer
12 7 (4.05%) Java Engineer
Libraries, Frameworks & Software Standards
1 26 (15.03%) Kafka
2 19 (10.98%) .NET
3 16 (9.25%) Spring Boot
4 13 (7.51%) RESTful
5 12 (6.94%) Web Services
6 11 (6.36%) XML
7 8 (4.62%) JSON
8 7 (4.05%) LAMP
8 7 (4.05%) Spark Streaming
9 6 (3.47%) Apache NiFi
10 4 (2.31%) RabbitMQ
11 3 (1.73%) ASP.NET
11 3 (1.73%) Oracle GoldenGate
11 3 (1.73%) Spring
12 2 (1.16%) J2EE
12 2 (1.16%) MDX
12 2 (1.16%) Middleware
12 2 (1.16%) OAuth
12 2 (1.16%) OpenID
12 2 (1.16%) SAML
Miscellaneous
1 19 (10.98%) Greenfield Project
2 18 (10.40%) Analytical Skills
3 14 (8.09%) N-Tier
4 11 (6.36%) Data Centre
5 9 (5.20%) Data Structures
6 8 (4.62%) Clustering
6 8 (4.62%) HACMP
7 6 (3.47%) Enterprise Software
7 6 (3.47%) Management Information System
8 4 (2.31%) Public Cloud
8 4 (2.31%) Replication
8 4 (2.31%) Virtual Team
9 3 (1.73%) Mainframe
10 2 (1.16%) Derivative
10 2 (1.16%) Driving Licence
10 2 (1.16%) Linux Command Line
10 2 (1.16%) Online Games
10 2 (1.16%) PMI
11 1 (0.58%) Fintech
11 1 (0.58%) Private Cloud
Operating Systems
1 25 (14.45%) Linux
2 20 (11.56%) Windows
2 20 (11.56%) Windows Server
3 19 (10.98%) Unix
4 10 (5.78%) Red Hat Enterprise Linux
5 9 (5.20%) AIX
6 8 (4.62%) Solaris
Processes & Methodologies
1 58 (33.53%) Business Intelligence
2 57 (32.95%) Agile Software Development
3 47 (27.17%) Performance Tuning
4 42 (24.28%) Data Modelling
5 34 (19.65%) ETL
6 26 (15.03%) IT Strategy
7 25 (14.45%) Software Engineering
8 24 (13.87%) ITIL
9 22 (12.72%) Server Building
10 21 (12.14%) Machine Learning
10 21 (12.14%) Microservices
10 21 (12.14%) Problem-Solving
10 21 (12.14%) Technical Leadership
10 21 (12.14%) Visualisation
11 18 (10.40%) Analytics
11 18 (10.40%) High Availability
12 17 (9.83%) Scrum
13 16 (9.25%) Artificial Intelligence
14 15 (8.67%) Dimensional Modelling
14 15 (8.67%) SOA
Programming Languages
1 114 (65.90%) SQL
2 65 (37.57%) T-SQL
3 34 (19.65%) Java
4 30 (17.34%) Python
5 18 (10.40%) Shell Script
6 17 (9.83%) C#
6 17 (9.83%) R
7 16 (9.25%) PowerShell
8 12 (6.94%) PL/SQL
9 5 (2.89%) Scala
10 4 (2.31%) PHP
11 2 (1.16%) Bash Shell
11 2 (1.16%) C++
11 2 (1.16%) JavaScript
11 2 (1.16%) Perl
11 2 (1.16%) Ruby
12 1 (0.58%) Java 8
Qualifications
1 48 (27.75%) Degree
2 23 (13.29%) Microsoft Certification
3 15 (8.67%) Security Cleared
4 3 (1.73%) Computer Science Degree
4 3 (1.73%) SC Cleared
5 2 (1.16%) CEH
5 2 (1.16%) PMI Certification
5 2 (1.16%) TOGAF Certification
Quality Assurance & Compliance
1 9 (5.20%) GDPR
2 7 (4.05%) QA
3 3 (1.73%) Data Quality
3 3 (1.73%) PMO
4 1 (0.58%) SLA
System Software
1 17 (9.83%) HDFS
2 15 (8.67%) Apache Flume
2 15 (8.67%) Docker
3 12 (6.94%) Virtual Machines
4 8 (4.62%) GPFS
4 8 (4.62%) VMware Infrastructure
5 7 (4.05%) Apache ZooKeeper
6 2 (1.16%) Active Directory
Systems Management
1 7 (4.05%) Hadoop YARN
2 3 (1.73%) Oozie
3 2 (1.16%) Ambari
3 2 (1.16%) Ansible
3 2 (1.16%) Consul
3 2 (1.16%) Kubernetes
3 2 (1.16%) Opscode Chef
3 2 (1.16%) Puppet
3 2 (1.16%) Salt
3 2 (1.16%) Terraform
4 1 (0.58%) WSUS
Vendors
1 65 (37.57%) Microsoft
2 36 (20.81%) Oracle
3 30 (17.34%) Tableau
4 12 (6.94%) Cloudera
4 12 (6.94%) Teradata
5 11 (6.36%) Intel
5 11 (6.36%) SAP
6 9 (5.20%) Informatica
7 8 (4.62%) NetApp
7 8 (4.62%) VMware
8 7 (4.05%) Talend
9 5 (2.89%) Hortonworks
9 5 (2.89%) MapR
10 4 (2.31%) Alteryx
10 4 (2.31%) Red Hat
11 2 (1.16%) Axway
11 2 (1.16%) Cisco
11 2 (1.16%) EXASOL
11 2 (1.16%) SnapLogic
11 2 (1.16%) TIBCO