The table below looks at the statistics for OLTP skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited OLTP over the 3 months to 4 August 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
4 Aug 2015
Same period 2014 Same period 2013
Online Transaction Processing (OLTP)
Rank 282 307 314
Rank change year-on-year
+25 +7
Permanent jobs citing OLTP 25 35 20
As % of all permanent IT jobs located in the City of London 0.24% 0.28% 0.17%
As % of the Database & Business Intelligence category 0.87% 0.96% 0.62%
Number of salaries quoted 21 25 11
Average salary £50,000 £52,500 £55,000
Average salary % change year-on-year
-4.76% -4.54%
90% offered a salary of more than £35,000 £39,200 £41,500
10% offered a salary of more than £67,500 £66,500 £61,500
UK excluding London average salary £46,250 £46,250 £50,000
% change year-on-year
- -7.50%
OLTP
London

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 City of London region.

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2877 3628 3250
As % of all permanent IT jobs located in the City of London 27.81% 29.52% 27.26%
Number of salaries quoted 2464 3134 2894
Average salary £57,500 £55,000 £55,000
Average salary % change year-on-year
+4.54% -
90% offered a salary of more than £40,000 £37,500 £35,000
10% offered a salary of more than £80,000 £72,500 £77,500
UK excluding London average salary £42,500 £40,000 £39,500
% change year-on-year
+6.25% +1.26%

OLTP
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT jobs citing OLTP across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

OLTP Jobs Demand Trend in the City of London

OLTP
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP across the City of London region.

OLTP Salary Trend in the City of London

OLTP
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing OLTP across the City of London region over the 3 months to 4 August 2015.

OLTP Salary Histogram in the City of London

OLTP
Top 30 Related IT Skills in the City of London

For the 6 months to 4 August 2015, IT jobs across the City of London region citing OLTP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP.

1 38 (88.37%) SQL
2 33 (76.74%) Data Warehouse
3 29 (67.44%) Business Intelligence
4 26 (60.47%) ETL
5 24 (55.81%) Oracle
6 22 (51.16%) SQL Server
7 20 (46.51%) SQL Server Integration Services
8 18 (41.86%) Finance
8 18 (41.86%) PL/SQL
8 18 (41.86%) Oracle Database
9 17 (39.53%) OLAP
10 15 (34.88%) Banking
11 12 (27.91%) Oracle Database 11g
11 12 (27.91%) Linux
11 12 (27.91%) Data Modelling
12 11 (25.58%) Performance Tuning
13 10 (23.26%) T-SQL
13 10 (23.26%) C
13 10 (23.26%) Oracle OLAP
14 9 (20.93%) Agile Software Development
14 9 (20.93%) SQL Server Analysis Services
14 9 (20.93%) Oracle BI EE
14 9 (20.93%) Data Architecture
14 9 (20.93%) Data Mining
14 9 (20.93%) Java
14 9 (20.93%) Windows
14 9 (20.93%) XML
14 9 (20.93%) Oracle Database 12c
14 9 (20.93%) Mentoring
15 8 (18.60%) Database Security

OLTP
Top Related IT Skills in the City of London by Category

For the 6 months to 4 August 2015, IT jobs across the City of London region citing OLTP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP. Up to 20 skills are shown per category.

