Period
to 24 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Scotland 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 24 November 2017 with a comparison to the same period in the previous 2 years.

PL/SQL (PLSQL)
UK > Scotland
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 75 50 69
Rank change year-on-year -25 +19 0
Permanent jobs citing PL/SQL 188 235 222
As % of all permanent IT jobs advertised in Scotland 3.32% 4.54% 3.43%
As % of the Programming Languages category 5.44% 8.42% 6.85%
Number of salaries quoted 119 134 123
Scotland median annual salary £42,500 £45,000 £42,500
Median salary % change year-on-year -5.56% +5.88% -
10th Percentile £32,000 £32,000 £28,750
90th Percentile £62,500 £57,125 £55,000
UK median annual salary £47,500 £50,000 £47,500
% change year-on-year -5.00% +5.26% +5.56%

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 Scotland with a requirement for coding skills.

All Programming Languages
Scotland
Permanent vacancies with a requirement for coding skills 3455 2792 3239
As % of all permanent IT jobs advertised in Scotland 61.01% 53.94% 50.09%
Number of salaries quoted 2235 1714 2015
Scotland median annual salary £42,500 £42,000 £40,000
Median salary % change year-on-year +1.19% +5.00% -
10th Percentile £28,750 £28,000 £27,500
90th Percentile £62,500 £60,000 £59,900
UK median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% +2.27%

PL/SQL
Job Vacancy Trend in Scotland

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

Job vacancy trend for PL/SQL in Scotland

PL/SQL
Salary Trend in Scotland

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

Salary trend for PL/SQL in Scotland

PL/SQL
Salary Histogram in Scotland

The salary distribution of IT jobs citing PL/SQL in Scotland over the 6 months to 24 November 2017.

Salary histogram for PL/SQL in Scotland

PL/SQL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PL/SQL within the Scotland region over the 6 months to 24 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
Edinburgh -39 82 £42,500 - 2
Glasgow -21 79 £43,750 -12.50% 2
Fife +1 6 £31,842 -30.78%
Aberdeen - 1 £60,000 -
PL/SQL
UK

For the 6 months to 24 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 Scotland region with a requirement for PL/SQL.

1 187 (99.47%) SQL
2 162 (86.17%) Oracle
3 74 (39.36%) Oracle Database
4 61 (32.45%) Java
5 59 (31.38%) Agile Software Development
6 44 (23.40%) Oracle Database 11g
7 41 (21.81%) Finance
8 37 (19.68%) Oracle Database 10g
9 25 (13.30%) C#
9 25 (13.30%) .NET
10 24 (12.77%) Oracle EBS
10 24 (12.77%) Oracle EBS R12
11 23 (12.23%) Test Automation
11 23 (12.23%) Data Warehouse
11 23 (12.23%) Oracle APEX
12 21 (11.17%) Scrum
13 20 (10.64%) Selenium
13 20 (10.64%) Software Engineering
13 20 (10.64%) JIRA
13 20 (10.64%) Oracle Forms
14 19 (10.11%) SDLC
15 18 (9.57%) Analytical Skills
15 18 (9.57%) Oracle Database 12c
16 17 (9.04%) TDD
16 17 (9.04%) Oracle Reports
16 17 (9.04%) Business Intelligence
17 16 (8.51%) ETL
18 15 (7.98%) Oracle Discoverer
18 15 (7.98%) Web Services
18 15 (7.98%) ITIL

