4 of 4 Contract OLTP Jobs

join a major Government department on a mission-critical project. You will work on a highly integrated Oracle custom application 19c supporting high-volume OLTP workloads across multiple government departments and l click apply for full job details ...

Role We are seeking an experienced Oracle Batch Developer to support a major Government department operating a highly integrated, mission-critical Oracle 19c OLTP environment . This role supports backend workloads that underpin essential business processes across multiple government departments and local authorities. You will play a key role … vital public services. Key Responsibilities Develop, maintain, and optimise Pro*C , PL/SQL , and shell script -based batch processes. Support a high-volume OLTP environment across custom Oracle applications and Oracle E-Business Suite. Analyse and modernise legacy code , working within multi-disciplinary teams to understand requirements, propose technical ...

join a major Government department on a mission-critical project. You will work on a highly integrated Oracle custom application 19c supporting high-volume OLTP workloads across multiple government departments and local authorities. Role Overview You will be responsible for developing and supporting batch processes within a complex Oracle environment … critical systems. Essential Skills & Experience Strong proficiency in Pro*C, PL/SQL, and shell scripting. Proven experience with batch processing and high-volume OLTP systems in Oracle custom or Oracle Apps EBS. Excellent analytical skills, including: Analysis of legacy codebases. Working within multi-disciplinary teams to shape requirements. Contributing ...

offs; identify functional dependencies and key 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 OLTP; understand when to denormalize for queries; trade-offs between 3NF, Data Vault, and star ...