Debugging & Code Review
Fixing code that will not run, and reviewing code that runs but should not be trusted.
Technical & Programming
Schema design, normalisation, complex queries, indexing and the query that takes four minutes and should take four milliseconds.
A badly normalised schema causes problems forever; a missing index causes problems immediately. Both are cheap to fix early and expensive to fix later.
We design to third normal form (denormalising deliberately where reads justify it), write the queries, and read the execution plan rather than guessing at performance.
Related
Next step
Send the brief, the deadline and anything you already have. You will get a reference number straight away and a considered reply, usually within one working day.