PL/SQL
Co-occurring IT Skills in Scotland 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 7 (3.72%) Apache
1 7 (3.72%) JBoss
2 5 (2.66%) GemFire
2 5 (2.66%) SAS
3 4 (2.13%) Apache Spark
3 4 (2.13%) Oracle SOA Suite
3 4 (2.13%) Tomcat
4 3 (1.60%) BizTalk Server
4 3 (1.60%) Confluence
4 3 (1.60%) SharePoint
5 2 (1.06%) Apache Pig
5 2 (1.06%) Oracle Self-Service HR
6 1 (0.53%) CICS
6 1 (0.53%) Oracle Application Server
Applications
1 7 (3.72%) Microsoft Excel
2 3 (1.60%) Microsoft Office
3 2 (1.06%) Microsoft PowerPoint
4 1 (0.53%) MS Visio
Business Applications
1 24 (12.77%) Oracle EBS
1 24 (12.77%) Oracle EBS R12
2 11 (5.85%) Oracle HRMS
2 11 (5.85%) Oracle Payroll
3 10 (5.32%) Oracle 11i
4 6 (3.19%) Oracle Financials
4 6 (3.19%) Oracle Procure-to-Pay
5 4 (2.13%) Endur
6 2 (1.06%) NetSuite
6 2 (1.06%) Oracle Applications
6 2 (1.06%) Sonata
7 1 (0.53%) Oracle BPM
7 1 (0.53%) Oracle iRecruitment
Cloud Services
1 3 (1.60%) Microsoft Azure
1 3 (1.60%) npm
2 1 (0.53%) Amazon AWS
Communications & Networking
1 5 (2.66%) GPRS
1 5 (2.66%) SMS
2 2 (1.06%) Network Security
3 1 (0.53%) Internet
Database & Business Intelligence
1 74 (39.36%) Oracle Database
2 44 (23.40%) Oracle Database 11g
3 37 (19.68%) Oracle Database 10g
4 23 (12.23%) Data Warehouse
5 18 (9.57%) Oracle Database 12c
6 17 (9.04%) Oracle Reports
7 15 (7.98%) Oracle Discoverer
8 14 (7.45%) Relational Database
9 11 (5.85%) SQL Server
10 10 (5.32%) RDBMS
11 8 (4.26%) BusinessObjects
11 8 (4.26%) Oracle BI EE
12 7 (3.72%) Oracle BI Publisher
13 6 (3.19%) Big Data
13 6 (3.19%) BusinessObjects Web Intelligence
13 6 (3.19%) SQLPlus
14 5 (2.66%) NoSQL
14 5 (2.66%) QlikView
15 4 (2.13%) BusinessObjects Business Intelligence
15 4 (2.13%) Power BI
Development Applications
1 23 (12.23%) Oracle APEX
2 20 (10.64%) JIRA
2 20 (10.64%) Oracle Forms
2 20 (10.64%) Selenium
3 9 (4.79%) JUnit
4 8 (4.26%) Cucumber
5 7 (3.72%) Maven
6 6 (3.19%) Jenkins
7 5 (2.66%) Git (software)
7 5 (2.66%) HP UFT
7 5 (2.66%) LoadRunner
8 4 (2.13%) Mockito
8 4 (2.13%) Team Foundation Server
9 3 (1.60%) Artifactory
9 3 (1.60%) Log4j
9 3 (1.60%) Subversion
9 3 (1.60%) TeamCity
10 2 (1.06%) PhpStorm
10 2 (1.06%) SoapUI
10 2 (1.06%) Toad
General
1 41 (21.81%) Finance
2 8 (4.26%) Telecoms
3 7 (3.72%) Banking
4 3 (1.60%) Retail Banking
5 2 (1.06%) Retail
6 1 (0.53%) Front Office
6 1 (0.53%) Legal
Job Titles
1 77 (40.96%) Developer
2 50 (26.60%) Oracle Developer
3 44 (23.40%) Analyst
4 29 (15.43%) Oracle Analyst
5 18 (9.57%) SQL Developer
6 16 (8.51%) Consultant
7 15 (7.98%) PL/SQL Developer
7 15 (7.98%) Support Analyst
8 14 (7.45%) Oracle Support Analyst
9 11 (5.85%) Functional Analyst
9 11 (5.85%) Oracle Payroll Analyst
10 10 (5.32%) HR Analyst
10 10 (5.32%) Java Developer
10 10 (5.32%) Oracle HRMS Analyst
10 10 (5.32%) Senior Analyst
11 9 (4.79%) Oracle HRMS Support
11 9 (4.79%) Oracle Payroll Support
12 8 (4.26%) ETL Tester
12 8 (4.26%) Oracle Consultant
12 8 (4.26%) Oracle DBA
Libraries, Frameworks & Software Standards
1 25 (13.30%) .NET
2 15 (7.98%) Spring
2 15 (7.98%) Web Services
3 12 (6.38%) Hibernate
4 11 (5.85%) SOAP
5 7 (3.72%) REST
5 7 (3.72%) RESTful
6 6 (3.19%) .NET Framework
6 6 (3.19%) HTML
6 6 (3.19%) XML
7 5 (2.66%) Gherkin
8 4 (2.13%) JPA
9 3 (1.60%) Apache Camel
9 3 (1.60%) Apache Flex
9 3 (1.60%) JDBC
9 3 (1.60%) Middleware
9 3 (1.60%) WCF
9 3 (1.60%) XSD
10 2 (1.06%) CGI
10 2 (1.06%) CodeIgniter
Miscellaneous
1 18 (9.57%) Analytical Skills
2 14 (7.45%) Computer Science
3 7 (3.72%) Management Information System
4 5 (2.66%) Data Centre
5 4 (2.13%) Algorithms
5 4 (2.13%) Data Structures
6 3 (1.60%) Fintech
6 3 (1.60%) Tandem
7 2 (1.06%) IVR
7 2 (1.06%) Smart Meter
7 2 (1.06%) Virtual Team
8 1 (0.53%) Greenfield Project
8 1 (0.53%) IBM Mainframe
8 1 (0.53%) Mainframe
8 1 (0.53%) Mobile App
Operating Systems
1 14 (7.45%) Unix
2 11 (5.85%) Linux
3 6 (3.19%) AIX
4 1 (0.53%) Tru64
Processes & Methodologies
1 59 (31.38%) Agile Software Development
2 23 (12.23%) Test Automation
3 21 (11.17%) Scrum
4 20 (10.64%) Software Engineering
5 19 (10.11%) SDLC
6 17 (9.04%) Business Intelligence
6 17 (9.04%) TDD
7 16 (8.51%) ETL
8 15 (7.98%) ITIL
9 14 (7.45%) Performance Testing
9 14 (7.45%) User Acceptance Testing
10 11 (5.85%) OO
10 11 (5.85%) Unit Testing
11 10 (5.32%) Data Modelling
11 10 (5.32%) System Testing
12 9 (4.79%) ERP
12 9 (4.79%) Mentoring
12 9 (4.79%) Risk Management
13 8 (4.26%) Change Management
13 8 (4.26%) Non-Functional Testing
Programming Languages
1 187 (99.47%) SQL
2 61 (32.45%) Java
3 25 (13.30%) C#
4 14 (7.45%) JavaScript
5 9 (4.79%) Scala
6 5 (2.66%) C++
6 5 (2.66%) Python
6 5 (2.66%) Shell Script
7 4 (2.13%) Perl
8 3 (1.60%) Bash Shell
8 3 (1.60%) C
8 3 (1.60%) Lisp
8 3 (1.60%) VB.NET
9 2 (1.06%) PHP
10 1 (0.53%) COBOL
10 1 (0.53%) JCL
Qualifications
1 10 (5.32%) Degree
2 8 (4.26%) Security Cleared
3 7 (3.72%) ISTQB
4 6 (3.19%) Oracle Certification
5 5 (2.66%) MCP
5 5 (2.66%) Microsoft Certification
5 5 (2.66%) OCP
5 5 (2.66%) SAP Certification
6 3 (1.60%) Numerate Degree
Quality Assurance & Compliance
1 8 (4.26%) QA
2 1 (0.53%) GDPR
System Software
1 2 (1.06%) Oracle RAC
Systems Management
1 7 (3.72%) Oracle RMAN
2 5 (2.66%) Data Guard
3 3 (1.60%) Ambari
3 3 (1.60%) Enterprise Manager Cloud Control
4 2 (1.06%) SCOM
5 1 (0.53%) CA Endevor
Vendors
1 162 (86.17%) Oracle
2 13 (6.91%) Microsoft
3 9 (4.79%) SAP
4 8 (4.26%) Cognizant
5 6 (3.19%) HP
6 5 (2.66%) Remedy
7 4 (2.13%) IFS
7 4 (2.13%) OpenLink
7 4 (2.13%) Perforce
8 3 (1.60%) Tableau
9 2 (1.06%) FNZ
9 2 (1.06%) Sage
10 1 (0.53%) Cognos
10 1 (0.53%) Hyperion
10 1 (0.53%) IBM
10 1 (0.53%) MicroStrategy
10 1 (0.53%) Pegasus
10 1 (0.53%) Red Hat
10 1 (0.53%) Teradata