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

3 months to
22 Jan 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
England / London
Rank 512 563 524
Rank change year-on-year
+51 -39
Permanent jobs citing OLTP 64 75 120
As % of all permanent IT jobs located in London 0.19% 0.18% 0.29%
As % of the Database & Business Intelligence category 0.65% 0.59% 0.97%
Number of salaries quoted 44 57 100
Median salary £65,000 £55,000 £60,000
Median salary % change year-on-year
+18.18% -8.33%
90% offered a salary of more than £45,000 £42,500 £42,000
10% offered a salary of more than £72,500 £82,500 £80,000
UK excluding London median salary £52,500 £47,500 £42,500
% change year-on-year
+10.52% +11.76%

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
9892 12794 12386
As % of all permanent IT jobs located in London 29.95% 31.47% 30.12%
Number of salaries quoted 8715 11078 10653
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 22 January 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 22 January 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 +40 5 £62,500 +8.69% 3
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 22 January 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 104 (85.25%) SQL
2 81 (66.39%) SQL Server
3 55 (45.08%) Data Warehouse
4 54 (44.26%) Performance Tuning
5 53 (43.44%) Oracle
6 46 (37.70%) Linux
7 38 (31.15%) OLAP
8 37 (30.33%) MS Excel
9 36 (29.51%) Agile Software Development
10 35 (28.69%) Finance
10 35 (28.69%) Analytical Skills
10 35 (28.69%) SQL Server Integration Services
11 31 (25.41%) Microsoft
12 29 (23.77%) Intel
12 29 (23.77%) T-SQL
13 28 (22.95%) SQL Server Reporting Services
14 26 (21.31%) Disaster Recovery
14 26 (21.31%) C++
14 26 (21.31%) Windows
14 26 (21.31%) ETL
14 26 (21.31%) Business Intelligence
15 25 (20.49%) DB2
15 25 (20.49%) STL
15 25 (20.49%) MySQL
15 25 (20.49%) Oracle OLAP
16 22 (18.03%) SQL Server Analysis Services
17 21 (17.21%) Degree
17 21 (17.21%) SAN
18 20 (16.39%) Web Services
19 19 (15.57%) Solaris

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 19 (15.57%) Apache
1 19 (15.57%) IIS
1 19 (15.57%) Oracle Coherence
1 19 (15.57%) Oracle HTTP Server
1 19 (15.57%) Tomcat
1 19 (15.57%) WebSphere
2 5 (4.10%) SharePoint
3 1 (0.82%) Apache Spark
Applications
1 37 (30.33%) MS Excel
Cloud Services
1 14 (11.48%) Microsoft Azure
2 13 (10.66%) Amazon AWS
3 6 (4.92%) IaaS
3 6 (4.92%) PaaS
4 3 (2.46%) Google Cloud Platform
5 2 (1.64%) SaaS
6 1 (0.82%) Cloud Computing
Communications & Networking
1 21 (17.21%) SAN
2 19 (15.57%) FCoE
2 19 (15.57%) Fibre Channel
2 19 (15.57%) HTTP
2 19 (15.57%) iSCSI
2 19 (15.57%) LAN
2 19 (15.57%) Multicast
2 19 (15.57%) NAS
2 19 (15.57%) WAN
3 1 (0.82%) Internet
3 1 (0.82%) VoIP
Database & Business Intelligence
1 81 (66.39%) SQL Server
2 55 (45.08%) Data Warehouse
3 38 (31.15%) OLAP
4 35 (28.69%) SQL Server Integration Services
5 28 (22.95%) SQL Server Reporting Services
6 25 (20.49%) DB2
6 25 (20.49%) MySQL
6 25 (20.49%) Oracle OLAP
7 22 (18.03%) SQL Server Analysis Services
8 13 (10.66%) MongoDB
8 13 (10.66%) SQL Server 2012
9 12 (9.84%) Oracle Database
10 10 (8.20%) KDB
10 10 (8.20%) Microsoft Analysis Services
11 9 (7.38%) NoSQL
12 8 (6.56%) SQL Server 2008
13 7 (5.74%) Relational Database
14 5 (4.10%) Oracle ODI
14 5 (4.10%) RDBMS
15 4 (3.28%) SQL Server 2014
Development Applications
1 8 (6.56%) Team Foundation Server
2 3 (2.46%) JIRA
3 2 (1.64%) Cucumber
3 2 (1.64%) FitNesse
3 2 (1.64%) JBehave
General
1 35 (28.69%) Finance
2 10 (8.20%) Retail
3 6 (4.92%) Games
4 5 (4.10%) Manufacturing
4 5 (4.10%) Marketing
5 3 (2.46%) Legal
5 3 (2.46%) Pharmaceutical
5 3 (2.46%) Telecoms
6 1 (0.82%) Banking
6 1 (0.82%) Investment Banking
Job Titles
1 52 (42.62%) Developer
2 27 (22.13%) DBA
3 24 (19.67%) SQL DBA
3 24 (19.67%) SQL Developer
4 22 (18.03%) Architect
5 19 (15.57%) C++ Developer
5 19 (15.57%) Infrastructure Architect
5 19 (15.57%) Lead Architect
6 18 (14.75%) Oracle Developer
7 15 (12.30%) SQL Server DBA
7 15 (12.30%) Unix Developer
8 12 (9.84%) Lead Developer
9 10 (8.20%) ETL Developer
10 8 (6.56%) Senior DBA
10 8 (6.56%) SSIS Developer
11 7 (5.74%) SSAS Developer
11 7 (5.74%) SSRS Developer
12 6 (4.92%) Senior SQL DBA
13 5 (4.10%) C# Developer
13 5 (4.10%) Team Leader
Libraries, Frameworks & Software Standards
1 25 (20.49%) STL
2 20 (16.39%) Web Services
3 19 (15.57%) Middleware
4 10 (8.20%) Boost C++ Libraries
4 10 (8.20%) XML
5 8 (6.56%) .NET
6 6 (4.92%) ASP.NET
7 5 (4.10%) Oracle GoldenGate
8 4 (3.28%) Ajax
8 4 (3.28%) ASP.NET MVC
8 4 (3.28%) HTML
8 4 (3.28%) REST
9 3 (2.46%) ASP.NET MVC 4
9 3 (2.46%) CSS
9 3 (2.46%) Entity Framework
9 3 (2.46%) KnockoutJS
9 3 (2.46%) LESS
9 3 (2.46%) RESTful
9 3 (2.46%) XHTML
9 3 (2.46%) XSL
Miscellaneous
1 35 (28.69%) Analytical Skills
2 17 (13.93%) Fintech
3 15 (12.30%) Replication
4 14 (11.48%) Computer Science
5 11 (9.02%) Clustering
6 10 (8.20%) Equities
6 10 (8.20%) Fixed Income
7 5 (4.10%) N-Tier
7 5 (4.10%) User Experience
8 3 (2.46%) Life Science
8 3 (2.46%) Online Games
9 2 (1.64%) Enterprise Software
10 1 (0.82%) Data Integration
10 1 (0.82%) Hedge funds
10 1 (0.82%) iPad
10 1 (0.82%) IVR
10 1 (0.82%) Management Information System
Operating Systems
1 46 (37.70%) Linux
2 26 (21.31%) Windows
3 19 (15.57%) Solaris
4 18 (14.75%) Unix
5 3 (2.46%) Windows Server 2008
6 2 (1.64%) Windows Server
7 1 (0.82%) Android
7 1 (0.82%) Apple iOS
7 1 (0.82%) Windows Server 2012
Processes & Methodologies
1 54 (44.26%) Performance Tuning
2 36 (29.51%) Agile Software Development
3 26 (21.31%) Business Intelligence
3 26 (21.31%) Disaster Recovery
3 26 (21.31%) ETL
4 19 (15.57%) Benchmarking
4 19 (15.57%) Risk Management
5 18 (14.75%) OO
6 16 (13.11%) Unit Testing
7 13 (10.66%) High Availability
8 10 (8.20%) E-Commerce
8 10 (8.20%) High-Frequency Trading
8 10 (8.20%) Low Latency
8 10 (8.20%) Performance Optimisation
8 10 (8.20%) System Testing
9 9 (7.38%) Database Tuning
9 9 (7.38%) Kimball Methodology
10 8 (6.56%) Mentoring
11 7 (5.74%) Dependency Management
11 7 (5.74%) People Management
Programming Languages
1 104 (85.25%) SQL
2 29 (23.77%) T-SQL
3 26 (21.31%) C++
4 15 (12.30%) PL/SQL
5 13 (10.66%) C#
6 11 (9.02%) Java
7 6 (4.92%) JavaScript
8 2 (1.64%) PowerShell
8 2 (1.64%) Python
9 1 (0.82%) Objective-C
9 1 (0.82%) PHP
9 1 (0.82%) R
9 1 (0.82%) Ruby
Qualifications
1 21 (17.21%) Degree
2 16 (13.11%) Microsoft Certification
3 5 (4.10%) MCSE
4 3 (2.46%) PhD
Quality Assurance & Compliance
1 6 (4.92%) QA
2 1 (0.82%) SLA
System Software
1 19 (15.57%) Hyper-V
1 19 (15.57%) KVM
1 19 (15.57%) NFS
1 19 (15.57%) Oracle RAC
1 19 (15.57%) SRDF
1 19 (15.57%) VMware Infrastructure
1 19 (15.57%) Xen
Systems Management
1 4 (3.28%) Failover Clustering
2 2 (1.64%) Microsoft Clustering
Vendors
1 53 (43.44%) Oracle
2 31 (25.41%) Microsoft
3 29 (23.77%) Intel
4 19 (15.57%) Cisco
4 19 (15.57%) EMC
4 19 (15.57%) IBM
4 19 (15.57%) NetApp
4 19 (15.57%) VMware
5 10 (8.20%) Vertica
6 3 (2.46%) Google
7 1 (0.82%) Sybase
7 1 (0.82%) Zend
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 2 days ago
London
Huxley
Salary: £60000 - £70000 per annum + Excellent Benefits
Posted: 13 days ago
London
Pioneer Search
Salary: £60000 - £90000 per annum + Competitive Bonus + Benefits
Posted: 5 days ago
London
Huxley
Salary: £60000 - £70000 per annum + Excellent Benefits
Posted: 18 days ago
City of London
Huxley
Salary: £55000 - £70000 per annum + Package
Posted: 12 days ago
London
Client Server
Salary: £30000 - £45000 per annum + benefits
Posted: 10 days ago
City of London
Huxley
Salary: £55000 - £70000 per annum + Package
Posted: 16 days ago
London
Client Server
Salary: £35k to £45k + benefits
Posted: 17 days ago
City, London
BJSS Ltd
Salary: From £90,000 to £105,000 per annum Bonus, Health & Pension
Posted: 12 days ago