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

Online Transaction Processing (OLTP)
UK > England
6 months to
18 Nov 2018
Same period 2017 Same period 2016
Rank 920 914 847
Rank change year-on-year -6 -67 -26
Permanent jobs citing OLTP 194 258 362
As % of all permanent IT jobs advertised in England 0.13% 0.15% 0.20%
As % of the Database & Business Intelligence category 0.45% 0.51% 0.68%
Number of salaries quoted 145 193 263
England median annual salary £57,500 £50,000 £50,000
Median salary % change year-on-year +15.00% - -9.09%
10th Percentile £38,000 £31,250 £33,750
90th Percentile £74,750 £83,500 £71,050
UK median annual salary £55,000 £50,000 £50,000
% change year-on-year +10.00% - -6.54%

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 43,539 50,605 53,015
As % of all permanent IT jobs advertised in England 29.09% 30.15% 29.58%
Number of salaries quoted 35,999 42,043 45,762
England median annual salary £51,250 £50,000 £47,500
Median salary % change year-on-year +2.50% +5.26% +5.56%
10th Percentile £31,250 £30,000 £29,000
90th Percentile £85,000 £77,500 £77,500
UK median annual salary £50,000 £47,960 £47,500
% change year-on-year +4.25% +0.97% +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 18 November 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 18 November 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 +16 90 £60,000 - 22
North of England +49 38 £50,000 -9.09% 7
North West +48 38 £50,000 - 5
South East +31 24 £57,500 +27.78% 9
Midlands -4 20 £48,000 -4.00% 1
East of England +20 17 £66,000 +65.00% 6
East Midlands -24 14 £48,000 -4.00%
West Midlands +32 6 £40,000 +6.67% 1
South West +21 3 £50,500 +55.38% 6
OLTP
UK

