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

Location
3 months to
19 Sep 2014
Same period 2013 Same period 2012
Online Transaction Processing (OLTP)
Rank 470 493 520
Rank change year-on-year
+23 +27
Permanent jobs citing OLTP 165 113 131
As % of all permanent IT jobs located in London 0.36% 0.25% 0.26%
As % of the Database & Business Intelligence category 1.19% 0.85% 0.92%
Number of salaries quoted 126 90 110
Average salary £52,500 £57,500 £57,500
Average salary % change year-on-year
-8.69% -
90% offered a salary of more than £38,750 £42,500 £42,250
10% offered a salary of more than £72,500 £85,000 £67,500
UK excluding London average salary £45,000 £50,000 £37,500
% change year-on-year
-10.00% +33.33%
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
13887 13369 14246
As % of all permanent IT jobs located in London 30.15% 30.03% 28.68%
Number of salaries quoted 12105 11622 12592
Average salary £52,500 £55,000 £50,000
Average salary % change year-on-year
-4.54% +10.00%
90% offered a salary of more than £37,500 £37,000 £35,000
10% offered a salary of more than £75,000 £72,500 £75,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

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 19 September 2014.

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 19 September 2014. 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 +26 32 £54,500 -9.16% 1
Hounslow - 12 £45,000 -
Croydon - 3 £55,000 - 1
Harrow - 1 £35,000 - 1
Southwark - 1 - -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 19 September 2014, 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 338 (84.71%) SQL
2 245 (61.40%) SQL Server
3 197 (49.37%) Oracle
4 163 (40.85%) Data Warehouse
5 157 (39.35%) ETL
6 152 (38.10%) OLAP
7 136 (34.09%) SQL Server Integration Services
8 130 (32.58%) T-SQL
9 127 (31.83%) Performance Tuning
10 124 (31.08%) Business Intelligence
11 121 (30.33%) Relational Database
12 115 (28.82%) UNIX
13 110 (27.57%) SQL Server Reporting Services
14 107 (26.82%) Degree
15 106 (26.57%) Agile Software Development
16 103 (25.81%) RDBMS
17 98 (24.56%) Linux
18 92 (23.06%) Microsoft
18 92 (23.06%) SQL Server 2008
19 89 (22.31%) E-Commerce
20 87 (21.80%) Oracle OLAP
21 83 (20.80%) Analytical Skills
22 75 (18.80%) PL/SQL
22 75 (18.80%) Data Modelling
23 72 (18.05%) QA
24 70 (17.54%) MySQL
25 69 (17.29%) Java
25 69 (17.29%) Replication
26 66 (16.54%) SQL Server Analysis Services
27 60 (15.04%) Oracle Database

OLTP
Top Related IT Skills in London by Category

