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

3 months to
29 Apr 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 566 565 484
Rank change year-on-year
-1 -81
Permanent jobs citing OLTP 90 98 213
As % of all permanent IT jobs located in London 0.21% 0.22% 0.43%
As % of the Database & Business Intelligence category 0.69% 0.70% 1.37%
Number of salaries quoted 59 75 165
Average salary £59,250 £65,000 £52,500
Average salary % change year-on-year
-8.84% +23.80%
90% offered a salary of more than £47,500 £48,500 £38,800
10% offered a salary of more than £75,000 £75,000 £66,800
UK excluding London average salary £52,500 £45,000 £55,000
% change year-on-year
+16.66% -18.18%
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
13037 13961 15560
As % of all permanent IT jobs located in London 30.85% 31.23% 31.75%
Number of salaries quoted 11403 11992 13296
Average salary £57,500 £55,000 £52,500
Average salary % change year-on-year
+4.54% +4.76%
90% offered a salary of more than £40,000 £38,500 £35,000
10% offered a salary of more than £80,000 £75,000 £80,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 29 April 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 29 April 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 15 £57,500 -8.00% 4
Kingston Upon Thames - 3 £59,250 -
Teddington - 2 - -
Romford - 1 £82,500 -
Surbiton - 1 £57,500 -
Wimbledon - 1 - -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 29 April 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 134 (78.82%) SQL
2 96 (56.47%) SQL Server
3 91 (53.53%) Oracle
4 77 (45.29%) OLAP
5 72 (42.35%) Data Warehouse
6 68 (40.00%) Microsoft
7 66 (38.82%) ETL
8 58 (34.12%) Business Intelligence
9 55 (32.35%) MS Excel
9 55 (32.35%) SQL Server Reporting Services
10 54 (31.76%) SQL Server Integration Services
11 51 (30.00%) MySQL
12 47 (27.65%) Finance
13 46 (27.06%) SQL Server Analysis Services
14 42 (24.71%) Degree
15 41 (24.12%) Performance Tuning
16 40 (23.53%) Oracle OLAP
17 39 (22.94%) Linux
18 38 (22.35%) Agile Software Development
19 37 (21.76%) PL/SQL
20 32 (18.82%) Oracle Database
21 28 (16.47%) Analytical Skills
21 28 (16.47%) Data Modelling
22 26 (15.29%) T-SQL
22 26 (15.29%) Java
22 26 (15.29%) Unix
22 26 (15.29%) Windows
22 26 (15.29%) MDX
22 26 (15.29%) Marketing
22 26 (15.29%) Relational Database

OLTP
Top Related IT Skills in London by Category

