Period
to 16 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Scotland with a requirement for PostgreSQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PostgreSQL over the 6 months to 16 January 2018 with a comparison to the same period in the previous 2 years.

PostgreSQL (Postgres)
UK > Scotland
6 months to
16 Jan 2018
Same period 2017 Same period 2016
Rank 113 136 148
Rank change year-on-year +23 +12 +61
Permanent jobs citing PostgreSQL 123 63 87
As % of all permanent IT jobs advertised in Scotland 2.24% 1.35% 1.43%
As % of the Database & Business Intelligence category 6.79% 4.17% 4.67%
Number of salaries quoted 68 50 54
Scotland median annual salary £46,250 £45,000 £40,000
Median salary % change year-on-year +2.78% +12.50% +14.29%
10th Percentile £27,675 £32,425 £31,250
90th Percentile £57,500 £63,250 £55,000
UK median annual salary £55,000 £55,000 £50,000
% change year-on-year - +10.00% +5.26%

PostgreSQL is in the Databases and Business Intelligence 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 database or business intelligence skills.

All Database and Business Intelligence Skills
Scotland
Permanent vacancies with a requirement for database or business intelligence skills 1,812 1,509 1,862
As % of all permanent IT jobs advertised in Scotland 32.95% 32.33% 30.51%
Number of salaries quoted 1,164 954 1,211
Scotland median annual salary £42,500 £43,500 £41,500
Median salary % change year-on-year -2.30% +4.82% +3.75%
10th Percentile £28,000 £28,750 £28,750
90th Percentile £61,250 £62,500 £62,500
UK median annual salary £48,000 £47,500 £45,000
% change year-on-year +1.05% +5.56% +1.12%

PostgreSQL
Job Vacancy Trend in Scotland

Job postings citing PostgreSQL as a percentage of all IT jobs advertised in Scotland.

Job vacancy trend for PostgreSQL in Scotland

PostgreSQL
Salary Trend in Scotland

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

Salary trend for PostgreSQL in Scotland

PostgreSQL
Salary Histogram in Scotland

The salary distribution of IT jobs citing PostgreSQL in Scotland over the 6 months to 16 January 2018.

Salary histogram for PostgreSQL in Scotland

PostgreSQL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PostgreSQL within the Scotland region over the 6 months to 16 January 2018. 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 +16 74 £43,750 -12.50% 13
Glasgow +14 64 £50,000 +25.00% 3
Dundee - 4 £23,500 -
PostgreSQL
UK

For the 6 months to 16 January 2018, IT jobs citing PostgreSQL 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 PostgreSQL.

1 74 (60.16%) Python
2 69 (56.10%) SQL
3 60 (48.78%) Java
4 54 (43.90%) Agile Software Development
5 53 (43.09%) Relational Database
6 49 (39.84%) JavaScript
7 43 (34.96%) HTML
8 38 (30.89%) NoSQL
9 35 (28.46%) AngularJS
9 35 (28.46%) Spring
10 34 (27.64%) Hibernate
10 34 (27.64%) OO
11 33 (26.83%) Machine Learning
12 31 (25.20%) MySQL
13 30 (24.39%) Statistics
14 27 (21.95%) Oracle
14 27 (21.95%) Data Warehouse
14 27 (21.95%) Finance
15 26 (21.14%) Amazon Redshift
16 25 (20.33%) Maven
17 23 (18.70%) Ansible
18 22 (17.89%) Docker
18 22 (17.89%) SDLC
18 22 (17.89%) Collaborative Working
18 22 (17.89%) PHP
18 22 (17.89%) OOP
18 22 (17.89%) Hadoop
18 22 (17.89%) Puppet
19 21 (17.07%) Linux
19 21 (17.07%) CSS

