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

3 months to
30 Aug 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 95 - 129
Rank change year-on-year
- 0
Permanent jobs citing OLTP 1 0 4
As % of all permanent IT jobs located in Cheshire 0.089% - 0.21%
As % of the Database & Business Intelligence category 0.26% - 0.52%
Number of salaries quoted 1 0 3
Median salary £45,000 - £40,000
UK excluding London median salary £50,000 £47,500 £47,750
% change year-on-year
+5.26% -0.52%
OLTP
North West

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

Database & Business Intelligence Category
Cheshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
382 632 774
As % of all permanent IT jobs located in Cheshire 34.05% 37.33% 40.52%
Number of salaries quoted 346 540 619
Median salary £38,000 £40,000 £37,500
Median salary % change year-on-year
-5.00% +6.66%
90% offered a salary of more than £28,600 £32,500 £29,500
10% offered a salary of more than £50,000 £55,000 £50,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend in Cheshire

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

OLTP Jobs Demand Trend in Cheshire

OLTP
Salary Trend in Cheshire

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

OLTP Salary Trend in Cheshire

OLTP
Top 9 Related IT Skills in Cheshire

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

1 1 (100.00%) SQL
1 1 (100.00%) T-SQL
1 1 (100.00%) SQL Server
1 1 (100.00%) Data Modelling
1 1 (100.00%) ETL
1 1 (100.00%) SQL Server Reporting Services
1 1 (100.00%) SQL Server Integration Services
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) Performance Monitoring

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

Database & Business Intelligence
1 1 (100.00%) SQL Server
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) SQL Server Integration Services
1 1 (100.00%) SQL Server Reporting Services
Job Titles
1 1 (100.00%) DBA
1 1 (100.00%) Developer
1 1 (100.00%) SQL DBA
1 1 (100.00%) SQL Developer
1 1 (100.00%) SQL Server DBA
1 1 (100.00%) SQL Server Developer
1 1 (100.00%) SSIS Developer
1 1 (100.00%) SSRS Developer
1 1 (100.00%) T-SQL Developer
Processes & Methodologies
1 1 (100.00%) Data Modelling
1 1 (100.00%) ETL
1 1 (100.00%) Performance Monitoring
Programming Languages
1 1 (100.00%) SQL
1 1 (100.00%) T-SQL