Period
to 20 July 2018

The following table provides summary statistics for permanent job vacancies advertised in Portsmouth with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 6 months to 20 July 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Hampshire > Portsmouth
6 months to
20 Jul 2018
Same period 2017 Same period 2016
Rank 28 62 39
Rank change year-on-year +34 -23 0
Permanent jobs citing T-SQL 53 16 29
As % of all permanent IT jobs advertised in Portsmouth 8.58% 2.25% 5.64%
As % of the Programming Languages category 14.06% 3.41% 9.51%
Number of salaries quoted 48 16 30
Portsmouth median annual salary £37,465 £44,250 £41,250
Median salary % change year-on-year -15.33% +7.27% +17.86%
10th Percentile £24,000 £30,938 £33,575
90th Percentile £51,500 £55,000 £47,500
Hampshire median annual salary £40,000 £40,000 £40,000

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for coding skills.

All Programming Languages
Portsmouth
Permanent vacancies with a requirement for coding skills 377 469 305
As % of all permanent IT jobs advertised in Portsmouth 61.00% 66.06% 59.34%
Number of salaries quoted 294 437 292
Portsmouth median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -5.88%
10th Percentile £26,750 £25,000 £27,500
90th Percentile £59,625 £57,500 £55,000
Hampshire median annual salary £43,000 £40,000 £40,000
% change year-on-year +7.50% - -

T-SQL
Job Vacancy Trend in Portsmouth

Job postings citing T-SQL as a percentage of all IT jobs advertised in Portsmouth.

Job vacancy trend for T-SQL in Portsmouth

T-SQL
Salary Trend in Portsmouth

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Portsmouth.

Salary trend for T-SQL in Portsmouth

T-SQL
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing T-SQL in Portsmouth over the 6 months to 20 July 2018.

Salary histogram for T-SQL in Portsmouth

For the 6 months to 20 July 2018, IT jobs citing T-SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Portsmouth region with a requirement for T-SQL.

1 52 (98.11%) SQL
2 46 (86.79%) SQL Server
3 34 (64.15%) .NET
3 34 (64.15%) C#
4 26 (49.06%) JavaScript
4 26 (49.06%) Microsoft
5 21 (39.62%) Performance Tuning
6 16 (30.19%) ASP.NET
6 16 (30.19%) MVC
7 15 (28.30%) SQL Server Reporting Services
8 14 (26.42%) SQL Server Integration Services
8 14 (26.42%) Analytics
8 14 (26.42%) E-Commerce
9 13 (24.53%) SQL Server Management Studio (SSMS)
10 12 (22.64%) ASP.NET MVC
10 12 (22.64%) SQL Server 2008
10 12 (22.64%) Replication
10 12 (22.64%) Data Modelling
10 12 (22.64%) Perfmon
11 11 (20.75%) SQL Server 2016
11 11 (20.75%) Problem-Solving
11 11 (20.75%) Linux
11 11 (20.75%) Statistics
11 11 (20.75%) SQL Server 2005
11 11 (20.75%) SQL Server 2012
11 11 (20.75%) Database Mirroring
12 10 (18.87%) Git (software)
12 10 (18.87%) Amazon AWS
12 10 (18.87%) CSS
12 10 (18.87%) HTML

T-SQL
Co-occurring IT Skills in Portsmouth 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:

