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 21 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
21 Feb 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
England / London
Rank 523 568 562
Rank change year-on-year
+45 -6
Permanent jobs citing OLTP 60 81 92
As % of all permanent IT jobs located in London 0.18% 0.20% 0.22%
As % of the Database & Business Intelligence category 0.60% 0.63% 0.73%
Number of salaries quoted 42 58 72
Median salary £65,000 £55,000 £55,000
Median salary % change year-on-year
+18.18% -
90% offered a salary of more than £45,000 £44,250 £47,500
10% offered a salary of more than £75,000 £75,000 £74,000
UK excluding London median salary £52,500 £47,500 £45,000
% change year-on-year
+10.52% +5.55%

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
10054 12765 12549
As % of all permanent IT jobs located in London 30.09% 31.40% 30.43%
Number of salaries quoted 8783 11066 10801
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
90% offered a salary of more than £39,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 21 February 2017.

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 21 February 2017. 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 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 +28 9 £70,000 +21.73%
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 21 February 2017, 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 101 (80.16%) SQL
2 79 (62.70%) SQL Server
3 58 (46.03%) Performance Tuning
4 54 (42.86%) Data Warehouse
5 51 (40.48%) Oracle
6 45 (35.71%) Linux
7 41 (32.54%) OLAP
8 40 (31.75%) SQL Server Integration Services
9 36 (28.57%) Analytical Skills
9 36 (28.57%) MS Excel
10 34 (26.98%) Microsoft
10 34 (26.98%) Agile Software Development
11 33 (26.19%) SQL Server Reporting Services
12 32 (25.40%) Business Intelligence
13 30 (23.81%) C++
14 29 (23.02%) STL
14 29 (23.02%) Finance
15 28 (22.22%) T-SQL
15 28 (22.22%) Intel
16 26 (20.63%) ETL
16 26 (20.63%) Disaster Recovery
16 26 (20.63%) Degree
17 25 (19.84%) Windows
18 24 (19.05%) MySQL
19 23 (18.25%) Oracle OLAP
20 22 (17.46%) SQL Server Analysis Services
20 22 (17.46%) DB2
20 22 (17.46%) Web Services
21 21 (16.67%) SAN
22 20 (15.87%) Microsoft Certification

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 16 (12.70%) Apache
1 16 (12.70%) IIS
1 16 (12.70%) Oracle Coherence
1 16 (12.70%) Oracle HTTP Server
1 16 (12.70%) Tomcat
1 16 (12.70%) WebSphere
2 5 (3.97%) SharePoint
3 1 (0.79%) Apache Solr
3 1 (0.79%) Apache Spark
Applications
1 36 (28.57%) MS Excel
Cloud Services
1 18 (14.29%) Microsoft Azure
2 16 (12.70%) Amazon AWS
3 7 (5.56%) IaaS
3 7 (5.56%) PaaS
4 3 (2.38%) Google Cloud Platform
5 2 (1.59%) Cloud Computing
5 2 (1.59%) SaaS
Communications & Networking
1 21 (16.67%) SAN
2 16 (12.70%) FCoE
2 16 (12.70%) Fibre Channel
2 16 (12.70%) HTTP
2 16 (12.70%) iSCSI
2 16 (12.70%) LAN
2 16 (12.70%) Multicast
2 16 (12.70%) NAS
2 16 (12.70%) WAN
3 1 (0.79%) Internet
3 1 (0.79%) VoIP
Database & Business Intelligence
1 79 (62.70%) SQL Server
2 54 (42.86%) Data Warehouse
3 41 (32.54%) OLAP
4 40 (31.75%) SQL Server Integration Services
5 33 (26.19%) SQL Server Reporting Services
6 24 (19.05%) MySQL
7 23 (18.25%) Oracle OLAP
8 22 (17.46%) DB2
8 22 (17.46%) SQL Server Analysis Services
9 17 (13.49%) SQL Server 2012
10 13 (10.32%) KDB
10 13 (10.32%) Oracle Database
11 11 (8.73%) Microsoft Analysis Services
11 11 (8.73%) MongoDB
12 9 (7.14%) SQL Server 2008
12 9 (7.14%) SQL Server 2014
13 8 (6.35%) NoSQL
14 6 (4.76%) Relational Database
15 5 (3.97%) Oracle ODI
16 4 (3.17%) RDBMS
Development Applications
1 11 (8.73%) Team Foundation Server
2 3 (2.38%) JIRA
3 1 (0.79%) Cucumber
3 1 (0.79%) ERwin
3 1 (0.79%) FitNesse
3 1 (0.79%) JBehave
3 1 (0.79%) MagicDraw
General
1 29 (23.02%) Finance
2 10 (7.94%) Retail
3 6 (4.76%) Games
4 4 (3.17%) Manufacturing
4 4 (3.17%) Marketing
5 3 (2.38%) Pharmaceutical
5 3 (2.38%) Telecoms
6 2 (1.59%) Banking
7 1 (0.79%) Advertising
7 1 (0.79%) Investment Banking
7 1 (0.79%) Wholesale Banking
Job Titles
1 58 (46.03%) Developer
2 25 (19.84%) DBA
2 25 (19.84%) SQL Developer
3 23 (18.25%) C++ Developer
3 23 (18.25%) SQL DBA
4 21 (16.67%) Architect
5 19 (15.08%) Oracle Developer
6 16 (12.70%) Infrastructure Architect
6 16 (12.70%) Lead Architect
6 16 (12.70%) Unix Developer
7 15 (11.90%) SQL Server DBA
8 10 (7.94%) Lead Developer
9 9 (7.14%) ETL Developer
9 9 (7.14%) Senior DBA
10 7 (5.56%) Database Developer
10 7 (5.56%) Low Latency C++ Developer
10 7 (5.56%) Senior SQL DBA
10 7 (5.56%) SQL Database Developer
10 7 (5.56%) SSIS Developer
10 7 (5.56%) Systems Developer
Libraries, Frameworks & Software Standards
1 29 (23.02%) STL
2 22 (17.46%) Web Services
3 16 (12.70%) Middleware
4 13 (10.32%) Boost C++ Libraries
5 9 (7.14%) XML
6 8 (6.35%) .NET
7 6 (4.76%) ASP.NET
8 5 (3.97%) Oracle GoldenGate
9 4 (3.17%) Ajax
9 4 (3.17%) ASP.NET MVC
9 4 (3.17%) HTML
9 4 (3.17%) REST
10 3 (2.38%) ASP.NET MVC 4
10 3 (2.38%) CSS
10 3 (2.38%) Entity Framework
10 3 (2.38%) KnockoutJS
10 3 (2.38%) LESS
10 3 (2.38%) RESTful
10 3 (2.38%) XHTML
10 3 (2.38%) XSL
Miscellaneous
1 36 (28.57%) Analytical Skills
2 20 (15.87%) Fintech
3 17 (13.49%) Computer Science
4 13 (10.32%) Equities
4 13 (10.32%) Fixed Income
4 13 (10.32%) Replication
5 8 (6.35%) Clustering
6 4 (3.17%) N-Tier
6 4 (3.17%) User Experience
7 3 (2.38%) Life Science
7 3 (2.38%) Online Games
8 2 (1.59%) Enterprise Software
9 1 (0.79%) Data Structures
9 1 (0.79%) iPad
9 1 (0.79%) IVR
9 1 (0.79%) Management Information System
9 1 (0.79%) Reference Data
9 1 (0.79%) Taxonomies
Operating Systems
1 45 (35.71%) Linux
2 25 (19.84%) Windows
3 19 (15.08%) Unix
4 16 (12.70%) Solaris
5 6 (4.76%) Windows Server 2008
6 5 (3.97%) Windows Server
6 5 (3.97%) Windows Server 2012
7 1 (0.79%) Android
7 1 (0.79%) Apple iOS
Processes & Methodologies
1 58 (46.03%) Performance Tuning
2 34 (26.98%) Agile Software Development
3 32 (25.40%) Business Intelligence
4 26 (20.63%) Disaster Recovery
4 26 (20.63%) ETL
5 19 (15.08%) OO
5 19 (15.08%) Unit Testing
6 16 (12.70%) Benchmarking
6 16 (12.70%) Risk Management
7 13 (10.32%) High-Frequency Trading
7 13 (10.32%) Low Latency
7 13 (10.32%) Performance Optimisation
7 13 (10.32%) System Testing
8 9 (7.14%) High Availability
9 8 (6.35%) Change Management
9 8 (6.35%) E-Commerce
9 8 (6.35%) Kimball Methodology
10 7 (5.56%) Database Tuning
10 7 (5.56%) OOP
11 6 (4.76%) Business Analysis
Programming Languages
1 101 (80.16%) SQL
2 30 (23.81%) C++
3 28 (22.22%) T-SQL
4 16 (12.70%) PL/SQL
5 13 (10.32%) C#
6 10 (7.94%) Java
7 6 (4.76%) JavaScript
8 5 (3.97%) PowerShell
9 2 (1.59%) Python
10 1 (0.79%) Objective-C
10 1 (0.79%) PHP
10 1 (0.79%) R
10 1 (0.79%) Ruby
10 1 (0.79%) SPARQL
Qualifications
1 26 (20.63%) Degree
2 20 (15.87%) Microsoft Certification
3 5 (3.97%) MCSE
4 3 (2.38%) PhD
Quality Assurance & Compliance
1 10 (7.94%) QA
2 2 (1.59%) Data Quality
3 1 (0.79%) SLA
System Software
1 16 (12.70%) Hyper-V
1 16 (12.70%) KVM
1 16 (12.70%) NFS
1 16 (12.70%) Oracle RAC
1 16 (12.70%) SRDF
1 16 (12.70%) VMware Infrastructure
1 16 (12.70%) Xen
Systems Management
1 4 (3.17%) Failover Clustering
2 1 (0.79%) Microsoft Clustering
Vendors
1 51 (40.48%) Oracle
2 34 (26.98%) Microsoft
3 28 (22.22%) Intel
4 16 (12.70%) Cisco
4 16 (12.70%) EMC
4 16 (12.70%) IBM
4 16 (12.70%) NetApp
4 16 (12.70%) VMware
5 13 (10.32%) Vertica
6 3 (2.38%) Google
7 1 (0.79%) Informatica
7 1 (0.79%) Sybase
7 1 (0.79%) Tableau
7 1 (0.79%) Zend
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 4 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 4 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 4 days ago
London
asos
Salary: Competitive Salary
Posted: 5 days ago
London
Reco Group
Salary: £35,000 - £60,000 per year
Posted: 15 days ago
London
Pioneer Search
Salary: £60000 - £90000 per annum + Competitive Bonus + Benefits
Posted: 6 days ago