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

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
England / London
Rank 533 574 570
Rank change year-on-year +41 -4  
Permanent jobs citing OLTP 55 82 84
As % of all permanent IT jobs advertised in London 0.16% 0.20% 0.20%
As % of the Database & Business Intelligence category 0.54% 0.63% 0.66%
Number of salaries quoted 40 55 61
Median salary £70,000 £57,500 £62,500
Median salary % change year-on-year +21.73% -8.00%  
90% offered a salary of more than £45,000 £45,500 £47,500
10% offered a salary of more than £80,250 £75,000 £74,000
UK excluding London median salary £52,500 £47,500 £45,000
% change year-on-year +10.52% +5.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 10162 13033 12723
As % of all permanent IT job vacancies advertised in London 30.21% 31.26% 30.33%
Number of salaries quoted 8826 11375 10921
Median salary £60,000 £57,000 £55,000
Median salary % change year-on-year +5.26% +3.63%  
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

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 March 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 March 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 +53 14 £71,250 +23.91% 2
West End of London - 3 £60,000 - 1
Brentford - 1 £60,000 -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 24 March 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 92 (74.19%) SQL
2 69 (55.65%) SQL Server
3 52 (41.94%) Oracle
4 48 (38.71%) Performance Tuning
5 46 (37.10%) Data Warehouse
6 42 (33.87%) Linux
7 36 (29.03%) OLAP
7 36 (29.03%) Agile Software Development
8 35 (28.23%) SQL Server Integration Services
9 34 (27.42%) Analytical Skills
10 32 (25.81%) C++
11 31 (25.00%) STL
12 29 (23.39%) MS Excel
12 29 (23.39%) SQL Server Reporting Services
13 28 (22.58%) Microsoft
14 27 (21.77%) Business Intelligence
14 27 (21.77%) Degree
15 26 (20.97%) ETL
16 25 (20.16%) T-SQL
16 25 (20.16%) MySQL
17 23 (18.55%) Intel
17 23 (18.55%) Fintech
18 21 (16.94%) Finance
18 21 (16.94%) Windows
18 21 (16.94%) Oracle OLAP
19 20 (16.13%) OO
19 20 (16.13%) Disaster Recovery
20 19 (15.32%) Web Services
20 19 (15.32%) DB2
20 19 (15.32%) PL/SQL

