The table below looks at the statistics for OLTP skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited OLTP over the 3 months to 19 September 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
19 Sep 2014
Same period 2013 Same period 2012
Online Transaction Processing (OLTP)
Rank 637 671 622
Rank change year-on-year
+34 -49
Permanent jobs citing OLTP 271 208 289
As % of all permanent IT jobs located in the UK 0.24% 0.19% 0.25%
As % of the Database & Business Intelligence category 0.78% 0.62% 0.80%
Number of salaries quoted 192 160 244
Average salary £50,000 £55,000 £44,000
Average salary % change year-on-year
-9.09% +25.00%
90% offered a salary of more than £37,500 £40,000 £32,500
10% offered a salary of more than £70,000 £75,000 £62,500
UK excluding London average salary £45,000 £50,000 £37,500
% change year-on-year
-10.00% +33.33%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
34891 33759 35987
As % of all permanent IT jobs located in the UK 30.48% 31.64% 31.06%
Number of salaries quoted 29329 29231 31666
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £67,500 £65,000 £65,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

OLTP
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing OLTP within the UK as a proportion of the total demand within the Database & Business Intelligence category.

OLTP Jobs Demand Trend in the UK

OLTP
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP within the UK.

OLTP Salary Trend in the UK

OLTP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLTP over the 3 months to 19 September 2014 within the UK.

OLTP Salary Histogram in the UK

OLTP
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLTP within the UK over the 3 months to 19 September 2014. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +39 265 £50,000 -9.09% 27
London +23 165 £52,500 -8.69% 9
City of London +26 32 £54,500 -9.16% 1
Yorkshire -7 27 £37,100 - 3
West Yorkshire -7 27 £37,100 - 3
South East -9 27 £52,500 -2.77% 4
Leeds - 22 £52,500 - 2
North West -24 19 £48,000 +92.00% 4
Manchester - 15 £48,000 - 4
East of England -33 12 £42,500 -15.00% 4
West Midlands -34 12 £45,000 -
Hounslow - 12 £45,000 -
Berkshire -3 9 £42,500 -39.28% 1
Rochdale - 9 £48,000 -
Staffordshire -34 8 £32,500 -31.57%
Essex - 8 £40,000 - 3
Surrey +2 7 £60,000 +11.11% 3
Southend-on-Sea - 6 £41,250 - 2
Stoke-on-Trent -15 5 - -
Kent - 5 £51,250 -
Reading -3 4 £62,500 +19.04% 1
Bradford - 4 £37,100 -
Worcestershire - 4 £45,000 -
Stafford -5 3 £32,500 -
Hertfordshire - 3 £47,750 -
Croydon - 3 £55,000 - 1
Slough +7 2 £41,250 -17.50%
Middlesex -1 2 £58,750 +38.23%
Redhill -12 2 £50,000 - 2
Cheshire -31 2 £42,500 +70.00%

OLTP
Top 30 Related IT Skills

For the 6 months to 19 September 2014, IT jobs within the UK citing OLTP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP.

1 464 (77.20%) SQL
2 356 (59.23%) SQL Server
3 259 (43.09%) Data Warehouse
4 258 (42.93%) Oracle
5 217 (36.11%) OLAP
6 203 (33.78%) ETL
7 197 (32.78%) SQL Server Integration Services
8 196 (32.61%) Performance Tuning
9 194 (32.28%) Business Intelligence
10 185 (30.78%) T-SQL
11 184 (30.62%) SQL Server Reporting Services
12 152 (25.29%) Relational Database
13 150 (24.96%) UNIX
14 142 (23.63%) Microsoft
15 141 (23.46%) Agile Software Development
16 133 (22.13%) Linux
17 132 (21.96%) Degree
18 131 (21.80%) SQL Server 2008
19 128 (21.30%) RDBMS
20 127 (21.13%) Data Modelling
21 120 (19.97%) SQL Server Analysis Services
22 118 (19.63%) E-Commerce
23 112 (18.64%) Analytical Skills
24 109 (18.14%) Oracle OLAP
25 107 (17.80%) Replication
26 98 (16.31%) Oracle Database
27 97 (16.14%) PL/SQL
28 93 (15.47%) Finance
29 87 (14.48%) Java
29 87 (14.48%) MySQL

OLTP
Top Related IT Skills by Category

For the 6 months to 19 September 2014, IT jobs within the UK citing OLTP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP. Up to 20 skills are shown per category.

