The table below looks at the statistics for OLTP skills in IT jobs advertised for the London region. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 27 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 May 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 551 589 495
Rank change year-on-year
+38 -94
Permanent jobs citing OLTP 93 81 221
As % of all permanent IT jobs located in London 0.23% 0.19% 0.45%
As % of the Database & Business Intelligence category 0.75% 0.58% 1.42%
Number of salaries quoted 58 64 170
Median salary £60,000 £65,000 £50,000
Median salary % change year-on-year
-7.69% +30.00%
90% offered a salary of more than £46,000 £50,000 £39,800
10% offered a salary of more than £80,750 £75,000 £65,000
UK excluding London median salary £47,500 £45,000 £52,500
% change year-on-year
+5.55% -14.28%
OLTP
England

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the London region.

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
12335 13932 15557
As % of all permanent IT jobs located in London 30.08% 32.09% 31.78%
Number of salaries quoted 10796 11923 13502
Median salary £57,500 £57,500 £52,500
Median salary % change year-on-year
- +9.52%
90% offered a salary of more than £40,000 £39,000 £36,000
10% offered a salary of more than £80,000 £75,000 £80,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLTP
Jobs Demand Trend in London

The demand trend of job ads across the London region citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in London

OLTP
Salary Trend in London

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

OLTP Salary Trend in London

OLTP
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing OLTP across the London region over the 3 months to 27 May 2016.

