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

Location
3 months to
22 Aug 2014
Same period 2013 Same period 2012
Online Transaction Processing (OLTP)
Rank 436 524 500
Rank change year-on-year
+88 -24
Permanent jobs citing OLTP 193 92 146
As % of all permanent IT jobs located in London 0.41% 0.20% 0.29%
As % of the Database & Business Intelligence category 1.33% 0.69% 1.00%
Number of salaries quoted 146 69 118
Average salary £52,500 £55,000 £55,000
Average salary % change year-on-year
-4.54% -
90% offered a salary of more than £39,000 £42,500 £41,750
10% offered a salary of more than £66,250 £82,000 £65,000
UK excluding London average salary £47,500 £50,000 £35,000
% change year-on-year
-5.00% +42.85%
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
14536 13324 14578
As % of all permanent IT jobs located in London 30.63% 29.65% 28.71%
Number of salaries quoted 12651 11556 12920
Average salary £52,500 £52,500 £52,500
90% offered a salary of more than £37,000 £36,000 £36,500
10% offered a salary of more than £75,000 £75,000 £75,000
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

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 22 August 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 22 August 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 +18 37 £53,500 -2.72% 4
Hounslow - 18 £45,000 -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 22 August 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 347 (83.82%) SQL
2 246 (59.42%) SQL Server
3 206 (49.76%) Oracle
4 168 (40.58%) Data Warehouse
5 163 (39.37%) ETL
6 148 (35.75%) OLAP
7 143 (34.54%) SQL Server Integration Services
8 130 (31.40%) T-SQL
9 129 (31.16%) Performance Tuning
10 127 (30.68%) Business Intelligence
11 125 (30.19%) Relational Database
12 119 (28.74%) Degree
13 116 (28.02%) UNIX
14 113 (27.29%) SQL Server Reporting Services
15 107 (25.85%) Linux
15 107 (25.85%) RDBMS
16 99 (23.91%) SQL Server 2008
17 93 (22.46%) Microsoft
18 88 (21.26%) E-Commerce
19 86 (20.77%) Java
20 83 (20.05%) Data Modelling
21 80 (19.32%) Oracle OLAP
22 79 (19.08%) PL/SQL
23 78 (18.84%) Replication
24 73 (17.63%) QA
25 71 (17.15%) SQL Server Analysis Services
25 71 (17.15%) MySQL
26 68 (16.43%) Oracle Database
27 62 (14.98%) Computer Science
27 62 (14.98%) C++

OLTP
Top Related IT Skills in London by Category

