> Markdown version of [/jobs/ext/2240716-database-lead-own-the-oracle-engine-behind-daily-trading-data](https://www.wearedevelopers.com/jobs/ext/2240716-database-lead-own-the-oracle-engine-behind-daily-trading-data). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Lead Own the Oracle Engine Behind Daily Trading Data - **Company:** PROPERTIES PLUS LLC - **Location:** Philadelphia, PA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Batch Processing, Databases, Extract Transform Load (ETL), Data Transformation, Python (Programming Language), Microsoft Office, Oracle (Applications), Oracle SQL Developer, Oracle Warehouse Builder, Performance Tuning, SQL Databases, Data Pipelines - **Published:** August 26, 2026 - **Apply:** https://www.dice.com/job-detail/33b0d60c-c64d-4260-9bb5-c05955ffd37a ## About the Role * Strong, hands-on experience with Oracle SQL (primary and non-negotiable) * Background in data transformation, file ingestion/ETL, or reconciliation-type work * Comfort and reliability with an early-morning schedule (critical process starts around 7am) * Ability to operate calmly and effectively under time pressure * Excellent problem-solving skills with unexpected or malformed data * Local to the Bala Cynwyd / Philadelphia area or truly committed to substantial on-site work * Working knowledge of Python is a plus * Exposure to financial operations concepts (cash, positions, settlements, clearing) is helpful * Experience supporting middle-office or operations-critical data processes is a bonus ## Description Database Lead Own the Oracle Engine Behind Daily Trading Data Philadelphia, PA | On-Site Be the reason the numbers are right before the market wakes up You re the person who actually makes the data show up where it needs to be, when it needs to be there. This role puts you at the heart of a mission-critical, early-morning process that the firm relies on every single day. You ll own the Oracle SQL pipelines that ingest and transform external cash position files at the start of the day, turning messy, imperfect inputs into clean, reliable data for downstream systems. When files arrive malformed or processes wobble, you re the calm in the storm diving into data, fixing issues in real time, and getting everything back on track. This is impact you can feel before 9am. If you live in Oracle SQL and love owning high-stakes data workflows, we should talk. What You'll Work On You ll sit on a middle-office data team focused on inbound clearing and cash positions. * Daily inbound cash position files * Middle-office data pipelines * Inbound clearing processes * File validation and transformation workflows * Downstream consumption systems and interfaces * Data reconciliation and exception handling * Operations-critical ETL-style processes Core tools and concepts include Oracle SQL as your primary language, plus data transformation, file ingestion/ETL, and reconciliation work. Python and financial operations concepts (cash, positions, settlements, clearing) are helpful extras. The core challenge: keep a complex, time-sensitive Oracle data process accurate, resilient, and on time every morning. What You'll Be Doing * Ingesting external cash position files received each morning * Validating incoming data to catch issues early * Transforming raw inputs into structured data ready for downstream systems * Developing and maintaining Oracle SQL processes that drive daily workflows * Optimizing existing Oracle SQL code for speed, reliability, and clarity * Troubleshooting data quality issues and file format problems in real time * Diagnosing and resolving process failures at the start of the day * Performing reconciliation work to ensure accuracy and completeness of positions * Collaborating with middle-office and technology stakeholders to resolve exceptions quickly * Supporting continuous improvement of daily processes and data pipelines * Documenting procedures and contributing to team knowledge sharing * Owning a repeatable, high-stakes daily process and keeping it running smoothly, You ve been the go-to Oracle SQL developer for a daily or time-sensitive data process someone who doesn t just write queries, but owns the flow end to end. You re used to taking raw files, making sense of them, and getting them into shape for systems that can t afford to be wrong or late. You re steady when things break at inconvenient times, you communicate clearly with operations and tech partners, and you like the satisfaction of knowing your work is foundational to the day s business. High-signal experience: Oracle SQL data transformation file ingestion ETL-style workflows data reconciliation middle-office data processes cash positions settlements clearing Python Why This Opportunity? This isn t another back-office report-writing role you re on the hook for a real, daily process that the business feels immediately if it s not right. You ll work close to the data and close to the people who rely on it, with a clear line between your work and the firm s ability to operate each day. There s an immediate opening on the team and a second seat expected soon, so strong candidates who aren t selected first will still be firmly on the radar for upcoming needs. If you value reliability, ownership, and seeing the direct impact of what you build every single morning, this is your lane. Important Requirements Substantial on-site presence in Bala Cynwyd / Philadelphia is expected. Early-morning start required (critical daily process begins around 7am). Interested? If you re the Oracle SQL pro people trust when the data absolutely has to be right and on time, send your details and let s have a confidential conversation. Please send your resume to Kevin McCarthy Keywords Database Lead, Oracle SQL Developer, Oracle Developer, SQL Developer, Middle Office Data, Inbound Clearing, Cash Positions, Data Engineer, ETL Developer, Data Transformation, File Ingestion, Reconciliation, Middle Office Technology, Operations Data, Financial Data, Python, Early Morning Shift, 7am Start, Production Support, Data Pipeline, Philadelphia, Bala Cynwyd, Clearing, Settlements, Positions Data, Operations-Critical Processes, Oracle SQL Tuning, Data Quality, Exception Handling, Daily Batch Processing, Financial Operations ## Related Videos - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client](https://www.wearedevelopers.com/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client) - [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [TiDB, One Layer at a Time: How Distributed SQL Became an Agentic AI Backbone](https://www.wearedevelopers.com/videos/100117-tidb-one-layer-at-a-time-how-distributed-sql-became-an-agentic-ai-backbone) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)