The first table below looks at the demand 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 16 April 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category for the City of London region.

Location
3 months to
16 Apr 2014
Same period 2013 Same period 2012
Online Transaction Processing (OLTP)
Rank 303 273 311
Rank change year-on-year
-30 +38
Permanent jobs citing OLTP 32 55 34
As % of all permanent IT jobs located in the City of London 0.25% 0.46% 0.24%
As % of the Database & Business Intelligence category 0.88% 1.65% 0.91%
Number of salaries quoted 18 43 32
Average salary £61,000 £57,500 £53,750
Average salary % change year-on-year
+6.08% +6.97%
90% offered a salary of more than £42,500 £48,000 £42,750
10% offered a salary of more than £63,250 £72,000 £81,000
UK excluding London average salary £50,000 £44,000 £38,500
% change year-on-year
+13.63% +14.28%
Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
3657 3340 3716
As % of all permanent IT jobs located in the City of London 28.68% 27.99% 26.63%
Number of salaries quoted 3180 2986 3443
Average salary £52,500 £52,500 £52,500
90% offered a salary of more than £35,000 £35,000 £37,500
10% offered a salary of more than £75,000 £72,100 £70,000
UK excluding London average salary £40,000 £39,500 £37,500
% change year-on-year
+1.26% +5.33%
OLTP
London

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 16 April 2014.

OLTP Salary Histogram in the City of London

OLTP
Top 30 Related IT Skills in the City of London

For the 6 months to 16 April 2014, 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 33 (64.71%) SQL
2 32 (62.75%) OLAP
3 31 (60.78%) SQL Server
4 27 (52.94%) Business Intelligence
4 27 (52.94%) SQL Server Integration Services
5 25 (49.02%) SQL Server Reporting Services
6 23 (45.10%) T-SQL
7 21 (41.18%) Performance Tuning
8 20 (39.22%) SQL Server 2008
9 19 (37.25%) Data Warehouse
10 18 (35.29%) Banking
10 18 (35.29%) Finance
11 16 (31.37%) MDX
12 15 (29.41%) SQL Server 2005
12 15 (29.41%) ETL
13 14 (27.45%) Windows
13 14 (27.45%) Oracle
14 11 (21.57%) SQL Server Analysis Services
14 11 (21.57%) Clustering
15 10 (19.61%) Oracle RAC
15 10 (19.61%) Linux
15 10 (19.61%) Oracle Database
16 9 (17.65%) Data Guard
16 9 (17.65%) Oracle Database 10g
16 9 (17.65%) Oracle Database 11g
16 9 (17.65%) Oracle RMAN
17 8 (15.69%) Replication
17 8 (15.69%) Disaster Recovery
17 8 (15.69%) Red Hat
17 8 (15.69%) E-Commerce

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

For the 6 months to 16 April 2014, 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.

