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

3 months to
25 Aug 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 44 23 38
Rank change year-on-year
-21 +15
Permanent jobs citing OLTP 7 18 4
As % of all permanent IT jobs located in Stoke-on-Trent 2.37% 9.09% 1.44%
As % of the Database & Business Intelligence category 4.70% 18.56% 2.56%
Number of salaries quoted 6 13 0
Median salary £46,250 £28,000 -
Median salary % change year-on-year
+65.17% -
UK excluding London median salary £50,000 £47,500 £47,500
% change year-on-year
+5.26% -
OLTP
Staffordshire

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 Stoke-on-Trent region.

Database & Business Intelligence Category
Stoke-on-Trent
Permanent IT job ads with a match in the
Database & Business Intelligence category
149 97 156
As % of all permanent IT jobs located in Stoke-on-Trent 50.51% 48.99% 56.12%
Number of salaries quoted 135 84 89
Median salary £35,000 £32,500 £32,500
Median salary % change year-on-year
+7.69% -
90% offered a salary of more than £25,000 £25,000 £19,500
10% offered a salary of more than £52,500 £55,000 £52,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend in Stoke-on-Trent

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

OLTP Jobs Demand Trend in Stoke-on-Trent

OLTP
Salary Trend in Stoke-on-Trent

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

OLTP Salary Trend in Stoke-on-Trent

OLTP
Top 17 Related IT Skills in Stoke-on-Trent

For the 6 months to 25 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 Stoke-on-Trent region with a requirement for OLTP.

1 7 (100.00%) SQL
1 7 (100.00%) T-SQL
1 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server Reporting Services
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server 2008
2 4 (57.14%) Performance Monitoring
2 4 (57.14%) ETL Development
2 4 (57.14%) Data Modelling
2 4 (57.14%) ETL
2 4 (57.14%) Business Intelligence
3 3 (42.86%) Microsoft
3 3 (42.86%) Analytical Skills
3 3 (42.86%) Performance Tuning
3 3 (42.86%) SQL Server Analysis Services
4 2 (28.57%) Enterprise Software
5 1 (14.29%) Finance

OLTP
Top Related IT Skills in Stoke-on-Trent 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 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server 2008
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server Reporting Services
2 3 (42.86%) SQL Server Analysis Services
General
1 1 (14.29%) Finance
Job Titles
1 4 (57.14%) Developer
1 4 (57.14%) SQL Developer
1 4 (57.14%) SQL Server Developer
2 3 (42.86%) DBA
2 3 (42.86%) Junior
2 3 (42.86%) Junior Developer
2 3 (42.86%) Junior SQL Developer
2 3 (42.86%) Junior SQL Server Developer
2 3 (42.86%) Senior Developer
2 3 (42.86%) Senior SQL Developer
2 3 (42.86%) Senior SQL Server Developer
2 3 (42.86%) SQL DBA
3 2 (28.57%) SQL Server DBA
4 1 (14.29%) Administrator
4 1 (14.29%) Business Intelligence Developer
4 1 (14.29%) MIS Developer
4 1 (14.29%) SQL BI Developer
4 1 (14.29%) SQL Server BI Developer
Miscellaneous
1 3 (42.86%) Analytical Skills
2 2 (28.57%) Enterprise Software
Processes & Methodologies
1 4 (57.14%) Business Intelligence
1 4 (57.14%) Data Modelling
1 4 (57.14%) ETL
1 4 (57.14%) ETL Development
1 4 (57.14%) Performance Monitoring
2 3 (42.86%) Performance Tuning
Programming Languages
1 7 (100.00%) SQL
1 7 (100.00%) T-SQL
Vendors
1 3 (42.86%) Microsoft