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

Location
3 months to
12 Feb 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 566 553 509
Rank change year-on-year
-13 -44
Permanent jobs citing OLTP 79 100 144
As % of all permanent IT jobs located in London 0.19% 0.24% 0.33%
As % of the Database & Business Intelligence category 0.62% 0.80% 1.08%
Number of salaries quoted 59 83 114
Average salary £55,000 £55,000 £60,000
Average salary % change year-on-year
- -8.33%
90% offered a salary of more than £44,500 £45,500 £42,500
10% offered a salary of more than £76,000 £74,800 £85,000
UK excluding London average salary £47,500 £45,000 £47,500
% change year-on-year
+5.55% -5.26%
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
12798 12465 13386
As % of all permanent IT jobs located in London 31.30% 29.99% 30.93%
Number of salaries quoted 11113 10741 11408
Average salary £55,000 £55,000 £55,000
90% offered a salary of more than £40,000 £37,500 £37,500
10% offered a salary of more than £80,000 £77,500 £75,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLTP
Jobs Demand Trend in London

This chart provides a 3-month moving total of permanent IT jobs citing OLTP across the London region as a proportion of the total demand within 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 12 February 2016.

OLTP Salary Histogram in London

OLTP
Job Locations in London

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLTP within the London region over the 3 months to 12 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +42 13 £57,500 -11.53%
Kingston Upon Thames - 3 £59,250 -
Surbiton - 3 £55,000 -
Croydon -6 1 £52,000 -16.80%
Teddington - 1 - - 1
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 12 February 2016, IT jobs across the London region citing OLTP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP.

1 111 (63.79%) SQL
2 82 (47.13%) SQL Server
3 77 (44.25%) Oracle
3 77 (44.25%) OLAP
4 69 (39.66%) ETL
4 69 (39.66%) Business Intelligence
5 67 (38.51%) Data Warehouse
6 51 (29.31%) SQL Server Reporting Services
7 49 (28.16%) SQL Server Integration Services
7 49 (28.16%) MySQL
8 43 (24.71%) Finance
9 42 (24.14%) Agile Software Development
10 40 (22.99%) Microsoft
11 37 (21.26%) Degree
12 36 (20.69%) MS Excel
13 34 (19.54%) SQL Server Analysis Services
14 33 (18.97%) Performance Tuning
15 32 (18.39%) PL/SQL
15 32 (18.39%) Oracle OLAP
16 31 (17.82%) Replication
16 31 (17.82%) Data Modelling
16 31 (17.82%) Linux
17 29 (16.67%) Oracle Database
18 28 (16.09%) Analytics
18 28 (16.09%) Unix
19 26 (14.94%) T-SQL
20 25 (14.37%) OO
20 25 (14.37%) Relational Database
21 24 (13.79%) Analytical Skills
21 24 (13.79%) Banking

OLTP
Top Related IT Skills in London by Category

For the 6 months to 12 February 2016, IT jobs across the London region citing OLTP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP. Up to 20 skills are shown per category.