For the 6 months to 22 August 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 12 (2.90%) Apache
2 9 (2.17%) Tomcat
3 8 (1.93%) IIS
4 3 (0.72%) SAS
5 2 (0.48%) WorkSite
5 2 (0.48%) SharePoint
6 1 (0.24%) MS Exchange
Applications
1 47 (11.35%) MS Excel
2 3 (0.72%) MS Visio
3 2 (0.48%) MS Project
3 2 (0.48%) MS Office
Business Applications
1 4 (0.97%) Oracle Applications
2 2 (0.48%) Oracle Procure-to-Pay
2 2 (0.48%) Oracle Financials
2 2 (0.48%) SAP Oil and Gas
3 1 (0.24%) Cognos TM1
3 1 (0.24%) Remedy ITSM
3 1 (0.24%) Dynamics CRM
Cloud Services
1 14 (3.38%) Amazon AWS
1 14 (3.38%) Amazon EC2
2 6 (1.45%) SaaS
2 6 (1.45%) Microsoft Azure
3 3 (0.72%) PaaS
3 3 (0.72%) IaaS
4 1 (0.24%) Cloud Computing
Communications & Networking
1 15 (3.62%) Internet
2 8 (1.93%) SSL
2 8 (1.93%) HTTP
2 8 (1.93%) TCP/IP
2 8 (1.93%) SAN
2 8 (1.93%) SSH
3 3 (0.72%) DNS
3 3 (0.72%) Ethernet
3 3 (0.72%) ATM
3 3 (0.72%) LAN
3 3 (0.72%) WAN
3 3 (0.72%) FCoE
3 3 (0.72%) Fibre Channel
3 3 (0.72%) iSCSI
3 3 (0.72%) InfiniBand
4 2 (0.48%) LDAP
5 1 (0.24%) Intranet
5 1 (0.24%) NAS
Database & Business Intelligence
1 246 (59.42%) SQL Server
2 168 (40.58%) Data Warehouse
3 148 (35.75%) OLAP
4 143 (34.54%) SQL Server Integration Services
5 125 (30.19%) Relational Database
6 113 (27.29%) SQL Server Reporting Services
7 107 (25.85%) RDBMS
8 99 (23.91%) SQL Server 2008
9 80 (19.32%) Oracle OLAP
10 71 (17.15%) SQL Server Analysis Services
10 71 (17.15%) MySQL
11 68 (16.43%) Oracle Database
12 54 (13.04%) SQL Server 2012
13 47 (11.35%) SQL Server 2005
14 46 (11.11%) DB2
15 45 (10.87%) Oracle ODI
16 40 (9.66%) Oracle Database 11g
17 26 (6.28%) DataStage
18 22 (5.31%) Oracle Database 10g
19 21 (5.07%) Big Data
Development Applications
1 28 (6.76%) Talend Open Studio
2 12 (2.90%) Team Foundation Server
2 12 (2.90%) Subversion
3 11 (2.66%) Visual Studio
4 8 (1.93%) Jenkins
4 8 (1.93%) Ant
4 8 (1.93%) Maven
4 8 (1.93%) CruiseControl
5 6 (1.45%) ERwin
6 3 (0.72%) Toad
7 2 (0.48%) MSBuild
8 1 (0.24%) PowerDesigner
8 1 (0.24%) Git (software)
8 1 (0.24%) Selenium
8 1 (0.24%) JIRA
8 1 (0.24%) SQL Server Management Studio (SSMS)
General
1 56 (13.53%) Finance
2 45 (10.87%) Games
3 27 (6.52%) Retail
4 22 (5.31%) Marketing
5 12 (2.90%) Law
5 12 (2.90%) Legal
5 12 (2.90%) Advertising
6 10 (2.42%) Pharmaceutical
6 10 (2.42%) Banking
7 8 (1.93%) Publishing
8 5 (1.21%) Music Industry
9 4 (0.97%) Online Betting
9 4 (0.97%) Telecoms
10 3 (0.72%) Investment Banking
11 2 (0.48%) Back Office
11 2 (0.48%) Billing
Job Titles
1 155 (37.44%) Developer
2 101 (24.40%) DBA
3 62 (14.98%) Software Engineer
4 50 (12.08%) SQL Developer
5 43 (10.39%) Administrator
6 42 (10.14%) Architect
7 40 (9.66%) Data Warehouse Developer
8 36 (8.70%) Database Developer
9 34 (8.21%) SQL DBA
10 32 (7.73%) Senior Developer
11 26 (6.28%) Business Intelligence Developer
11 26 (6.28%) SQL Server DBA
12 25 (6.04%) Oracle DBA
13 23 (5.56%) Oracle Data Warehouse Developer
14 22 (5.31%) Senior DBA
15 21 (5.07%) Senior Software Engineer
16 20 (4.83%) Software Development Engineer
16 20 (4.83%) Development Engineer
17 18 (4.35%) Data Architect
18 16 (3.86%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 46 (11.11%) .NET
2 42 (10.14%) Swing
3 41 (9.90%) STL
4 28 (6.76%) XML
5 22 (5.31%) Django
5 22 (5.31%) MDX
6 20 (4.83%) CSS
7 16 (3.86%) ASP.NET
8 11 (2.66%) HTML
8 11 (2.66%) Apache Flex
9 9 (2.17%) J2EE
9 9 (2.17%) J2SE
9 9 (2.17%) Servlets
10 8 (1.93%) Flash
10 8 (1.93%) COM
11 6 (1.45%) Web Services
11 6 (1.45%) WinForms
12 5 (1.21%) Regular Expression
12 5 (1.21%) JPA
12 5 (1.21%) .NET Framework
Miscellaneous
1 78 (18.84%) Replication
2 62 (14.98%) Computer Science
3 58 (14.01%) iPad
4 39 (9.42%) Clustering
5 24 (5.80%) Online Games
6 14 (3.38%) Mathematics
7 11 (2.66%) Management Information System
7 11 (2.66%) Data Integration
8 9 (2.17%) Enterprise Software
9 7 (1.69%) Chemistry
9 7 (1.69%) Statistics
10 6 (1.45%) Life Science
10 6 (1.45%) Visualisation
11 5 (1.21%) Blackberry
11 5 (1.21%) Digital Media
11 5 (1.21%) Social Network
12 3 (0.72%) Economics
12 3 (0.72%) N-Tier
12 3 (0.72%) Data Conversion
12 3 (0.72%) Mobile App
Operating Systems
1 116 (28.02%) UNIX
2 107 (25.85%) Linux
3 55 (13.29%) Windows
4 16 (3.86%) Android
4 16 (3.86%) Windows Server 2008
4 16 (3.86%) Solaris
5 8 (1.93%) Windows Server 2012
6 7 (1.69%) Red Hat Enterprise Linux
7 6 (1.45%) Oracle Linux
8 4 (0.97%) AIX
Processes & Methodologies
1 163 (39.37%) ETL
2 129 (31.16%) Performance Tuning
3 127 (30.68%) Business Intelligence
4 88 (21.26%) E-Commerce
5 83 (20.05%) Data Modelling
6 62 (14.98%) Software Engineering
7 53 (12.80%) Scrum
8 49 (11.84%) Dimensional Modelling
9 46 (11.11%) Unit Testing
10 42 (10.14%) Validation
10 42 (10.14%) OO
11 38 (9.18%) Agile Software Development
12 37 (8.94%) Analytics
13 32 (7.73%) TDD
14 27 (6.52%) Data Analysis
15 25 (6.04%) Disaster Recovery
15 25 (6.04%) Data Management
16 20 (4.83%) Migration
16 20 (4.83%) Project Management
17 18 (4.35%) ITIL
Programming Languages
1 347 (83.82%) SQL
2 130 (31.40%) T-SQL
3 86 (20.77%) Java
4 79 (19.08%) PL/SQL
5 62 (14.98%) C++
6 42 (10.14%) C
7 39 (9.42%) JavaScript
8 38 (9.18%) Shell Script
9 37 (8.94%) C#
10 30 (7.25%) Python
11 25 (6.04%) Perl
12 16 (3.86%) PHP
13 12 (2.90%) Clojure
14 11 (2.66%) VB
14 11 (2.66%) Bash Shell
15 9 (2.17%) VB6
16 8 (1.93%) ActionScript
16 8 (1.93%) Tcl
17 7 (1.69%) PowerHouse
18 5 (1.21%) PowerShell
Qualifications
1 119 (28.74%) Degree
2 33 (7.97%) Microsoft Certification
3 31 (7.49%) MCITP
4 16 (3.86%) MCTS
5 7 (1.69%) MCSE
6 6 (1.45%) PhD
6 6 (1.45%) OCP
6 6 (1.45%) Oracle Certification
7 2 (0.48%) MCDBA
Quality Assurance & Compliance
1 73 (17.63%) QA
2 42 (10.14%) ISO 9001
3 6 (1.45%) Data Quality
4 3 (0.72%) PCI DSS
4 3 (0.72%) ISO/IEC 27001
System Software
1 21 (5.07%) Oracle RAC
2 12 (2.90%) Oracle RMAN
3 6 (1.45%) Hyper-V
4 5 (1.21%) Active Directory
4 5 (1.21%) VMware Infrastructure
5 2 (0.48%) VMware ESX
Systems Management
1 24 (5.80%) Data Guard
2 12 (2.90%) Opscode Chef
3 10 (2.42%) Oracle Enterprise Manager
4 4 (0.97%) Nagios
4 4 (0.97%) Foglight
5 3 (0.72%) SCOM
Vendors
1 206 (49.76%) Oracle
2 93 (22.46%) Microsoft
3 52 (12.56%) IBM
4 47 (11.35%) Informatica
5 35 (8.45%) Sybase
6 28 (6.76%) Talend
7 18 (4.35%) VMware
8 17 (4.11%) Red Gate
9 15 (3.62%) Business Objects
10 13 (3.14%) Tableau
11 12 (2.90%) Sun
12 10 (2.42%) Netezza
13 9 (2.17%) SAP
14 8 (1.93%) Facebook
14 8 (1.93%) MicroStrategy
14 8 (1.93%) Teradata
15 7 (1.69%) Red Hat
15 7 (1.69%) HP
15 7 (1.69%) Vertica
16 5 (1.21%) Ab Initio
London
Connectus
Salary: £45000 - £55000 per annum
Posted: 20 hours ago
City of London
Modis International - London
Salary: £50000 - £65000 per annum
Posted: 20 hours ago
London
Vertical IT
Salary: £45000 - £70000 per annum + Benefits
Posted: Yesterday
London
Harris Global
Salary: Up to £75,000 per annum excellent bonus + benefits
Posted: Yesterday
London
Experis Ltd
Salary: £50000 - £60000 per annum + 10% bonus + excellent benefits
Posted: 2 days ago
London
Lorien Resourcing
Salary: Competitive Salary and Benefits
Posted: 3 days ago
London
Salt
Salary: £60000 - £70000 per annum + Bonus + Excellent Benefits
Posted: 4 days ago
South East London
Client Server
Salary: £40k to £55k + benefits
Posted: 4 days ago
London
TribePost.co.uk
Salary: Excellent DOE
Posted: 4 days ago
West London
OpenBet Technology
Salary: Competitive Salary and Company Benefits
Posted: 7 days ago
City of London
Real Staffing
Salary: £55000 - £70000 per annum + competitive
Posted: 14 days ago
Central London / West End
Cognizant
Salary: Competitive
Posted: 16 days ago
City of London
Real Staffing
Salary: £55000 - £70000 per annum + Good Benefits
Posted: 21 days ago
City of London
Bridge Noble
Salary: £55000 - £65000 per annum + Bonus + Benefits
Posted: 23 days ago