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

3 months to
29 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 540 606 485
Rank change year-on-year
+66 -121
Permanent jobs citing OLTP 83 73 209
As % of all permanent IT jobs located in London 0.21% 0.16% 0.43%
As % of the Database & Business Intelligence category 0.72% 0.53% 1.38%
Number of salaries quoted 46 57 162
Median salary £55,000 £55,000 £51,500
Median salary % change year-on-year
- +6.79%
90% offered a salary of more than £32,500 £41,500 £39,000
10% offered a salary of more than £80,000 £80,000 £65,000
UK excluding London median salary £43,000 £45,000 £47,750
% change year-on-year
-4.44% -5.75%
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
11512 13739 15158
As % of all permanent IT jobs located in London 29.26% 30.95% 31.33%
Number of salaries quoted 9988 11599 13192
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 £38,500 £36,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 29 July 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 29 July 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 +42 13 £80,000 +77.77%
Teddington - 3 £52,500 -
Uxbridge - 1 £55,000 -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 29 July 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 150 (86.71%) SQL
2 115 (66.47%) Oracle
3 97 (56.07%) SQL Server
4 78 (45.09%) OLAP
5 73 (42.20%) Finance
6 65 (37.57%) Performance Tuning
7 64 (36.99%) Data Warehouse
8 57 (32.95%) Business Intelligence
9 55 (31.79%) Microsoft
10 54 (31.21%) MySQL
11 53 (30.64%) ETL
12 51 (29.48%) Degree
12 51 (29.48%) Oracle OLAP
13 50 (28.90%) Linux
14 49 (28.32%) SQL Server Integration Services
15 48 (27.75%) SQL Server Reporting Services
16 46 (26.59%) MS Excel
17 43 (24.86%) Analytical Skills
18 41 (23.70%) PL/SQL
19 38 (21.97%) Windows
20 37 (21.39%) Oracle Database
21 36 (20.81%) Agile Software Development
22 34 (19.65%) SQL Server Analysis Services
23 32 (18.50%) OO
23 32 (18.50%) SQL Server 2008
24 28 (16.18%) Unix
24 28 (16.18%) DB2
24 28 (16.18%) C++
25 25 (14.45%) IBM
25 25 (14.45%) Kimball Methodology

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 14 (8.09%) IIS
2 13 (7.51%) Apache
2 13 (7.51%) Oracle Coherence
2 13 (7.51%) Oracle HTTP Server
2 13 (7.51%) Tomcat
2 13 (7.51%) WebSphere
3 4 (2.31%) Confluence
3 4 (2.31%) Oracle Spatial
3 4 (2.31%) Oracle Workflow
4 3 (1.73%) WebLogic
Applications
1 46 (26.59%) MS Excel
2 4 (2.31%) MS Office
3 1 (0.58%) MS PowerPoint
3 1 (0.58%) MS Visio
3 1 (0.58%) Spreadsheet
Business Applications
1 4 (2.31%) Cognos Business Intelligence
1 4 (2.31%) Unica
2 2 (1.16%) Endur
2 2 (1.16%) MetaTrader
2 2 (1.16%) SAP FI
Cloud Services
1 5 (2.89%) Amazon AWS
1 5 (2.89%) Microsoft Azure
Communications & Networking
1 18 (10.40%) SAN
2 13 (7.51%) FCoE
2 13 (7.51%) Fibre Channel
2 13 (7.51%) HTTP
2 13 (7.51%) iSCSI
2 13 (7.51%) LAN
2 13 (7.51%) Multicast
2 13 (7.51%) NAS
2 13 (7.51%) WAN
Database & Business Intelligence
1 97 (56.07%) SQL Server
2 78 (45.09%) OLAP
3 64 (36.99%) Data Warehouse
4 54 (31.21%) MySQL
5 51 (29.48%) Oracle OLAP
6 49 (28.32%) SQL Server Integration Services
7 48 (27.75%) SQL Server Reporting Services
8 37 (21.39%) Oracle Database
9 34 (19.65%) SQL Server Analysis Services
10 32 (18.50%) SQL Server 2008
11 28 (16.18%) DB2
12 19 (10.98%) Oracle ODI
12 19 (10.98%) Relational Database
13 18 (10.40%) SQL Server 2012
14 16 (9.25%) Oracle Database 10g
14 16 (9.25%) Oracle Database 11g
15 15 (8.67%) BusinessObjects
16 14 (8.09%) SQL Server 2014
17 13 (7.51%) Microsoft Analysis Services
18 11 (6.36%) OLAP Cube
Development Applications
1 14 (8.09%) Team Foundation Server
2 11 (6.36%) Git (software)
2 11 (6.36%) Oracle APEX
2 11 (6.36%) VSS/SourceSafe
3 6 (3.47%) Jenkins
3 6 (3.47%) JIRA
4 1 (0.58%) Subversion
4 1 (0.58%) Visual Studio
General
1 73 (42.20%) Finance
2 14 (8.09%) Banking
3 12 (6.94%) Telecoms
4 10 (5.78%) Marketing
4 10 (5.78%) Retail
5 9 (5.20%) Pharmaceutical
6 5 (2.89%) Private Banking
6 5 (2.89%) Publishing
7 3 (1.73%) Back Office
7 3 (1.73%) Games
7 3 (1.73%) Legal
8 2 (1.16%) Advertising
8 2 (1.16%) Financial Institution
Job Titles
1 103 (59.54%) Developer
2 57 (32.95%) Oracle Developer
3 34 (19.65%) DBA
4 31 (17.92%) SQL Developer
5 27 (15.61%) SQL DBA
6 23 (13.29%) C++ Developer
6 23 (13.29%) Unix Developer
7 19 (10.98%) Architect
7 19 (10.98%) SQL Server DBA
8 16 (9.25%) Infrastructure Architect
8 16 (9.25%) SSIS Developer
8 16 (9.25%) SSRS Developer
9 15 (8.67%) SSAS Developer
10 14 (8.09%) Senior Developer
11 13 (7.51%) Business Intelligence Developer
11 13 (7.51%) Lead Architect
12 12 (6.94%) Lead Developer
13 9 (5.20%) ETL Developer
14 8 (4.62%) .NET Developer
14 8 (4.62%) C# Developer
Libraries, Frameworks & Software Standards
1 24 (13.87%) Web Services
2 23 (13.29%) STL
3 17 (9.83%) .NET
4 16 (9.25%) Middleware
5 13 (7.51%) Oracle GoldenGate
6 11 (6.36%) SOAP
6 11 (6.36%) XML
7 10 (5.78%) ASP.NET
8 9 (5.20%) MDX
9 6 (3.47%) Django
10 5 (2.89%) WinForms
11 4 (2.31%) ASP.NET MVC
12 3 (1.73%) ODBC
12 3 (1.73%) SAML
Miscellaneous
1 43 (24.86%) Analytical Skills
2 21 (12.14%) Clustering
3 20 (11.56%) Replication
4 14 (8.09%) Enterprise Software
5 12 (6.94%) Data Integration
6 10 (5.78%) Fintech
6 10 (5.78%) Management Information System
7 9 (5.20%) Life Science
8 7 (4.05%) Data Structures
9 5 (2.89%) Computer Science
10 3 (1.73%) Mobile Payment
10 3 (1.73%) Online Games
10 3 (1.73%) PKI
11 2 (1.16%) Blackberry
11 2 (1.16%) Spread Betting
12 1 (0.58%) Economics
12 1 (0.58%) Mathematics
12 1 (0.58%) Social Media
12 1 (0.58%) User Experience
12 1 (0.58%) Visualisation
Operating Systems
1 50 (28.90%) Linux
2 38 (21.97%) Windows
3 28 (16.18%) Unix
4 18 (10.40%) Solaris
5 13 (7.51%) Windows Server
6 6 (3.47%) Windows Server 2008
7 4 (2.31%) Windows Server 2012
8 2 (1.16%) Red Hat Enterprise Linux
Processes & Methodologies
1 65 (37.57%) Performance Tuning
2 57 (32.95%) Business Intelligence
3 53 (30.64%) ETL
4 36 (20.81%) Agile Software Development
5 32 (18.50%) OO
6 25 (14.45%) Kimball Methodology
7 23 (13.29%) Dimensional Modelling
8 17 (9.83%) Benchmarking
8 17 (9.83%) Continuous Integration
9 16 (9.25%) Project Management
10 15 (8.67%) SDLC
11 14 (8.09%) Disaster Recovery
12 13 (7.51%) Data Modelling
12 13 (7.51%) Data Transformation
12 13 (7.51%) Risk Management
13 12 (6.94%) DNA
13 12 (6.94%) User Acceptance Testing
14 11 (6.36%) Automated Testing
14 11 (6.36%) ITIL
14 11 (6.36%) System Testing
Programming Languages
1 150 (86.71%) SQL
2 41 (23.70%) PL/SQL
3 28 (16.18%) C++
4 23 (13.29%) Java
5 21 (12.14%) T-SQL
6 16 (9.25%) C#
7 15 (8.67%) JavaScript
8 13 (7.51%) PowerShell
9 12 (6.94%) Python
10 7 (4.05%) Perl
11 6 (3.47%) C
12 5 (2.89%) PHP
12 5 (2.89%) Shell Script
13 3 (1.73%) Data Analysis Expressions (DAX)
14 1 (0.58%) VB.NET
14 1 (0.58%) VBA
14 1 (0.58%) VBScript
Qualifications
1 51 (29.48%) Degree
2 9 (5.20%) PhD
3 3 (1.73%) IBM Certification
4 2 (1.16%) MCSE
4 2 (1.16%) Microsoft Certification
5 1 (0.58%) MBA
5 1 (0.58%) Oracle Certification
Quality Assurance & Compliance
1 9 (5.20%) QA
2 8 (4.62%) Data Quality
3 5 (2.89%) PCI DSS
4 4 (2.31%) SLA
System Software
1 14 (8.09%) Oracle RAC
2 13 (7.51%) Hyper-V
2 13 (7.51%) KVM
2 13 (7.51%) NFS
2 13 (7.51%) SRDF
2 13 (7.51%) VMware Infrastructure
2 13 (7.51%) Xen
Systems Management
1 3 (1.73%) OpenView
1 3 (1.73%) Tivoli
2 1 (0.58%) Ansible
2 1 (0.58%) Microsoft Clustering
2 1 (0.58%) Oracle RMAN
2 1 (0.58%) Perfmon
2 1 (0.58%) Puppet
Vendors
1 115 (66.47%) Oracle
2 55 (31.79%) Microsoft
3 25 (14.45%) IBM
4 13 (7.51%) Cisco
4 13 (7.51%) EMC
4 13 (7.51%) Intel
4 13 (7.51%) NetApp
4 13 (7.51%) VMware
5 12 (6.94%) Cognos
6 10 (5.78%) Tableau
7 6 (3.47%) Facebook
8 5 (2.89%) SAP
8 5 (2.89%) Vertica
9 4 (2.31%) Alterian
9 4 (2.31%) Apteco
9 4 (2.31%) Informatica
10 3 (1.73%) Alteryx
10 3 (1.73%) BMC
10 3 (1.73%) Google
10 3 (1.73%) Sybase
South East London
Client Server
Salary: £25k to £40k + benefits
Posted: 6 hours ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 5 days ago
London
Client Server
Salary: £30k to £45k + benefits
Posted: 7 days ago
South West London
Gamesys
Posted: 21 days ago