For the 6 months to 19 September 2014, 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 10 (2.51%) Apache
2 7 (1.75%) Tomcat
3 6 (1.50%) SAS
3 6 (1.50%) IIS
4 3 (0.75%) SharePoint
5 2 (0.50%) WorkSite
6 1 (0.25%) MS Exchange
Applications
1 49 (12.28%) MS Excel
2 2 (0.50%) MS Visio
2 2 (0.50%) MS Project
2 2 (0.50%) MS Office
Business Applications
1 4 (1.00%) Oracle Applications
1 4 (1.00%) Dynamics CRM
2 2 (0.50%) Remedy ITSM
2 2 (0.50%) Oracle Procure-to-Pay
2 2 (0.50%) Oracle Financials
2 2 (0.50%) SAP Oil and Gas
3 1 (0.25%) Cognos TM1
Cloud Services
1 10 (2.51%) Amazon EC2
1 10 (2.51%) Microsoft Azure
1 10 (2.51%) Amazon AWS
2 6 (1.50%) SaaS
3 3 (0.75%) PaaS
3 3 (0.75%) IaaS
4 1 (0.25%) Cloud Computing
Communications & Networking
1 13 (3.26%) Internet
2 9 (2.26%) SAN
3 6 (1.50%) SSH
3 6 (1.50%) HTTP
3 6 (1.50%) TCP/IP
3 6 (1.50%) SSL
4 3 (0.75%) DNS
4 3 (0.75%) ATM
4 3 (0.75%) LAN
4 3 (0.75%) WAN
4 3 (0.75%) Ethernet
4 3 (0.75%) iSCSI
4 3 (0.75%) FCoE
4 3 (0.75%) Fibre Channel
4 3 (0.75%) InfiniBand
5 2 (0.50%) LDAP
6 1 (0.25%) Intranet
6 1 (0.25%) NAS
Database & Business Intelligence
1 245 (61.40%) SQL Server
2 163 (40.85%) Data Warehouse
3 152 (38.10%) OLAP
4 136 (34.09%) SQL Server Integration Services
5 121 (30.33%) Relational Database
6 110 (27.57%) SQL Server Reporting Services
7 103 (25.81%) RDBMS
8 92 (23.06%) SQL Server 2008
9 87 (21.80%) Oracle OLAP
10 70 (17.54%) MySQL
11 66 (16.54%) SQL Server Analysis Services
12 60 (15.04%) Oracle Database
13 50 (12.53%) SQL Server 2012
14 47 (11.78%) DB2
15 46 (11.53%) Oracle ODI
16 40 (10.03%) SQL Server 2005
17 39 (9.77%) Oracle Database 11g
18 29 (7.27%) DataStage
19 22 (5.51%) Oracle Database 10g
20 21 (5.26%) Big Data
Development Applications
1 31 (7.77%) Talend Open Studio
2 12 (3.01%) Subversion
3 10 (2.51%) Team Foundation Server
4 9 (2.26%) Visual Studio
5 6 (1.50%) Ant
5 6 (1.50%) Maven
5 6 (1.50%) CruiseControl
5 6 (1.50%) Jenkins
6 5 (1.25%) ERwin
7 3 (0.75%) Toad
8 2 (0.50%) VSS/SourceSafe
8 2 (0.50%) Selenium
8 2 (0.50%) Mercurial
8 2 (0.50%) MSBuild
9 1 (0.25%) Git (software)
9 1 (0.25%) JIRA
General
1 52 (13.03%) Finance
2 47 (11.78%) Games
3 24 (6.02%) Retail
4 19 (4.76%) Marketing
5 14 (3.51%) Advertising
6 12 (3.01%) Legal
6 12 (3.01%) Pharmaceutical
7 9 (2.26%) Law
8 7 (1.75%) Banking
9 5 (1.25%) Music Industry
10 4 (1.00%) Online Betting
10 4 (1.00%) Telecoms
11 2 (0.50%) Back Office
11 2 (0.50%) Billing
11 2 (0.50%) Investment Banking
12 1 (0.25%) Publishing
Job Titles
1 157 (39.35%) Developer
2 91 (22.81%) DBA
3 57 (14.29%) Software Engineer
4 48 (12.03%) SQL Developer
5 42 (10.53%) Database Developer
6 39 (9.77%) Data Warehouse Developer
7 38 (9.52%) SQL DBA
8 32 (8.02%) Administrator
9 29 (7.27%) Senior Developer
9 29 (7.27%) Architect
10 28 (7.02%) SQL Server DBA
11 27 (6.77%) Business Intelligence Developer
12 26 (6.52%) Oracle Data Warehouse Developer
13 23 (5.76%) Oracle DBA
14 21 (5.26%) Software Development Engineer
14 21 (5.26%) Senior DBA
14 21 (5.26%) Development Engineer
15 18 (4.51%) Senior Software Engineer
16 15 (3.76%) Data Architect
17 14 (3.51%) Consultant
Libraries, Frameworks & Software Standards
1 51 (12.78%) .NET
2 39 (9.77%) STL
3 36 (9.02%) Swing
4 24 (6.02%) ASP.NET
4 24 (6.02%) XML
5 20 (5.01%) Django
6 17 (4.26%) MDX
7 16 (4.01%) CSS
8 12 (3.01%) HTML
9 11 (2.76%) COM
10 9 (2.26%) Apache Flex
11 8 (2.01%) WinForms
12 7 (1.75%) J2SE
12 7 (1.75%) J2EE
12 7 (1.75%) Servlets
13 6 (1.50%) Flash
13 6 (1.50%) Web Services
13 6 (1.50%) jQuery
13 6 (1.50%) HTML5
13 6 (1.50%) Twitter Bootstrap
Miscellaneous
1 83 (20.80%) Analytical Skills
2 69 (17.29%) Replication
3 57 (14.29%) Computer Science
4 55 (13.78%) iPad
5 35 (8.77%) Clustering
6 27 (6.77%) Online Games
7 12 (3.01%) Data Integration
7 12 (3.01%) Management Information System
7 12 (3.01%) Mathematics
8 9 (2.26%) Life Science
9 7 (1.75%) Enterprise Software
10 6 (1.50%) Visualisation
11 5 (1.25%) Digital Media
11 5 (1.25%) Social Network
11 5 (1.25%) Blackberry
12 4 (1.00%) N-Tier
13 3 (0.75%) Economics
13 3 (0.75%) Statistics
13 3 (0.75%) Data Conversion
13 3 (0.75%) Mobile App
Operating Systems
1 115 (28.82%) UNIX
2 98 (24.56%) Linux
3 42 (10.53%) Windows
4 19 (4.76%) Android
5 12 (3.01%) Windows Server 2008
6 8 (2.01%) Solaris
7 7 (1.75%) Oracle Linux
8 6 (1.50%) Windows Server 2012
8 6 (1.50%) Red Hat Enterprise Linux
9 4 (1.00%) AIX
Processes & Methodologies
1 157 (39.35%) ETL
2 127 (31.83%) Performance Tuning
3 124 (31.08%) Business Intelligence
4 106 (26.57%) Agile Software Development
5 89 (22.31%) E-Commerce
6 75 (18.80%) Data Modelling
7 56 (14.04%) Software Engineering
8 52 (13.03%) Dimensional Modelling
8 52 (13.03%) Scrum
9 50 (12.53%) Unit Testing
10 44 (11.03%) OO
11 36 (9.02%) Validation
12 31 (7.77%) TDD
13 27 (6.77%) Analytics
14 25 (6.27%) Disaster Recovery
14 25 (6.27%) Data Analysis
15 22 (5.51%) Project Management
16 20 (5.01%) Data Management
17 19 (4.76%) ITIL
17 19 (4.76%) Database Tuning
Programming Languages
1 338 (84.71%) SQL
2 130 (32.58%) T-SQL
3 75 (18.80%) PL/SQL
4 69 (17.29%) Java
5 58 (14.54%) C++
6 47 (11.78%) C#
7 40 (10.03%) JavaScript
8 38 (9.52%) Shell Script
9 36 (9.02%) C
10 26 (6.52%) Python
11 14 (3.51%) PHP
12 13 (3.26%) VB
13 12 (3.01%) Perl
14 11 (2.76%) VB6
15 10 (2.51%) Clojure
16 7 (1.75%) PowerShell
17 6 (1.50%) Tcl
17 6 (1.50%) ActionScript
18 5 (1.25%) PowerHouse
19 4 (1.00%) Ruby
Qualifications
1 107 (26.82%) Degree
2 29 (7.27%) Microsoft Certification
3 28 (7.02%) MCITP
4 12 (3.01%) MCTS
5 8 (2.01%) PhD
6 7 (1.75%) MCSE
7 6 (1.50%) OCP
7 6 (1.50%) Oracle Certification
8 2 (0.50%) DV Cleared
8 2 (0.50%) Security Cleared
9 1 (0.25%) OCA
9 1 (0.25%) MCDBA
Quality Assurance & Compliance
1 72 (18.05%) QA
2 36 (9.02%) ISO 9001
3 3 (0.75%) PCI DSS
3 3 (0.75%) ISO/IEC 27001
4 2 (0.50%) Data Quality
5 1 (0.25%) SLA
System Software
1 22 (5.51%) Oracle RAC
2 11 (2.76%) Oracle RMAN
3 6 (1.50%) Hyper-V
4 5 (1.25%) Active Directory
5 4 (1.00%) VMware Infrastructure
6 2 (0.50%) VMware ESX
Systems Management
1 27 (6.77%) Data Guard
2 11 (2.76%) Oracle Enterprise Manager
3 10 (2.51%) Opscode Chef
4 5 (1.25%) Foglight
5 1 (0.25%) SCOM
5 1 (0.25%) Oracle Statspack
Vendors
1 197 (49.37%) Oracle
2 92 (23.06%) Microsoft
3 53 (13.28%) IBM
4 47 (11.78%) Informatica
5 31 (7.77%) Talend
6 28 (7.02%) Sybase
7 16 (4.01%) Tableau
8 15 (3.76%) VMware
8 15 (3.76%) Business Objects
9 13 (3.26%) Red Gate
10 10 (2.51%) Netezza
11 9 (2.26%) Sun
12 8 (2.01%) SAP
12 8 (2.01%) Teradata
12 8 (2.01%) Facebook
13 7 (1.75%) Vertica
13 7 (1.75%) HP
14 6 (1.50%) MicroStrategy
14 6 (1.50%) Red Hat
14 6 (1.50%) Ab Initio
Croydon, Surrey
Lawrence Harvey Enterprise
Salary: £55000 - £70000 per annum + Benefits
Posted: Yesterday
City of London
Real Staffing
Salary: £55000 - £68000 per annum + competitive
Posted: Yesterday
West London
Harris Global
Posted: 2 days ago
London
Engage PSG
Salary: £45000 - £55000 per annum + flex bens, bonus
Posted: 4 days ago
South East London
Client Server
Salary: £40k to £55k + benefits
Posted: 5 days ago
Harrow, Middlesex
Salt
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 6 days ago
London
NFP Group Ltd
Salary: £65000 - £85000 per annum + Excellent Benefits
Posted: 15 days ago
London
EasyRoommate
Salary: Attractive Basic
Posted: 23 days ago