◆ Data & Analytics

What a sql developer
really does.

20 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.

20evidenced tasks
67,140in the US (2025)
$139,500median pay / year
6systems it runs on
See the 20 tasks ↓Open in the atlasThe full career map →
This is what one task looks like here
Create data models and schemas
Design the relational and dimensional schemas for the sales and custom…4 sources agree

The shape of the day

tap a movement to see its tasks

Which one is you, right now?

Pick the moment · no score, no sign-up
Which moment is you right now?
Whichever you pick, the task behind it opens below.

The work, task by task

20 tasks
Hands on the work16
Create data models and schemas+
Design the relational and dimensional schemas for the sales and customer domains, document field types and keys, ensure GDPR-compliant exchange formats, and produce the DDL and an ER diagram for review by Friday noon.
escojdonetwiki4 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Optimize database performance+
Analyze the slowest queries from last week's reports, propose and apply index and partitioning changes, capture before/after plans and runtime metrics, and schedule a rollback if latency rises above 300ms.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Express strategic data requirements+
Draft a one-page brief of strategic data requirements: core entities, freshness SLAs, ownership, allowed consumers, and exchange formats, circulate to product, analytics and security for sign-off by Wednesday.
jdwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Implement data backup and recovery procedures+
Create a nightly backup plan including full and incremental snapshots, document restore steps with RTO/RPO targets, run a test restore to a staging instance and record timing and data integrity results.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Create and manage data models+
Build canonical data models for customer, product and order, enforce naming and data-exchange standards, publish the model package with sample datasets and a versioned migration path for downstream teams.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Troubleshoot database issues+
Investigate the slow-running orders database: run the failing report query, collect the execution plan and recent wait stats, capture the error logs from last 48 hours, and summarise three likely causes with priority and next steps for the on-call dev by noon tomorrow.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Collaborate with software developers and analysts+
Coordinate with Marco in backend, Priya the analyst, and the frontend team to define the data contract for the new customer profile API, list required fields, types, example rows, and one reconciliation test, then circulate the draft for approval by Friday.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Create an inventory of the data needed+
Inventory the data needed for the quarterly churn model: extract table names, key fields, update frequency, owners and sample row counts from the customer schema, compile into a single spreadsheet and flag any missing sources by Wednesday.
wiki
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Watch and assess1
Keep it safe1
Grow the practice1
Work with people1

What the work runs on

named inside the evidenced tasks
10 tasksApache Hivestores and models large structured datasets and supports DDL for schema definition in data warehouse-like environments
3 tasksAmazon Redshiftoffers query plan inspection, distribution and sort key tuning, and performance metrics for analytic workloads
3 tasksApache Airfloworchestrates data flows and enforces freshness SLAs so requirements translate into scheduled pipelines
2 tasksApache Cassandrasupports schema migrations and testing on distributed column-family data models for high-write workloads
1 taskAmazon Elastic Compute Cloud EC2provides snapshot and instance restore capabilities used to run backups and execute test restores in staging
1 taskAmazon DynamoDBsupports fine‑grained access controls, encryption at rest and audit patterns suitable for enforcing data integrity and security in operational stores
Browse every evidenced software task →

The same task, four heights

this page is height one
ExecuteDo today's task, with fewer mistakesyou are here → ImproveMake it easy for the next person to acceptin the atlas → DecideWork out the right move when it is unclearin the atlas → BecomeLearn the pattern so it stops coming backin the atlas →

Can AI actually do this job?

the honest answer

It can

where it genuinely helps
  • Explain the theory behind the work
  • Draft, tidy and structure your writing
  • Rehearse a hard conversation before you have it
  • Build a study plan that fits your gaps

It cannot

where it stops, completely
  • Be in the room where a sql developer actually works
  • Carry the responsibility when the call is wrong — that weight stays yours
  • Notice what no one wrote down: the hesitation, the thing left unsaid
  • Live with the outcome

What the work pays

two countries, two different measures

United States

this exact occupation · BLS 2025
  • $139,500 a year — the middle: half earn more, half earn less
  • The lowest tenth earn near $86,240; the top tenth near $204,000
  • 67,140 people employed in this occupation

India

