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 3 months to 25 June 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK
3 months to
25 Jun 2017
Same period 2016 Same period 2015
Rank 770 745 747
Rank change year-on-year -25 +2  
Permanent jobs citing OLTP 102 179 225
As % of all permanent IT jobs advertised in the UK 0.12% 0.18% 0.20%
As % of the Database & Business Intelligence category 0.38% 0.62% 0.62%
Number of salaries quoted 62 122 151
Median salary £50,750 £50,000 £52,500
Median salary % change year-on-year +1.50% -4.76%  
90% offered a salary of more than £32,500 £35,250 £32,450
10% offered a salary of more than £65,000 £78,850 £70,250
UK excluding London median salary £45,250 £45,000 £45,000
% change year-on-year +0.55% -  

OLTP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 27194 29052 36094
As % of all permanent IT job vacancies advertised in the UK 30.87% 29.93% 32.61%
Number of salaries quoted 22923 24759 30469
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26%  
90% offered a salary of more than £32,500 £32,500 £31,500
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

OLTP
Job Vacancy Trend

The job posting trend of jobs advertised citing OLTP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 25 June 2017.

Salary histogram for OLTP in the UK

OLTP
Top 30 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 3 months to 25 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -14 101 £50,000 - 20
London -28 44 £61,250 +6.52% 10
South East +38 16 £55,000 +10.00% 1
East of England - 13 £41,250 - 5
East Midlands +27 11 £35,250 -17.05%
Northamptonshire +8 11 £35,250 -
Wellingborough - 11 £35,250 -
South West 0 7 £32,500 -18.75% 1
Luton - 7 £42,500 - 2
Bedfordshire - 7 £42,500 - 2
Surrey +27 6 £60,000 -
Somerset -5 5 £32,500 -20.73% 1
Bath -10 5 £32,500 -20.73% 1
Essex - 5 £45,000 - 3
West Midlands +9 4 £56,250 +25.00%
West Sussex - 4 £30,000 -
Redhill - 4 £60,000 -
Hampshire -3 3 £48,000 +6.66%
Manchester - 3 £70,750 - 1
North West - 3 £70,750 - 2
Haywards Heath - 3 £30,000 -
Brentwood - 3 - - 1
Berkshire +30 2 £55,000 +33.33%
Staffordshire +12 2 £53,750 +34.37%
Yorkshire +6 2 £65,000 -16.12% 1
West Yorkshire +6 2 £65,000 -16.12% 1
Guildford - 2 £50,000 -
Fareham - 2 £48,000 -
Wokingham - 2 £55,000 -
Coventry - 2 £57,500 -

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

