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

Location
3 months to
6 Mar 2015
Same period 2014 Same period 2013
Online Transaction Processing (OLTP)
Rank 286 279 272
Rank change year-on-year
-7 -7
Permanent jobs citing OLTP 17 23 36
As % of all permanent IT jobs located in the City of London 0.17% 0.22% 0.34%
As % of the Database & Business Intelligence category 0.63% 0.82% 1.18%
Number of salaries quoted 17 13 26
Average salary £72,500 £62,500 £52,500
Average salary % change year-on-year
+16.00% +19.04%
90% offered a salary of more than £48,000 £46,000 £45,000
10% offered a salary of more than £74,000 £68,500 £65,000
UK excluding London average salary £45,000 £47,500 £42,500
% change year-on-year
-5.26% +11.76%
OLTP
London

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 City of London region.

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2680 2816 3059
As % of all permanent IT jobs located in the City of London 26.81% 27.46% 28.62%
Number of salaries quoted 2360 2460 2788
Average salary £55,000 £55,000 £50,000
Average salary % change year-on-year
- +10.00%
90% offered a salary of more than £37,500 £35,000 £35,000
10% offered a salary of more than £75,000 £70,000 £75,000
UK excluding London average salary £40,000 £40,000 £40,000

OLTP
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT jobs citing OLTP across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

OLTP Jobs Demand Trend in the City of London

OLTP
Salary Trend in the City of London

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

OLTP Salary Trend in the City of London

OLTP
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing OLTP across the City of London region over the 3 months to 6 March 2015.

OLTP Salary Histogram in the City of London

OLTP
Top 30 Related IT Skills in the City of London

For the 6 months to 6 March 2015, IT jobs across the City of 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 53 (88.33%) SQL
2 40 (66.67%) Oracle
3 39 (65.00%) Data Warehouse
4 37 (61.67%) Business Intelligence
5 34 (56.67%) ETL
6 33 (55.00%) SQL Server
7 24 (40.00%) .NET
8 22 (36.67%) OLAP
9 19 (31.67%) Data Modelling
10 18 (30.00%) SQL Server 2012
10 18 (30.00%) Oracle Database
11 17 (28.33%) ERP
11 17 (28.33%) Java
11 17 (28.33%) JavaScript
12 16 (26.67%) CRM
12 16 (26.67%) Microsoft
12 16 (26.67%) Siebel
12 16 (26.67%) Oracle BI EE
12 16 (26.67%) Oracle BI Publisher
13 15 (25.00%) Oracle OLAP
14 14 (23.33%) T-SQL
15 13 (21.67%) PL/SQL
15 13 (21.67%) SQL Server Reporting Services
15 13 (21.67%) Analytical Skills
16 12 (20.00%) Performance Tuning
16 12 (20.00%) Agile Software Development
17 11 (18.33%) Finance
17 11 (18.33%) SQL Server Integration Services
17 11 (18.33%) SQL Server 2008
17 11 (18.33%) Oracle Database 11g

OLTP
Top Related IT Skills in the City of London by Category