OLTP
Top Related 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 14 (11.29%) Apache
1 14 (11.29%) Tomcat
2 11 (8.87%) IIS
2 11 (8.87%) Oracle Coherence
2 11 (8.87%) Oracle HTTP Server
2 11 (8.87%) WebSphere
3 3 (2.42%) Apache Spark
3 3 (2.42%) JBoss
3 3 (2.42%) WebLogic
4 1 (0.81%) Apache Solr
4 1 (0.81%) SharePoint
Applications
1 29 (23.39%) MS Excel
Cloud Services
1 19 (15.32%) Microsoft Azure
2 16 (12.90%) Amazon AWS
3 8 (6.45%) IaaS
4 6 (4.84%) Cloud Computing
5 5 (4.03%) PaaS
6 3 (2.42%) SaaS
7 1 (0.81%) Google Cloud Platform
Communications & Networking
1 16 (12.90%) SAN
2 11 (8.87%) FCoE
2 11 (8.87%) Fibre Channel
2 11 (8.87%) HTTP
2 11 (8.87%) iSCSI
2 11 (8.87%) LAN
2 11 (8.87%) Multicast
2 11 (8.87%) NAS
2 11 (8.87%) WAN
3 1 (0.81%) Internet
Database & Business Intelligence
1 69 (55.65%) SQL Server
2 46 (37.10%) Data Warehouse
3 36 (29.03%) OLAP
4 35 (28.23%) SQL Server Integration Services
5 29 (23.39%) SQL Server Reporting Services
6 25 (20.16%) MySQL
7 21 (16.94%) Oracle OLAP
8 19 (15.32%) DB2
9 16 (12.90%) Oracle Database
9 16 (12.90%) SQL Server 2012
10 14 (11.29%) KDB
10 14 (11.29%) SQL Server Analysis Services
11 12 (9.68%) SQL Server 2014
12 11 (8.87%) Oracle ODI
13 10 (8.06%) NoSQL
14 9 (7.26%) Microsoft Analysis Services
14 9 (7.26%) MongoDB
14 9 (7.26%) SQL Server 2008
15 5 (4.03%) Relational Database
16 4 (3.23%) OLAP Cube
Development Applications
1 7 (5.65%) Team Foundation Server
2 5 (4.03%) JIRA
3 1 (0.81%) Cucumber
3 1 (0.81%) ERwin
3 1 (0.81%) FitNesse
3 1 (0.81%) JBehave
3 1 (0.81%) MagicDraw
General
1 21 (16.94%) Finance
2 6 (4.84%) Retail
3 4 (3.23%) Games
4 3 (2.42%) Pharmaceutical
5 2 (1.61%) Advertising
5 2 (1.61%) Banking
5 2 (1.61%) Telecoms
6 1 (0.81%) Investment Banking
6 1 (0.81%) Wholesale Banking
Job Titles
1 59 (47.58%) Developer
2 25 (20.16%) C++ Developer
3 24 (19.35%) DBA
4 22 (17.74%) Architect
4 22 (17.74%) SQL Developer
5 21 (16.94%) Oracle Developer
5 21 (16.94%) SQL DBA
6 17 (13.71%) Unix Developer
7 15 (12.10%) Lead Architect
7 15 (12.10%) SQL Server DBA
8 14 (11.29%) Infrastructure Architect
9 9 (7.26%) Technical Architect
10 8 (6.45%) ETL Developer
10 8 (6.45%) Low Latency C++ Developer
10 8 (6.45%) Senior DBA
10 8 (6.45%) Systems Developer
11 7 (5.65%) Database Developer
11 7 (5.65%) Lead Developer
11 7 (5.65%) SQL Database Developer
12 6 (4.84%) Senior SQL DBA
Libraries, Frameworks & Software Standards
1 31 (25.00%) STL
2 19 (15.32%) Web Services
3 14 (11.29%) Boost C++ Libraries
3 14 (11.29%) Middleware
4 9 (7.26%) .NET
5 8 (6.45%) Oracle GoldenGate
6 6 (4.84%) ASP.NET
6 6 (4.84%) XML
7 4 (3.23%) ASP.NET MVC
8 3 (2.42%) ASP.NET MVC 4
8 3 (2.42%) CSS
8 3 (2.42%) Entity Framework
8 3 (2.42%) HTML
8 3 (2.42%) KnockoutJS
8 3 (2.42%) LESS
8 3 (2.42%) REST
8 3 (2.42%) RESTful
8 3 (2.42%) SAML
8 3 (2.42%) XHTML
8 3 (2.42%) XSL
Miscellaneous
1 34 (27.42%) Analytical Skills
2 23 (18.55%) Fintech
3 17 (13.71%) Computer Science
4 14 (11.29%) Equities
4 14 (11.29%) Fixed Income
4 14 (11.29%) Replication
5 7 (5.65%) Clustering
6 4 (3.23%) Management Information System
7 3 (2.42%) Life Science
7 3 (2.42%) PKI
8 2 (1.61%) Enterprise Software
8 2 (1.61%) Online Games
9 1 (0.81%) Data Structures
9 1 (0.81%) Reference Data
9 1 (0.81%) Taxonomies
Operating Systems
1 42 (33.87%) Linux
2 21 (16.94%) Windows
3 18 (14.52%) Unix
4 11 (8.87%) Solaris
5 5 (4.03%) Windows Server
5 5 (4.03%) Windows Server 2008
5 5 (4.03%) Windows Server 2012
Processes & Methodologies
1 48 (38.71%) Performance Tuning
2 36 (29.03%) Agile Software Development
3 27 (21.77%) Business Intelligence
4 26 (20.97%) ETL
5 20 (16.13%) Disaster Recovery
5 20 (16.13%) OO
6 16 (12.90%) Unit Testing
7 14 (11.29%) High-Frequency Trading
7 14 (11.29%) Low Latency
7 14 (11.29%) Performance Optimisation
7 14 (11.29%) System Testing
8 11 (8.87%) Benchmarking
8 11 (8.87%) High Availability
8 11 (8.87%) Risk Management
9 8 (6.45%) Change Management
9 8 (6.45%) Database Tuning
9 8 (6.45%) Dimensional Modelling
9 8 (6.45%) ETL Development
9 8 (6.45%) Kimball Methodology
10 7 (5.65%) Project Management
Programming Languages
1 92 (74.19%) SQL
2 32 (25.81%) C++
3 25 (20.16%) T-SQL
4 19 (15.32%) PL/SQL
5 13 (10.48%) C#
6 9 (7.26%) Java
7 6 (4.84%) JavaScript
8 5 (4.03%) PowerShell
9 3 (2.42%) Python
9 3 (2.42%) R
10 1 (0.81%) SPARQL
Qualifications
1 27 (21.77%) Degree
2 16 (12.90%) Microsoft Certification
3 3 (2.42%) PhD
4 1 (0.81%) MCSE
Quality Assurance & Compliance
1 10 (8.06%) QA
2 2 (1.61%) Data Quality
3 1 (0.81%) SLA
System Software
1 11 (8.87%) Hyper-V
1 11 (8.87%) KVM
1 11 (8.87%) NFS
1 11 (8.87%) Oracle RAC
1 11 (8.87%) SRDF
1 11 (8.87%) VMware Infrastructure
1 11 (8.87%) Xen
Systems Management
1 4 (3.23%) Failover Clustering
2 3 (2.42%) Oracle Enterprise Manager
2 3 (2.42%) Tivoli
Vendors
1 52 (41.94%) Oracle
2 28 (22.58%) Microsoft
3 23 (18.55%) Intel
4 14 (11.29%) IBM
4 14 (11.29%) Vertica
5 11 (8.87%) Cisco
5 11 (8.87%) EMC
5 11 (8.87%) NetApp
5 11 (8.87%) VMware
6 3 (2.42%) BMC
7 1 (0.81%) Google
7 1 (0.81%) Informatica
7 1 (0.81%) Tableau
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 2 days ago
City, London
Rutherford Grant Recruitment
Salary: £60000.00 per annum
Posted: 3 days ago
Central London / West End
The Workshop
Posted: 3 days ago