Our database is exhibiting structural problems that trace back to the way its indexes were created and maintained. I need a specialist who can dig into the current schema, spot every faulty or missing index, and rebuild the structure so the tables relate cleanly and queries run as they should. You’ll start by auditing the existing schema and execution plans to confirm where index duplication, gaps, or bad selectivity are slowing things down. Once the weak points are mapped, I want a clear plan of action, then a set of scripts that create, drop, or rebuild the necessary indexes with minimal disruption to live traffic. After the changes are applied, please benchmark typical read- and write-heavy queries so we can validate the improvement before we push everything to production. Deliverables: • Audit report outlining each problematic index and its impact • SQL scripts (or equivalent) that implement the fixes, clearly commented • Brief test log comparing performance before and after the repair If you need additional schema details or sample workloads, let me know and I’ll provide them right away. Looking forward to getting our structure back on solid ground.