Application Platforms
1 2 (4.65%) WebLogic
1 2 (4.65%) Tomcat
1 2 (4.65%) Oracle Application Server
Applications
1 3 (6.98%) MS Excel
Business Applications
1 8 (18.60%) Oracle Applications
2 3 (6.98%) Cognos Business Intelligence
3 2 (4.65%) Oracle BPM
Cloud Services
1 1 (2.33%) Amazon AWS
Communications & Networking
1 4 (9.30%) Internet
2 2 (4.65%) LDAP
3 1 (2.33%) SSH
Database & Business Intelligence
1 33 (76.74%) Data Warehouse
2 22 (51.16%) SQL Server
3 20 (46.51%) SQL Server Integration Services
4 18 (41.86%) Oracle Database
5 17 (39.53%) OLAP
6 12 (27.91%) Oracle Database 11g
7 10 (23.26%) Oracle OLAP
8 9 (20.93%) Data Mining
8 9 (20.93%) SQL Server Analysis Services
8 9 (20.93%) Oracle BI EE
8 9 (20.93%) Oracle Database 12c
9 8 (18.60%) SQL Server Reporting Services
10 6 (13.95%) SQL Server 2008
10 6 (13.95%) Oracle BI Publisher
11 4 (9.30%) PowerCenter
12 3 (6.98%) Relational Database
12 3 (6.98%) Cognos Analysis Studio
12 3 (6.98%) Cognos Event Studio
12 3 (6.98%) Cognos Metric Studio
12 3 (6.98%) SQL Server 2012
Development Applications
1 6 (13.95%) Git (software)
2 5 (11.63%) Team Foundation Server
2 5 (11.63%) Subversion
3 1 (2.33%) Maven
3 1 (2.33%) JIRA
3 1 (2.33%) Talend Open Studio
3 1 (2.33%) Jenkins
3 1 (2.33%) Oracle Forms
General
1 18 (41.86%) Finance
2 15 (34.88%) Banking
3 5 (11.63%) Legal
4 4 (9.30%) Marketing
5 2 (4.65%) Retail
5 2 (4.65%) Back Office
6 1 (2.33%) Financial Institution
6 1 (2.33%) Law
6 1 (2.33%) Billing
Job Titles
1 25 (58.14%) Developer
2 12 (27.91%) Oracle Developer
3 9 (20.93%) SQL Developer
4 7 (16.28%) Senior Oracle Developer
4 7 (16.28%) Senior Developer
5 6 (13.95%) Head of Development
6 4 (9.30%) DBA
6 4 (9.30%) Business Intelligence Developer
6 4 (9.30%) Support Analyst
6 4 (9.30%) Applications Support
6 4 (9.30%) Analyst
7 3 (6.98%) Lead Developer
7 3 (6.98%) Administrator
7 3 (6.98%) Applications Support Analyst
8 2 (4.65%) Data Warehouse Developer
8 2 (4.65%) Java Technical Architect
8 2 (4.65%) Business Intelligence Analyst
8 2 (4.65%) Technical Architect
8 2 (4.65%) Architect
8 2 (4.65%) Cognos Developer
Libraries, Frameworks & Software Standards
1 9 (20.93%) XML
2 8 (18.60%) .NET
3 5 (11.63%) XSLT
4 3 (6.98%) XSD
5 2 (4.65%) DOM
5 2 (4.65%) J2EE
5 2 (4.65%) JSP
5 2 (4.65%) SOAP
5 2 (4.65%) Struts
5 2 (4.65%) Web Services
5 2 (4.65%) JMS
5 2 (4.65%) XML Schema
5 2 (4.65%) JavaBeans
5 2 (4.65%) JAXB
5 2 (4.65%) SAX
5 2 (4.65%) Middleware
5 2 (4.65%) JMX
5 2 (4.65%) Spring
5 2 (4.65%) Oracle Fusion
5 2 (4.65%) HTML
Miscellaneous
1 7 (16.28%) Analytical Skills
2 6 (13.95%) Replication
3 2 (4.65%) Clustering
3 2 (4.65%) Computer Science
3 2 (4.65%) Data Integration
3 2 (4.65%) W3C
4 1 (2.33%) Blackberry
4 1 (2.33%) Management Information System
4 1 (2.33%) Data Structures
Operating Systems
1 12 (27.91%) Linux
2 9 (20.93%) Windows
3 5 (11.63%) UNIX
4 1 (2.33%) Red Hat Enterprise Linux
Processes & Methodologies
1 29 (67.44%) Business Intelligence
2 26 (60.47%) ETL
3 12 (27.91%) Data Modelling
4 11 (25.58%) Performance Tuning
5 9 (20.93%) Data Architecture
5 9 (20.93%) Agile Software Development
5 9 (20.93%) Mentoring
6 8 (18.60%) Database Security
7 7 (16.28%) SDLC
8 6 (13.95%) CRM
8 6 (13.95%) ERP
9 5 (11.63%) Change Control
10 4 (9.30%) User Acceptance Testing
10 4 (9.30%) UML
11 3 (6.98%) Disaster Recovery
12 2 (4.65%) Migration
12 2 (4.65%) BPEL
12 2 (4.65%) Data Analysis
12 2 (4.65%) Logistics
12 2 (4.65%) OO
Programming Languages
1 38 (88.37%) SQL
2 18 (41.86%) PL/SQL
3 10 (23.26%) T-SQL
3 10 (23.26%) C
4 9 (20.93%) Java
5 6 (13.95%) JavaScript
6 4 (9.30%) XPath
7 2 (4.65%) C#
8 1 (2.33%) VBA
8 1 (2.33%) Python
8 1 (2.33%) Shell Script
8 1 (2.33%) Jython
Qualifications
1 8 (18.60%) OCP
1 8 (18.60%) Oracle Certification
2 3 (6.98%) Degree
3 1 (2.33%) ITIL Certification
3 1 (2.33%) IBM Certification
Quality Assurance & Compliance
1 4 (9.30%) QA
2 2 (4.65%) Data Quality
System Software
1 1 (2.33%) VMware Infrastructure
Systems Management
1 5 (11.63%) Control-M
2 2 (4.65%) Oracle Enterprise Manager
Vendors
1 24 (55.81%) Oracle
2 8 (18.60%) Microsoft
3 6 (13.95%) Informatica
3 6 (13.95%) Siebel
4 3 (6.98%) Cognos
5 2 (4.65%) IBM
6 1 (2.33%) Red Hat
6 1 (2.33%) Salesforce.com
6 1 (2.33%) Bloomberg
6 1 (2.33%) VMware
6 1 (2.33%) Vertica
6 1 (2.33%) ParAccel
6 1 (2.33%) Talend
6 1 (2.33%) WorldPay
6 1 (2.33%) Actian
City, London
Deerfoot IT Resources Ltd
Salary: £65000 - £72000 per annum + Banking bonus
Posted: 4 days ago
City, London
Benedict Cole Limited
Salary: £70000 - £75000 per annum + benefits
Posted: 6 days ago
City, London
Oscar Associates (UK) Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: 6 days ago
City of London
Hays IT - Uk Posting account
Salary: £65000.00 - £70000.00 per annum + package
Posted: 7 days ago
City of London
Hays IT - Uk Posting account
Salary: £50000.00 - £60000.00 per annum + package
Posted: 8 days ago
City of London
First Point
Salary: £35000 - £45000 per annum
Posted: 19 days ago
City of London
Modis International - London
Salary: £40000 - £50000 per annum + PACKAGE
Posted: 26 days ago