The table below looks at the statistics for OLTP skills in IT jobs advertised for the Surrey region. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 23 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
23 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 186 185 219
Rank change year-on-year
-1 +34
Permanent jobs citing OLTP 5 30 6
As % of all permanent IT jobs located in Surrey 0.14% 0.65% 0.12%
As % of the Database & Business Intelligence category 0.45% 2.04% 0.36%
Number of salaries quoted 5 21 6
Median salary £60,000 £45,000 £65,000
Median salary % change year-on-year
+33.33% -30.76%
UK excluding London median salary £43,000 £45,000 £46,250
% change year-on-year
-4.44% -2.70%
OLTP
South East

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 Surrey region.

Database & Business Intelligence Category
Surrey
Permanent IT job ads with a match in the
Database & Business Intelligence category
1103 1474 1652
As % of all permanent IT jobs located in Surrey 30.63% 32.02% 32.56%
Number of salaries quoted 968 1271 1402
Median salary £50,000 £45,000 £45,000
Median salary % change year-on-year
+11.11% -
90% offered a salary of more than £33,500 £30,000 £31,500
10% offered a salary of more than £70,000 £65,000 £65,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 Surrey

The demand trend of job ads across the Surrey region citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in Surrey

OLTP
Salary Trend in Surrey

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

OLTP Salary Trend in Surrey

OLTP
Salary Histogram in Surrey

This chart provides a salary histogram for IT jobs citing OLTP across the Surrey region over the 3 months to 23 July 2016.

OLTP Salary Histogram in Surrey

OLTP
Job Locations in Surrey

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the Surrey region over the 3 months to 23 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
Reigate 0 2 £55,000 +22.22%
OLTP
South East

OLTP
Top 30 Related IT Skills in Surrey

For the 6 months to 23 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 Surrey region with a requirement for OLTP.

1 5 (38.46%) Unix
1 5 (38.46%) Data Warehouse
1 5 (38.46%) Linux
1 5 (38.46%) Red Hat
1 5 (38.46%) Disaster Recovery
1 5 (38.46%) Red Hat Enterprise Linux
1 5 (38.46%) High Availability
2 4 (30.77%) Stakeholder and Relationship Management
2 4 (30.77%) Agile Software Development
2 4 (30.77%) Finance
2 4 (30.77%) Stakeholder Management
3 3 (23.08%) Scrum
3 3 (23.08%) Middleware
3 3 (23.08%) MS Excel
3 3 (23.08%) ETL
3 3 (23.08%) Business Intelligence
3 3 (23.08%) Microsoft
3 3 (23.08%) SQL Server
3 3 (23.08%) OLAP
3 3 (23.08%) CSS
3 3 (23.08%) HTML
3 3 (23.08%) JavaScript
3 3 (23.08%) PHP
3 3 (23.08%) SQL
3 3 (23.08%) T-SQL
3 3 (23.08%) Web Development
3 3 (23.08%) QA
3 3 (23.08%) jQuery
3 3 (23.08%) SQL Server Analysis Services
3 3 (23.08%) SQL Server 2008

OLTP
Top Related IT Skills in Surrey 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:

Applications
1 3 (23.08%) MS Excel
Communications & Networking
1 2 (15.38%) SAN
2 1 (7.69%) Fibre Channel
2 1 (7.69%) LAN
2 1 (7.69%) NAS
2 1 (7.69%) PABX
2 1 (7.69%) VoIP
2 1 (7.69%) WAN
2 1 (7.69%) Wi-Fi
Database & Business Intelligence
1 5 (38.46%) Data Warehouse
2 3 (23.08%) Data Mart
2 3 (23.08%) OLAP
2 3 (23.08%) SQL Server
2 3 (23.08%) SQL Server 2008
2 3 (23.08%) SQL Server 2012
2 3 (23.08%) SQL Server 2014
2 3 (23.08%) SQL Server Analysis Services
2 3 (23.08%) SQL Server Integration Services
3 1 (7.69%) MySQL
3 1 (7.69%) VLDB
General
1 4 (30.77%) Finance
Job Titles
1 5 (38.46%) Administrator
1 5 (38.46%) Architect
2 4 (30.77%) Database Architect
2 4 (30.77%) Enterprise Architect
2 4 (30.77%) Enterprise Infrastructure Architect
2 4 (30.77%) Infrastructure Architect
2 4 (30.77%) Linux Administrator
2 4 (30.77%) Linux Systems Administrator
2 4 (30.77%) Systems Administrator
3 3 (23.08%) Business Intelligence Developer
3 3 (23.08%) Developer
3 3 (23.08%) Microsoft BI Developer
3 3 (23.08%) Microsoft Developer
3 3 (23.08%) Middleware Architect
3 3 (23.08%) Web Developer
4 1 (7.69%) Integration Architect
4 1 (7.69%) Strategy Architect
4 1 (7.69%) Unix Administrator
Libraries, Frameworks & Software Standards
1 3 (23.08%) AngularJS
1 3 (23.08%) CSS
1 3 (23.08%) HTML
1 3 (23.08%) jQuery
1 3 (23.08%) Middleware
1 3 (23.08%) Node.js
Miscellaneous
1 3 (23.08%) Visualisation
2 2 (15.38%) Computer Science
3 1 (7.69%) BYOD
3 1 (7.69%) Data Centre
3 1 (7.69%) EMC VMAX
Operating Systems
1 5 (38.46%) Linux
1 5 (38.46%) Red Hat Enterprise Linux
1 5 (38.46%) Unix
2 1 (7.69%) Solaris
Processes & Methodologies
1 5 (38.46%) Disaster Recovery
1 5 (38.46%) High Availability
2 4 (30.77%) Agile Software Development
2 4 (30.77%) Stakeholder and Relationship Management
2 4 (30.77%) Stakeholder Management
3 3 (23.08%) Business Intelligence
3 3 (23.08%) Data Visualisation
3 3 (23.08%) ETL
3 3 (23.08%) Performance Tuning
3 3 (23.08%) Scrum
3 3 (23.08%) Web Development
4 1 (7.69%) DevOps
4 1 (7.69%) Logistics
4 1 (7.69%) TOGAF
Programming Languages
1 3 (23.08%) JavaScript
1 3 (23.08%) PHP
1 3 (23.08%) SQL
1 3 (23.08%) T-SQL
Qualifications
1 1 (7.69%) Degree
Quality Assurance & Compliance
1 3 (23.08%) QA
System Software
1 1 (7.69%) GlusterFS
1 1 (7.69%) Veritas Cluster Server
Systems Management
1 1 (7.69%) NetBackup
1 1 (7.69%) Oracle ZFS
1 1 (7.69%) Red Hat Satellite
1 1 (7.69%) Veritas Storage Foundation
Vendors
1 5 (38.46%) Red Hat
2 3 (23.08%) Microsoft
3 1 (7.69%) Brocade
3 1 (7.69%) EMC
3 1 (7.69%) Oracle
3 1 (7.69%) StorageTek
3 1 (7.69%) Sun
3 1 (7.69%) Veritas