6 of 6 OLTP Jobs in England

days/week) Required Skillset: Pro*C, PL/SQL and shell scripting. Experience in developing and supporting batch processes and high-volume OLTP systems in either Oracle custom or Oracle Apps EBS. Strong analytical skills required - including analysis of legacy codeset, working within a multi-disciplinary teams to impact ...

Experience designing event driven Experience developing software with cloud technologies (preferably AWS). Experience with a range of database technologies and practices including OLAP, OLTP, ETL and Data Warehousing. Experience with AI architecture. Interested in learning more? Apply now or contact us for a confidential discussion about the role ...

Server fundamentals including, indexes, statistics, query plans, tempdb, installation, configuration, DMVs and, troubleshooting. A good understanding relational table design including normalisation, constraints, OLAP vs OLTP, traditional data warehousing. Experienced in critical thinking and troubleshooting. Experience with Azure SQL Database and Azure SQL Managed instance would be beneficial. Experience with Power ...

stacks) Experience within mature B2B SaaS environments Deep knowledge of cloud architecture (ideally AWS) Experience with microservices, event-driven systems Strong understanding of OLAP, OLTP, ETL & data warehousing DevOps-first mindset Excellent stakeholder engagement skills Interested? If you're an Architect who wants real influence in a scaling SaaS environment ...

Build Kafka-based integration pipelines and event-driven architectures Deliver dual-run migrations, cutover planning, rollback and reconciliation Perform logical and physical data modelling (OLTP and analytics trade-offs) Ensure strong data quality, validation and governance controls Essential Skills Proven experience as a Data Architect or Data Migration Architect Strong ...

replay, backfill. Db2 & z/OS knowledge: Db2 catalog, z/OS fundamentals, batch windows, performance considerations. Relational modelling: Data modelling; normalization, indexing, partitioning; OLTP vs. analytics trade-offs. Integration patterns: Kafka (hands-on), CDC-to-target pipelines, UPSERT/MERGE logic; Python/SQL; strong troubleshooting. Data quality mindset … trade-offs; identify functional dependencies and anomalies. Physical data modelling: Table design, partitioning strategies, indexes; SCD types; dimensional vs. transactional schemas; storage patterns for OLTP vs. analytics. Normalization & design: Normalize to 3NF/BCNF for transactional systems; understand when to denormalize for queries; trade-offs between 3NF, Data Vault ...