For the 6 months to 18 November 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 151 (77.84%) SQL
2 117 (60.31%) SQL Server
3 108 (55.67%) Data Warehouse
4 89 (45.88%) SQL Server Integration Services
5 73 (37.63%) Microsoft
6 72 (37.11%) T-SQL
7 70 (36.08%) Business Intelligence
8 63 (32.47%) Agile Software Development
9 60 (30.93%) SQL Server Reporting Services
10 59 (30.41%) Relational Database
11 58 (29.90%) OLAP
12 56 (28.87%) Degree
12 56 (28.87%) Performance Tuning
13 53 (27.32%) Oracle
14 50 (25.77%) Data Modelling
15 45 (23.20%) ETL
16 44 (22.68%) MongoDB
17 41 (21.13%) NoSQL
18 39 (20.10%) Big Data
19 37 (19.07%) Finance
20 35 (18.04%) SQL Server 2008
20 35 (18.04%) Hadoop
21 34 (17.53%) MySQL
22 33 (17.01%) Java
23 32 (16.49%) ITIL
23 32 (16.49%) SQL Server 2012
24 31 (15.98%) SQL Server Analysis Services
25 29 (14.95%) IT Strategy
26 28 (14.43%) PL/SQL
26 28 (14.43%) Microsoft Certification

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 27 (13.92%) Apache Spark
2 8 (4.12%) Apache
3 7 (3.61%) Apache Pig
3 7 (3.61%) SAS
4 6 (3.09%) Oracle Application Server
5 5 (2.58%) SharePoint
6 2 (1.03%) Cloud Foundry
6 2 (1.03%) GemFire
6 2 (1.03%) Tomcat
7 1 (0.52%) OpenStack
7 1 (0.52%) WebLogic
Applications
1 15 (7.73%) Microsoft Excel
2 10 (5.15%) MS Visio
3 3 (1.55%) Microsoft PowerPoint
4 1 (0.52%) Microsoft Office
4 1 (0.52%) Spreadsheet
Business Applications
1 6 (3.09%) Oracle EBS
1 6 (3.09%) Oracle Retail
2 2 (1.03%) SAP Business One
Cloud Services
1 23 (11.86%) Microsoft Azure
2 11 (5.67%) PaaS
3 9 (4.64%) Amazon AWS
4 8 (4.12%) SaaS
5 6 (3.09%) GitHub
6 2 (1.03%) Azure Data Factory
6 2 (1.03%) IaaS
Communications & Networking
1 7 (3.61%) SAN
2 5 (2.58%) Firewall
2 5 (2.58%) Internet
3 2 (1.03%) DNS
4 1 (0.52%) HTTP
4 1 (0.52%) MPLS
4 1 (0.52%) VPLS
Database & Business Intelligence
1 117 (60.31%) SQL Server
2 108 (55.67%) Data Warehouse
3 89 (45.88%) SQL Server Integration Services
4 60 (30.93%) SQL Server Reporting Services
5 59 (30.41%) Relational Database
6 58 (29.90%) OLAP
7 44 (22.68%) MongoDB
8 41 (21.13%) NoSQL
9 39 (20.10%) Big Data
10 35 (18.04%) Hadoop
10 35 (18.04%) SQL Server 2008
11 34 (17.53%) MySQL
12 32 (16.49%) SQL Server 2012
13 31 (15.98%) SQL Server Analysis Services
14 27 (13.92%) Oracle OLAP
14 27 (13.92%) SQL Server 2014
15 26 (13.40%) Oracle Database
16 25 (12.89%) Apache Hive
16 25 (12.89%) Power BI
17 23 (11.86%) Impala
Development Applications
1 14 (7.22%) Gradle
2 12 (6.19%) Cucumber
2 12 (6.19%) ERwin
3 10 (5.15%) Git (software)
4 7 (3.61%) JIRA
5 6 (3.09%) Oracle APEX
5 6 (3.09%) PVCS
5 6 (3.09%) Toad
6 2 (1.03%) Eclipse
6 2 (1.03%) Jenkins
6 2 (1.03%) JUnit
6 2 (1.03%) SQL Server Management Studio (SSMS)
6 2 (1.03%) Subversion
7 1 (0.52%) ER Studio
7 1 (0.52%) TestRail
7 1 (0.52%) Visual Studio
General
1 37 (19.07%) Finance
2 16 (8.25%) Retail
3 12 (6.19%) Games
3 12 (6.19%) Retail Banking
4 9 (4.64%) Banking
5 7 (3.61%) Marketing
6 6 (3.09%) Advertising
6 6 (3.09%) Publishing
7 5 (2.58%) Back Office
7 5 (2.58%) Corporate Banking
7 5 (2.58%) Financial Institution
8 2 (1.03%) Billing
9 1 (0.52%) Automotive
9 1 (0.52%) Investment Banking
9 1 (0.52%) Pharmaceutical
9 1 (0.52%) Retail Finance
Job Titles
1 54 (27.84%) DBA
2 51 (26.29%) Developer
3 39 (20.10%) SQL DBA
4 36 (18.56%) Architect
5 28 (14.43%) Data Architect
6 26 (13.40%) Administrator
7 16 (8.25%) Data Warehouse Developer
8 15 (7.73%) Business Intelligence Architect
8 15 (7.73%) Software Engineer
9 14 (7.22%) Oracle Developer
10 12 (6.19%) Oracle Data Warehouse Developer
11 10 (5.15%) Analyst
11 10 (5.15%) SQL Developer
11 10 (5.15%) SQL Server DBA
12 8 (4.12%) Business Intelligence Developer
12 8 (4.12%) Consultant
12 8 (4.12%) Senior Developer
13 7 (3.61%) Big Data Developer
13 7 (3.61%) Development DBA
13 7 (3.61%) Java Engineer
Libraries, Frameworks & Software Standards
1 26 (13.40%) Web Services
2 24 (12.37%) Kafka
3 22 (11.34%) XML
4 18 (9.28%) JSON
5 16 (8.25%) .NET
6 15 (7.73%) Spring Boot
7 12 (6.19%) Oracle GoldenGate
7 12 (6.19%) RESTful
8 9 (4.64%) Spark Streaming
9 6 (3.09%) RabbitMQ
10 3 (1.55%) ASP.NET
10 3 (1.55%) MDX
10 3 (1.55%) Middleware
11 2 (1.03%) J2EE
11 2 (1.03%) Spring
11 2 (1.03%) Spring Batch
11 2 (1.03%) Spring Integration
12 1 (0.52%) LDAP
12 1 (0.52%) REST
12 1 (0.52%) SAML
Miscellaneous
1 18 (9.28%) Analytical Skills
2 17 (8.76%) Greenfield Project
3 14 (7.22%) Computer Science
4 13 (6.70%) Clustering
4 13 (6.70%) Replication
5 10 (5.15%) Data Centre
6 8 (4.12%) N-Tier
7 7 (3.61%) Enterprise Software
7 7 (3.61%) Hybrid Cloud
8 6 (3.09%) Management Information System
9 5 (2.58%) Reference Data
10 4 (2.06%) Fintech
10 4 (2.06%) Online Games
10 4 (2.06%) Tandem
11 3 (1.55%) FlexPod
11 3 (1.55%) HACMP
11 3 (1.55%) Mainframe
11 3 (1.55%) VxBlock/Vblock
12 2 (1.03%) Linux Command Line
12 2 (1.03%) Virtual Team
Operating Systems
1 27 (13.92%) Linux
2 24 (12.37%) Windows
3 22 (11.34%) Unix
4 21 (10.82%) Windows Server
5 7 (3.61%) Red Hat Enterprise Linux
6 4 (2.06%) AIX
6 4 (2.06%) Solaris
7 3 (1.55%) Oracle Linux
7 3 (1.55%) SUSE
8 1 (0.52%) CentOS
8 1 (0.52%) Debian
Processes & Methodologies
1 70 (36.08%) Business Intelligence
2 63 (32.47%) Agile Software Development
3 56 (28.87%) Performance Tuning
4 50 (25.77%) Data Modelling
5 45 (23.20%) ETL
6 32 (16.49%) ITIL
7 29 (14.95%) IT Strategy
8 27 (13.92%) Dimensional Modelling
9 26 (13.40%) Scrum
10 25 (12.89%) Data Management
10 25 (12.89%) Server Building
11 23 (11.86%) Problem-Solving
12 22 (11.34%) Software Engineering
13 21 (10.82%) Data Analysis
13 21 (10.82%) Migration
14 20 (10.31%) Data Integration
14 20 (10.31%) ETL Development
14 20 (10.31%) Kimball Methodology
15 19 (9.79%) Microservices
16 18 (9.28%) Analytics
Programming Languages
1 151 (77.84%) SQL
2 72 (37.11%) T-SQL
3 33 (17.01%) Java
4 28 (14.43%) PL/SQL
5 17 (8.76%) PowerShell
6 16 (8.25%) Python
7 12 (6.19%) Shell Script
8 11 (5.67%) C#
9 7 (3.61%) Scala
10 5 (2.58%) R
11 2 (1.03%) Bash Shell
11 2 (1.03%) Perl
12 1 (0.52%) Data Analysis Expressions (DAX)
12 1 (0.52%) Java 8
Qualifications
1 56 (28.87%) Degree
2 28 (14.43%) Microsoft Certification
3 5 (2.58%) Security Cleared
4 3 (1.55%) MCSE
5 2 (1.03%) Computer Science Degree
5 2 (1.03%) MCITP
5 2 (1.03%) RHCE
5 2 (1.03%) RHCSA
6 1 (0.52%) ISTQB
6 1 (0.52%) TOGAF Certification
Quality Assurance & Compliance
1 8 (4.12%) QA
2 5 (2.58%) Data Quality
3 4 (2.06%) PMO
4 1 (0.52%) GDPR
4 1 (0.52%) PCI DSS
System Software
1 14 (7.22%) Docker
2 13 (6.70%) HDFS
3 12 (6.19%) Virtual Machines
4 11 (5.67%) Apache Flume
5 9 (4.64%) Apache ZooKeeper
6 6 (3.09%) Oracle RAC
7 5 (2.58%) VMware Infrastructure
8 3 (1.55%) GPFS
9 1 (0.52%) Microsoft App-V
Systems Management
1 6 (3.09%) Data Guard
2 4 (2.06%) Oozie
3 3 (1.55%) Terraform
4 2 (1.03%) Consul
4 2 (1.03%) Kubernetes
4 2 (1.03%) Oracle Enterprise Manager
5 1 (0.52%) Ansible
5 1 (0.52%) Nagios
5 1 (0.52%) OpenView
5 1 (0.52%) Puppet
5 1 (0.52%) Tivoli
Vendors
1 73 (37.63%) Microsoft
2 53 (27.32%) Oracle
3 24 (12.37%) Tableau
4 12 (6.19%) SAP
5 9 (4.64%) Cloudera
6 7 (3.61%) Hortonworks
6 7 (3.61%) MapR
7 6 (3.09%) Red Hat
8 5 (2.58%) EXASOL
8 5 (2.58%) Intel
8 5 (2.58%) Teradata
8 5 (2.58%) VMware
9 3 (1.55%) Alteryx
9 3 (1.55%) IBM
9 3 (1.55%) NetApp
10 2 (1.03%) Cognos
10 2 (1.03%) Google
10 2 (1.03%) Informatica
10 2 (1.03%) MicroStrategy
10 2 (1.03%) Netezza