PostgreSQL
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 14 (11.38%) Apache Spark
2 8 (6.50%) MQSeries
3 6 (4.88%) Tomcat
4 5 (4.07%) Apache
5 4 (3.25%) Confluence
6 3 (2.44%) SAS
7 2 (1.63%) Elasticsearch
8 1 (0.81%) JBoss
8 1 (0.81%) Jupyter
8 1 (0.81%) WordPress
Applications
1 2 (1.63%) Microsoft Office
2 1 (0.81%) Microsoft Excel
Business Applications
1 1 (0.81%) FastStats
1 1 (0.81%) Oracle BPM
Cloud Services
1 18 (14.63%) Amazon AWS
2 9 (7.32%) Microsoft Azure
3 7 (5.69%) Amazon EC2
4 6 (4.88%) SaaS
5 5 (4.07%) Cloud Computing
6 4 (3.25%) Amazon S3
6 4 (3.25%) Google Cloud Platform
6 4 (3.25%) Heroku
7 3 (2.44%) Amazon EMR
7 3 (2.44%) Google Analytics
7 3 (2.44%) PaaS
8 2 (1.63%) GitHub
8 2 (1.63%) IaaS
9 1 (0.81%) AWS CloudFormation
9 1 (0.81%) AWS Elastic Beanstalk
9 1 (0.81%) AWS Lambda
9 1 (0.81%) Google App Engine
9 1 (0.81%) Serverless
Communications & Networking
1 5 (4.07%) AMQP
2 3 (2.44%) SNMP
2 3 (2.44%) SSL
3 2 (1.63%) DHCP
3 2 (1.63%) DNS
3 2 (1.63%) SMTP
3 2 (1.63%) TCP/IP
3 2 (1.63%) Wi-Fi
Database & Business Intelligence
1 53 (43.09%) Relational Database
2 38 (30.89%) NoSQL
3 31 (25.20%) MySQL
4 27 (21.95%) Data Warehouse
5 26 (21.14%) Amazon Redshift
6 22 (17.89%) Hadoop
7 18 (14.63%) MongoDB
8 14 (11.38%) Apache Cassandra
9 12 (9.76%) RDBMS
10 8 (6.50%) Big Data
10 8 (6.50%) Bigtable
11 3 (2.44%) Apache Hive
11 3 (2.44%) HBase
11 3 (2.44%) SQL Server
12 2 (1.63%) BusinessObjects
12 2 (1.63%) Couchbase
12 2 (1.63%) DB2
12 2 (1.63%) GIS
12 2 (1.63%) Oracle Database 10g
12 2 (1.63%) Oracle Database 11g
Development Applications
1 25 (20.33%) Maven
2 14 (11.38%) Git (software)
3 8 (6.50%) Jenkins
4 7 (5.69%) Subversion
5 5 (4.07%) JIRA
6 4 (3.25%) DbUnit
6 4 (3.25%) jMock
6 4 (3.25%) JUnit
6 4 (3.25%) Mockito
6 4 (3.25%) SonarQube
6 4 (3.25%) TeamCity
7 3 (2.44%) Mercurial
8 2 (1.63%) Bitbucket
9 1 (0.81%) Ant
9 1 (0.81%) Cucumber
9 1 (0.81%) Jasmine
9 1 (0.81%) Mocha
9 1 (0.81%) Protractor
9 1 (0.81%) RSpec
General
1 27 (21.95%) Finance
2 4 (3.25%) Banking
2 4 (3.25%) Games
3 3 (2.44%) Marketing
4 2 (1.63%) Dutch Language
4 2 (1.63%) French Language
4 2 (1.63%) German Language
4 2 (1.63%) Multimedia
4 2 (1.63%) Retail
4 2 (1.63%) Spanish Language
5 1 (0.81%) Advertising
5 1 (0.81%) Local Government
5 1 (0.81%) Manufacturing
Job Titles
1 58 (47.15%) Developer
2 44 (35.77%) Java Developer
3 29 (23.58%) Data Scientist
4 15 (12.20%) Senior Developer
5 11 (8.94%) Software Engineer
6 10 (8.13%) Senior Java Developer
7 8 (6.50%) Web Developer
8 7 (5.69%) Software Developer
9 6 (4.88%) Java Software Developer
10 5 (4.07%) C++ Software Engineer
10 5 (4.07%) Data Engineer
10 5 (4.07%) GUI Software Engineer
10 5 (4.07%) Linux Engineer
11 4 (3.25%) Junior
11 4 (3.25%) Junior Developer
11 4 (3.25%) Ruby Developer
11 4 (3.25%) Ruby on Rails Developer
11 4 (3.25%) Senior Ruby Developer
11 4 (3.25%) Senior Ruby on Rails Developer
12 3 (2.44%) Senior Software Engineer
Libraries, Frameworks & Software Standards
1 43 (34.96%) HTML
2 35 (28.46%) AngularJS
2 35 (28.46%) Spring
3 34 (27.64%) Hibernate
4 21 (17.07%) CSS
4 21 (17.07%) XML
5 11 (8.94%) REST
5 11 (8.94%) SOAP
6 10 (8.13%) Node.js
6 10 (8.13%) React
7 9 (7.32%) Middleware
7 9 (7.32%) Ruby on Rails
8 8 (6.50%) NumPy
8 8 (6.50%) Web Services
8 8 (6.50%) XML Schema
9 7 (5.69%) CSS3
9 7 (5.69%) HTML5
9 7 (5.69%) J2EE
9 7 (5.69%) RESTful
10 6 (4.88%) Qt
Miscellaneous
1 20 (16.26%) Algorithms
1 20 (16.26%) Enterprise Software
2 11 (8.94%) Computer Science
2 11 (8.94%) Fintech
3 10 (8.13%) Greenfield Project
4 8 (6.50%) Virtual Team
5 3 (2.44%) Analytical Skills
5 3 (2.44%) User Experience
6 2 (1.63%) DataPower
6 2 (1.63%) Mobile App
7 1 (0.81%) Blog
7 1 (0.81%) Management Information System
Operating Systems
1 21 (17.07%) Linux
2 10 (8.13%) Windows
3 6 (4.88%) Unix
4 5 (4.07%) Red Hat Enterprise Linux
5 3 (2.44%) CentOS
6 2 (1.63%) AIX
6 2 (1.63%) Android
6 2 (1.63%) HPUX
6 2 (1.63%) Mac OS X
6 2 (1.63%) Solaris
6 2 (1.63%) Windows 2000
6 2 (1.63%) Windows 7
6 2 (1.63%) Windows Vista
6 2 (1.63%) Windows XP
7 1 (0.81%) Apple iOS
7 1 (0.81%) OpenWrt
7 1 (0.81%) Ubuntu
Processes & Methodologies
1 54 (43.90%) Agile Software Development
2 34 (27.64%) OO
3 33 (26.83%) Machine Learning
4 30 (24.39%) Statistics
5 22 (17.89%) Collaborative Working
5 22 (17.89%) OOP
5 22 (17.89%) SDLC
6 17 (13.82%) Software Engineering
7 16 (13.01%) TDD
8 15 (12.20%) Continuous Integration
8 15 (12.20%) Mathematics
9 13 (10.57%) BDD
10 12 (9.76%) Open Source
10 12 (9.76%) Scrum
10 12 (9.76%) Web Development
11 11 (8.94%) ETL
11 11 (8.94%) Microservices
12 9 (7.32%) Analytics
12 9 (7.32%) Creative Problem-Solving
12 9 (7.32%) Test Automation
Programming Languages
1 74 (60.16%) Python
2 69 (56.10%) SQL
3 60 (48.78%) Java
4 49 (39.84%) JavaScript
5 22 (17.89%) PHP
6 10 (8.13%) C++
7 9 (7.32%) R
7 9 (7.32%) Ruby
8 8 (6.50%) XPath
9 7 (5.69%) C#
10 4 (3.25%) TypeScript
11 3 (2.44%) C
11 3 (2.44%) Scala
12 2 (1.63%) Jython
12 2 (1.63%) Perl
12 2 (1.63%) Shell Script
13 1 (0.81%) Bash Shell
13 1 (0.81%) PL/SQL
Qualifications
1 19 (15.45%) Degree
2 10 (8.13%) Computer Science Degree
3 4 (3.25%) Security Cleared
4 1 (0.81%) PhD
4 1 (0.81%) Postgraduate
Quality Assurance & Compliance
1 7 (5.69%) QA
2 1 (0.81%) BS7666
2 1 (0.81%) Data Quality
2 1 (0.81%) Disclosure Scotland
System Software
1 22 (17.89%) Docker
2 3 (2.44%) VMware Infrastructure
2 3 (2.44%) vSphere
3 2 (1.63%) NFS
4 1 (0.81%) Firmware
Systems Management
1 23 (18.70%) Ansible
2 22 (17.89%) Puppet
3 2 (1.63%) Tivoli
3 2 (1.63%) Tivoli Monitoring
4 1 (0.81%) Hadoop YARN
4 1 (0.81%) Kibana
4 1 (0.81%) logstash
4 1 (0.81%) Opscode Chef
Vendors
1 27 (21.95%) Oracle
2 6 (4.88%) Google
3 4 (3.25%) Microsoft
3 4 (3.25%) Red Hat
4 3 (2.44%) VMware
5 2 (1.63%) Hitachi
5 2 (1.63%) Hortonworks
5 2 (1.63%) IBM
5 2 (1.63%) Salesforce.com
5 2 (1.63%) Vertica
6 1 (0.81%) Cognos
6 1 (0.81%) HP
6 1 (0.81%) Sybase
6 1 (0.81%) Talend