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

3 months to
29 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 186 185 184
Rank change year-on-year
-1 -1
Permanent jobs citing OLTP 10 10 15
As % of all permanent IT jobs located in Manchester 0.27% 0.26% 0.37%
As % of the Database & Business Intelligence category 0.77% 0.80% 0.97%
Number of salaries quoted 10 9 14
Median salary £52,500 £47,500 £48,000
Median salary % change year-on-year
+10.52% -1.04%
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 Manchester region.

Database & Business Intelligence Category
Manchester
Permanent IT job ads with a match in the
Database & Business Intelligence category
1305 1249 1543
As % of all permanent IT jobs located in Manchester 34.60% 32.01% 37.93%
Number of salaries quoted 1157 1060 1314
Median salary £45,000 £42,500 £37,500
Median salary % change year-on-year
+5.88% +13.33%
90% offered a salary of more than £30,000 £30,000 £27,000
10% offered a salary of more than £60,000 £52,500 £55,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 Manchester

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

OLTP Jobs Demand Trend in Manchester

OLTP
Salary Trend in Manchester

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

OLTP Salary Trend in Manchester

OLTP
Salary Histogram in Manchester

This chart provides a salary histogram for IT jobs citing OLTP across the Manchester region over the 3 months to 29 September 2016.

OLTP Salary Histogram in Manchester

OLTP
Top 17 Related IT Skills in Manchester

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

1 10 (100.00%) SQL
1 10 (100.00%) SQL Server
2 9 (90.00%) SQL Server Analysis Services
2 9 (90.00%) Enterprise Software
2 9 (90.00%) Performance Tuning
2 9 (90.00%) SQL Server Reporting Services
2 9 (90.00%) SQL Server Integration Services
2 9 (90.00%) T-SQL
2 9 (90.00%) Business Intelligence
2 9 (90.00%) Microsoft
3 8 (80.00%) SQL Server 2008
4 1 (10.00%) Agile Software Development
4 1 (10.00%) Data Warehouse
4 1 (10.00%) High Availability
4 1 (10.00%) Performance Monitoring
4 1 (10.00%) DevOps
4 1 (10.00%) SDLC

OLTP
Top Related IT Skills in Manchester 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 10 (100.00%) SQL Server
2 9 (90.00%) SQL Server Analysis Services
2 9 (90.00%) SQL Server Integration Services
2 9 (90.00%) SQL Server Reporting Services
3 8 (80.00%) SQL Server 2008
4 1 (10.00%) Data Warehouse
Job Titles
1 10 (100.00%) DBA
1 10 (100.00%) SQL DBA
1 10 (100.00%) SQL Server DBA
2 3 (30.00%) Developer
2 3 (30.00%) Development DBA
2 3 (30.00%) SQL Developer
2 3 (30.00%) SQL Server Developer
2 3 (30.00%) SQL Server Development DBA
3 1 (10.00%) DBA Manager
3 1 (10.00%) Project Manager
3 1 (10.00%) Technical Manager
3 1 (10.00%) Technical Project Manager
Miscellaneous
1 9 (90.00%) Enterprise Software
Processes & Methodologies
1 9 (90.00%) Business Intelligence
1 9 (90.00%) Performance Tuning
2 1 (10.00%) Agile Software Development
2 1 (10.00%) DevOps
2 1 (10.00%) High Availability
2 1 (10.00%) Performance Monitoring
2 1 (10.00%) SDLC
Programming Languages
1 10 (100.00%) SQL
2 9 (90.00%) T-SQL
Vendors
1 9 (90.00%) Microsoft