Application Platforms
1 2 (3.77%) CMS
1 2 (3.77%) IIS
Cloud Services
1 10 (18.87%) Amazon AWS
2 7 (13.21%) Google Analytics
3 3 (5.66%) Microsoft Azure
4 2 (3.77%) Amazon S3
Database & Business Intelligence
1 46 (86.79%) SQL Server
2 15 (28.30%) SQL Server Reporting Services
3 14 (26.42%) SQL Server Integration Services
4 12 (22.64%) SQL Server 2008
5 11 (20.75%) SQL Server 2005
5 11 (20.75%) SQL Server 2012
5 11 (20.75%) SQL Server 2016
6 8 (15.09%) Relational Database
7 7 (13.21%) NoSQL
7 7 (13.21%) RDBMS
7 7 (13.21%) SQL Server Analysis Services
8 5 (9.43%) InfluxDB
8 5 (9.43%) MongoDB
9 3 (5.66%) Azure SQL Database
9 3 (5.66%) Power BI
10 2 (3.77%) OLTP
11 1 (1.89%) Big Data
11 1 (1.89%) BusinessObjects
Development Applications
1 13 (24.53%) SQL Server Management Studio (SSMS)
2 10 (18.87%) Git (software)
3 7 (13.21%) JIRA
4 1 (1.89%) NUnit
General
1 2 (3.77%) Retail
2 1 (1.89%) Advertising
2 1 (1.89%) Back Office
2 1 (1.89%) Marketing
Job Titles
1 28 (52.83%) Developer
2 21 (39.62%) .NET Developer
3 19 (35.85%) DBA
4 15 (28.30%) Administrator
5 14 (26.42%) C# Developer
6 13 (24.53%) Software Developer
6 13 (24.53%) SQL DBA
7 12 (22.64%) C# .NET Developer
8 10 (18.87%) C# Software Developer
9 9 (16.98%) Junior
9 9 (16.98%) Junior Developer
10 8 (15.09%) .NET Software Developer
11 7 (13.21%) Junior .NET Developer
12 6 (11.32%) ASP.NET Developer
12 6 (11.32%) C# ASP.NET Developer
12 6 (11.32%) SQL Developer
13 5 (9.43%) Senior Developer
14 4 (7.55%) Graduate Software Developer
14 4 (7.55%) Senior .NET Developer
14 4 (7.55%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 34 (64.15%) .NET
2 16 (30.19%) ASP.NET
3 12 (22.64%) ASP.NET MVC
4 10 (18.87%) CSS
4 10 (18.87%) HTML
5 8 (15.09%) Web Services
6 7 (13.21%) .NET Framework
6 7 (13.21%) CSS3
6 7 (13.21%) HTML5
7 4 (7.55%) MDX
8 3 (5.66%) AngularJS
8 3 (5.66%) Kendo UI
9 2 (3.77%) ASP.NET Web Forms
10 1 (1.89%) .NET Core
10 1 (1.89%) Twitter Bootstrap
Miscellaneous
1 12 (22.64%) Replication
2 2 (3.77%) Computer Science
3 1 (1.89%) Enterprise Software
Operating Systems
1 11 (20.75%) Linux
2 2 (3.77%) Windows
2 2 (3.77%) Windows Server
Processes & Methodologies
1 21 (39.62%) Performance Tuning
2 16 (30.19%) MVC
3 14 (26.42%) Analytics
3 14 (26.42%) E-Commerce
4 12 (22.64%) Data Modelling
5 11 (20.75%) Database Mirroring
5 11 (20.75%) Problem-Solving
5 11 (20.75%) Statistics
6 10 (18.87%) Business Intelligence
6 10 (18.87%) CRM
7 7 (13.21%) Agile Software Development
7 7 (13.21%) Creative Thinking
8 6 (11.32%) Web Analytics
9 4 (7.55%) Mentoring
9 4 (7.55%) Software Engineering
10 3 (5.66%) Front End Development
10 3 (5.66%) SOLID
11 2 (3.77%) Content Management
11 2 (3.77%) Performance Monitoring
11 2 (3.77%) Web Development
Programming Languages
1 52 (98.11%) SQL
2 34 (64.15%) C#
3 26 (49.06%) JavaScript
4 8 (15.09%) VB.NET
5 4 (7.55%) Java
6 3 (5.66%) VB
6 3 (5.66%) VB6
7 2 (3.77%) C
Qualifications
1 4 (7.55%) Degree
2 1 (1.89%) Computer Science Degree
Systems Management
1 12 (22.64%) Perfmon
2 2 (3.77%) SQL Sentry
Vendors
1 26 (49.06%) Microsoft
2 7 (13.21%) Google
3 2 (3.77%) Tableau