Open Lance

Data & Analytics

Hire SQL Developers for Queries and Reporting

SQL developers write the queries that pull reports from databases, design tables, and speed up queries that have become slow.

Post a job How hiring works

The role

What SQL developers do

A SQL developer writes queries and views for reporting, designs schemas and indexes, tunes slow queries with execution plans, and sometimes writes stored procedures. They keep data correct with constraints and careful migrations.

Typical deliverables

  • Reporting queries and views
  • Database schema and indexes
  • Query performance tuning
  • Stored procedures and functions
  • Data cleanup and migration scripts

Tools you will see

  • PostgreSQL
  • MySQL
  • SQL Server
  • Execution plans
  • Window functions
  • dbt

Choosing

How to choose SQL developers

What to look for

  • Readable queries with clear logic.
  • Use of execution plans to tune performance.
  • Sound schema design and constraints.
  • Care running changes on production data.

Questions to ask

  1. 1How would you find why this query is slow?
  2. 2How do you make changes safely on production data?
  3. 3Which database systems have you worked with?
  4. 4How would you design tables for this data?

Planning

Before you post the job

Access safely

Start with read-only access or a copy of the database where possible.

What drives cost

Database size, query complexity, performance goals and migration needs.

Hiring on Open Lance

  • Posting a job and reviewing proposals are free.
  • Each milestone is funded into escrow before work starts and paid when you approve it.
  • Hire fixed-price, hourly, as a monthly Dedicated Hire, or buy a packaged Drop-In.
  • Client fees are shown before you pay and added on top of the work.

How escrow and approval work · Pricing

FAQ

Questions about hiring SQL developers

Is SQL the same across databases?

The basics are shared, but each database has its own features and syntax.

Can they speed up our reports?

Often, with better indexes, rewritten queries or summary tables.

Do they need production access?

For analysis, read-only access or a replica is usually enough.

Related

Related skills

Before you hireWriting the job postReading the proposalsSetting milestones

Post a job for SQL developers

Describe the work and compare proposals. You only fund the first milestone once you have chosen someone.

Post a job