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

3 months to
26 Jun 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 538 593 479
Rank change year-on-year
+55 -114
Permanent jobs citing OLTP 96 74 232
As % of all permanent IT jobs located in London 0.24% 0.17% 0.46%
As % of the Database & Business Intelligence category 0.83% 0.51% 1.46%
Number of salaries quoted 57 59 175
Median salary £57,500 £65,000 £50,000
Median salary % change year-on-year
-11.53% +30.00%
90% offered a salary of more than £39,500 £50,000 £40,000
10% offered a salary of more than £80,000 £87,000 £64,000
UK excluding London median salary £45,000 £45,000 £45,000
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
11600 14382 15929
As % of all permanent IT jobs located in London 29.43% 32.14% 31.72%
Number of salaries quoted 10106 12196 13877
Median salary £57,500 £57,500 £55,000
Median salary % change year-on-year
- +4.54%
90% offered a salary of more than £40,000 £39,000 £37,000
10% offered a salary of more than £80,000 £77,500 £80,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLTP
Jobs Demand Trend in London

The demand trend of job ads across the London region citing OLTP as a proportion of all IT jobs with a match in 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 26 June 2016.

OLTP Salary Histogram in London

OLTP
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the London region over the 3 months to 26 June 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +62 20 £62,500 +11.11%
Teddington - 3 £52,500 - 2
Romford - 1 £82,500 -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 26 June 2016, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the London region with a requirement for OLTP.

1 148 (82.68%) SQL
2 114 (63.69%) Oracle
3 99 (55.31%) SQL Server
4 86 (48.04%) OLAP
5 67 (37.43%) Finance
6 64 (35.75%) Microsoft
6 64 (35.75%) Data Warehouse
7 61 (34.08%) Business Intelligence
8 58 (32.40%) ETL
9 57 (31.84%) MySQL
9 57 (31.84%) Performance Tuning
10 54 (30.17%) MS Excel
10 54 (30.17%) SQL Server Reporting Services
11 53 (29.61%) SQL Server Integration Services
11 53 (29.61%) Oracle OLAP
12 51 (28.49%) Degree
13 46 (25.70%) Linux
14 43 (24.02%) PL/SQL
15 40 (22.35%) SQL Server Analysis Services
16 39 (21.79%) Analytical Skills
17 37 (20.67%) Oracle Database
18 35 (19.55%) Agile Software Development
19 32 (17.88%) Windows
20 31 (17.32%) OO
21 28 (15.64%) Unix
22 27 (15.08%) C++
22 27 (15.08%) SQL Server 2008
23 26 (14.53%) Web Services
24 25 (13.97%) Java
24 25 (13.97%) DB2

