1 to 25 of 33 OLTP Jobs in the UK

standards, design patterns, and development best practices. Database & Data Engineering Strong experience with SQL Server, PostgreSQL, and enterprise database platforms. Expertise in: Data modelling (OLTP, OLAP, dimensional models) Query optimization and performance tuning Database scalability and resilience Data governance and quality management Experience delivering large-scale ETL/ELT solutions ...

scalable and reliable applications that support forecasting, analytics, and decision-making processes across the businessDevelop distributed processing pipelines and asynchronous workloadsDesign and optimize relational OLTP databases, data models, and query performanceBuild and maintain data processing, analytical, and forecasting workflowsDesign, develop, and maintain internal web applications when requiredBuild intuitive interfaces ...

tools such as ERwin, Power Designer, or MagicDraw. Knowledge of data architecture options including ODS, Data Lake, Data Catalog (DCAT), Data Warehousing, OLTP, and OLAP, and the treatment of data as a technology asset. Knowledge of core Solution Architecture capabilities: Master and Reference Data Management, Data Quality, Metadata Management, Data ...

such as CI/CD and TDDExperience with big data frameworks such as Apache Spark or similar technologiesSolid understanding of data modelling, data warehousing, OLTP and data lake architecturesExperience working with cloud ecosystems such as AWS, Azure or GCPFamiliarity with tools such as Kafka, Airflow, Hive, Delta, or similar technologiesStrong ...

tools such as ERwin, Power Designer, or MagicDraw.Knowledge of data architecture options including ODS, Data Lake, Data Catalog (DCAT), Data Warehousing, OLTP, and OLAP, and the treatment of data as a technology asset.Knowledge of core Solution Architecture capabilities: Master and Reference Data Management, Data Quality, Metadata Management, Data Taxonomy, Data ...

analytical query execution using DuckDB or Apache Spark.• Production-grade relational database expertise, particularly PostgreSQL (query tuning, indexing, partitioning, replication, and schema design across OLTP and analytics).• Strong KDB experience, covering key concepts such as tp/ctp/rdb/hdb and differences between real-time vs historical ...

alongside proven years of dedicated professional experience in enterprise data engineering and architecture.Data Warehousing & Data Lake Mastery: Expert-level mastery of SQL (OLAP/OLTP) and enterprise cloud data platforms (specifically Snowflake), combined with practical experience architecting open data lake structures using Apache Iceberg.Software Engineering & Streaming: Demonstrated expertise building production ...

Strong proficiency in T-SQL and experience developing complex queries and procedures. Expertise in Spark and PySpark for scalable data processing. Solid understanding of OLTP and OLAP architectures and data modelling principles. Experience with Microsoft Azure, including Fabric, Azure Data Factory, Data Lake, Data Warehouse, and Blob Storage. Sound knowledge ...

with cloud data platforms (Azure Synapse, Snowflake, GCP BigQuery) and modern data storage solutions.Strong SQL skills and good knowledge of data warehousing, lakehouses, and OLTP/OLAP systems.Demonstratable interest and awareness in emerging technologiesWhat we look forWe are looking for highly motivated individuals who are passionate about Data and Analytics ...

cloud data platforms (Azure Synapse, Snowflake, GCP BigQuery) and modern data storage solutions. Strong SQL skills and good knowledge of data warehousing, lakehouses, and OLTP/OLAP systems. Demonstratable interest and awareness in emerging technologies What we look for We are looking for highly motivated individuals who are passionate about ...

time histories, and derived analytics—every record must be correct, durable, globally available, and served with low latency. Our team builds Bloomberg’s distributed OLTP storage platform. We operate petabytes of critical financial data across more than 10,000 MySQL shards, using InnoDB and MyRocks as storage engines and Vitess ...

Design (DB2/400, MS SQL Server). Document, Imaging, and Web Content Management (FileNet). Business Intelligence, Data Warehouse, and ETL. Transaction Design (OLTP, Batch). Component Based Design. Application Integration. Performance Engineering. Demonstrates analytical and diagnostic skills dealing with issues that are often novel and not readily defined ...

data across asset classes , including vendor integration and financial identifier mapping (ISIN, CUSIP, etc.) Strong understanding of data pipelines, data quality/reconciliation, and OLTP vs OLAP paradigms Technical background, with hands-on programming experience (Python, Java or similar) and prior experience in engineering or development roles Proven track record ...