Application Platforms
1 12 (6.90%) Confluence
2 4 (2.30%) Tomcat
3 3 (1.72%) Apache Pig
3 3 (1.72%) Oracle Spatial
3 3 (1.72%) SharePoint
4 2 (1.15%) Apache
4 2 (1.15%) Apache Spark
5 1 (0.57%) IIS
5 1 (0.57%) Liferay
5 1 (0.57%) Oracle Service Bus
5 1 (0.57%) Oracle Workflow
5 1 (0.57%) WebLogic
5 1 (0.57%) WebLogic Portal
Applications
1 36 (20.69%) MS Excel
2 1 (0.57%) MS Office
2 1 (0.57%) MS PowerPoint
Business Applications
1 12 (6.90%) Cognos Business Intelligence
2 1 (0.57%) MetaTrader
2 1 (0.57%) Unica
Cloud Services
1 16 (9.20%) Amazon AWS
2 12 (6.90%) Microsoft Azure
3 5 (2.87%) SaaS
Communications & Networking
1 4 (2.30%) Internet
1 4 (2.30%) SAN
2 3 (1.72%) SSH
3 1 (0.57%) Fibre Channel
3 1 (0.57%) LDAP
Database & Business Intelligence
1 82 (47.13%) SQL Server
2 77 (44.25%) OLAP
3 67 (38.51%) Data Warehouse
4 51 (29.31%) SQL Server Reporting Services
5 49 (28.16%) MySQL
5 49 (28.16%) SQL Server Integration Services
6 34 (19.54%) SQL Server Analysis Services
7 32 (18.39%) Oracle OLAP
8 29 (16.67%) Oracle Database
9 25 (14.37%) Relational Database
10 17 (9.77%) Oracle ODI
11 13 (7.47%) Amazon RDS
11 13 (7.47%) NoSQL
11 13 (7.47%) SQL Server 2008
12 12 (6.90%) Cognos Analysis Studio
12 12 (6.90%) Cognos Event Studio
12 12 (6.90%) Cognos Metric Studio
13 11 (6.32%) DB2
13 11 (6.32%) SQL Server 2012
14 10 (5.75%) QlikView
Development Applications
1 21 (12.07%) Git (software)
2 17 (9.77%) Jenkins
3 15 (8.62%) JIRA
4 12 (6.90%) Team Foundation Server
5 6 (3.45%) Subversion
6 3 (1.72%) Maven
6 3 (1.72%) Sonatype Nexus
6 3 (1.72%) Visual Studio
7 2 (1.15%) Mercurial
7 2 (1.15%) Oracle Forms
7 2 (1.15%) VSS/SourceSafe
General
1 43 (24.71%) Finance
2 24 (13.79%) Banking
3 23 (13.22%) Marketing
4 15 (8.62%) Retail
5 10 (5.75%) Games
5 10 (5.75%) Legal
5 10 (5.75%) Pharmaceutical
6 7 (4.02%) Back Office
7 5 (2.87%) Investment Banking
8 4 (2.30%) Financial Institution
8 4 (2.30%) Telecoms
9 3 (1.72%) Billing
10 1 (0.57%) Manufacturing
10 1 (0.57%) Private Banking
Job Titles
1 85 (48.85%) Developer
2 40 (22.99%) DBA
3 31 (17.82%) Oracle Developer
4 25 (14.37%) SQL Developer
5 21 (12.07%) Administrator
5 21 (12.07%) Database Developer
6 20 (11.49%) Architect
6 20 (11.49%) MySQL DBA
7 19 (10.92%) Senior Developer
8 18 (10.34%) Business Intelligence Developer
9 17 (9.77%) C++ Developer
9 17 (9.77%) Unix Developer
10 15 (8.62%) Senior Database Developer
10 15 (8.62%) SQL DBA
11 13 (7.47%) Lead Developer
12 12 (6.90%) Cognos BI Developer
12 12 (6.90%) Cognos Developer
13 10 (5.75%) Azure Developer
13 10 (5.75%) Marketing Database Developer
13 10 (5.75%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 22 (12.64%) .NET
1 22 (12.64%) MDX
1 22 (12.64%) XML
2 17 (9.77%) STL
3 16 (9.20%) Middleware
4 14 (8.05%) HTML
5 13 (7.47%) Apache Flex
5 13 (7.47%) HTML5
5 13 (7.47%) JavaFX
5 13 (7.47%) Web Services
6 9 (5.17%) Oracle GoldenGate
7 6 (3.45%) ASP.NET
7 6 (3.45%) XSLT
8 5 (2.87%) ASP.NET MVC
9 3 (1.72%) Backbone.js
9 3 (1.72%) JSP
9 3 (1.72%) KnockoutJS
9 3 (1.72%) Mustache
9 3 (1.72%) SOAP
9 3 (1.72%) Struts
Miscellaneous
1 31 (17.82%) Replication
2 24 (13.79%) Analytical Skills
3 23 (13.22%) Clustering
4 13 (7.47%) Enterprise Software
5 9 (5.17%) Client/Server
5 9 (5.17%) Online Games
6 7 (4.02%) Reference Data
7 6 (3.45%) Computer Science
7 6 (3.45%) Life Science
7 6 (3.45%) Management Information System
8 5 (2.87%) Data Integration
9 3 (1.72%) Data Structures
10 2 (1.15%) Blackberry
10 2 (1.15%) Data Centre
11 1 (0.57%) Contract for Difference
11 1 (0.57%) Economics
11 1 (0.57%) Mathematics
11 1 (0.57%) Ontologies
11 1 (0.57%) Spread Betting
11 1 (0.57%) Statistics
Operating Systems
1 31 (17.82%) Linux
2 28 (16.09%) Unix
3 17 (9.77%) Windows
4 6 (3.45%) Solaris
5 3 (1.72%) AIX
6 2 (1.15%) Red Hat Enterprise Linux
6 2 (1.15%) Windows Server
Processes & Methodologies
1 69 (39.66%) Business Intelligence
1 69 (39.66%) ETL
2 42 (24.14%) Agile Software Development
3 33 (18.97%) Performance Tuning
4 31 (17.82%) Data Modelling
5 28 (16.09%) Analytics
6 25 (14.37%) OO
7 20 (11.49%) E-Commerce
7 20 (11.49%) ITIL
8 19 (10.92%) SDLC
9 18 (10.34%) Mentoring
9 18 (10.34%) Open Source
10 17 (9.77%) Kimball Methodology
10 17 (9.77%) Marketing Analytics
11 16 (9.20%) Data Management
12 15 (8.62%) PRINCE2
13 11 (6.32%) Change Control
13 11 (6.32%) High Availability
13 11 (6.32%) Software Delivery
14 10 (5.75%) Investment Management
Programming Languages
1 111 (63.79%) SQL
2 32 (18.39%) PL/SQL
3 26 (14.94%) T-SQL
4 20 (11.49%) C#
5 17 (9.77%) C++
5 17 (9.77%) Java
6 10 (5.75%) C
6 10 (5.75%) Perl
7 9 (5.17%) JavaScript
8 7 (4.02%) Python
8 7 (4.02%) Shell Script
9 5 (2.87%) PowerShell
10 3 (1.72%) Jython
10 3 (1.72%) XPath
11 2 (1.15%) Bash Shell
12 1 (0.57%) Clojure
12 1 (0.57%) Data Analysis Expressions (DAX)
12 1 (0.57%) Ruby
12 1 (0.57%) Scala
12 1 (0.57%) SPARQL
Qualifications
1 37 (21.26%) Degree
2 6 (3.45%) PhD
3 3 (1.72%) ITIL Certification
4 2 (1.15%) DV Cleared
4 2 (1.15%) IBM Certification
4 2 (1.15%) Security Cleared
5 1 (0.57%) MCSE
5 1 (0.57%) Microsoft Certification
5 1 (0.57%) OCA
5 1 (0.57%) OCP
5 1 (0.57%) Oracle Certification
Quality Assurance & Compliance
1 21 (12.07%) Data Quality
2 14 (8.05%) PCI DSS
3 7 (4.02%) QA
3 7 (4.02%) SLA
4 6 (3.45%) EMIR
5 5 (2.87%) Dodd-Frank
6 3 (1.72%) COBIT
7 1 (0.57%) MiFID
System Software
1 8 (4.60%) Oracle RAC
2 3 (1.72%) VMware Infrastructure
3 2 (1.15%) Veritas Cluster Server
4 1 (0.57%) Docker
4 1 (0.57%) GlusterFS
Systems Management
1 12 (6.90%) Puppet
2 9 (5.17%) Oracle RMAN
3 8 (4.60%) Oracle Enterprise Manager
4 5 (2.87%) Data Guard
5 3 (1.72%) Oracle ZFS
6 2 (1.15%) NetBackup
6 2 (1.15%) Oracle Statspack
6 2 (1.15%) Veritas Storage Foundation
7 1 (0.57%) Control-M
7 1 (0.57%) Mesos
7 1 (0.57%) Red Hat Satellite
7 1 (0.57%) Tivoli
Vendors
1 77 (44.25%) Oracle
2 40 (22.99%) Microsoft
3 16 (9.20%) Cognos
4 13 (7.47%) IBM
4 13 (7.47%) InterSystems
5 12 (6.90%) hybris
6 5 (2.87%) Bloomberg
7 4 (2.30%) Red Gate
7 4 (2.30%) Tableau
8 3 (1.72%) GoldenSource
8 3 (1.72%) Informatica
8 3 (1.72%) Vertica
8 3 (1.72%) VMware
8 3 (1.72%) WorldPay
9 2 (1.15%) RainStor
9 2 (1.15%) Red Hat
9 2 (1.15%) Remedy
9 2 (1.15%) Sun
9 2 (1.15%) Sybase
9 2 (1.15%) Veritas
London
SLS Services Limited
Posted: 20 hours ago
Central London / West End
Digital Vision Search Ltd
Salary: From £65,000 to £75,000 per annum + Shares + Private Healthcare
Posted: Yesterday
North London
Lorien Resourcing
Salary: £55000 - £65000 per annum + Bonus + Benefits
Posted: 3 days ago
London
Bridge Noble
Salary: £45000 - £70000 per annum + stock options
Posted: 4 days ago
London
Real Staffing
Salary: £70000 - £80000 per annum + competitive
Posted: 7 days ago
London
iKas International
Salary: £55000 - £70000 per annum
Posted: 22 days ago
Teddington
Ortolan Group
Posted: 23 days ago