2 of 2 Remote/Hybrid Contract OLTP Jobs

Oracle Batch Developer

Hiring Organisation
KBC Technologies UK LTD
Location
London, South East, England, United Kingdom
Employment Type
Contractor
Contract Rate
Salary negotiable
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 ...

Data Architect Mainframe Migration & Modernization

Hiring Organisation
Stackstudio Digital Ltd
Location
London, United Kingdom
Employment Type
Contract, Work From Home
Contract Rate
From £500 to £550 per day
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 ...