SQL developer
Build the queries, database logic and data structures that applications and reporting depend on.
Remote
A guide to the work this role can cover. Current candidates and availability are confirmed against your brief.
The work to cover
- Develop SQL queries, stored procedures and database changes.
- Investigate slow execution, incorrect results and transaction behaviour.
What to assess
Use the brief to decide which technical evidence matters. An assessment could explore the following:
Review a slow query and explain its execution plan, indexing choices and checks for unchanged results.
Consultant profile
Naledi M.SQL developerCape Town, South Africa
- How they can help
- Refactors reporting queries and checks performance, reconciliation and permissions against agreed business definitions and representative data.
- Experience
- 8 years
- Qualification
- BSc, Computer Science
- Key systems
- SQL Server / PostgreSQL / SSIS
A reporting query that stays correct as data changes
The example brief
A business report becomes slow and inconsistent after its source tables change.
What the contribution could look like
- Trace joins, filters and execution plans against the agreed reporting definitions.
- Refactor the query and verify reconciliation, permissions and behaviour with representative data.
Working alongside
Data engineers, database administrators and reporting owners.
Brief us on this role
Start with this role, then tell us what the work needs. You can clear the role and describe the work in your own words.