Applications
1 2 (3.92%) MS Excel
Business Applications
1 6 (11.76%) Cognos Business Intelligence
Cloud Services
1 4 (7.84%) SaaS
Communications & Networking
1 2 (3.92%) SAN
2 1 (1.96%) Wireless
Database & Business Intelligence
1 32 (62.75%) OLAP
2 31 (60.78%) SQL Server
3 27 (52.94%) SQL Server Integration Services
4 25 (49.02%) SQL Server Reporting Services
5 20 (39.22%) SQL Server 2008
6 19 (37.25%) Data Warehouse
7 15 (29.41%) SQL Server 2005
8 11 (21.57%) SQL Server Analysis Services
9 10 (19.61%) Oracle Database
10 9 (17.65%) Oracle Database 10g
10 9 (17.65%) Oracle Database 11g
11 6 (11.76%) Relational Database
12 5 (9.80%) SQL Server 2012
12 5 (9.80%) RDBMS
13 4 (7.84%) Hadoop
14 3 (5.88%) Oracle9i Database
14 3 (5.88%) MySQL
15 2 (3.92%) Oracle OLAP
15 2 (3.92%) SQL Server 2000
15 2 (3.92%) Oracle Exadata
Development Applications
1 3 (5.88%) Team Foundation Server
2 2 (3.92%) Visual Studio
3 1 (1.96%) Oracle Forms
General
1 18 (35.29%) Banking
1 18 (35.29%) Finance
2 6 (11.76%) Retail
3 5 (9.80%) Pharmaceutical
3 5 (9.80%) Telecoms
4 4 (7.84%) Online Betting
4 4 (7.84%) Investment Banking
5 2 (3.92%) Marketing
6 1 (1.96%) Advertising
Job Titles
1 23 (45.10%) DBA
2 19 (37.25%) Developer
3 12 (23.53%) Report Developer
4 9 (17.65%) Oracle DBA
5 8 (15.69%) Senior DBA
6 6 (11.76%) Team Leader
6 6 (11.76%) Cognos Consultant
6 6 (11.76%) Consultant
6 6 (11.76%) Administrator
7 5 (9.80%) SQL DBA
7 5 (9.80%) Oracle Team Leader
8 3 (5.88%) DBA Manager
8 3 (5.88%) Data Warehouse Developer
8 3 (5.88%) Business Intelligence Developer
9 1 (1.96%) Software Developer
9 1 (1.96%) Architect
9 1 (1.96%) Junior
9 1 (1.96%) Senior Developer
9 1 (1.96%) Data Architect
9 1 (1.96%) Business Developer
Libraries, Frameworks & Software Standards
1 16 (31.37%) MDX
2 3 (5.88%) JDBC
2 3 (5.88%) Apache Flex
3 1 (1.96%) ASP.NET MVC
3 1 (1.96%) STL
3 1 (1.96%) .NET
3 1 (1.96%) ASP.NET
3 1 (1.96%) COM
3 1 (1.96%) WinForms
Miscellaneous
1 11 (21.57%) Clustering
2 8 (15.69%) Replication
3 6 (11.76%) Blackberry
4 4 (7.84%) Mathematics
5 2 (3.92%) Digital Media
6 1 (1.96%) Hedge funds
6 1 (1.96%) Data Integration
6 1 (1.96%) PDA
6 1 (1.96%) Statistics
6 1 (1.96%) Spread Betting
Operating Systems
1 14 (27.45%) Windows
2 10 (19.61%) Linux
3 8 (15.69%) Red Hat Enterprise Linux
4 6 (11.76%) Solaris
5 2 (3.92%) UNIX
5 2 (3.92%) Windows Server 2008
Processes & Methodologies
1 27 (52.94%) Business Intelligence
2 21 (41.18%) Performance Tuning
3 15 (29.41%) ETL
4 8 (15.69%) Disaster Recovery
4 8 (15.69%) E-Commerce
5 4 (7.84%) Release Management
5 4 (7.84%) Scrum
6 3 (5.88%) Problem Management
6 3 (5.88%) Change Data Capture
6 3 (5.88%) Database Security
6 3 (5.88%) Service Management
6 3 (5.88%) Data Security
6 3 (5.88%) Resource Management
7 2 (3.92%) Data Modelling
7 2 (3.92%) ITIL
7 2 (3.92%) Kimball Methodology
7 2 (3.92%) Continuous Improvement
7 2 (3.92%) Capacity Planning
8 1 (1.96%) Capacity Management
8 1 (1.96%) Analytics
Programming Languages
1 33 (64.71%) SQL
2 23 (45.10%) T-SQL
3 7 (13.73%) Java
4 5 (9.80%) Shell Script
5 3 (5.88%) PowerShell
5 3 (5.88%) Perl
6 2 (3.92%) PL/SQL
6 2 (3.92%) C#
7 1 (1.96%) VC++
7 1 (1.96%) C++
7 1 (1.96%) JavaScript
7 1 (1.96%) VB
7 1 (1.96%) VB6
Qualifications
1 6 (11.76%) CIPD
2 5 (9.80%) Degree
3 4 (7.84%) MCITP
3 4 (7.84%) Microsoft Certification
3 4 (7.84%) OCP
3 4 (7.84%) Oracle Certification
4 2 (3.92%) MCTS
Quality Assurance & Compliance
1 3 (5.88%) QA
2 2 (3.92%) SLA
System Software
1 10 (19.61%) Oracle RAC
2 9 (17.65%) Oracle RMAN
3 1 (1.96%) VMware ESX
Systems Management
1 9 (17.65%) Data Guard
2 3 (5.88%) Oracle Enterprise Manager
3 2 (3.92%) Oracle Statspack
Vendors
1 14 (27.45%) Oracle
2 8 (15.69%) Red Hat
3 7 (13.73%) Netezza
4 6 (11.76%) Microsoft
4 6 (11.76%) Cognos
5 4 (7.84%) IBM
6 3 (5.88%) Sun
7 2 (3.92%) MicroStrategy
7 2 (3.92%) Red Gate
8 1 (1.96%) Vertica
8 1 (1.96%) Informatica
8 1 (1.96%) VMware
City of London
Hays IT - Uk Posting account
Salary: £35000.00 - £50000.00 per annum + Benefits
Posted: 28 days ago