Online Transaction Processing (OLTP)
UK

The table below provides summary statistics for permanent job vacancies requiring OLTP skills. It includes a benchmarking guide to the annual salaries offered in vacancies that cited OLTP over the 6 months leading up to 1 May 2025, comparing them to the same period in the previous two years.

6 months to
1 May 2025
Same period 2024 Same period 2023
Rank 659 855 881
Rank change year-on-year +196 +26 +94
Permanent jobs citing OLTP 33 41 108
As % of all permanent jobs advertised in the UK 0.063% 0.042% 0.10%
As % of the Database & Business Intelligence category 0.44% 0.23% 0.48%
Number of salaries quoted 32 31 74
10th Percentile £45,625 £41,250 £45,000
25th Percentile £62,500 £43,625 £48,750
Median annual salary (50th Percentile) £67,500 £67,500 £65,000
Median % change year-on-year - +3.85% +4.84%
75th Percentile £73,125 £71,250 £83,750
90th Percentile £79,875 - £100,000
UK excluding London median annual salary £67,500 £67,500 £65,000
% change year-on-year - +3.85% +18.18%

All Database and Business Intelligence Skills
UK

OLTP falls under the Databases and Business Intelligence category. For comparison with the information above, the following table provides summary statistics for all permanent job vacancies requiring database or business intelligence skills.

Permanent vacancies with a requirement for database or business intelligence skills 7,431 18,186 22,342
As % of all permanent jobs advertised in the UK 14.28% 18.47% 21.50%
Number of salaries quoted 5,213 12,623 13,902
10th Percentile £37,500 £35,000 £37,500
25th Percentile £47,500 £42,725 £47,500
Median annual salary (50th Percentile) £62,500 £57,500 £65,000
Median % change year-on-year +8.70% -11.54% +8.33%
75th Percentile £83,750 £76,250 £83,750
90th Percentile £115,000 £95,000 £103,750
UK excluding London median annual salary £55,000 £52,500 £55,000
% change year-on-year +4.76% -4.55% +4.76%

OLTP
Job Vacancy Trend

Job postings citing OLTP as a proportion of all IT jobs advertised.

Job vacancy trend for OLTP in the UK

OLTP
Salary Trend

3-month moving average salary quoted in jobs citing OLTP.

Salary trend for OLTP in the UK

OLTP
Salary Histogram

Salary distribution for jobs citing OLTP over the 6 months to 1 May 2025.

Salary histogram for OLTP in the UK

OLTP
Top 6 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK over the 6 months to 1 May 2025. 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
Jobs
England +166 33 £67,500 - 9
UK excluding London +202 27 £67,500 - 3
South East +117 23 £67,500 - 3
Work from Home +191 19 £67,500 - 5
London +111 6 £52,500 +40.00% 8
East of England +59 4 £77,500 +10.71%

OLTP
Co-occurring Skills and Capabilities by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 4 (12.12%) Apache Airflow
2 2 (6.06%) Apache
2 2 (6.06%) Apache Spark
Business Applications
1 2 (6.06%) Payment Gateway
Cloud Services
1 6 (18.18%) Azure
2 4 (12.12%) AWS
2 4 (12.12%) Power Platform
3 2 (6.06%) Amazon ECS
3 2 (6.06%) Amazon EMR
3 2 (6.06%) Amazon MSK
3 2 (6.06%) Amazon SQS
3 2 (6.06%) AWS Lambda
3 2 (6.06%) Azure Data Factory
3 2 (6.06%) Azure DevOps
3 2 (6.06%) Azure Synapse Analytics
3 2 (6.06%) dbt
3 2 (6.06%) Serverless
3 2 (6.06%) Virtual Private Cloud
Database & Business Intelligence
1 6 (18.18%) Data Warehouse
1 6 (18.18%) SQL Server
2 4 (12.12%) OLAP
2 4 (12.12%) Power BI
2 4 (12.12%) Relational Database
2 4 (12.12%) SQL Server Integration Services
3 2 (6.06%) Amazon Aurora
3 2 (6.06%) Apache Hive
3 2 (6.06%) Azure SQL Database
3 2 (6.06%) Big Data
3 2 (6.06%) Data Lake
3 2 (6.06%) DynamoDB
3 2 (6.06%) MySQL
3 2 (6.06%) RDBMS
General
1 8 (24.24%) Analytical Skills
2 6 (18.18%) Social Skills
3 2 (6.06%) Banking
3 2 (6.06%) Finance
3 2 (6.06%) Games
3 2 (6.06%) Marketing
3 2 (6.06%) Retail
Job Titles
1 25 (75.76%) Developer
2 23 (69.70%) Oracle Developer
2 23 (69.70%) Senior
2 23 (69.70%) Senior Developer
2 23 (69.70%) Senior Oracle Developer
3 13 (39.39%) PL/SQL Developer
3 13 (39.39%) Senior PL/SQL Developer
3 13 (39.39%) Senior SQL Developer
3 13 (39.39%) SQL Developer
4 2 (6.06%) Analyst
4 2 (6.06%) Architect
4 2 (6.06%) Data Analyst
4 2 (6.06%) Data Architect
4 2 (6.06%) Data Integration Analyst
4 2 (6.06%) Data Warehouse Architect
4 2 (6.06%) Integration Analyst
4 2 (6.06%) PHP Developer
4 2 (6.06%) QA Engineer
4 2 (6.06%) Report Analyst
4 2 (6.06%) Technical Architect
Libraries, Frameworks & Software Standards
1 22 (66.67%) HTML
2 16 (48.48%) SOAP
2 16 (48.48%) XML
3 6 (18.18%) JSON
4 4 (12.12%) Kafka
4 4 (12.12%) Node.js
5 2 (6.06%) Laravel
5 2 (6.06%) NestJS
5 2 (6.06%) React
5 2 (6.06%) Spring
5 2 (6.06%) Symfony
Miscellaneous
1 6 (18.18%) Self-Motivation
2 2 (6.06%) Cloud Native
2 2 (6.06%) Online Games
Operating Systems
1 2 (6.06%) Unix
Processes & Methodologies
1 16 (48.48%) Problem-Solving
1 16 (48.48%) Software Testing
2 6 (18.18%) Agile
2 6 (18.18%) Clean Code
2 6 (18.18%) Configuration Management
2 6 (18.18%) DevOps
2 6 (18.18%) Issue Tracking
3 4 (12.12%) Analytics
3 4 (12.12%) Business Intelligence
3 4 (12.12%) CQRS
3 4 (12.12%) Data Modelling
3 4 (12.12%) High Availability
3 4 (12.12%) Test Automation
4 2 (6.06%) CI/CD
4 2 (6.06%) Data Pipeline
4 2 (6.06%) Design Patterns
4 2 (6.06%) Infrastructure as Code
4 2 (6.06%) Product Requirements
4 2 (6.06%) Sprint Planning
4 2 (6.06%) Technical Leadership
Programming Languages
1 29 (87.88%) SQL
2 23 (69.70%) PL/SQL
3 8 (24.24%) Java
3 8 (24.24%) JavaScript
4 4 (12.12%) TypeScript
5 2 (6.06%) PHP
5 2 (6.06%) Shell Script
Qualifications
1 12 (36.36%) Degree
2 2 (6.06%) Computer Science Degree
Quality Assurance & Compliance
1 4 (12.12%) Data Quality
1 4 (12.12%) GDPR
1 4 (12.12%) QA
2 2 (6.06%) PCI DSS
2 2 (6.06%) SLA
Vendors
1 23 (69.70%) Oracle
2 2 (6.06%) Databricks
2 2 (6.06%) Google