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 10 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
10 Dec 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 536 569 505
Rank change year-on-year
+33 -64
Permanent jobs citing OLTP 73 79 163
As % of all permanent IT jobs located in London 0.21% 0.18% 0.36%
As % of the Database & Business Intelligence category 0.70% 0.58% 1.20%
Number of salaries quoted 43 60 132
Median salary £62,500 £60,000 £57,500
Median salary % change year-on-year
+4.16% +4.34%
90% offered a salary of more than £45,000 £47,250 £37,750
10% offered a salary of more than £72,500 £82,500 £77,250
UK excluding London median salary £52,500 £50,000 £40,000
% change year-on-year
+5.00% +25.00%
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
10433 13575 13539
As % of all permanent IT jobs located in London 29.64% 31.42% 30.16%
Number of salaries quoted 9083 11586 11677
Median salary £60,000 £55,500 £55,000
Median salary % change year-on-year
+8.10% +0.90%
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 £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 10 December 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 10 December 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 +26 11 £66,000 +3.52% 1
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 10 December 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 118 (88.06%) SQL
2 93 (69.40%) SQL Server
3 66 (49.25%) Oracle
4 62 (46.27%) Data Warehouse
4 62 (46.27%) Performance Tuning
5 51 (38.06%) OLAP
6 50 (37.31%) Linux
7 46 (34.33%) Finance
8 42 (31.34%) Agile Software Development
8 42 (31.34%) SQL Server Integration Services
9 41 (30.60%) MS Excel
10 40 (29.85%) Analytical Skills
11 37 (27.61%) Windows
12 36 (26.87%) ETL
12 36 (26.87%) Microsoft
13 35 (26.12%) SQL Server Reporting Services
14 34 (25.37%) Oracle OLAP
15 33 (24.63%) DB2
15 33 (24.63%) MySQL
15 33 (24.63%) T-SQL
16 31 (23.13%) Business Intelligence
17 30 (22.39%) Intel
18 29 (21.64%) SAN
18 29 (21.64%) SQL Server Analysis Services
19 28 (20.90%) Degree
20 25 (18.66%) Disaster Recovery
20 25 (18.66%) IIS
20 25 (18.66%) Oracle RAC
21 24 (17.91%) iSCSI
21 24 (17.91%) VMware Infrastructure

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 25 (18.66%) IIS
2 24 (17.91%) Apache
2 24 (17.91%) Oracle Coherence
2 24 (17.91%) Oracle HTTP Server
2 24 (17.91%) Tomcat
2 24 (17.91%) WebSphere
3 5 (3.73%) SharePoint
4 1 (0.75%) Apache Spark
Applications
1 41 (30.60%) MS Excel
Cloud Services
1 9 (6.72%) Amazon AWS
1 9 (6.72%) Microsoft Azure
2 5 (3.73%) IaaS
2 5 (3.73%) PaaS
3 3 (2.24%) Google Cloud Platform
4 2 (1.49%) SaaS
Communications & Networking
1 29 (21.64%) SAN
2 24 (17.91%) FCoE
2 24 (17.91%) Fibre Channel
2 24 (17.91%) HTTP
2 24 (17.91%) iSCSI
2 24 (17.91%) LAN
2 24 (17.91%) Multicast
2 24 (17.91%) NAS
2 24 (17.91%) WAN
3 1 (0.75%) VoIP
Database & Business Intelligence
1 93 (69.40%) SQL Server
2 62 (46.27%) Data Warehouse
3 51 (38.06%) OLAP
4 42 (31.34%) SQL Server Integration Services
5 35 (26.12%) SQL Server Reporting Services
6 34 (25.37%) Oracle OLAP
7 33 (24.63%) DB2
7 33 (24.63%) MySQL
8 29 (21.64%) SQL Server Analysis Services
9 15 (11.19%) SQL Server 2008
10 14 (10.45%) MongoDB
11 13 (9.70%) Oracle Database
12 12 (8.96%) Microsoft Analysis Services
13 11 (8.21%) Relational Database
13 11 (8.21%) SQL Server 2012
14 9 (6.72%) NoSQL
15 8 (5.97%) Oracle ODI
16 7 (5.22%) SQL Server 2014
17 6 (4.48%) KDB
17 6 (4.48%) RDBMS
Development Applications
1 12 (8.96%) Team Foundation Server
2 4 (2.99%) JIRA
3 2 (1.49%) Cucumber
3 2 (1.49%) FitNesse
3 2 (1.49%) JBehave
4 1 (0.75%) Git (software)
4 1 (0.75%) Jenkins
4 1 (0.75%) Oracle APEX
4 1 (0.75%) VSS/SourceSafe
General
1 46 (34.33%) Finance
2 10 (7.46%) Retail
3 6 (4.48%) Marketing
3 6 (4.48%) Pharmaceutical
3 6 (4.48%) Telecoms
4 5 (3.73%) Games
4 5 (3.73%) Manufacturing
5 3 (2.24%) Legal
6 2 (1.49%) Banking
7 1 (0.75%) Investment Banking
Job Titles
1 62 (46.27%) Developer
2 29 (21.64%) DBA
2 29 (21.64%) SQL Developer
3 26 (19.40%) SQL DBA
4 25 (18.66%) Architect
5 24 (17.91%) Infrastructure Architect
5 24 (17.91%) Lead Architect
6 23 (17.16%) Oracle Developer
7 20 (14.93%) C++ Developer
8 16 (11.94%) SQL Server DBA
8 16 (11.94%) Unix Developer
9 11 (8.21%) ETL Developer
10 10 (7.46%) SSIS Developer
11 9 (6.72%) Lead Developer
11 9 (6.72%) SSRS Developer
12 8 (5.97%) Senior Developer
12 8 (5.97%) SSAS Developer
13 7 (5.22%) .NET Developer
13 7 (5.22%) C# Developer
14 6 (4.48%) Team Leader
Libraries, Frameworks & Software Standards
1 24 (17.91%) Middleware
2 22 (16.42%) STL
2 22 (16.42%) Web Services
3 13 (9.70%) XML
4 12 (8.96%) .NET
5 10 (7.46%) ASP.NET
6 9 (6.72%) Oracle GoldenGate
7 6 (4.48%) Boost C++ Libraries
8 5 (3.73%) ASP.NET MVC
9 4 (2.99%) Ajax
9 4 (2.99%) HTML
9 4 (2.99%) REST
9 4 (2.99%) WinForms
10 3 (2.24%) ASP.NET MVC 4
10 3 (2.24%) CSS
10 3 (2.24%) Entity Framework
10 3 (2.24%) KnockoutJS
10 3 (2.24%) RESTful
10 3 (2.24%) XHTML
10 3 (2.24%) XSL
Miscellaneous
1 40 (29.85%) Analytical Skills
2 17 (12.69%) Replication
3 16 (11.94%) Fintech
4 13 (9.70%) Clustering
5 12 (8.96%) Computer Science
6 6 (4.48%) Equities
6 6 (4.48%) Fixed Income
6 6 (4.48%) Life Science
6 6 (4.48%) User Experience
7 5 (3.73%) Enterprise Software
7 5 (3.73%) N-Tier
8 3 (2.24%) Data Structures
8 3 (2.24%) Management Information System
8 3 (2.24%) Online Games
9 2 (1.49%) Data Integration
9 2 (1.49%) Hedge funds
9 2 (1.49%) iPad
10 1 (0.75%) IVR
10 1 (0.75%) Social Media
Operating Systems
1 50 (37.31%) Linux
2 37 (27.61%) Windows
3 24 (17.91%) Solaris
4 19 (14.18%) Unix
5 7 (5.22%) Windows Server 2008
6 6 (4.48%) Windows Server
7 3 (2.24%) Windows Server 2012
8 1 (0.75%) Android
8 1 (0.75%) Apple iOS
Processes & Methodologies
1 62 (46.27%) Performance Tuning
2 42 (31.34%) Agile Software Development
3 36 (26.87%) ETL
4 31 (23.13%) Business Intelligence
5 25 (18.66%) Disaster Recovery
6 24 (17.91%) Benchmarking
6 24 (17.91%) Risk Management
7 22 (16.42%) OO
8 14 (10.45%) High Availability
8 14 (10.45%) Kimball Methodology
9 11 (8.21%) Unit Testing
10 10 (7.46%) Database Tuning
10 10 (7.46%) Mentoring
11 9 (6.72%) Data Transformation
11 9 (6.72%) Database Mirroring
11 9 (6.72%) E-Commerce
11 9 (6.72%) Project Management
12 8 (5.97%) Dependency Management
12 8 (5.97%) Dimensional Modelling
12 8 (5.97%) OOP
Programming Languages
1 118 (88.06%) SQL
2 33 (24.63%) T-SQL
3 22 (16.42%) C++
4 17 (12.69%) PL/SQL
5 16 (11.94%) C#
6 14 (10.45%) Java
7 11 (8.21%) JavaScript
8 5 (3.73%) PowerShell
9 4 (2.99%) Python
10 1 (0.75%) C
10 1 (0.75%) Objective-C
10 1 (0.75%) PHP
10 1 (0.75%) R
10 1 (0.75%) Ruby
10 1 (0.75%) VBA
Qualifications
1 28 (20.90%) Degree
2 13 (9.70%) Microsoft Certification
3 6 (4.48%) PhD
4 5 (3.73%) MCSE
5 1 (0.75%) Oracle Certification
Quality Assurance & Compliance
1 9 (6.72%) QA
2 1 (0.75%) Data Quality
2 1 (0.75%) PCI DSS
2 1 (0.75%) SLA
System Software
1 25 (18.66%) Oracle RAC
2 24 (17.91%) Hyper-V
2 24 (17.91%) KVM
2 24 (17.91%) NFS
2 24 (17.91%) SRDF
2 24 (17.91%) VMware Infrastructure
2 24 (17.91%) Xen
Systems Management
1 3 (2.24%) Failover Clustering
1 3 (2.24%) Microsoft Clustering
2 1 (0.75%) Ansible
2 1 (0.75%) Perfmon
Vendors
1 66 (49.25%) Oracle
2 36 (26.87%) Microsoft
3 30 (22.39%) Intel
4 24 (17.91%) Cisco
4 24 (17.91%) EMC
4 24 (17.91%) IBM
4 24 (17.91%) NetApp
4 24 (17.91%) VMware
5 6 (4.48%) Vertica
6 4 (2.99%) Google
7 2 (1.49%) Tableau
8 1 (0.75%) Facebook
8 1 (0.75%) RedGate
8 1 (0.75%) Salesforce.com
8 1 (0.75%) Sybase
8 1 (0.75%) Zend
City, London
Client Server
Salary: £35k to £45k + benefits
Posted: 3 days ago
London
Client Server
Salary: £35k to £45k + benefits
Posted: 3 days ago
London
Pioneer Search
Salary: £60000.00 - £85000.00 per annum + Competitive Bonus + Benefits
Posted: 2 days ago
London
Client Server
Salary: £35k to £45k + benefits
Posted: 8 days ago