country where this role is located Preferred Qualifications Previous experience with CPM, EPM, BI, DWH solutions Deep understanding of Relational (RDBMS/OLTP) and Multi-Dimensional Databases (OLAP) Practical experience with SQL, MDX, and Extract-Transform-Load (ETL) processes Broad understanding of Enterprise and Software-as-a-Service (SaaS) architectures ...

Datapower).Relational Database Design (DB2/400, MS SQL Server).Document, Imaging, and Web Content Management (FileNet).Business Intelligence, Data Warehouse, and ETL.Transaction Design (OLTP, Batch).Component Based Design.Application Integration.Performance Engineering.Demonstrates analytical and diagnostic skills dealing with issues that are often novel and not readily defined, lack known precedent ...

on. You know your tools Deep, hands-on SQL Server experience — T-SQL, SSMS, execution plans, and diagnosing performance orintegrity issues in large OLTP schemas. Comfortable with AWS RDS for SQL Server, including monitoring, performance insights, and operationalmanagement. Solid scripting ability (Python and/or PowerShell) for building the discovery ...

on. You know your tools Deep, hands‐on SQL Server experience — T‐SQL, SSMS, execution plans, and diagnosing performance or integrity issues in large OLTP schemas. Comfortable with AWS RDS for SQL Server, including monitoring, performance insights, and operational management. Solid scripting ability (Python and/or PowerShell) for building ...

This position plays a crucial role in leveraging data as a competitive advantage by defining architecture that spans transactional and analytical systems, ensuring scalable OLTP foundations. The ideal candidate will champion an AI-first approach in product development, collaborating closely with various teams to drive strategic business objectives while mentoring ...

industry hardware such as ATM’s, HSM’s HP Nonstop and related standards and security requirements including PCI and OWASP.• Excellent understanding of online transaction processing, including knowledge of ATM transaction processing.• Experience of TCP/IP and communication protocols.• Strong knowledge of TAL, COBOL, SCOBOL and TACL• Understanding ...

degree or higher in Computer Science or a related discipline. 3 years commercial experience min. Working knowledge of scripting and querying in RDBMS OLTP or OLAP data stores such as SQL Server. Basic Windows Server administration and troubleshooting Crystal reports or other reporting solutions One or more programming languages preferred ...

tooling. Support distributed Db2 connections and operate confidently in a data shared environment. Monitor, tune and protect performance for a high-volume OLTP (CICS)/Db2 workload. Improve reliability and recoverability by designing and implementing automation and engineering solutions. Lead capacity planning and ensure storage and archiving procedures are robust ...

PySpark, selecting fit-for-purpose approaches based on scale, performance and operational needs. Write advanced SQL for data transformation, reconciliation, profiling and analysis across OLTP and analytical data platforms. Design data models for operational and analytical use cases, including dimensional modelling, slowly changing dimensions, lakehouse and data-lake patterns. Work … Hands‐on proficiency in Python, including Pandas, Polars and PySpark, with experience writing testable and maintainable code. Strong SQL proficiency and practical understanding of OLTP databases, relational design and query performance. Strong understanding of data modelling, data warehousing, dimensional modelling and slowly changing dimensions. Experience designing and implementing ETL/ ...

PySpark, selecting fit-for-purpose approaches based on scale, performance and operational needs. Write advanced SQL for data transformation, reconciliation, profiling and analysis across OLTP and analytical data platforms. Design data models for operational and analytical use cases, including dimensional modelling, slowly changing dimensions, lakehouse and data-lake patterns. Work … Hands‐on proficiency in Python, including Pandas, Polars and PySpark, with experience writing testable and maintainable code. Strong SQL proficiency and practical understanding of OLTP databases, relational design and query performance. Strong understanding of data modelling, data warehousing, dimensional modelling and slowly changing dimensions. Experience designing and implementing ETL/ ...

improvement, and establish database engineering best practices across our products.A primary responsibility of this role is to optimize and maintain our high-volume OLTP databases, with a strong emphasis on PostgreSQL. You will assess existing environments, identify performance and scalability bottlenecks, and drive improvements across schema design, indexing, partitioning, query … related field5+ years of experience as a Database Engineer, Data Engineer, or similar roleCore Data Engineering & ArchitectureExperience designing, implementing, and maintaining high performant, scalable OLTP systems.Hands-on experience and advanced knowledge of SQL (e.g., Postgres, Snowflake)Strong experience with data modeling, data warehouses, and lakehouse architecturesExperience designing and implementing scalable ...

gravity9 is a boutique IT consulting company headquartered in the UK with offices in the US, Canada, Poland, and Colombia. Our team has deep experience in engineering, experience design and product management. We enjoy a ...