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

3 months to
28 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 97 - 133
Rank change year-on-year
- 0
Permanent jobs citing OLTP 1 0 2
As % of all permanent IT jobs located in Cheshire 0.085% - 0.10%
As % of the Database & Business Intelligence category 0.25% - 0.25%
Number of salaries quoted 1 0 2
Median salary £45,000 - £42,500
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%
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
399 658 808
As % of all permanent IT jobs located in Cheshire 34.07% 39.03% 41.71%
Number of salaries quoted 362 580 656
Median salary £40,000 £40,000 £40,000
90% offered a salary of more than £30,000 £32,500 £30,000
10% offered a salary of more than £50,000 £55,000 £50,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 28 September 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