The following table provides summary statistics for permanent job vacancies advertised in London 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 24 June 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
England / London
3 months to
24 Jun 2017
Same period 2016 Same period 2015
Rank 572 546 608
Rank change year-on-year -26 +62  
Permanent jobs citing OLTP 44 98 71
As % of all permanent IT jobs advertised in London 0.12% 0.24% 0.16%
As % of the Database & Business Intelligence category 0.40% 0.83% 0.49%
Number of salaries quoted 18 57 57
Median salary £61,250 £57,500 £65,000
Median salary % change year-on-year +6.52% -11.53%  
90% offered a salary of more than £42,500 £39,500 £50,000
10% offered a salary of more than £95,000 £80,000 £82,000
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 advertised in London with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
London
Permanent job vacancies with a requirement for database and business intelligence skills 10902 11809 14459
As % of all permanent IT job vacancies advertised in London 30.09% 29.48% 32.19%
Number of salaries quoted 9075 10266 12290
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.34% -  
90% offered a salary of more than £40,000 £40,000 £39,000
10% offered a salary of more than £82,500 £80,000 £80,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

OLTP
Job Vacancy Trend in London

The job posting trend of jobs advertised in London 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 London

OLTP
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP in London.

Salary trend for OLTP in London

OLTP
Salary Histogram in London

The salary distribution of IT jobs citing OLTP in London over the 3 months to 24 June 2017.

Salary histogram for OLTP in London

OLTP
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the London region over the 3 months to 24 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
City of London +7 1 £52,500 -16.00% 1
OLTP
England

For the 6 months to 24 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 across the London region with a requirement for OLTP.

1 69 (69.70%) SQL
2 52 (52.53%) Oracle
3 51 (51.52%) SQL Server
4 40 (40.40%) MySQL
5 39 (39.39%) OLAP
6 38 (38.38%) Data Warehouse
7 36 (36.36%) ETL
8 34 (34.34%) Performance Tuning
9 32 (32.32%) PL/SQL
10 27 (27.27%) Oracle Database
11 24 (24.24%) ETL Development
11 24 (24.24%) Oracle OLAP
12 23 (23.23%) C++
12 23 (23.23%) Linux
13 22 (22.22%) DB2
13 22 (22.22%) Dimensional Modelling
13 22 (22.22%) Oracle ODI
14 21 (21.21%) SQL Server Integration Services
14 21 (21.21%) Degree
14 21 (21.21%) STL
14 21 (21.21%) SQL Server Reporting Services
15 20 (20.20%) Business Intelligence
15 20 (20.20%) Analytical Skills
16 18 (18.18%) Oracle GoldenGate
16 18 (18.18%) Fintech
17 17 (17.17%) Replication
17 17 (17.17%) QA
18 16 (16.16%) Agile Software Development
18 16 (16.16%) Microsoft
18 16 (16.16%) Web Services