OLTP
Top Related IT Skills in London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 9 (5.03%) Apache
1 9 (5.03%) IIS
1 9 (5.03%) Oracle Coherence
1 9 (5.03%) Oracle HTTP Server
1 9 (5.03%) Tomcat
1 9 (5.03%) WebSphere
2 6 (3.35%) Confluence
3 5 (2.79%) Oracle Spatial
3 5 (2.79%) Oracle Workflow
4 3 (1.68%) WebLogic
5 1 (0.56%) Apache Pig
5 1 (0.56%) Apache Spark
Applications
1 54 (30.17%) MS Excel
2 5 (2.79%) MS Office
3 1 (0.56%) MS PowerPoint
3 1 (0.56%) MS Visio
3 1 (0.56%) Spreadsheet
Business Applications
1 5 (2.79%) Unica
2 4 (2.23%) Cognos Business Intelligence
3 3 (1.68%) MetaTrader
4 2 (1.12%) Endur
4 2 (1.12%) SAP FI
Cloud Services
1 11 (6.15%) Microsoft Azure
2 8 (4.47%) Amazon AWS
Communications & Networking
1 13 (7.26%) SAN
2 10 (5.59%) Fibre Channel
3 9 (5.03%) FCoE
3 9 (5.03%) HTTP
3 9 (5.03%) iSCSI
3 9 (5.03%) LAN
3 9 (5.03%) Multicast
3 9 (5.03%) NAS
3 9 (5.03%) WAN
Database & Business Intelligence
1 99 (55.31%) SQL Server
2 86 (48.04%) OLAP
3 64 (35.75%) Data Warehouse
4 57 (31.84%) MySQL
5 54 (30.17%) SQL Server Reporting Services
6 53 (29.61%) Oracle OLAP
6 53 (29.61%) SQL Server Integration Services
7 40 (22.35%) SQL Server Analysis Services
8 37 (20.67%) Oracle Database
9 27 (15.08%) SQL Server 2008
10 25 (13.97%) DB2
11 21 (11.73%) Oracle ODI
12 19 (10.61%) Relational Database
12 19 (10.61%) SQL Server 2012
13 16 (8.94%) BusinessObjects
13 16 (8.94%) Oracle Database 10g
13 16 (8.94%) Oracle Database 11g
14 13 (7.26%) Microsoft Analysis Services
15 12 (6.70%) OLAP Cube
15 12 (6.70%) SQL Server 2014
Development Applications
1 14 (7.82%) Git (software)
2 13 (7.26%) Team Foundation Server
3 11 (6.15%) Oracle APEX
3 11 (6.15%) VSS/SourceSafe
4 9 (5.03%) Jenkins
5 8 (4.47%) JIRA
6 1 (0.56%) Subversion
6 1 (0.56%) Visual Studio
General
1 67 (37.43%) Finance
2 19 (10.61%) Retail
3 18 (10.06%) Marketing
4 14 (7.82%) Banking
5 13 (7.26%) Telecoms
6 10 (5.59%) Pharmaceutical
7 6 (3.35%) Games
8 5 (2.79%) Private Banking
8 5 (2.79%) Publishing
9 4 (2.23%) Legal
10 3 (1.68%) Back Office
11 2 (1.12%) Advertising
11 2 (1.12%) Financial Institution
12 1 (0.56%) Manufacturing
Job Titles
1 110 (61.45%) Developer
2 58 (32.40%) Oracle Developer
3 33 (18.44%) DBA
3 33 (18.44%) SQL Developer
4 24 (13.41%) SQL DBA
5 22 (12.29%) C++ Developer
5 22 (12.29%) SSIS Developer
5 22 (12.29%) SSRS Developer
5 22 (12.29%) Unix Developer
6 21 (11.73%) SSAS Developer
7 20 (11.17%) Senior Developer
8 16 (8.94%) Architect
8 16 (8.94%) SQL Server DBA
9 14 (7.82%) Business Intelligence Developer
10 12 (6.70%) Database Developer
10 12 (6.70%) Infrastructure Architect
11 11 (6.15%) Lead Developer
12 9 (5.03%) .NET Developer
12 9 (5.03%) C# Developer
12 9 (5.03%) Senior Database Developer
Libraries, Frameworks & Software Standards
1 26 (14.53%) Web Services
2 22 (12.29%) .NET
2 22 (12.29%) STL
3 15 (8.38%) MDX
4 13 (7.26%) Oracle GoldenGate
4 13 (7.26%) XML
5 12 (6.70%) Middleware
6 11 (6.15%) SOAP
7 9 (5.03%) ASP.NET
8 5 (2.79%) ASP.NET MVC
8 5 (2.79%) Django
9 4 (2.23%) WinForms
10 3 (1.68%) ODBC
10 3 (1.68%) SAML
11 1 (0.56%) Kafka
11 1 (0.56%) Play Framework
Miscellaneous
1 39 (21.79%) Analytical Skills
2 21 (11.73%) Replication
3 20 (11.17%) Clustering
4 14 (7.82%) Data Integration
4 14 (7.82%) Enterprise Software
5 11 (6.15%) Management Information System
6 9 (5.03%) Data Structures
6 9 (5.03%) Fintech
6 9 (5.03%) Life Science
7 8 (4.47%) Computer Science
8 5 (2.79%) Online Games
9 3 (1.68%) Mobile Payment
9 3 (1.68%) PKI
9 3 (1.68%) Spread Betting
10 2 (1.12%) Blackberry
11 1 (0.56%) Client/Server
11 1 (0.56%) Contract for Difference
11 1 (0.56%) Economics
11 1 (0.56%) Mathematics
11 1 (0.56%) User Experience
Operating Systems
1 46 (25.70%) Linux
2 32 (17.88%) Windows
3 28 (15.64%) Unix
4 16 (8.94%) Solaris
5 10 (5.59%) Windows Server
6 3 (1.68%) Red Hat Enterprise Linux
6 3 (1.68%) Windows Server 2008
6 3 (1.68%) Windows Server 2012
Processes & Methodologies
1 61 (34.08%) Business Intelligence
2 58 (32.40%) ETL
3 57 (31.84%) Performance Tuning
4 35 (19.55%) Agile Software Development
5 31 (17.32%) OO
6 25 (13.97%) Kimball Methodology
7 24 (13.41%) Dimensional Modelling
8 21 (11.73%) Data Modelling
9 18 (10.06%) Analytics
10 17 (9.50%) Continuous Integration
11 16 (8.94%) E-Commerce
12 15 (8.38%) Project Management
13 14 (7.82%) Data Transformation
13 14 (7.82%) ITIL
13 14 (7.82%) Open Source
13 14 (7.82%) SDLC
14 13 (7.26%) Benchmarking
15 12 (6.70%) Disaster Recovery
15 12 (6.70%) DNA
15 12 (6.70%) User Acceptance Testing
Programming Languages
1 148 (82.68%) SQL
2 43 (24.02%) PL/SQL
3 27 (15.08%) C++
4 25 (13.97%) Java
5 22 (12.29%) C#
6 21 (11.73%) T-SQL
7 14 (7.82%) JavaScript
8 12 (6.70%) Python
9 11 (6.15%) PowerShell
10 8 (4.47%) Perl
11 6 (3.35%) C
12 5 (2.79%) PHP
12 5 (2.79%) Shell Script
13 3 (1.68%) Data Analysis Expressions (DAX)
14 1 (0.56%) Clojure
14 1 (0.56%) Ruby
14 1 (0.56%) Scala
14 1 (0.56%) VB.NET
14 1 (0.56%) VBA
14 1 (0.56%) VBScript
Qualifications
1 51 (28.49%) Degree
2 9 (5.03%) PhD
3 3 (1.68%) IBM Certification
4 2 (1.12%) MCSE
4 2 (1.12%) Microsoft Certification
5 1 (0.56%) MBA
Quality Assurance & Compliance
1 11 (6.15%) Data Quality
2 8 (4.47%) PCI DSS
3 7 (3.91%) QA
4 5 (2.79%) SLA
System Software
1 9 (5.03%) Hyper-V
1 9 (5.03%) KVM
1 9 (5.03%) NFS
1 9 (5.03%) Oracle RAC
1 9 (5.03%) SRDF
1 9 (5.03%) VMware Infrastructure
1 9 (5.03%) Xen
2 1 (0.56%) Docker
2 1 (0.56%) GlusterFS
2 1 (0.56%) Veritas Cluster Server
Systems Management
1 3 (1.68%) OpenView
1 3 (1.68%) Puppet
1 3 (1.68%) Tivoli
2 2 (1.12%) Oracle RMAN
3 1 (0.56%) Ansible
3 1 (0.56%) Mesos
3 1 (0.56%) NetBackup
3 1 (0.56%) Oracle ZFS
3 1 (0.56%) Perfmon
3 1 (0.56%) Red Hat Satellite
3 1 (0.56%) Veritas Storage Foundation
Vendors
1 114 (63.69%) Oracle
2 64 (35.75%) Microsoft
3 21 (11.73%) IBM
4 13 (7.26%) Cognos
5 10 (5.59%) EMC
5 10 (5.59%) Tableau
6 9 (5.03%) Cisco
6 9 (5.03%) Intel
6 9 (5.03%) NetApp
6 9 (5.03%) VMware
7 5 (2.79%) Alterian
7 5 (2.79%) Apteco
7 5 (2.79%) Facebook
7 5 (2.79%) SAP
7 5 (2.79%) Vertica
8 4 (2.23%) Informatica
8 4 (2.23%) Sun
9 3 (1.68%) BMC
9 3 (1.68%) Red Hat
9 3 (1.68%) Sybase
London
TDA Group
Salary: £65000 per annum + Benefits & Bonus
Posted: 3 days ago
London
Client Server
Salary: £30k to £45k + benefits
Posted: 3 days ago
Teddington, Middlesex
Profile 29 Limited
Salary: Up to £68,000 per annum + benefits (see advert)
Posted: 4 days ago
London
ASOS
Salary: Excellent salary and package
Posted: 12 days ago
London
Computer Futures
Salary: £50000 - £55000 per annum + competitive
Posted: 16 days ago
Teddington
Ortolan Group
Posted: 9 days ago
London
Client Server
Salary: £25k to £40k + benefits
Posted: 12 days ago
London
Client Server
Salary: £25k to £40k + benefits
Posted: 19 days ago