I am searching for a contractor to perform work on C# code that interacts with a SQLite database. The C# code is structured as a three-tiered software application, with decoupled domain objects, logic controllers, and user interface. The code is for the most part complete, however, the SQLite CRUD methods are not working correctly using async and multi-threading. Your job is to diagnose these issues and fix them, validating each fix with a unit test. Further, to advise improvements to the database design to make it more reliable and faster.
As a contractor hired to this job, you should be familiar with the following, and have access to the programs listed (no software licenses will be purchased for you):
-- .Net 4.5.2
-- Visual Studio 2012
-- SQLite v4.0.30319
-- UI is Windows Forms project type
-- VisualSVN repository (I use TortoiseSVN client)
-- Test Driven Development using nunit
-- You are required to be an English speaker, with excellent...