OLTP
Co-occurring IT Skills in London 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 5 (5.05%) Apache Spark
2 4 (4.04%) Apache
3 3 (3.03%) JBoss
3 3 (3.03%) Tomcat
3 3 (3.03%) WebLogic
4 2 (2.02%) Elasticsearch
5 1 (1.01%) Apache Solr
5 1 (1.01%) OpenStack
Cloud Services
1 15 (15.15%) Microsoft Azure
2 14 (14.14%) Amazon AWS
3 6 (6.06%) Cloud Computing
4 3 (3.03%) Google Cloud Platform
4 3 (3.03%) IaaS
5 2 (2.02%) SaaS
6 1 (1.01%) Datadog
6 1 (1.01%) PaaS
Communications & Networking
1 4 (4.04%) SAN
1 4 (4.04%) Wireless
2 1 (1.01%) Internet
Database & Business Intelligence
1 51 (51.52%) SQL Server
2 40 (40.40%) MySQL
3 39 (39.39%) OLAP
4 38 (38.38%) Data Warehouse
5 27 (27.27%) Oracle Database
6 24 (24.24%) Oracle OLAP
7 22 (22.22%) DB2
7 22 (22.22%) Oracle ODI
8 21 (21.21%) SQL Server Integration Services
8 21 (21.21%) SQL Server Reporting Services
9 15 (15.15%) Relational Database
10 14 (14.14%) SQL Server 2012
11 12 (12.12%) SQL Server 2014
12 11 (11.11%) NoSQL
12 11 (11.11%) OLAP Cube
12 11 (11.11%) SQL Server 2008
13 10 (10.10%) SQL Server Analysis Services
14 8 (8.08%) Big Data
15 7 (7.07%) KDB
16 6 (6.06%) Hadoop
Development Applications
1 12 (12.12%) JIRA
2 9 (9.09%) Team Foundation Server
3 4 (4.04%) Oracle Forms
4 1 (1.01%) ERwin
4 1 (1.01%) Git (software)
4 1 (1.01%) Jenkins
4 1 (1.01%) MagicDraw
4 1 (1.01%) Octopus Deploy
General
1 9 (9.09%) Finance
2 4 (4.04%) Pharmaceutical
2 4 (4.04%) Retail
3 3 (3.03%) Banking
4 2 (2.02%) Advertising
5 1 (1.01%) Games
5 1 (1.01%) Investment Banking
5 1 (1.01%) Wholesale Banking
Job Titles
1 49 (49.49%) Developer
2 25 (25.25%) Oracle Developer
3 18 (18.18%) C++ Developer
4 17 (17.17%) SQL Developer
5 14 (14.14%) Architect
5 14 (14.14%) Unix Developer
6 13 (13.13%) DBA
7 11 (11.11%) Data Warehouse Developer
8 10 (10.10%) Oracle Data Warehouse Developer
8 10 (10.10%) SQL DBA
9 9 (9.09%) SQL Server DBA
9 9 (9.09%) Technical Architect
10 6 (6.06%) Database Developer
10 6 (6.06%) PL/SQL Developer
11 5 (5.05%) Lead Developer
11 5 (5.05%) SQL Database Developer
12 4 (4.04%) Lead Architect
12 4 (4.04%) Low Latency C++ Developer
12 4 (4.04%) Systems Developer
12 4 (4.04%) Technical Leader
Libraries, Frameworks & Software Standards
1 21 (21.21%) STL
2 18 (18.18%) Oracle GoldenGate
3 16 (16.16%) Web Services
4 10 (10.10%) XML
5 7 (7.07%) .NET
5 7 (7.07%) Boost C++ Libraries
6 5 (5.05%) ASP.NET
6 5 (5.05%) ASP.NET MVC
6 5 (5.05%) WinForms
7 4 (4.04%) COM
8 3 (3.03%) Java EE
8 3 (3.03%) Middleware
8 3 (3.03%) SAML
9 2 (2.02%) RESTful
9 2 (2.02%) Velocity
10 1 (1.01%) Kafka
10 1 (1.01%) LAMP
10 1 (1.01%) Lucene
10 1 (1.01%) MDX
Miscellaneous
1 20 (20.20%) Analytical Skills
2 18 (18.18%) Fintech
3 17 (17.17%) Replication
4 7 (7.07%) Equities
4 7 (7.07%) Fixed Income
5 6 (6.06%) Clustering
5 6 (6.06%) Computer Science
6 4 (4.04%) PDA
7 3 (3.03%) Management Information System
7 3 (3.03%) PKI
8 2 (2.02%) Reference Data
9 1 (1.01%) Data Structures
9 1 (1.01%) Derivative
9 1 (1.01%) Life Science
9 1 (1.01%) OTC Derivatives
9 1 (1.01%) Public Cloud
9 1 (1.01%) Taxonomies
Operating Systems
1 23 (23.23%) Linux
2 15 (15.15%) Unix
3 13 (13.13%) Windows
4 4 (4.04%) Windows Server
4 4 (4.04%) Windows Server 2008
4 4 (4.04%) Windows Server 2012
Processes & Methodologies
1 36 (36.36%) ETL
2 34 (34.34%) Performance Tuning
3 24 (24.24%) ETL Development
4 22 (22.22%) Dimensional Modelling
5 20 (20.20%) Business Intelligence
6 16 (16.16%) Agile Software Development
7 15 (15.15%) OO
8 12 (12.12%) Kimball Methodology
8 12 (12.12%) Unit Testing
9 11 (11.11%) Kanban
10 10 (10.10%) Data Transformation
10 10 (10.10%) Database Tuning
11 9 (9.09%) Disaster Recovery
11 9 (9.09%) Performance Optimisation
11 9 (9.09%) Scrum
11 9 (9.09%) Test Automation
12 7 (7.07%) DevOps
12 7 (7.07%) High-Frequency Trading
12 7 (7.07%) Low Latency
12 7 (7.07%) System Testing
Programming Languages
1 69 (69.70%) SQL
2 32 (32.32%) PL/SQL
3 23 (23.23%) C++
4 15 (15.15%) Java
4 15 (15.15%) T-SQL
5 7 (7.07%) C#
6 5 (5.05%) JavaScript
6 5 (5.05%) PowerShell
6 5 (5.05%) Python
7 4 (4.04%) VB
7 4 (4.04%) VB6
8 2 (2.02%) PHP
8 2 (2.02%) R
9 1 (1.01%) Bash Shell
9 1 (1.01%) Data Analysis Expressions (DAX)
9 1 (1.01%) Perl
9 1 (1.01%) Shell Script
9 1 (1.01%) SPARQL
Qualifications
1 21 (21.21%) Degree
2 7 (7.07%) Microsoft Certification
3 2 (2.02%) Computer Science Degree
4 1 (1.01%) MCITP
4 1 (1.01%) MCSE
Quality Assurance & Compliance
1 17 (17.17%) QA
2 4 (4.04%) Data Quality
3 1 (1.01%) PCI DSS
3 1 (1.01%) Sarbanes-Oxley
System Software
1 2 (2.02%) Virtual Machines
2 1 (1.01%) Apache Flume
2 1 (1.01%) KVM
2 1 (1.01%) VMware Infrastructure
Systems Management
1 4 (4.04%) Ansible
2 3 (3.03%) Oracle Enterprise Manager
2 3 (3.03%) Tivoli
3 2 (2.02%) Failover Clustering
3 2 (2.02%) Microsoft Clustering
4 1 (1.01%) Cobbler
4 1 (1.01%) Kibana
4 1 (1.01%) Nagios
4 1 (1.01%) Opscode Chef
4 1 (1.01%) Perfmon
4 1 (1.01%) PowerCLI
4 1 (1.01%) Puppet
4 1 (1.01%) Rundeck
4 1 (1.01%) ZABBIX
Vendors
1 52 (52.53%) Oracle
2 16 (16.16%) Microsoft
3 7 (7.07%) Vertica
4 5 (5.05%) Intel
5 3 (3.03%) BMC
5 3 (3.03%) Google
5 3 (3.03%) IBM
6 2 (2.02%) Tableau
7 1 (1.01%) Adobe
7 1 (1.01%) Brocade
7 1 (1.01%) Cisco
7 1 (1.01%) Cloudera
7 1 (1.01%) Dynatrace
7 1 (1.01%) Informatica
7 1 (1.01%) Juniper
7 1 (1.01%) Percona
7 1 (1.01%) RedGate
7 1 (1.01%) Sitecore
7 1 (1.01%) Sybase
7 1 (1.01%) VMware
Central London / West End
The Workshop
Posted: Yesterday
London
Talent Spa
Salary: £70k per year
Posted: Yesterday
City, London
onezeero.
Salary: £65000 per annum
Posted: 5 days ago
South East London
Client Server
Salary: £35k to £50k + benefits
Posted: 2 days ago
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 5 days ago
London
Franklin Bates
Salary: From £50,000 to £60,000 per annum
Posted: 5 days ago
West London
Profile 29 Limited
Salary: From £80,000 to £100,000 per annum + benefits
Posted: 4 days ago
London
Client Server
Salary: £35000 - £50000 per annum + benefits
Posted: 10 days ago
London
Client Server
Salary: £35k to £50k + benefits
Posted: 17 days ago
London
Client Server
Salary: £35k to £50k + benefits
Posted: 24 days ago