SQL Extraction Logic Architect

Offer description

I need a seasoned data architect to design and implement robust extraction logic in pure SQL against our MySQL environment. The end-goal is fast, reliable pulls that feed our internal dashboards and ad-hoc analysis workloads. Here’s what I’m after: • Map the current MySQL schema and propose the optimal extraction strategy for each key table. • Write reusable, well-documented SQL scripts (views, stored procedures, or CTE-based queries) that can be scheduled or triggered as needed. • Ensure the logic scales for growing data volumes and follows best practices for indexing, partitioning, and error handling. • Provide clear documentation so analysts can understand and adapt the queries without additional hand-holding. Acceptance criteria • All querie...

Skills and categories

Similar offers