the occupation GROUP, not this job · PLFS via ILOSTAT 2025
  • ₹38,298 a month — the median for Professionals, the group this work sits in
  • India publishes pay by broad occupation group, so this covers many jobs besides this one. It is a shape, not a salary.
read this carefullyThese two numbers are not comparable and must not be converted into each other. One is a yearly figure for this job alone; the other is a monthly figure for a whole family of jobs. What travels between them is the pattern, not the amount: experience lifts pay almost everywhere.

Where the evidence lives

open any of it yourself
O*NETThe US Department of Labor's own record of this job9 of these tasks ESCOThe European skills and occupations register5 of these tasks Job descriptionsReal postings, in the wild11 of these tasks WikipediaHow the world describes this work5 of these tasks US Bureau of Labor StatisticsPay and employment, by occupation2025 figures UK NOS TECHDUDB2Create databases to store and retrieve datanational standard UK NOS TECDT80851Design data processing systemsnational standard

Close to this work

12 nearby
Data & AnalyticsFinancial Analyst26 evidenced tasks Data & AnalyticsExperimentation Analyst26 evidenced tasks Data & AnalyticsData Governance Analyst26 evidenced tasks Data & AnalyticsR Analyst26 evidenced tasks Data & AnalyticsCrm Analyst26 evidenced tasks Data & AnalyticsWeb Analyst26 evidenced tasks Data & AnalyticsGrowth Analyst26 evidenced tasks Data & AnalyticsProduct Analyst25 evidenced tasks

Questions people actually ask

You’ll split time between writing and testing SQL queries, tuning performance, and meeting with analysts or engineers to confirm data needs. Expect to work on schema changes, create data sets for reports, and troubleshoot slow queries or failed jobs.

A typical day often includes checking ETL pipelines (for example, jobs in Apache Airflow), running optimization on systems like Amazon Redshift or Apache Hive, and answering user questions about data definitions or access.

Start with relational SQL engines and at least one cloud analytic DB: Amazon Redshift for cloud warehousing and Apache Hive for Hadoop‑style SQL. Learn core SQL, indexing, joins, and explain plans on those systems.

Add basics of orchestration and NoSQL: Apache Airflow for job scheduling and Apache Cassandra or Amazon DynamoDB for wide‑column/NoSQL patterns. Know EC2 because many databases run on it.

First measure: use EXPLAIN plans and query runtime stats to find slow scans and expensive joins. On Redshift, adjust distribution keys, sort keys, and vacuum/analyze regularly. On Hive, tune partitioning and file formats (Parquet/ORC) to reduce I/O.

Also set and calculate optimum database parameters (memory, concurrency) using vendor manuals and calculators, and profile jobs in Airflow to see bottlenecks across ETL steps.

Yes, AI can draft queries, suggest indexes, or generate test data, but always verify output. Run AI‑generated SQL on a dev database, review execution plans, and check results against known data. Treat AI like a junior colleague that must be reviewed.

Avoid letting AI change production schemas or run recovery scripts. Use it to speed repetitive tasks, not to replace your validation of data integrity and security.

The U.S. Bureau of Labor Statistics (BLS) reports 67,140 employed in this SOC and gives a median annual wage of $139,500. The lowest tenth earn about $86,240, and the top tenth about $204,000 (BLS).

Salaries vary by region, experience, and systems you know (cloud, NoSQL, big‑data). Employers pay more for Redshift/Hive/Cassandra/Cloud expertise.

An SQL Developer focuses on query design, stored procedures, data models, and creating data sets for applications and analysts. You’ll also express strategic data requirements and provide a common business vocabulary.

Data Engineers build ETL pipelines and orchestration (often using Airflow) and work more on big‑data tech. DBAs focus on backups, recovery, security, and server-level tuning. In smaller teams these roles overlap.

Learn strong SQL (joins, window functions, aggregation), schema design, and how to test and modify databases. Practice on Redshift and Hive, and learn basic Airflow to understand ETL scheduling.

Also learn troubleshooting steps: reading logs, using EXPLAIN plans, and implementing backup/recovery. Soft skills: clear business vocabulary, estimating project time/cost, and teaching users how to use data safely.