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

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 184 180 230
Rank change year-on-year
-4 +50
Permanent jobs citing OLTP 9 41 7
As % of all permanent IT jobs located in Surrey 0.25% 0.88% 0.13%
As % of the Database & Business Intelligence category 0.78% 2.71% 0.41%
Number of salaries quoted 9 33 7
Median salary £60,000 £45,000 £65,000
Median salary % change year-on-year
+33.33% -30.76%
UK excluding London median salary £45,000 £45,000 £45,000
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
1156 1511 1713
As % of all permanent IT jobs located in Surrey 31.61% 32.41% 32.19%
Number of salaries quoted 1010 1294 1446
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 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 1 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 1 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 -7 3 £55,000 +22.22%
Woking - 1 £50,000 -
OLTP
South East

OLTP
Top 30 Related IT Skills in Surrey

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