1 168 (75.00%) SQL
2 124 (55.36%) SQL Server
3 120 (53.57%) OLAP
4 94 (41.96%) ETL
5 84 (37.50%) Data Warehouse
5 84 (37.50%) Oracle
6 79 (35.27%) SQL Server Integration Services
7 76 (33.93%) Performance Tuning
8 74 (33.04%) Business Intelligence
9 70 (31.25%) MySQL
10 66 (29.46%) Microsoft
11 64 (28.57%) SQL Server Reporting Services
12 63 (28.13%) T-SQL
13 57 (25.45%) SQL Server Analysis Services
14 46 (20.54%) Analytical Skills
15 45 (20.09%) PL/SQL
16 44 (19.64%) Agile Software Development
17 42 (18.75%) Oracle OLAP
18 40 (17.86%) Oracle Database
19 39 (17.41%) Replication
19 39 (17.41%) Linux
20 38 (16.96%) Disaster Recovery
21 35 (15.63%) ITIL
21 35 (15.63%) Degree
22 34 (15.18%) Relational Database
23 33 (14.73%) SQL Server 2012
23 33 (14.73%) Java
24 31 (13.84%) SQL Server 2008
25 30 (13.39%) Unix
25 30 (13.39%) Data Modelling

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 9 (4.02%) Apache Spark
2 8 (3.57%) Apache
2 8 (3.57%) IIS
3 7 (3.13%) SharePoint
3 7 (3.13%) Tomcat
4 4 (1.79%) Cloud Foundry
4 4 (1.79%) Elasticsearch
4 4 (1.79%) GemFire
4 4 (1.79%) Oracle Service Bus
5 3 (1.34%) JBoss
5 3 (1.34%) WebLogic
6 1 (0.45%) Apache Solr
6 1 (0.45%) OpenStack
6 1 (0.45%) Oracle SOA Suite
Applications
1 5 (2.23%) Microsoft Excel
2 4 (1.79%) MS Visio
Business Applications
1 4 (1.79%) SAP CO
1 4 (1.79%) SAP FI
1 4 (1.79%) SAP FI/CO
1 4 (1.79%) SAP FSCM
1 4 (1.79%) SAP MM
1 4 (1.79%) SAP PS
1 4 (1.79%) SAP SD
2 1 (0.45%) Cognos Business Intelligence
2 1 (0.45%) Dynamics CRM
2 1 (0.45%) FastStats
Cloud Services
1 24 (10.71%) Microsoft Azure
2 18 (8.04%) Amazon AWS
3 14 (6.25%) Cloud Computing
4 10 (4.46%) GitHub
5 7 (3.13%) PaaS
6 6 (2.68%) IaaS
7 3 (1.34%) Azure Data Factory
7 3 (1.34%) Google Cloud Platform
7 3 (1.34%) SaaS
8 1 (0.45%) Data Lake Analytics
8 1 (0.45%) Datadog
8 1 (0.45%) Slack
Communications & Networking
1 10 (4.46%) SAN
2 9 (4.02%) Intranet
3 5 (2.23%) Fibre Channel
4 4 (1.79%) Wireless
5 3 (1.34%) Extranet
6 2 (0.89%) Internet
Database & Business Intelligence
1 124 (55.36%) SQL Server
2 120 (53.57%) OLAP
3 84 (37.50%) Data Warehouse
4 79 (35.27%) SQL Server Integration Services
5 70 (31.25%) MySQL
6 64 (28.57%) SQL Server Reporting Services
7 57 (25.45%) SQL Server Analysis Services
8 42 (18.75%) Oracle OLAP
9 40 (17.86%) Oracle Database
10 34 (15.18%) Relational Database
11 33 (14.73%) SQL Server 2012
12 31 (13.84%) SQL Server 2008
13 25 (11.16%) SQL Server 2014
14 24 (10.71%) DB2
15 23 (10.27%) NoSQL
16 22 (9.82%) Oracle ODI
17 21 (9.38%) RDBMS
18 20 (8.93%) Data Mining
19 19 (8.48%) Hadoop
20 16 (7.14%) Big Data
Development Applications
1 18 (8.04%) Team Foundation Server
2 14 (6.25%) JIRA
2 14 (6.25%) Visual Studio
3 7 (3.13%) Git (software)
4 5 (2.23%) Jenkins
4 5 (2.23%) Talend Open Studio
4 5 (2.23%) tSQLt
5 4 (1.79%) Eclipse
5 4 (1.79%) Gradle
5 4 (1.79%) JUnit
5 4 (1.79%) Oracle Forms
6 1 (0.45%) ERwin
6 1 (0.45%) git-flow
6 1 (0.45%) MagicDraw
6 1 (0.45%) Octopus Deploy
General
1 22 (9.82%) Finance
2 15 (6.70%) Advertising
3 12 (5.36%) Retail
4 4 (1.79%) Pharmaceutical
5 3 (1.34%) Banking
6 1 (0.45%) Automotive
6 1 (0.45%) Games
6 1 (0.45%) Investment Banking
6 1 (0.45%) Marketing
6 1 (0.45%) Wholesale Banking
Job Titles
1 92 (41.07%) Developer
2 52 (23.21%) DBA
3 43 (19.20%) SQL Developer
4 35 (15.63%) SQL DBA
5 34 (15.18%) Administrator
6 31 (13.84%) Architect
7 26 (11.61%) Analyst
7 26 (11.61%) SQL Server DBA
8 25 (11.16%) Oracle Developer
9 22 (9.82%) Business Intelligence Developer
10 20 (8.93%) SQL Analyst
11 18 (8.04%) C++ Developer
12 17 (7.59%) Data Analyst
12 17 (7.59%) Technical Architect
13 16 (7.14%) SQL Data Analyst
14 14 (6.25%) Unix Developer
15 13 (5.80%) Data Warehouse Developer
15 13 (5.80%) SQL BI Developer
16 12 (5.36%) Business Intelligence Analyst
17 11 (4.91%) Lead Architect
Libraries, Frameworks & Software Standards
1 21 (9.38%) STL
2 20 (8.93%) Web Services
3 18 (8.04%) Oracle GoldenGate
4 17 (7.59%) .NET
5 15 (6.70%) XML
6 14 (6.25%) HTML
7 9 (4.02%) MDX
8 7 (3.13%) ASP.NET
8 7 (3.13%) Boost C++ Libraries
8 7 (3.13%) Middleware
9 6 (2.68%) ASP.NET MVC
10 5 (2.23%) Kafka
10 5 (2.23%) WinForms
11 4 (1.79%) COM
11 4 (1.79%) JSON
11 4 (1.79%) Spark Streaming
11 4 (1.79%) Spring
11 4 (1.79%) Spring Batch
11 4 (1.79%) Spring Boot
11 4 (1.79%) Spring Integration
Miscellaneous
1 46 (20.54%) Analytical Skills
2 39 (17.41%) Replication
3 25 (11.16%) Computer Science
4 20 (8.93%) Fintech
5 18 (8.04%) Clustering
6 7 (3.13%) Equities
6 7 (3.13%) Fixed Income
7 6 (2.68%) Foreign Exchange (FX)
8 5 (2.23%) EMC VMAX
9 4 (1.79%) Linux Command Line
9 4 (1.79%) Management Information System
9 4 (1.79%) PDA
9 4 (1.79%) Virtual Team
10 3 (1.34%) PKI
11 2 (0.89%) Blog
11 2 (0.89%) Data Protection Act
11 2 (0.89%) Enterprise Software
11 2 (0.89%) Reference Data
12 1 (0.45%) Data Structures
12 1 (0.45%) Public Cloud
Operating Systems
1 39 (17.41%) Linux
2 30 (13.39%) Unix
3 24 (10.71%) Windows
4 12 (5.36%) Windows Server 2008
4 12 (5.36%) Windows Server 2012
5 10 (4.46%) Red Hat Enterprise Linux
6 7 (3.13%) Windows Server
7 6 (2.68%) Solaris
8 2 (0.89%) Ubuntu
9 1 (0.45%) Windows NT
Processes & Methodologies
1 94 (41.96%) ETL
2 76 (33.93%) Performance Tuning
3 74 (33.04%) Business Intelligence
4 44 (19.64%) Agile Software Development
5 38 (16.96%) Disaster Recovery
6 35 (15.63%) ITIL
7 30 (13.39%) Data Modelling
8 28 (12.50%) High Availability
9 27 (12.05%) ETL Development
10 26 (11.61%) Kimball Methodology
11 23 (10.27%) Dimensional Modelling
12 17 (7.59%) E-Commerce
12 17 (7.59%) UML
13 16 (7.14%) Unit Testing
14 15 (6.70%) Change Management
14 15 (6.70%) Data Transformation
14 15 (6.70%) Database Tuning
14 15 (6.70%) DevOps
14 15 (6.70%) Scrum
14 15 (6.70%) Visualisation
Programming Languages
1 168 (75.00%) SQL
2 63 (28.13%) T-SQL
3 45 (20.09%) PL/SQL
4 33 (14.73%) Java
5 23 (10.27%) C++
6 14 (6.25%) C#
7 10 (4.46%) PowerShell
8 9 (4.02%) Shell Script
9 6 (2.68%) ABAP
9 6 (2.68%) JavaScript
10 5 (2.23%) Python
10 5 (2.23%) VB.NET
11 4 (1.79%) VB
11 4 (1.79%) VB6
11 4 (1.79%) VBScript
12 3 (1.34%) PHP
13 2 (0.89%) R
14 1 (0.45%) Data Analysis Expressions (DAX)
14 1 (0.45%) Perl
14 1 (0.45%) XPath
Qualifications
1 35 (15.63%) Degree
2 16 (7.14%) Microsoft Certification
3 7 (3.13%) Oracle Certification
4 5 (2.23%) SC Cleared
4 5 (2.23%) Security Cleared
5 4 (1.79%) MCITP
6 3 (1.34%) Computer Science Degree
7 2 (0.89%) MCSE
Quality Assurance & Compliance
1 21 (9.38%) QA
2 15 (6.70%) Data Quality
3 2 (0.89%) GDPR
3 2 (0.89%) PCI DSS
4 1 (0.45%) Sarbanes-Oxley
4 1 (0.45%) SLA
System Software
1 10 (4.46%) Oracle RAC
2 6 (2.68%) Active Directory
3 5 (2.23%) GlusterFS
3 5 (2.23%) Veritas Cluster Server
4 4 (1.79%) Apache ZooKeeper
4 4 (1.79%) HDFS
5 2 (0.89%) Virtual Machines
5 2 (0.89%) VMware Infrastructure
6 1 (0.45%) Apache Flume
6 1 (0.45%) KVM
Systems Management
1 7 (3.13%) Oracle Enterprise Manager
2 6 (2.68%) NetBackup
2 6 (2.68%) Red Hat Satellite
3 5 (2.23%) Oracle ZFS
3 5 (2.23%) Veritas Storage Foundation
4 4 (1.79%) Ansible
4 4 (1.79%) Enterprise Manager Cloud Control
4 4 (1.79%) Oracle RMAN
5 3 (1.34%) Tivoli
6 2 (0.89%) Failover Clustering
6 2 (0.89%) Microsoft Clustering
7 1 (0.45%) Cobbler
7 1 (0.45%) Kibana
7 1 (0.45%) Nagios
7 1 (0.45%) Opscode Chef
7 1 (0.45%) Perfmon
7 1 (0.45%) PowerCLI
7 1 (0.45%) Rundeck
7 1 (0.45%) Systems Management Server (SMS)
7 1 (0.45%) ZABBIX
Vendors
1 84 (37.50%) Oracle
2 66 (29.46%) Microsoft
3 10 (4.46%) Red Hat
4 9 (4.02%) Cognos
5 7 (3.13%) Vertica
6 6 (2.68%) Brocade
6 6 (2.68%) RedGate
6 6 (2.68%) SAP
6 6 (2.68%) SolarWinds
6 6 (2.68%) Tableau
6 6 (2.68%) Veritas
7 5 (2.23%) EMC
7 5 (2.23%) Informatica
7 5 (2.23%) Intel
7 5 (2.23%) StorageTek
7 5 (2.23%) Sun
7 5 (2.23%) Talend
8 4 (1.79%) Google
8 4 (1.79%) IBM
8 4 (1.79%) Jaspersoft
Central London / West End
The Workshop
Posted: 2 days ago
Brentwood, Essex
Shawbrook
Posted: 2 days ago
London
Talent Spa
Salary: £70k per year
Posted: 2 days ago
Colchester
Nigel Frank International
Salary: £35000 - £45000 per annum + Benefits
Posted: 5 days ago
City, London
onezeero.
Salary: £65000 per annum
Posted: 6 days ago
South East London
Client Server
Salary: £35k to £50k + benefits
Posted: 3 days ago
Manchester, Lancashire
Harvey Nash plc
Posted: 4 days ago
Bath, Avon
Optima Connections
Salary: From £30,000 to £35,000 per annum + Benefits
Posted: 6 days ago
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 6 days ago
London
Franklin Bates
Salary: From £50,000 to £60,000 per annum
Posted: 6 days ago
Colchester
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits, Pension
Posted: 10 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 6 days ago
Brighton
Nigel Frank International
Salary: £70000 per annum + Pension, Health, Bonus
Posted: 13 days ago
Preston, Lancashire
Oscar
Salary: £25000 - £40000 per annum
Posted: 3 days ago
West London
Profile 29 Limited
Salary: From £80,000 to £100,000 per annum + benefits
Posted: 5 days ago
Bradford, West Yorkshire
Candour Solutions
Salary: From £60,000 to £70,000 per annum plus outstanding benefits
Posted: 6 days ago
London
Client Server
Salary: £35000 - £50000 per annum + benefits
Posted: 11 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 16 days ago
London
Client Server
Salary: £35k to £50k + benefits
Posted: 18 days ago
London
Client Server
Salary: £35k to £50k + benefits
Posted: 25 days ago