OLTP Salary Histogram 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 27 May 2016. 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
(Click see detailed
statistics and trends)
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 +45 17 £62,500 -
Teddington - 4 £52,500 - 1
Romford - 1 £82,500 -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 27 May 2016, 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 139 (81.29%) SQL
2 104 (60.82%) Oracle
3 99 (57.89%) SQL Server
4 84 (49.12%) OLAP
5 69 (40.35%) Microsoft
6 64 (37.43%) Data Warehouse
7 62 (36.26%) ETL
7 62 (36.26%) Business Intelligence
8 58 (33.92%) MS Excel
9 54 (31.58%) Finance
10 53 (30.99%) SQL Server Integration Services
11 52 (30.41%) SQL Server Reporting Services
11 52 (30.41%) MySQL
12 49 (28.65%) Oracle OLAP
13 48 (28.07%) Performance Tuning
14 47 (27.49%) Degree
15 43 (25.15%) SQL Server Analysis Services
16 41 (23.98%) PL/SQL
17 39 (22.81%) Linux
18 34 (19.88%) Oracle Database
19 33 (19.30%) Agile Software Development
20 31 (18.13%) Analytical Skills
21 29 (16.96%) Windows
21 29 (16.96%) Data Modelling
22 28 (16.37%) OO
23 26 (15.20%) Java
23 26 (15.20%) Unix
24 25 (14.62%) .NET
24 25 (14.62%) Kimball Methodology
25 24 (14.04%) C++

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 6 (3.51%) Apache
1 6 (3.51%) Confluence
2 5 (2.92%) IIS
2 5 (2.92%) Oracle Coherence
2 5 (2.92%) Oracle HTTP Server
2 5 (2.92%) Oracle Spatial
2 5 (2.92%) Oracle Workflow
2 5 (2.92%) Tomcat
2 5 (2.92%) WebSphere
3 3 (1.75%) WebLogic
4 2 (1.17%) Apache Pig
4 2 (1.17%) Apache Spark
Applications
1 58 (33.92%) MS Excel
2 5 (2.92%) MS Office
3 1 (0.58%) MS PowerPoint
3 1 (0.58%) MS Visio
3 1 (0.58%) Spreadsheet
Business Applications
1 5 (2.92%) Unica
2 4 (2.34%) Cognos Business Intelligence
3 3 (1.75%) MetaTrader
4 2 (1.17%) Endur
4 2 (1.17%) SAP FI
Cloud Services
1 14 (8.19%) Microsoft Azure
2 7 (4.09%) Amazon AWS
Communications & Networking
1 7 (4.09%) SAN
2 6 (3.51%) Fibre Channel
3 5 (2.92%) FCoE
3 5 (2.92%) HTTP
3 5 (2.92%) iSCSI
3 5 (2.92%) LAN
3 5 (2.92%) Multicast
3 5 (2.92%) NAS
3 5 (2.92%) WAN
Database & Business Intelligence
1 99 (57.89%) SQL Server
2 84 (49.12%) OLAP
3 64 (37.43%) Data Warehouse
4 53 (30.99%) SQL Server Integration Services
5 52 (30.41%) MySQL
5 52 (30.41%) SQL Server Reporting Services
6 49 (28.65%) Oracle OLAP
7 43 (25.15%) SQL Server Analysis Services
8 34 (19.88%) Oracle Database
9 23 (13.45%) SQL Server 2008
10 22 (12.87%) DB2
10 22 (12.87%) Relational Database
11 21 (12.28%) Oracle ODI
12 20 (11.70%) SQL Server 2012
13 16 (9.36%) BusinessObjects
14 13 (7.60%) OLAP Cube
14 13 (7.60%) Oracle Database 10g
14 13 (7.60%) Oracle Database 11g
15 12 (7.02%) Big Data
16 11 (6.43%) Microsoft Analysis Services
Development Applications
1 13 (7.60%) Git (software)
1 13 (7.60%) Team Foundation Server
2 8 (4.68%) Jenkins
2 8 (4.68%) Oracle APEX
2 8 (4.68%) VSS/SourceSafe
3 6 (3.51%) JIRA
4 1 (0.58%) Subversion
4 1 (0.58%) Visual Studio
General
1 54 (31.58%) Finance
2 24 (14.04%) Marketing
3 21 (12.28%) Retail
4 12 (7.02%) Banking
5 11 (6.43%) Games
6 10 (5.85%) Pharmaceutical
6 10 (5.85%) Telecoms
7 6 (3.51%) Legal
8 5 (2.92%) Private Banking
8 5 (2.92%) Publishing
9 3 (1.75%) Back Office
10 2 (1.17%) Advertising
10 2 (1.17%) Financial Institution
11 1 (0.58%) Manufacturing
Job Titles
1 105 (61.40%) Developer
2 54 (31.58%) Oracle Developer
3 34 (19.88%) SQL Developer
4 31 (18.13%) DBA
5 24 (14.04%) SSAS Developer
5 24 (14.04%) SSIS Developer
5 24 (14.04%) SSRS Developer
6 20 (11.70%) SQL DBA
7 19 (11.11%) C++ Developer
7 19 (11.11%) Senior Developer
7 19 (11.11%) Unix Developer
8 17 (9.94%) Database Developer
9 16 (9.36%) Architect
10 14 (8.19%) Business Intelligence Developer
10 14 (8.19%) SQL Server DBA
11 13 (7.60%) Senior Database Developer
12 11 (6.43%) Lead Developer
13 10 (5.85%) Azure Developer
13 10 (5.85%) Marketing Database Developer
14 9 (5.26%) C# .NET Developer
Libraries, Frameworks & Software Standards
1 25 (14.62%) .NET
2 24 (14.04%) Web Services
3 21 (12.28%) MDX
4 19 (11.11%) STL
5 17 (9.94%) XML
6 13 (7.60%) Oracle GoldenGate
7 10 (5.85%) Middleware
8 9 (5.26%) ASP.NET
9 8 (4.68%) SOAP
10 7 (4.09%) ASP.NET MVC
11 3 (1.75%) ODBC
11 3 (1.75%) SAML
12 2 (1.17%) Apache Flex
12 2 (1.17%) Django
12 2 (1.17%) HTML
12 2 (1.17%) HTML5
12 2 (1.17%) JavaFX
12 2 (1.17%) Kafka
12 2 (1.17%) WinForms
13 1 (0.58%) Play Framework
Miscellaneous
1 31 (18.13%) Analytical Skills
2 22 (12.87%) Replication
3 17 (9.94%) Clustering
4 13 (7.60%) Data Integration
4 13 (7.60%) Enterprise Software
5 10 (5.85%) Online Games
6 9 (5.26%) Life Science
6 9 (5.26%) Management Information System
7 7 (4.09%) Computer Science
8 6 (3.51%) Data Structures
9 4 (2.34%) Fintech
10 3 (1.75%) Mobile Payment
10 3 (1.75%) PKI
10 3 (1.75%) Spread Betting
11 2 (1.17%) Blackberry
12 1 (0.58%) Client/Server
12 1 (0.58%) Contract for Difference
12 1 (0.58%) Economics
12 1 (0.58%) Mathematics
12 1 (0.58%) Ontologies
Operating Systems
1 39 (22.81%) Linux
2 29 (16.96%) Windows
3 26 (15.20%) Unix
4 12 (7.02%) Solaris
5 8 (4.68%) Windows Server
6 3 (1.75%) Red Hat Enterprise Linux
7 1 (0.58%) AIX
7 1 (0.58%) Windows Server 2008
7 1 (0.58%) Windows Server 2012
Processes & Methodologies
1 62 (36.26%) Business Intelligence
1 62 (36.26%) ETL
2 48 (28.07%) Performance Tuning
3 33 (19.30%) Agile Software Development
4 29 (16.96%) Data Modelling
5 28 (16.37%) OO
6 25 (14.62%) Kimball Methodology
7 24 (14.04%) Dimensional Modelling
8 23 (13.45%) Analytics
9 21 (12.28%) Open Source
10 19 (11.11%) E-Commerce
11 16 (9.36%) Marketing Analytics
12 15 (8.77%) Data Transformation
12 15 (8.77%) SDLC
13 14 (8.19%) Data Management
13 14 (8.19%) Project Management
14 13 (7.60%) Continuous Integration
15 12 (7.02%) ITIL
16 11 (6.43%) Disaster Recovery
16 11 (6.43%) PRINCE2
Programming Languages
1 139 (81.29%) SQL
2 41 (23.98%) PL/SQL
3 26 (15.20%) Java
4 24 (14.04%) C++
5 23 (13.45%) C#
6 22 (12.87%) T-SQL
7 11 (6.43%) JavaScript
8 10 (5.85%) Python
9 9 (5.26%) Perl
10 8 (4.68%) PowerShell
11 5 (2.92%) PHP
11 5 (2.92%) Shell Script
12 3 (1.75%) C
12 3 (1.75%) Data Analysis Expressions (DAX)
13 1 (0.58%) Clojure
13 1 (0.58%) Ruby
13 1 (0.58%) Scala
13 1 (0.58%) SPARQL
13 1 (0.58%) VB.NET
13 1 (0.58%) VBScript
Qualifications
1 47 (27.49%) Degree
2 9 (5.26%) PhD
3 3 (1.75%) IBM Certification
4 2 (1.17%) MCSE
4 2 (1.17%) Microsoft Certification
5 1 (0.58%) MBA
Quality Assurance & Compliance
1 12 (7.02%) Data Quality
2 8 (4.68%) PCI DSS
3 6 (3.51%) SLA
4 5 (2.92%) QA
5 1 (0.58%) COBIT
System Software
1 5 (2.92%) Hyper-V
1 5 (2.92%) KVM
1 5 (2.92%) NFS
1 5 (2.92%) Oracle RAC
1 5 (2.92%) SRDF
1 5 (2.92%) VMware Infrastructure
1 5 (2.92%) Xen
2 1 (0.58%) Docker
2 1 (0.58%) GlusterFS
2 1 (0.58%) Veritas Cluster Server
Systems Management
1 3 (1.75%) OpenView
1 3 (1.75%) Oracle RMAN
1 3 (1.75%) Puppet
1 3 (1.75%) Tivoli
2 1 (0.58%) Mesos
2 1 (0.58%) NetBackup
2 1 (0.58%) Oracle Enterprise Manager
2 1 (0.58%) Oracle ZFS
2 1 (0.58%) Red Hat Satellite
2 1 (0.58%) Veritas Storage Foundation
Vendors
1 104 (60.82%) Oracle
2 69 (40.35%) Microsoft
3 18 (10.53%) IBM
4 13 (7.60%) Cognos
5 11 (6.43%) Tableau
6 6 (3.51%) EMC
6 6 (3.51%) Vertica
7 5 (2.92%) Alterian
7 5 (2.92%) Apteco
7 5 (2.92%) Cisco
7 5 (2.92%) Facebook
7 5 (2.92%) Intel
7 5 (2.92%) NetApp
7 5 (2.92%) SAP
7 5 (2.92%) VMware
8 4 (2.34%) Informatica
8 4 (2.34%) Sun
9 3 (1.75%) BMC
9 3 (1.75%) Red Hat
9 3 (1.75%) Sybase
London
Oscar
Salary: £50000 - £53000 per annum + Benefits
Posted: 2 hours ago
London
onezeero.
Salary: £55000 - £65000 per annum + 20% uncapped bonus + 12% pension
Posted: 2 days ago
South East London
Think IT Recruitment
Salary: £40000 - £50000 per annum + benefits
Posted: 3 days ago
London
Client Server
Salary: £25k to £40k + benefits
Posted: 7 days ago
London
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + bonus, pension, health care
Posted: 21 days ago
London
Client Server
Salary: £25,000 to £40,000 + benefits
Posted: 14 days ago
Teddington
Ortolan Group
Posted: 22 days ago