Period
to 17 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Lancashire with a requirement for PL/SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PL/SQL over the 6 months to 17 November 2017 with a comparison to the same period in the previous 2 years.

PL/SQL (PLSQL)
North West > Lancashire
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 71 85 84
Rank change year-on-year +14 -1 -16
Permanent jobs citing PL/SQL 14 4 9
As % of all permanent IT jobs advertised in Lancashire 1.58% 0.43% 0.87%
As % of the Programming Languages category 2.68% 0.80% 1.62%
Number of salaries quoted 13 4 9
Lancashire median annual salary £37,500 £45,000 £38,000
Median salary % change year-on-year -16.67% +18.42% +8.57%
10th Percentile £30,500 £45,000 £24,000
90th Percentile £39,750 £45,000 £42,500
North West median annual salary £48,750 £45,000 £45,000
% change year-on-year +8.33% - +12.50%

PL/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 Lancashire with a requirement for coding skills.

All Programming Languages
Lancashire
Permanent vacancies with a requirement for coding skills 523 503 554
As % of all permanent IT jobs advertised in Lancashire 59.03% 54.38% 53.73%
Number of salaries quoted 441 450 455
Lancashire median annual salary £35,000 £36,500 £35,000
Median salary % change year-on-year -4.11% +4.29% -
10th Percentile £25,500 £24,875 £23,700
90th Percentile £47,500 £45,000 £45,000
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +6.67%

PL/SQL
Job Vacancy Trend in Lancashire

Job postings citing PL/SQL as a percentage of all IT jobs advertised in Lancashire.

Job vacancy trend for PL/SQL in Lancashire

PL/SQL
Salary Trend in Lancashire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing PL/SQL in Lancashire.

Salary trend for PL/SQL in Lancashire

PL/SQL
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PL/SQL within the Lancashire region over the 6 months to 17 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Chorley - 4 £37,250 -
Skelmersdale - 4 £33,000 - 1
Preston - 2 £37,500 -
PL/SQL
North West

For the 6 months to 17 November 2017, IT jobs citing PL/SQL 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 Lancashire region with a requirement for PL/SQL.

1 14 (100.00%) SQL
1 14 (100.00%) Oracle
2 13 (92.86%) Oracle Database
3 6 (42.86%) Degree
3 6 (42.86%) REST
3 6 (42.86%) .NET
3 6 (42.86%) Sybase
3 6 (42.86%) ASP.NET
3 6 (42.86%) SOAP
3 6 (42.86%) C#
3 6 (42.86%) XML
3 6 (42.86%) XSLT
3 6 (42.86%) Adobe
3 6 (42.86%) ColdFusion
3 6 (42.86%) PowerBuilder
4 4 (28.57%) Spring
4 4 (28.57%) Software Engineering
4 4 (28.57%) Computer Science
4 4 (28.57%) .NET Framework
4 4 (28.57%) Continuous Integration
4 4 (28.57%) High Availability
4 4 (28.57%) Greenfield Project
4 4 (28.57%) Computer Science Degree
4 4 (28.57%) Innovative Thinking
4 4 (28.57%) Oracle Forms
4 4 (28.57%) Oracle Reports
4 4 (28.57%) Java
4 4 (28.57%) T-SQL
4 4 (28.57%) Web Services
4 4 (28.57%) Agile Software Development

PL/SQL
Co-occurring IT Skills in Lancashire 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 6 (42.86%) ColdFusion
Business Applications
1 3 (21.43%) Oracle EBS R12
2 2 (14.29%) Oracle EBS
3 1 (7.14%) Oracle Applications
Database & Business Intelligence
1 13 (92.86%) Oracle Database
2 4 (28.57%) Oracle Reports
3 3 (21.43%) Oracle Database 12c
4 1 (7.14%) Relational Database
Development Applications
1 6 (42.86%) PowerBuilder
2 4 (28.57%) Oracle Forms
3 2 (14.29%) Oracle APEX
General
1 4 (28.57%) Manufacturing
Job Titles
1 14 (100.00%) Developer
2 6 (42.86%) .NET Developer
3 5 (35.71%) SQL Developer
4 4 (28.57%) Database Developer
4 4 (28.57%) Oracle Developer
4 4 (28.57%) SQL Database Developer
5 2 (14.29%) .NET Software Developer
5 2 (14.29%) ASP.NET Developer
5 2 (14.29%) C# .NET Developer
5 2 (14.29%) C# ASP.NET Developer
5 2 (14.29%) C# Developer
5 2 (14.29%) C# Software Developer
5 2 (14.29%) Oracle Forms Developer
5 2 (14.29%) Oracle Reports Developer
5 2 (14.29%) Report Developer
5 2 (14.29%) Software Developer
6 1 (7.14%) PL/SQL Developer
Libraries, Frameworks & Software Standards
1 6 (42.86%) .NET
1 6 (42.86%) ASP.NET
1 6 (42.86%) REST
1 6 (42.86%) SOAP
1 6 (42.86%) XML
1 6 (42.86%) XSLT
2 4 (28.57%) .NET Framework
2 4 (28.57%) Hibernate
2 4 (28.57%) Spring
2 4 (28.57%) Web Services
Miscellaneous
1 4 (28.57%) Computer Science
1 4 (28.57%) Greenfield Project
2 1 (7.14%) Analytical Skills
Processes & Methodologies
1 4 (28.57%) Agile Software Development
1 4 (28.57%) Continuous Integration
1 4 (28.57%) High Availability
1 4 (28.57%) Innovative Thinking
1 4 (28.57%) Software Engineering
2 1 (7.14%) Data Analysis
2 1 (7.14%) E-business
2 1 (7.14%) Performance Tuning
2 1 (7.14%) Six Sigma
Programming Languages
1 14 (100.00%) SQL
2 6 (42.86%) C#
3 4 (28.57%) Java
3 4 (28.57%) T-SQL
Qualifications
1 6 (42.86%) Degree
2 4 (28.57%) Computer Science Degree
Vendors
1 14 (100.00%) Oracle
2 6 (42.86%) Adobe
2 6 (42.86%) Sybase