Source: https://deftridge.com/job/slow-query-optimisation-san-francisco-dt-6162735/ Title: Slow Query Optimisation, hybrid in San Francisco | Deftridge Summary: Slow Query Optimisation for a specialist SQL & ETL Support, hybrid in San Francisco. $140-$171 an hour, about 6 hours in total. Starts within 7 days. One-off Shortlisting · 4 candidates Posted Oct 22 · DT-6162735 # Slow Query Optimisation · E-commerce Specialist · SQL & ETL Support · Hybrid · San Francisco **$140–$171** / hour About $470–$1,240 in total. Set by the company within a range checked against market pay for the role; your recruiter agrees your exact rate with you before anything is sent. Deftridge adds 15% on top and bills it to the company, so **nothing comes out of your rate**. - **Company** Series B subscription commerce company for children's clothing · 201–500 employeesCL-64936 · based in Boston - **Where** Hybrid · San Francisco - **Format** One-off task - **Time needed** about 6 h in total - **Start** Starts within 7 days - **Level** Specialist · 2-5 years - **When you work** Weekday evenings1 h a week overlap with PT The company is already looking at 4 profiles for this task. It is still open: new profiles are added to the shortlist until the company decides. **8** professionals have asked about this task **220** tasks of this type completed on Deftridge ## About this task This Series B subscription commerce company for children's clothing (201–500 employees) is looking for a specialist SQL & ETL Support for a single piece of work with a fixed scope and a fixed price. Rewrites queries and adds indexes or partitions. A fresh pair of experienced eyes is needed, and the result is a document or file the team can use straight away. It sells online, so volumes move with promotions and the calendar matters. The team sits in San Francisco. Everything can be done remotely; an occasional visit is welcome and never required for the first month. Most people do this on weekday evenings; replies inside the working day are not expected. About 1 hour a week should overlap with the team's day (PT). ## What you deliver - Speed up the ten slowest warehouse queries and report before and after run times. - A 20-minute walkthrough call, or a recorded screen share if you prefer - The finished deliverable in the agreed file format, with sources and assumptions listed - One round of edits after the company's review is included ## How the work runs - Day 1: kickoff call and access to the files - Days 2 to 5: the work, with questions answered the same day - Last day: delivery and a short walkthrough **Duration:** 2 to 3 weeks. Accepted when the company contact confirms the deliverable against the written checklist. One round of edits is included. ## Tools SQL BigQuery Snowflake ## Who fits - 2-5 years of hands-on work as an SQL & ETL Support, or the equivalent mix of roles - Comfortable working in SQL, BigQuery and Snowflake - Your own work history stays private; the company sees a first name, your field and a rate ### Nice to have - Used to short written handovers - A habit of asking one clarifying question early rather than five late ## Not included - Anything that needs a signature in your own name unless the brief says so - Travel or work at a fixed location - On-call availability outside the agreed window ## How you get paid - The company prepays Deftridge before your first hour, so payment does not depend on a late invoice. - Deftridge pays you in USD after the company confirms the hours or the deliverable. The payment date is written in your task agreement. - You work as an independent contractor: you report your own income, and your recruiter sends the statements your accountant needs. - You never chase the company. Questions about money go to Deftridge. ## What happens after you say you're interested 1. **Within one working day** A recruiter writes to you to confirm your hours and the rate you want. 1. **You agree the rate** You and the recruiter fix an exact rate inside the company's range. You decide whether to go ahead. 1. **With your written OK** The company sees the anonymous profile below. Most companies answer within three working days. 1. **Start** You sign the task agreement and the company's confidentiality terms through Deftridge, and begin on the date above. ## What the company sees about you First name, field, experience, tools and the hours you offer. Not your surname, your employer or your contact details. Your profile **Alex** Specialist SQL & ETL Support - **Experience** 2-5 years in data & analytics - **Tools** SQL, BigQuery, Snowflake - **Offers** 6 hours in total, weekday evenings - **Rate** $156 an hour, agreed with the recruiter ## How this rate compares The midpoint of this range, $156 an hour, is **above** the median specialist SQL & ETL Support rate in California ($135). The shaded band is the 25th to 75th percentile of the market. Median $135 This task $156 $97 $191 [All SQL & ETL Support jobs in United States](https://deftridge.com/jobs/sql-etl-support/united-states/) · [SQL & ETL Support rates in California](https://deftridge.com/rates/sql-etl-support/california/) · [Data & Analytics jobs](https://deftridge.com/jobs/data-and-analytics/) ## Questions about pay and privacy The rules are the same for every task. [Pricing](https://deftridge.com/pricing/) explains the 15% fee, prepayment and when you are paid; [How it works](https://deftridge.com/how-it-works/) covers matching, what the company sees and side work next to a job. CL-64936 is the Deftridge code for this company. Its name is shared only after you agree to an introduction, and you decide whether to go ahead. ## Interested in this task? Leave your first name and e-mail. You hear back from a recruiter inside one working day, and nothing reaches the company without your written OK. - You see and agree the rate before the company hears about you - Your employer and surname stay private - E-mail only, no phone calls Thank you, Slow Query Optimisation · E-commerce is noted. A recruiter writes to you from a @deftridge.com address within one working day; the next steps are listed on this page. ## More SQL & ETL Support tasks [All SQL & ETL Support jobs](https://deftridge.com/jobs/sql-etl-support/) One-off Posted Nov 2 ### [Warehouse Cost Review](https://deftridge.com/job/warehouse-cost-review-boston-dt-6531484/) Senior · SQL & ETL Support Series B subscription commerce company for children's clothing · 201–500 employees **$138–$174** / hour About $620–$1,250 in total - about 6 h in total - Hybrid · Boston - Starts within 7 days - Top 25% for the role [View task](https://deftridge.com/job/warehouse-cost-review-boston-dt-6531484/) Bundle Posted Nov 2 ### [SQL Report Library](https://deftridge.com/job/sql-report-library-san-francisco-dt-6650718/) Manager · SQL & ETL Support Series B subscription commerce company for children's clothing · 201–500 employees **$177–$201** / hour About $1,510–$3,000 a month - 8–16 h a month - Hybrid · San Francisco - Starts within 2 weeks - Top 25% for the role [View task](https://deftridge.com/job/sql-report-library-san-francisco-dt-6650718/) Regular Posted Oct 30 ### [Pipeline Failure Triage](https://deftridge.com/job/pipeline-failure-triage-san-francisco-dt-8476416/) Manager · SQL & ETL Support Renewable energy developer in wind · 501–1,000 employees **$168–$202** / hour About $3,600 a month at 5 h a week - 3–6 h a week - Hybrid · San Francisco - Starts within 2 weeks - Top 25% for the role [View task](https://deftridge.com/job/pipeline-failure-triage-san-francisco-dt-8476416/) **$140–$171 / hr** I'm interested