For the 6 months to 29 April 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 6 (3.53%) Confluence
2 4 (2.35%) Oracle Spatial
2 4 (2.35%) Oracle Workflow
3 3 (1.76%) Apache
3 3 (1.76%) WebLogic
4 2 (1.18%) Apache Pig
4 2 (1.18%) Apache Spark
4 2 (1.18%) IIS
4 2 (1.18%) Oracle Coherence
4 2 (1.18%) Oracle HTTP Server
4 2 (1.18%) SharePoint
4 2 (1.18%) Tomcat
4 2 (1.18%) WebSphere
Applications
1 55 (32.35%) MS Excel
2 4 (2.35%) MS Office
3 1 (0.59%) MS PowerPoint
3 1 (0.59%) MS Visio
3 1 (0.59%) Spreadsheet
Business Applications
1 4 (2.35%) Cognos Business Intelligence
1 4 (2.35%) Unica
2 3 (1.76%) MetaTrader
Cloud Services
1 14 (8.24%) Microsoft Azure
2 7 (4.12%) Amazon AWS
Communications & Networking
1 5 (2.94%) SAN
2 3 (1.76%) Fibre Channel
3 2 (1.18%) FCoE
3 2 (1.18%) HTTP
3 2 (1.18%) iSCSI
3 2 (1.18%) LAN
3 2 (1.18%) Multicast
3 2 (1.18%) NAS
3 2 (1.18%) WAN
Database & Business Intelligence
1 96 (56.47%) SQL Server
2 77 (45.29%) OLAP
3 72 (42.35%) Data Warehouse
4 55 (32.35%) SQL Server Reporting Services
5 54 (31.76%) SQL Server Integration Services
6 51 (30.00%) MySQL
7 46 (27.06%) SQL Server Analysis Services
8 40 (23.53%) Oracle OLAP
9 32 (18.82%) Oracle Database
10 26 (15.29%) Relational Database
11 22 (12.94%) SQL Server 2008
12 18 (10.59%) SQL Server 2012
13 16 (9.41%) Oracle ODI
14 15 (8.82%) DB2
15 13 (7.65%) NoSQL
16 12 (7.06%) OLAP Cube
17 11 (6.47%) Oracle Database 10g
17 11 (6.47%) Oracle Database 11g
18 10 (5.88%) Microsoft Analysis Services
19 9 (5.29%) MongoDB
Development Applications
1 13 (7.65%) Git (software)
2 11 (6.47%) Team Foundation Server
3 8 (4.71%) Jenkins
4 6 (3.53%) JIRA
4 6 (3.53%) Oracle APEX
4 6 (3.53%) VSS/SourceSafe
5 1 (0.59%) Visual Studio
General
1 47 (27.65%) Finance
2 26 (15.29%) Marketing
3 20 (11.76%) Retail
4 12 (7.06%) Banking
4 12 (7.06%) Games
5 9 (5.29%) Legal
6 8 (4.71%) Telecoms
7 7 (4.12%) Pharmaceutical
8 5 (2.94%) Private Banking
9 4 (2.35%) Publishing
10 3 (1.76%) Back Office
11 2 (1.18%) Advertising
11 2 (1.18%) Financial Institution
12 1 (0.59%) Investment Banking
12 1 (0.59%) Manufacturing
Job Titles
1 100 (58.82%) Developer
2 47 (27.65%) Oracle Developer
3 35 (20.59%) SQL Developer
4 32 (18.82%) DBA
5 25 (14.71%) SSIS Developer
5 25 (14.71%) SSRS Developer
6 24 (14.12%) SSAS Developer
7 23 (13.53%) Architect
8 22 (12.94%) Database Developer
9 21 (12.35%) SQL DBA
10 19 (11.18%) C++ Developer
10 19 (11.18%) Unix Developer
11 18 (10.59%) Senior Developer
12 15 (8.82%) Business Intelligence Developer
12 15 (8.82%) Senior Database Developer
13 14 (8.24%) SQL Server DBA
14 13 (7.65%) Solutions Architect
15 11 (6.47%) Administrator
15 11 (6.47%) SQL Database Developer
16 10 (5.88%) Lead Developer
Libraries, Frameworks & Software Standards
1 26 (15.29%) MDX
2 21 (12.35%) .NET
3 20 (11.76%) Web Services
4 19 (11.18%) STL
4 19 (11.18%) XML
5 16 (9.41%) Middleware
6 12 (7.06%) Apache Flex
6 12 (7.06%) HTML
6 12 (7.06%) HTML5
6 12 (7.06%) JavaFX
6 12 (7.06%) Oracle GoldenGate
7 6 (3.53%) ASP.NET
7 6 (3.53%) SOAP
8 5 (2.94%) ASP.NET MVC
9 3 (1.76%) SAML
10 2 (1.18%) Kafka
11 1 (0.59%) Play Framework
11 1 (0.59%) WinForms
11 1 (0.59%) XML Schema
Miscellaneous
1 28 (16.47%) Analytical Skills
2 23 (13.53%) Replication
3 19 (11.18%) Enterprise Software
4 16 (9.41%) Clustering
5 13 (7.65%) Data Integration
6 11 (6.47%) Online Games
7 8 (4.71%) Management Information System
8 7 (4.12%) Computer Science
9 6 (3.53%) Data Structures
9 6 (3.53%) Life Science
10 3 (1.76%) Mobile Payment
10 3 (1.76%) PKI
10 3 (1.76%) Spread Betting
11 2 (1.18%) Blackberry
11 2 (1.18%) Fintech
11 2 (1.18%) Reference Data
12 1 (0.59%) Client/Server
12 1 (0.59%) EMC VMAX
12 1 (0.59%) Hedge funds
12 1 (0.59%) Ontologies
Operating Systems
1 39 (22.94%) Linux
2 26 (15.29%) Unix
2 26 (15.29%) Windows
3 11 (6.47%) Solaris
4 7 (4.12%) Windows Server
5 3 (1.76%) Red Hat Enterprise Linux
6 2 (1.18%) AIX
Processes & Methodologies
1 66 (38.82%) ETL
2 58 (34.12%) Business Intelligence
3 41 (24.12%) Performance Tuning
4 38 (22.35%) Agile Software Development
5 28 (16.47%) Data Modelling
6 25 (14.71%) OO
7 24 (14.12%) Kimball Methodology
8 23 (13.53%) Analytics
9 21 (12.35%) Open Source
10 20 (11.76%) Dimensional Modelling
11 19 (11.18%) Data Management
12 18 (10.59%) E-Commerce
12 18 (10.59%) Marketing Analytics
13 14 (8.24%) Data Transformation
14 12 (7.06%) ITIL
14 12 (7.06%) PRINCE2
14 12 (7.06%) Project Management
14 12 (7.06%) SDLC
15 11 (6.47%) Continuous Integration
15 11 (6.47%) Software Delivery
Programming Languages
1 134 (78.82%) SQL
2 37 (21.76%) PL/SQL
3 26 (15.29%) Java
3 26 (15.29%) T-SQL
4 24 (14.12%) C++
5 19 (11.18%) C#
6 12 (7.06%) Perl
7 8 (4.71%) PowerShell
7 8 (4.71%) Python
8 6 (3.53%) JavaScript
9 5 (2.94%) PHP
10 4 (2.35%) Data Analysis Expressions (DAX)
10 4 (2.35%) Shell Script
11 1 (0.59%) C
11 1 (0.59%) Clojure
11 1 (0.59%) Ruby
11 1 (0.59%) Scala
11 1 (0.59%) SPARQL
11 1 (0.59%) VB.NET
11 1 (0.59%) VBScript
Qualifications
1 42 (24.71%) Degree
2 6 (3.53%) PhD
3 3 (1.76%) IBM Certification
4 2 (1.18%) MCSE
4 2 (1.18%) Microsoft Certification
5 1 (0.59%) MBA
5 1 (0.59%) OCA
5 1 (0.59%) OCP
5 1 (0.59%) Oracle Certification
Quality Assurance & Compliance
1 21 (12.35%) Data Quality
2 8 (4.71%) PCI DSS
3 7 (4.12%) SLA
4 6 (3.53%) QA
5 2 (1.18%) COBIT
6 1 (0.59%) Dodd-Frank
6 1 (0.59%) EMIR
System Software
1 3 (1.76%) Oracle RAC
2 2 (1.18%) Hyper-V
2 2 (1.18%) KVM
2 2 (1.18%) NFS
2 2 (1.18%) SRDF
2 2 (1.18%) VMware Infrastructure
2 2 (1.18%) Xen
3 1 (0.59%) Docker
3 1 (0.59%) GlusterFS
3 1 (0.59%) Veritas Cluster Server
Systems Management
1 6 (3.53%) Oracle RMAN
2 3 (1.76%) OpenView
2 3 (1.76%) Oracle ZFS
2 3 (1.76%) Puppet
2 3 (1.76%) Tivoli
3 2 (1.18%) Data Guard
3 2 (1.18%) Oracle Enterprise Manager
3 2 (1.18%) Oracle Statspack
4 1 (0.59%) Mesos
4 1 (0.59%) NetBackup
4 1 (0.59%) Red Hat Satellite
4 1 (0.59%) Veritas Storage Foundation
Vendors
1 91 (53.53%) Oracle
2 68 (40.00%) Microsoft
3 12 (7.06%) IBM
3 12 (7.06%) InterSystems
4 11 (6.47%) Cognos
4 11 (6.47%) Tableau
5 7 (4.12%) Vertica
6 5 (2.94%) Facebook
7 4 (2.35%) Alterian
7 4 (2.35%) Apteco
7 4 (2.35%) RedGate
7 4 (2.35%) Sun
8 3 (1.76%) BMC
8 3 (1.76%) EMC
8 3 (1.76%) hybris
8 3 (1.76%) Red Hat
9 2 (1.18%) Cisco
9 2 (1.18%) Intel
9 2 (1.18%) NetApp
9 2 (1.18%) Remedy
City, London
Sage UK Limited
Posted: 2 days ago
South West London
HAYS INFORMATION TECHNOLOGY
Salary: £50000.00 - £60000.00 per annum
Posted: 3 days ago
City of London
Hays London City Cheapside
Salary: £60000.00 - £65000.00 per annum
Posted: 15 days ago
City of London
Deerfoot IT Resources Ltd
Salary: £60000 - £65000 per annum + Bonus and Benefits
Posted: 15 days ago
South East London
TFL
Salary: From £50,000 to £60,000 per annum + Excellent Benefits
Posted: 23 days ago
Head Office, Hanger Lane, London
River Island
Salary: Competitive plus benefits
Posted: 25 days ago