Application Platforms
1 20 (3.33%) Apache
2 12 (2.00%) Tomcat
3 10 (1.66%) SharePoint
4 9 (1.50%) IIS
4 9 (1.50%) NetWeaver
5 6 (1.00%) WebSphere
5 6 (1.00%) SAS
6 3 (0.50%) WebLogic
7 2 (0.33%) WebSphere Application Server
7 2 (0.33%) WorkSite
8 1 (0.17%) MQSeries
8 1 (0.17%) MS Exchange
Applications
1 79 (13.14%) MS Excel
2 5 (0.83%) MS Visio
2 5 (0.83%) MS Office
3 3 (0.50%) PowerPivot
4 2 (0.33%) MS Project
5 1 (0.17%) MS PowerPoint
Business Applications
1 5 (0.83%) Oracle EBS
1 5 (0.83%) Oracle Applications
2 4 (0.67%) Dynamics CRM
3 2 (0.33%) HFM
3 2 (0.33%) Oracle ERP
3 2 (0.33%) Oracle Financials
3 2 (0.33%) Remedy ITSM
3 2 (0.33%) Oracle Procure-to-Pay
3 2 (0.33%) SAP Oil and Gas
4 1 (0.17%) SAP APO
4 1 (0.17%) Cognos TM1
4 1 (0.17%) SAP SCM
Cloud Services
1 14 (2.33%) Amazon EC2
2 10 (1.66%) Microsoft Azure
2 10 (1.66%) Amazon AWS
3 6 (1.00%) SaaS
4 3 (0.50%) PaaS
4 3 (0.50%) IaaS
5 1 (0.17%) Cloud Computing
Communications & Networking
1 18 (3.00%) Internet
2 15 (2.50%) SAN
3 9 (1.50%) HTTP
4 6 (1.00%) TCP/IP
4 6 (1.00%) SSH
4 6 (1.00%) SSL
5 4 (0.67%) iSCSI
5 4 (0.67%) LAN
5 4 (0.67%) WAN
5 4 (0.67%) Fibre Channel
6 3 (0.50%) InfiniBand
6 3 (0.50%) FCoE
6 3 (0.50%) Ethernet
6 3 (0.50%) ATM
6 3 (0.50%) DNS
7 2 (0.33%) LDAP
7 2 (0.33%) NAS
7 2 (0.33%) Firewall
8 1 (0.17%) Cisco PIX
8 1 (0.17%) Cisco ASA
Database & Business Intelligence
1 356 (59.23%) SQL Server
2 259 (43.09%) Data Warehouse
3 217 (36.11%) OLAP
4 197 (32.78%) SQL Server Integration Services
5 184 (30.62%) SQL Server Reporting Services
6 152 (25.29%) Relational Database
7 131 (21.80%) SQL Server 2008
8 128 (21.30%) RDBMS
9 120 (19.97%) SQL Server Analysis Services
10 109 (18.14%) Oracle OLAP
11 98 (16.31%) Oracle Database
12 87 (14.48%) MySQL
13 73 (12.15%) SQL Server 2012
14 67 (11.15%) Oracle Database 11g
15 65 (10.82%) SQL Server 2005
16 60 (9.98%) Oracle ODI
17 53 (8.82%) Big Data
18 52 (8.65%) DB2
19 41 (6.82%) Oracle Database 10g
20 32 (5.32%) Microsoft Analysis Services
Development Applications
1 31 (5.16%) Talend Open Studio
2 15 (2.50%) Subversion
3 14 (2.33%) Team Foundation Server
4 13 (2.16%) Toad
5 10 (1.66%) Visual Studio
5 10 (1.66%) Mercurial
6 9 (1.50%) Eclipse
7 8 (1.33%) ClearCase
8 7 (1.16%) ERwin
9 6 (1.00%) CruiseControl
9 6 (1.00%) Maven
9 6 (1.00%) Ant
9 6 (1.00%) Jenkins
10 5 (0.83%) VSS/SourceSafe
11 3 (0.50%) SQL Server Management Studio (SSMS)
12 2 (0.33%) MSBuild
12 2 (0.33%) Selenium
13 1 (0.17%) Git (software)
13 1 (0.17%) Oracle Forms
13 1 (0.17%) JIRA
General
1 93 (15.47%) Finance
2 59 (9.82%) Games
3 29 (4.83%) Retail
4 26 (4.33%) Marketing
5 17 (2.83%) Legal
6 14 (2.33%) Advertising
7 12 (2.00%) Pharmaceutical
7 12 (2.00%) Banking
8 9 (1.50%) Law
9 8 (1.33%) Telecoms
10 5 (0.83%) Music Industry
11 4 (0.67%) Online Betting
12 3 (0.50%) Investment Banking
12 3 (0.50%) Back Office
13 2 (0.33%) Billing
14 1 (0.17%) German Language
14 1 (0.17%) Aerospace
14 1 (0.17%) Publishing
Job Titles
1 205 (34.11%) Developer
2 178 (29.62%) DBA
3 69 (11.48%) Software Engineer
4 68 (11.31%) Administrator
4 68 (11.31%) SQL DBA
5 63 (10.48%) SQL Developer
6 58 (9.65%) Architect
7 47 (7.82%) Business Intelligence Developer
8 42 (6.99%) Database Developer
8 42 (6.99%) Oracle DBA
9 40 (6.66%) SQL Server DBA
9 40 (6.66%) Data Warehouse Developer
10 37 (6.16%) Senior Developer
11 32 (5.32%) Data Architect
12 27 (4.49%) Senior DBA
13 26 (4.33%) Oracle Data Warehouse Developer
14 25 (4.16%) Analyst
15 23 (3.83%) Data Manager
16 21 (3.49%) Software Development Engineer
16 21 (3.49%) Database Engineer
Libraries, Frameworks & Software Standards
1 77 (12.81%) .NET
2 48 (7.99%) XML
3 39 (6.49%) STL
4 36 (5.99%) Swing
4 36 (5.99%) ASP.NET
5 28 (4.66%) MDX
6 20 (3.33%) Django
7 18 (3.00%) COM
7 18 (3.00%) CSS
8 17 (2.83%) Servlets
8 17 (2.83%) HTML
9 11 (1.83%) SOAP
10 9 (1.50%) JDBC
10 9 (1.50%) Java EE
10 9 (1.50%) JSON
10 9 (1.50%) Apache Flex
10 9 (1.50%) WSDL
11 8 (1.33%) WinForms
11 8 (1.33%) J2EE
11 8 (1.33%) Web Services
Miscellaneous
1 112 (18.64%) Analytical Skills
2 107 (17.80%) Replication
3 86 (14.31%) Computer Science
4 55 (9.15%) iPad
5 51 (8.49%) Clustering
6 36 (5.99%) Online Games
7 26 (4.33%) Mathematics
8 25 (4.16%) N-Tier
9 15 (2.50%) Data Integration
10 14 (2.33%) Management Information System
11 12 (2.00%) Visualisation
11 12 (2.00%) Mobile App
12 10 (1.66%) Enterprise Software
13 9 (1.50%) Life Science
13 9 (1.50%) Physics
14 8 (1.33%) Client/Server
15 5 (0.83%) Social Network
15 5 (0.83%) Digital Media
15 5 (0.83%) Statistics
15 5 (0.83%) Reference Data
Operating Systems
1 150 (24.96%) UNIX
2 133 (22.13%) Linux
3 70 (11.65%) Windows
4 19 (3.16%) Android
5 16 (2.66%) Windows Server 2008
6 14 (2.33%) Solaris
7 11 (1.83%) AIX
8 9 (1.50%) Windows Server 2012
9 8 (1.33%) Red Hat Enterprise Linux
10 7 (1.16%) Oracle Linux
11 4 (0.67%) Ubuntu
12 2 (0.33%) SUSE
13 1 (0.17%) Debian
13 1 (0.17%) CentOS
Processes & Methodologies
1 203 (33.78%) ETL
2 196 (32.61%) Performance Tuning
3 194 (32.28%) Business Intelligence
4 141 (23.46%) Agile Software Development
5 127 (21.13%) Data Modelling
6 118 (19.63%) E-Commerce
7 71 (11.81%) Software Engineering
8 67 (11.15%) Unit Testing
9 64 (10.65%) Dimensional Modelling
10 60 (9.98%) Disaster Recovery
11 58 (9.65%) Scrum
12 47 (7.82%) OO
13 45 (7.49%) Analytics
14 38 (6.32%) Project Management
14 38 (6.32%) TDD
15 37 (6.16%) Validation
16 30 (4.99%) ITIL
17 29 (4.83%) Migration
17 29 (4.83%) High Availability
18 27 (4.49%) Data Analysis
Programming Languages
1 464 (77.20%) SQL
2 185 (30.78%) T-SQL
3 97 (16.14%) PL/SQL
4 87 (14.48%) Java
5 76 (12.65%) C#
6 59 (9.82%) C++
7 52 (8.65%) Shell Script
8 46 (7.65%) JavaScript
9 38 (6.32%) C
10 27 (4.49%) Python
11 23 (3.83%) Perl
12 15 (2.50%) VB
13 14 (2.33%) PHP
14 13 (2.16%) VB6
15 10 (1.66%) Clojure
16 9 (1.50%) PowerShell
17 6 (1.00%) Tcl
17 6 (1.00%) Korn
17 6 (1.00%) ActionScript
18 5 (0.83%) PowerHouse
Qualifications
1 132 (21.96%) Degree
2 40 (6.66%) Microsoft Certification
3 35 (5.82%) MCITP
4 16 (2.66%) MCTS
5 8 (1.33%) PhD
6 7 (1.16%) MCSE
7 6 (1.00%) MCDBA
7 6 (1.00%) OCP
7 6 (1.00%) Oracle Certification
8 5 (0.83%) Security Cleared
9 3 (0.50%) ITIL Foundation Certificate
10 2 (0.33%) DV Cleared
11 1 (0.17%) OCA
Quality Assurance & Compliance
1 72 (11.98%) QA
2 38 (6.32%) ISO 9001
3 5 (0.83%) Sarbanes-Oxley
4 3 (0.50%) PCI DSS
4 3 (0.50%) Data Quality
4 3 (0.50%) ISO/IEC 27001
5 2 (0.33%) TickIT
6 1 (0.17%) SLA
System Software
1 41 (6.82%) Oracle RAC
2 25 (4.16%) Oracle RMAN
3 8 (1.33%) Hyper-V
4 6 (1.00%) VMware Infrastructure
5 5 (0.83%) Active Directory
6 3 (0.50%) Veritas Volume Manager
6 3 (0.50%) Veritas File System
6 3 (0.50%) EMC RecoverPoint
6 3 (0.50%) HDFS
7 2 (0.33%) VMware ESX
8 1 (0.17%) RHEV
Systems Management
1 41 (6.82%) Data Guard
2 14 (2.33%) Oracle Enterprise Manager
3 10 (1.66%) Opscode Chef
4 5 (0.83%) Foglight
5 3 (0.50%) EMC Navisphere
5 3 (0.50%) NetBackup
5 3 (0.50%) SCOM
6 1 (0.17%) Oracle Statspack
Vendors
1 258 (42.93%) Oracle
2 142 (23.63%) Microsoft
3 63 (10.48%) IBM
4 49 (8.15%) Informatica
5 31 (5.16%) Talend
6 30 (4.99%) Sybase
7 23 (3.83%) Tableau
8 21 (3.49%) Business Objects
9 19 (3.16%) VMware
10 18 (3.00%) SAP
11 14 (2.33%) Red Hat
12 13 (2.16%) Red Gate
12 13 (2.16%) Sun
13 10 (1.66%) Netezza
13 10 (1.66%) Vertica
14 9 (1.50%) Teradata
15 8 (1.33%) MicroStrategy
15 8 (1.33%) Cognos
15 8 (1.33%) Facebook
16 7 (1.16%) HP
Croydon, Surrey
Lawrence Harvey Enterprise
Salary: £55000 - £70000 per annum + Benefits
Posted: Yesterday
City of London
Real Staffing
Salary: £55000 - £68000 per annum + competitive
Posted: Yesterday
Redhill, Surrey
The Bridge Ltd
Salary: From £35,000 to £65,000 per annum plus benefits
Posted: 2 days ago
West London
Harris Global
Posted: 2 days ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: COMPETITIVE
Posted: 2 days ago
Nottingham
Computer Futures
Salary: £45000 - £50000 per annum + great benefits
Posted: 3 days ago
Southend-On-Sea, Essex
Oscar Associates (UK) Ltd
Salary: £35000 - £45000 per annum
Posted: 4 days ago
Essex
Oscar Associates (UK) Ltd
Salary: £45000 - £55000 per annum
Posted: 4 days ago
Manchester, Lancashire
Lorien Resourcing
Posted: 4 days ago
Cambridge, Cambridgeshire
Salt
Salary: £40000 - £60000 per annum + Bonus + Excellent Benefits
Posted: 4 days ago
Southend-On-Sea, Essex
Capita Resourcing - IT Resourcing
Salary: £35000 - £45000 per annum + Bonus + Benefits
Posted: 4 days ago
Manchester, Lancashire
Applause IT Innovation
Salary: £37000 - £45000 per annum + Depending on exp +Benefits
Posted: 5 days ago
London
Engage PSG
Salary: £45000 - £55000 per annum + flex bens, bonus
Posted: 5 days ago
Leeds, West Yorkshire
4it Recruitment Ltd
Salary: £Excellent Salary + Benefits
Posted: 5 days ago
South East London
Client Server
Salary: £40k to £55k + benefits
Posted: 6 days ago
Reading, Berkshire
Streamline Connections
Salary: £60000 - £65000 per annum + Excellent Benefits
Posted: 6 days ago
Harrow, Middlesex
Salt
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 6 days ago
Brighouse
Computer Futures
Salary: £28000 - £38000 per annum + competitive
Posted: 6 days ago
London
NFP Group Ltd
Salary: £65000 - £85000 per annum + Excellent Benefits
Posted: 15 days ago
Manchester
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 17 days ago