Period
to 21 October 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 21 October 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Hampshire > Portsmouth
6 months to
21 Oct 2018
Same period 2017 Same period 2016
Rank 24 58 28
Rank change year-on-year +34 -30 -1
Permanent jobs citing T-SQL 57 26 48
As % of all permanent IT jobs advertised in Portsmouth 9.66% 3.85% 7.78%
As % of the Programming Languages category 15.12% 6.50% 13.48%
Number of salaries quoted 59 27 48
Portsmouth median annual salary £40,000 £35,000 £37,500
Median salary % change year-on-year +14.29% -6.67% -11.76%
10th Percentile £24,000 £24,000 £31,250
90th Percentile £50,000 £51,250 £44,125
Hampshire median annual salary £40,000 £38,500 £40,000
% change year-on-year +3.90% -3.75% +3.90%

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 400 356
As % of all permanent IT jobs advertised in Portsmouth 63.90% 59.17% 57.70%
Number of salaries quoted 337 372 347
Portsmouth median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -5.88%
10th Percentile £28,500 £23,775 £26,250
90th Percentile £60,500 £57,500 £57,500
Hampshire median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -3.61%

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 21 October 2018.

Salary histogram for T-SQL in Portsmouth

For the 6 months to 21 October 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 56 (98.25%) SQL
2 51 (89.47%) SQL Server
3 49 (85.96%) .NET
3 49 (85.96%) C#
4 40 (70.18%) JavaScript
5 31 (54.39%) ASP.NET
5 31 (54.39%) MVC
6 28 (49.12%) Agile Software Development
6 28 (49.12%) ASP.NET MVC
7 27 (47.37%) CSS
7 27 (47.37%) HTML
8 22 (38.60%) CRM
9 21 (36.84%) E-Commerce
10 20 (35.09%) Microsoft
10 20 (35.09%) Web Services
10 20 (35.09%) Analytics
11 18 (31.58%) TDD
12 17 (29.82%) HTML5
12 17 (29.82%) CSS3
13 14 (24.56%) Business Intelligence
14 13 (22.81%) Git (software)
14 13 (22.81%) Web Analytics
15 12 (21.05%) AngularJS
16 11 (19.30%) Problem-Solving
17 10 (17.54%) ASP.NET Web Forms
17 10 (17.54%) jQuery
17 10 (17.54%) VB.NET
18 9 (15.79%) Retail
18 9 (15.79%) Unit Testing
18 9 (15.79%) React

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 3 (5.26%) IIS
2 2 (3.51%) CMS
Cloud Services
1 8 (14.04%) Amazon AWS
2 7 (12.28%) Google Analytics
3 2 (3.51%) Microsoft Azure
Communications & Networking
1 3 (5.26%) DNS
2 2 (3.51%) HTTP
2 2 (3.51%) SMTP
2 2 (3.51%) TCP/IP
Database & Business Intelligence
1 51 (89.47%) SQL Server
2 8 (14.04%) Relational Database
2 8 (14.04%) SQL Server 2016
3 7 (12.28%) NoSQL
3 7 (12.28%) RDBMS
4 6 (10.53%) SQL Server Analysis Services
5 3 (5.26%) SQL Server Reporting Services
6 2 (3.51%) Azure SQL Database
6 2 (3.51%) Power BI
6 2 (3.51%) SQL Server 2008
6 2 (3.51%) SQL Server Integration Services
7 1 (1.75%) Big Data
7 1 (1.75%) BusinessObjects
Development Applications
1 13 (22.81%) Git (software)
2 7 (12.28%) JIRA
3 4 (7.02%) NUnit
4 2 (3.51%) SQL Server Management Studio (SSMS)
5 1 (1.75%) Team Foundation Server
General
1 9 (15.79%) Retail
2 5 (8.77%) Back Office
3 1 (1.75%) Banking
3 1 (1.75%) Finance
3 1 (1.75%) Marketing
Job Titles
1 42 (73.68%) Developer
2 31 (54.39%) .NET Developer
3 21 (36.84%) Software Developer
4 19 (33.33%) C# .NET Developer
4 19 (33.33%) C# Developer
5 12 (21.05%) .NET Software Developer
5 12 (21.05%) C# Software Developer
6 10 (17.54%) ASP.NET Developer
6 10 (17.54%) C# ASP.NET Developer
6 10 (17.54%) SQL Developer
7 7 (12.28%) Senior Developer
8 6 (10.53%) DBA
8 6 (10.53%) JavaScript Developer
8 6 (10.53%) SQL DBA
9 5 (8.77%) E-Commerce Developer
9 5 (8.77%) Senior .NET Developer
10 4 (7.02%) .NET Software Engineer
10 4 (7.02%) Junior .NET Developer
10 4 (7.02%) Junior Developer
10 4 (7.02%) Senior E-Commerce Developer
Libraries, Frameworks & Software Standards
1 49 (85.96%) .NET
2 31 (54.39%) ASP.NET
3 28 (49.12%) ASP.NET MVC
4 27 (47.37%) CSS
4 27 (47.37%) HTML
5 20 (35.09%) Web Services
6 17 (29.82%) CSS3
6 17 (29.82%) HTML5
7 12 (21.05%) AngularJS
8 10 (17.54%) ASP.NET Web Forms
8 10 (17.54%) jQuery
9 9 (15.79%) React
10 8 (14.04%) .NET Framework
11 4 (7.02%) MDX
12 2 (3.51%) Kendo UI
12 2 (3.51%) Twitter Bootstrap
13 1 (1.75%) ASP.NET Web API
13 1 (1.75%) Entity Framework
13 1 (1.75%) KnockoutJS
13 1 (1.75%) LINQ
Miscellaneous
1 6 (10.53%) Computer Science
2 5 (8.77%) Enterprise Software
3 1 (1.75%) Fintech
3 1 (1.75%) Replication
Operating Systems
1 4 (7.02%) Windows
2 2 (3.51%) Linux
2 2 (3.51%) Unix
2 2 (3.51%) Windows 10
2 2 (3.51%) Windows 7
2 2 (3.51%) Windows Server
2 2 (3.51%) Windows Server 2008
Processes & Methodologies
1 31 (54.39%) MVC
2 28 (49.12%) Agile Software Development
3 22 (38.60%) CRM
4 21 (36.84%) E-Commerce
5 20 (35.09%) Analytics
6 18 (31.58%) TDD
7 14 (24.56%) Business Intelligence
8 13 (22.81%) Web Analytics
9 11 (19.30%) Problem-Solving
10 9 (15.79%) Unit Testing
11 7 (12.28%) Performance Tuning
11 7 (12.28%) Web Development
12 5 (8.77%) Software Engineering
13 4 (7.02%) BDD
13 4 (7.02%) Creative Thinking
13 4 (7.02%) Mentoring
13 4 (7.02%) SOA
14 2 (3.51%) Content Management
14 2 (3.51%) Customer Requirements
14 2 (3.51%) Fault Management
Programming Languages
1 56 (98.25%) SQL
2 49 (85.96%) C#
3 40 (70.18%) JavaScript
4 10 (17.54%) VB.NET
5 4 (7.02%) Java
6 3 (5.26%) VB
6 3 (5.26%) VB6
7 2 (3.51%) C
7 2 (3.51%) PowerShell
7 2 (3.51%) VBScript
Qualifications
1 8 (14.04%) Degree
2 2 (3.51%) Computer Science Degree
2 2 (3.51%) SC Cleared
2 2 (3.51%) Security Cleared
System Software
1 2 (3.51%) Active Directory
Systems Management
1 2 (3.51%) SCCM
1 2 (3.51%) SCOM
2 1 (1.75%) Perfmon
Vendors
1 20 (35.09%) Microsoft
2 7 (12.28%) Google
3 2 (3.51%) Tableau
3 2 (3.51%) VMware