Source: https://deftridge.com/job/slow-query-optimisation-united-states-dt-1921130/ Title: Slow Query Optimisation, remote, US, $119-143/h | Deftridge Summary: Slow Query Optimisation for a senior SQL & ETL Support, remote in the US. $119-$143 an hour, about 6 hours in total. Starts within 2 weeks. One-off Posted Nov 2 · DT-1921130 # Slow Query Optimisation Senior · SQL & ETL Support · Remote · United States **$119–$143** / hour About $390–$1,050 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** Telecom operator in IoT connectivity · 201–500 employeesCL-37709 · based in Eagle Pass - **Where** Remote · United States - **Format** One-off task - **Time needed** about 6 h in total - **Start** Starts within 2 weeks - **Level** Senior · 5-10 years - **When you work** Evenings or weekends1 h a week overlap with CT **224** tasks of this type completed on Deftridge ## About this task This telecom operator in IoT connectivity (201–500 employees) is looking for a senior 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 is a telecom company, with large datasets and long-running programmes. The work is fully remote. Any location in United States works, with a few hours of overlap with the team's day. Evenings or weekends are fine, as long as the agreed weekly output is there. About 1 hour a week should overlap with the team's day (CT). ## What you deliver - Speed up the ten slowest warehouse queries and report before and after run times. - One round of edits after the company's review is included - The finished deliverable in the agreed file format, with sources and assumptions listed - A final note stating what was checked and what was left out of scope ## 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:** about 10 working days. Accepted after the walkthrough. Edits requested within three working days are part of the price. ## Tools SQL BigQuery Snowflake ## Who fits - 5-10 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 - A habit of asking one clarifying question early rather than five late - Has worked with a distributed team across time zones ## Not included - Managing other contractors or employees - On-call availability outside the agreed window - Anything that needs a signature in your own name unless the brief says so ## 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** Senior SQL & ETL Support - **Experience** 5-10 years in data & analytics - **Tools** SQL, BigQuery, Snowflake - **Offers** 6 hours in total, weekday evenings - **Rate** $131 an hour, agreed with the recruiter ## How this rate compares The midpoint of this range, $131 an hour, is **above** the median senior SQL & ETL Support rate in the United States ($130). The shaded band is the 25th to 75th percentile of the market. Median $130 This task $131 $92 $180 [All SQL & ETL Support jobs in United States](https://deftridge.com/jobs/sql-etl-support/united-states/) · [SQL & ETL Support rates in United States](https://deftridge.com/rates/sql-etl-support/united-states/) · [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-37709 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 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/) Regular Posted Nov 3 ### [Pipeline Failure Triage](https://deftridge.com/job/pipeline-failure-triage-new-york-city-dt-5895583/) Senior · SQL & ETL Support Performance marketing agency for travel brands · 201–500 employees **$134–$159** / hour About $2,850 a month at 5 h a week - 3–6 h a week - Hybrid · New York City - Starts within 7 days - Top 25% for the role [View task](https://deftridge.com/job/pipeline-failure-triage-new-york-city-dt-5895583/) One-off Posted Nov 2 ### [Warehouse Cost Review](https://deftridge.com/job/warehouse-cost-review-medford-dt-6638878/) Senior · SQL & ETL Support Omnichannel retailer with stores in six countries · 201–500 employees **$123–$158** / hour About $560–$1,120 in total - about 6 h in total - Hybrid · Medford - Starts within 7 days - Top 25% for the role [View task](https://deftridge.com/job/warehouse-cost-review-medford-dt-6638878/) Bundle Posted Nov 2 ### [SQL Report Library (SQL)](https://deftridge.com/job/sql-report-library-fort-worth-dt-4798797/) Manager · SQL & ETL Support Series C medical devices company for dental practices · 201–500 employees **$156–$188** / hour About $1,380–$2,750 a month - 8–16 h a month - Hybrid · Fort Worth - Starts within 7 days - Top 25% for the role [View task](https://deftridge.com/job/sql-report-library-fort-worth-dt-4798797/) **$119–$143 / hr** I'm interested