Recall that deeper second stage I brought up? This is the section that decides the outcome, the
final gate before an interview. The recruiter reads more closely here, and even so
95% of the screen still rests on your most recent role.
Makes sense: your current job is the clearest signal of where your seniority sits, what you can
do, and what you genuinely own. To win the "yes", that role needs to span the
entire role profile for a SQL Developer, with one focused bullet for each area you
listed back in the Profile Summary's Domain Expertise line.
1
Stored Procedures & Queries
Most SQL resumes stop at "built REST APIs" right here. Hiring managers want
design judgment: clear contracts, versioning that didn't break clients, and auth handled
properly. Name the API style you shipped and how you kept it stable.
Techniques
Contract-first design
Versioning & pagination
Auth & rate limiting
Idempotency keys
Tools
Stored procs, views, UDFs
Window functions, CTEs, MERGE
Stored procs, views, functions
Metrics
Query runtime
Rows processed
Error rate
2
Business Logic & Domain Modeling
This is where mid-level candidates stay vague. Show that you model the domain, not just CRUD
tables: clear boundaries, invariants enforced in code, and state transitions that survive
edge cases. Name the patterns you used and the messy business rule you tamed.
Techniques
Domain-driven design
Bounded contexts
State machines
Validation & invariants
Tools
T-SQL, PL/SQL, SQL
Pydantic, Zod, dataclasses
Hexagonal architecture, CQRS
Metrics
Defect escape rate
Edge-case bug count
Rework rate
3
Data Modeling & Warehousing
Hiring managers want real query numbers, not hand-waving. Name the index you added and the result it drove
(query 1.2s to 90ms, not "optimized the database"). A number like that lands because
the reader can check it.
Techniques
Normalization & star schema
Dimensional modeling (Kimball)
Slowly changing dimensions
Partitioning & archiving
Tools
SQL Server, Oracle
Snowflake, BigQuery
dbt, SSIS
Metrics
Query runtime
Logical reads, index seeks
4
ETL & Pipelines
Two stakes here: reliability and data quality. Show the pipelines you built, the failure modes you
planned for, and a real trade-off you made (full vs incremental loads, ELT vs ETL). Not
"familiar with SSIS" sitting in a skills list.
Techniques
Incremental / CDC loads
Idempotent & restartable jobs
Error handling & logging
Data lineage
Tools
SSIS, Azure Data Factory
dbt, Airflow
Snowflake, Synapse
Metrics
Pipeline SLA
Data freshness
Load duration
5
Jobs & Scheduling
Prove you keep the data correct when jobs run unattended. Scheduled loads, idempotent reruns,
retries with alerting, and owning a genuine batch workflow from end to end (nightly loads,
reconciliations, data sync).
Techniques
Scheduled batch design
Idempotent reruns
Failure alerting
Dependency orchestration
Tools
SQL Agent, Oracle Scheduler
Airflow, ADF triggers
SSIS schedules, cron
Metrics
Rows loaded/run
Job failure rate
Reload rate
6
Query Optimization & Scale
This is one of the clearest mid-versus-senior tells. Show the slow query you found, the rewrite or
index you added, and the data volume it survived. A runtime number with a before/after beats
"made it faster" every time.
Techniques
Index & statistics tuning
Set-based rewrites
Partitioning & sharding
Execution plan analysis
Tools
Query Store, SQL Profiler
EXPLAIN / PLAN_TABLE
DMVs, wait stats
Metrics
Query runtime
Logical reads cut
Load duration
7
Testing, Reliability & Observability
Few things separate mid from senior as sharply as this. Layered tests plus metrics, logs, and
traces that pull MTTR down on the incidents that actually page you. A coverage percentage on its
own proves nothing.
Techniques
Unit & integration tests
Contract tests
Structured logging
Distributed tracing
Tools
tSQLt, data quality tests
Postman, Pact
Datadog, Prometheus, OpenTelemetry
Metrics
Coverage %
MTTR
Error budget burn
Incident count
8
Deployment, CI/CD & Operational Ownership
Companies promote engineers who own their services in production. Automated pipelines, safe
rollouts behind flags, infrastructure as code, and a real on-call story where you cut the toil
or the page volume.
Techniques
CI/CD pipelines
Blue-green & canary deploys
Infrastructure as code
On-call & runbooks
Tools
GitHub Actions, GitLab CI
Docker, Kubernetes
Terraform, LaunchDarkly
Metrics
Deploy frequency
Change failure rate
MTTR, page volume