For the 6 months to 6 March 2015, IT jobs across the City of 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 2 (3.33%) WebLogic
1 2 (3.33%) Oracle Application Server
1 2 (3.33%) Elasticsearch
Applications
1 1 (1.67%) MS Excel
Business Applications
1 2 (3.33%) Oracle BPM
2 1 (1.67%) Oracle Applications
Cloud Services
1 3 (5.00%) SaaS
2 1 (1.67%) Amazon EC2
2 1 (1.67%) Amazon AWS
Communications & Networking
1 4 (6.67%) Internet
2 2 (3.33%) LDAP
Database & Business Intelligence
1 39 (65.00%) Data Warehouse
2 33 (55.00%) SQL Server
3 22 (36.67%) OLAP
4 18 (30.00%) SQL Server 2012
4 18 (30.00%) Oracle Database
5 16 (26.67%) Oracle BI Publisher
5 16 (26.67%) Oracle BI EE
6 15 (25.00%) Oracle OLAP
7 13 (21.67%) SQL Server Reporting Services
8 11 (18.33%) SQL Server Integration Services
8 11 (18.33%) SQL Server 2008
8 11 (18.33%) Oracle Database 11g
9 9 (15.00%) Oracle Database 12c
10 7 (11.67%) SQL Server Analysis Services
10 7 (11.67%) Oracle Database 10g
10 7 (11.67%) SQL Server 2000
10 7 (11.67%) MySQL
11 6 (10.00%) Hadoop
12 5 (8.33%) NoSQL
12 5 (8.33%) TKPROF
Development Applications
1 5 (8.33%) Subversion
2 3 (5.00%) VSS/SourceSafe
2 3 (5.00%) Oracle Forms
2 3 (5.00%) Mercurial
3 2 (3.33%) Talend Open Studio
4 1 (1.67%) AccuRev
4 1 (1.67%) Team Foundation Server
4 1 (1.67%) Visual Studio
4 1 (1.67%) Selenium
General
1 11 (18.33%) Finance
2 8 (13.33%) Banking
3 2 (3.33%) Law
4 1 (1.67%) Advertising
4 1 (1.67%) Retail
Job Titles
1 25 (41.67%) Developer
2 16 (26.67%) Head of Development
3 15 (25.00%) DBA
4 8 (13.33%) SQL DBA
5 6 (10.00%) SQL Developer
5 6 (10.00%) Oracle Developer
5 6 (10.00%) SQL Server DBA
5 6 (10.00%) Database Developer
5 6 (10.00%) Report Developer
6 5 (8.33%) Senior SQL DBA
6 5 (8.33%) Senior DBA
6 5 (8.33%) Senior SQL Server DBA
7 4 (6.67%) Administrator
7 4 (6.67%) Business Intelligence Developer
8 3 (5.00%) Head of Business Intelligence
8 3 (5.00%) Business Developer
9 2 (3.33%) Team Leader
9 2 (3.33%) Senior Developer
9 2 (3.33%) Server Administrator
10 1 (1.67%) MySQL DBA
Libraries, Frameworks & Software Standards
1 24 (40.00%) .NET
2 3 (5.00%) HTML
3 2 (3.33%) REST
3 2 (3.33%) Oracle Fusion
3 2 (3.33%) SOAP
3 2 (3.33%) Web Services
3 2 (3.33%) XML
3 2 (3.33%) XSD
3 2 (3.33%) XSLT
3 2 (3.33%) XML Schema
3 2 (3.33%) Middleware
4 1 (1.67%) jQuery
4 1 (1.67%) HTML5
4 1 (1.67%) ASP.NET
4 1 (1.67%) Twitter Bootstrap
Miscellaneous
1 13 (21.67%) Analytical Skills
2 10 (16.67%) Clustering
3 9 (15.00%) Replication
4 6 (10.00%) Data Integration
5 3 (5.00%) Computer Science
5 3 (5.00%) Reference Data
6 2 (3.33%) Data Structures
6 2 (3.33%) Social Network
6 2 (3.33%) Open Source
6 2 (3.33%) W3C
7 1 (1.67%) Economics
Operating Systems
1 3 (5.00%) UNIX
1 3 (5.00%) Windows
1 3 (5.00%) Windows Server 2008
2 1 (1.67%) Linux
Processes & Methodologies
1 37 (61.67%) Business Intelligence
2 34 (56.67%) ETL
3 19 (31.67%) Data Modelling
4 17 (28.33%) ERP
5 16 (26.67%) CRM
6 12 (20.00%) Agile Software Development
6 12 (20.00%) Performance Tuning
7 8 (13.33%) High Availability
7 8 (13.33%) Load Balancing
7 8 (13.33%) Disaster Recovery
8 6 (10.00%) Data Architecture
9 5 (8.33%) E-Commerce
9 5 (8.33%) UML
9 5 (8.33%) OO
9 5 (8.33%) OOD
9 5 (8.33%) Logical Data Model
9 5 (8.33%) Physical Data Model
10 4 (6.67%) Service Delivery
10 4 (6.67%) TDD
11 3 (5.00%) Information Management
Programming Languages
1 53 (88.33%) SQL
2 17 (28.33%) Java
2 17 (28.33%) JavaScript
3 14 (23.33%) T-SQL
4 13 (21.67%) PL/SQL
5 4 (6.67%) Bash Shell
6 3 (5.00%) C
7 2 (3.33%) VBA
7 2 (3.33%) XPath
8 1 (1.67%) Shell Script
8 1 (1.67%) C#
8 1 (1.67%) Perl
Qualifications
1 8 (13.33%) Degree
2 3 (5.00%) DV Cleared
2 3 (5.00%) Security Cleared
3 1 (1.67%) Microsoft Certification
3 1 (1.67%) MCITP
Quality Assurance & Compliance
1 7 (11.67%) QA
2 5 (8.33%) Data Quality
System Software
1 10 (16.67%) Oracle RAC
Systems Management
1 5 (8.33%) Oracle Enterprise Manager
2 1 (1.67%) Nagios
Vendors
1 40 (66.67%) Oracle
2 16 (26.67%) Siebel
2 16 (26.67%) Microsoft
3 6 (10.00%) Informatica
4 3 (5.00%) Teradata
4 3 (5.00%) Red Gate
4 3 (5.00%) SAP
4 3 (5.00%) Cognos
4 3 (5.00%) Birst
5 2 (3.33%) Sun
5 2 (3.33%) Vertica
5 2 (3.33%) Talend
City of London
Real Staffing
Salary: £50000 - £60000 per annum + competitive
Posted: 3 days ago
City of London
iKonnect
Salary: £45000 per annum + Benefits & Bonus
Posted: 3 days ago
City of London
Mason Frank
Salary: £68000 - £75000 per annum + Fantastic Benefits Package
Posted: 16 days ago