Principal SQL Performance Optimization Specialist – Pharmaceutical Domain
Budget: $8 – $15 USD
I maintain a growing set of clinical-trials tables and need targeted SQL support from someone who already speaks the language of pharma. Your mission is to make the data faster, cleaner, and easier to work with while keeping compliance standards intact.
Here’s what I need:
• A sound relational model (or an improved one) for clinical-trials data.
• Complex, well-documented SQL queries that researchers can reuse without modification.
• Practical performance-tuning steps—indexes, execution-plan tweaks, and configuration hints—to shorten runtimes.
The immediate goal is to optimize storage and retrieval; reports and dashboards will come later. I can provide table structures, sample datasets, and a sandbox to test in. Please be comfortable navigating protocol numbers, visit dates, and adverse-event records so that naming conventions and joins stay audit-friendly.
If you have both serious SQL chops and hands-on experience with clinical-research datasets, I’d love to see how you can streamline my current setup and outline the next steps toward a lean, reliable database.
Here’s what I need:
• A sound relational model (or an improved one) for clinical-trials data.
• Complex, well-documented SQL queries that researchers can reuse without modification.
• Practical performance-tuning steps—indexes, execution-plan tweaks, and configuration hints—to shorten runtimes.
The immediate goal is to optimize storage and retrieval; reports and dashboards will come later. I can provide table structures, sample datasets, and a sandbox to test in. Please be comfortable navigating protocol numbers, visit dates, and adverse-event records so that naming conventions and joins stay audit-friendly.
If you have both serious SQL chops and hands-on experience with clinical-research datasets, I’d love to see how you can streamline my current setup and outline the next steps toward a lean, reliable database.