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

3 months to
26 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 561 553 527
Rank change year-on-year
-8 -26
Permanent jobs citing OLTP 56 107 160
As % of all permanent IT jobs located in London 0.15% 0.25% 0.35%
As % of the Database & Business Intelligence category 0.49% 0.82% 1.13%
Number of salaries quoted 32 80 121
Median salary £55,000 £60,000 £52,500
Median salary % change year-on-year
-8.33% +14.28%
90% offered a salary of more than £36,150 £46,350 £39,000
10% offered a salary of more than £67,500 £70,250 £72,500
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%
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
11372 12976 14133
As % of all permanent IT jobs located in London 29.70% 29.75% 30.82%
Number of salaries quoted 9908 10989 12270
Median salary £60,000 £57,500 £52,500
Median salary % change year-on-year
+4.34% +9.52%
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 £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 26 September 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 September 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 +30 7 £66,000 -2.22% 1
Croydon - 1 £60,000 -
Uxbridge - 1 £55,000 -
OLTP
England

OLTP
Top 30 Related IT Skills in London

For the 6 months to 26 September 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 131 (86.18%) SQL
2 95 (62.50%) SQL Server
3 87 (57.24%) Oracle
4 69 (45.39%) OLAP
4 69 (45.39%) Performance Tuning
5 68 (44.74%) Finance
6 64 (42.11%) Data Warehouse
7 55 (36.18%) Business Intelligence
8 54 (35.53%) SQL Server Integration Services
9 48 (31.58%) SQL Server Reporting Services
9 48 (31.58%) ETL
10 46 (30.26%) Linux
11 41 (26.97%) Oracle OLAP
11 41 (26.97%) MS Excel
11 41 (26.97%) Microsoft
12 40 (26.32%) SQL Server Analysis Services
12 40 (26.32%) Analytical Skills
13 39 (25.66%) Degree
13 39 (25.66%) Agile Software Development
13 39 (25.66%) MySQL
14 36 (23.68%) Windows
15 33 (21.71%) DB2
16 29 (19.08%) T-SQL
17 28 (18.42%) PL/SQL
17 28 (18.42%) OO
18 27 (17.76%) IBM
19 26 (17.11%) SAN
19 26 (17.11%) SQL Server 2008
20 24 (15.79%) Unix
21 23 (15.13%) 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 21 (13.82%) IIS
2 20 (13.16%) Apache
2 20 (13.16%) Oracle Coherence
2 20 (13.16%) Oracle HTTP Server
2 20 (13.16%) Tomcat
2 20 (13.16%) WebSphere
3 4 (2.63%) SharePoint
4 3 (1.97%) Oracle Spatial
5 2 (1.32%) Oracle Workflow
6 1 (0.66%) WebLogic
Applications
1 41 (26.97%) MS Excel
2 2 (1.32%) MS Office
3 1 (0.66%) MS Visio
Business Applications
1 4 (2.63%) Cognos Business Intelligence
2 2 (1.32%) Endur
2 2 (1.32%) SAP FI
2 2 (1.32%) Unica
Cloud Services
1 2 (1.32%) Google Cloud Platform
1 2 (1.32%) Microsoft Azure
1 2 (1.32%) PaaS
2 1 (0.66%) Amazon AWS
2 1 (0.66%) IaaS
2 1 (0.66%) SaaS
Communications & Networking
1 26 (17.11%) SAN
2 20 (13.16%) FCoE
2 20 (13.16%) Fibre Channel
2 20 (13.16%) HTTP
2 20 (13.16%) iSCSI
2 20 (13.16%) LAN
2 20 (13.16%) Multicast
2 20 (13.16%) NAS
2 20 (13.16%) WAN
3 1 (0.66%) VoIP
Database & Business Intelligence
1 95 (62.50%) SQL Server
2 69 (45.39%) OLAP
3 64 (42.11%) Data Warehouse
4 54 (35.53%) SQL Server Integration Services
5 48 (31.58%) SQL Server Reporting Services
6 41 (26.97%) Oracle OLAP
7 40 (26.32%) SQL Server Analysis Services
8 39 (25.66%) MySQL
9 33 (21.71%) DB2
10 26 (17.11%) SQL Server 2008
11 20 (13.16%) Oracle Database
12 18 (11.84%) Relational Database
13 15 (9.87%) Oracle ODI
14 14 (9.21%) Microsoft Analysis Services
15 12 (7.89%) SQL Server 2012
15 12 (7.89%) SQL Server 2014
16 11 (7.24%) BusinessObjects
17 9 (5.92%) NoSQL
17 9 (5.92%) Oracle Database 10g
17 9 (5.92%) Oracle Database 11g
Development Applications
1 19 (12.50%) Team Foundation Server
2 6 (3.95%) Oracle APEX
2 6 (3.95%) VSS/SourceSafe
3 2 (1.32%) JIRA
4 1 (0.66%) Cucumber
4 1 (0.66%) FitNesse
4 1 (0.66%) Git (software)
4 1 (0.66%) JBehave
4 1 (0.66%) Jenkins
4 1 (0.66%) Subversion
4 1 (0.66%) Visual Studio
General
1 68 (44.74%) Finance
2 10 (6.58%) Retail
3 9 (5.92%) Marketing
3 9 (5.92%) Pharmaceutical
3 9 (5.92%) Telecoms
4 7 (4.61%) Banking
5 6 (3.95%) Legal
6 5 (3.29%) Manufacturing
7 3 (1.97%) Back Office
7 3 (1.97%) Publishing
8 2 (1.32%) Financial Institution
8 2 (1.32%) Games
9 1 (0.66%) Advertising
Job Titles
1 89 (58.55%) Developer
2 42 (27.63%) Oracle Developer
3 30 (19.74%) SQL Developer
4 26 (17.11%) DBA
5 23 (15.13%) Architect
6 22 (14.47%) SQL DBA
7 21 (13.82%) Infrastructure Architect
8 20 (13.16%) Lead Architect
9 19 (12.50%) C++ Developer
9 19 (12.50%) Unix Developer
10 17 (11.18%) Lead Developer
11 16 (10.53%) Senior Developer
12 14 (9.21%) SQL Server DBA
12 14 (9.21%) SSIS Developer
12 14 (9.21%) SSRS Developer
13 13 (8.55%) Business Intelligence Developer
13 13 (8.55%) SSAS Developer
14 11 (7.24%) ETL Developer
15 10 (6.58%) C# Developer
16 8 (5.26%) .NET Developer
Libraries, Frameworks & Software Standards
1 21 (13.82%) Middleware
1 21 (13.82%) Web Services
2 19 (12.50%) STL
3 14 (9.21%) .NET
4 13 (8.55%) XML
5 10 (6.58%) ASP.NET
5 10 (6.58%) Oracle GoldenGate
6 6 (3.95%) Django
6 6 (3.95%) SOAP
7 5 (3.29%) MDX
7 5 (3.29%) WinForms
8 4 (2.63%) ASP.NET MVC
9 3 (1.97%) ODBC
10 1 (0.66%) Ajax
10 1 (0.66%) HTML
10 1 (0.66%) HTML5
10 1 (0.66%) Node.js
10 1 (0.66%) REST
10 1 (0.66%) SAML
Miscellaneous
1 40 (26.32%) Analytical Skills
2 16 (10.53%) Clustering
3 15 (9.87%) Replication
4 10 (6.58%) Fintech
5 9 (5.92%) Enterprise Software
5 9 (5.92%) Life Science
6 8 (5.26%) Data Integration
7 6 (3.95%) Management Information System
7 6 (3.95%) User Experience
8 5 (3.29%) N-Tier
9 3 (1.97%) Data Structures
10 2 (1.32%) Blackberry
10 2 (1.32%) Hedge funds
10 2 (1.32%) iPad
11 1 (0.66%) Computer Science
11 1 (0.66%) IVR
11 1 (0.66%) Online Games
11 1 (0.66%) PKI
11 1 (0.66%) Social Media
11 1 (0.66%) Visualisation
Operating Systems
1 46 (30.26%) Linux
2 36 (23.68%) Windows
3 24 (15.79%) Unix
4 22 (14.47%) Solaris
5 8 (5.26%) Windows Server
5 8 (5.26%) Windows Server 2008
6 4 (2.63%) Windows Server 2012
7 1 (0.66%) Android
7 1 (0.66%) Apple iOS
7 1 (0.66%) Red Hat Enterprise Linux
Processes & Methodologies
1 69 (45.39%) Performance Tuning
2 55 (36.18%) Business Intelligence
3 48 (31.58%) ETL
4 39 (25.66%) Agile Software Development
5 28 (18.42%) OO
6 23 (15.13%) Kimball Methodology
7 21 (13.82%) Benchmarking
8 20 (13.16%) Risk Management
9 18 (11.84%) Dimensional Modelling
9 18 (11.84%) Disaster Recovery
10 15 (9.87%) Project Management
11 14 (9.21%) Mentoring
11 14 (9.21%) SDLC
12 12 (7.89%) Data Transformation
13 11 (7.24%) Database Mirroring
14 10 (6.58%) Data Modelling
14 10 (6.58%) Dependency Management
14 10 (6.58%) High Availability
14 10 (6.58%) People Management
14 10 (6.58%) User Acceptance Testing
Programming Languages
1 131 (86.18%) SQL
2 29 (19.08%) T-SQL
3 28 (18.42%) PL/SQL
4 19 (12.50%) C++
5 16 (10.53%) Java
6 15 (9.87%) JavaScript
7 14 (9.21%) C#
8 8 (5.26%) Python
9 7 (4.61%) PowerShell
10 6 (3.95%) C
11 3 (1.97%) Data Analysis Expressions (DAX)
11 3 (1.97%) Shell Script
12 1 (0.66%) Objective-C
12 1 (0.66%) Perl
12 1 (0.66%) PHP
12 1 (0.66%) Ruby
12 1 (0.66%) VB.NET
12 1 (0.66%) VBA
12 1 (0.66%) VBScript
Qualifications
1 39 (25.66%) Degree
2 9 (5.92%) PhD
3 5 (3.29%) MCSE
3 5 (3.29%) Microsoft Certification
4 3 (1.97%) IBM Certification
5 1 (0.66%) Oracle Certification
Quality Assurance & Compliance
1 11 (7.24%) QA
2 3 (1.97%) Data Quality
3 1 (0.66%) PCI DSS
3 1 (0.66%) SLA
System Software
1 21 (13.82%) Oracle RAC
2 20 (13.16%) Hyper-V
2 20 (13.16%) KVM
2 20 (13.16%) NFS
2 20 (13.16%) SRDF
2 20 (13.16%) VMware Infrastructure
2 20 (13.16%) Xen
Systems Management
1 3 (1.97%) Microsoft Clustering
2 1 (0.66%) Ansible
2 1 (0.66%) OpenView
2 1 (0.66%) Perfmon
2 1 (0.66%) Tivoli
Vendors
1 87 (57.24%) Oracle
2 41 (26.97%) Microsoft
3 27 (17.76%) IBM
4 20 (13.16%) Cisco
4 20 (13.16%) EMC
4 20 (13.16%) Intel
4 20 (13.16%) NetApp
4 20 (13.16%) VMware
5 7 (4.61%) Cognos
6 6 (3.95%) Tableau
7 5 (3.29%) Google
7 5 (3.29%) SAP
8 4 (2.63%) Informatica
8 4 (2.63%) Sybase
9 3 (1.97%) Alteryx
10 2 (1.32%) Alterian
10 2 (1.32%) Apteco
10 2 (1.32%) OpenLink
10 2 (1.32%) Salesforce.com
11 1 (0.66%) Zend
City, London
Stott & May
Salary: £65000 - £80000 per annum + Bonus + overtime + 5k benefits
Posted: 11 hours ago
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 3 days ago
London
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 10 days ago