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

3 months to
26 Jun 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 49 25 47
Rank change year-on-year
-24 +22
Permanent jobs citing OLTP 4 13 2
As % of all permanent IT jobs located in Stoke-on-Trent 1.32% 6.57% 0.63%
As % of the Database & Business Intelligence category 2.88% 15.12% 1.28%
Number of salaries quoted 3 11 2
Median salary £40,000 £32,500 £45,000
Median salary % change year-on-year
+23.07% -27.77%
UK excluding London median salary £45,000 £45,000 £45,000
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
139 86 156
As % of all permanent IT jobs located in Stoke-on-Trent 46.03% 43.43% 49.52%
Number of salaries quoted 128 70 112
Median salary £35,000 £38,500 £33,500
Median salary % change year-on-year
-9.09% +14.92%
90% offered a salary of more than £25,000 £24,400 £19,500
10% offered a salary of more than £45,000 £52,500 £55,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 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 26 Related IT Skills in Stoke-on-Trent

For the 6 months to 26 June 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%) SQL Server
2 5 (71.43%) T-SQL
2 5 (71.43%) Data Modelling
2 5 (71.43%) SQL Server Reporting Services
2 5 (71.43%) SQL Server 2008
3 4 (57.14%) SQL Server Integration Services
3 4 (57.14%) ETL
3 4 (57.14%) Performance Monitoring
3 4 (57.14%) ETL Development
4 3 (42.86%) Analytical Skills
5 2 (28.57%) Business Intelligence
5 2 (28.57%) Finance
6 1 (14.29%) Performance Tuning
6 1 (14.29%) Relational Database
6 1 (14.29%) Database Mirroring
6 1 (14.29%) Games
6 1 (14.29%) Replication
6 1 (14.29%) RDBMS
6 1 (14.29%) Microsoft
6 1 (14.29%) Capacity Planning
6 1 (14.29%) High Availability
6 1 (14.29%) Degree
6 1 (14.29%) QA
6 1 (14.29%) User Acceptance Testing
6 1 (14.29%) SQL Server Analysis Services

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
2 5 (71.43%) SQL Server 2008
2 5 (71.43%) SQL Server Reporting Services
3 4 (57.14%) SQL Server Integration Services
4 1 (14.29%) RDBMS
4 1 (14.29%) Relational Database
4 1 (14.29%) SQL Server Analysis Services
General
1 2 (28.57%) Finance
2 1 (14.29%) Games
Job Titles
1 5 (71.43%) Developer
1 5 (71.43%) SQL Developer
2 4 (57.14%) SQL Server Developer
3 3 (42.86%) Junior
4 2 (28.57%) Administrator
4 2 (28.57%) DBA
4 2 (28.57%) Junior Developer
4 2 (28.57%) Junior SQL Developer
4 2 (28.57%) Junior SQL Server Developer
4 2 (28.57%) MIS Developer
4 2 (28.57%) Senior Developer
4 2 (28.57%) Senior SQL Developer
4 2 (28.57%) Senior SQL Server Developer
5 1 (14.29%) Graduate DBA
5 1 (14.29%) Junior DBA
5 1 (14.29%) Production DBA
5 1 (14.29%) Report Developer
5 1 (14.29%) SQL BI Developer
5 1 (14.29%) SQL Server BI Developer
5 1 (14.29%) SSRS Developer
Miscellaneous
1 3 (42.86%) Analytical Skills
2 1 (14.29%) Replication
Processes & Methodologies
1 5 (71.43%) Data Modelling
2 4 (57.14%) ETL
2 4 (57.14%) ETL Development
2 4 (57.14%) Performance Monitoring
3 2 (28.57%) Business Intelligence
4 1 (14.29%) Capacity Planning
4 1 (14.29%) Database Mirroring
4 1 (14.29%) High Availability
4 1 (14.29%) Performance Tuning
4 1 (14.29%) User Acceptance Testing
Programming Languages
1 7 (100.00%) SQL
2 5 (71.43%) T-SQL
Qualifications
1 1 (14.29%) Degree
Quality Assurance & Compliance
1 1 (14.29%) QA
Vendors
1 1 (14.29%) Microsoft