SQL Programmer needed to propose an architecture for a complex business process that we are migrating to a WPF front end, SQL Server back end.
The process mines hospital data and assigns calculated fields at a row level, incorporating several layers of business logic. We are looking for an hour-long review of a three-page spec. The finished product is a 1-2 page development plan, complete with a development strategy, considerations of pressure points, scale and bottlenecks. Development strategy should touch on use of interim tables, views and nested views, temp tables, stored procedures, etc. Freelancer should be available for 2-3 brief clarification questions if solicited.
Pending review of the development plan submitted, we will look for an ongoing engagement throughout development (up to 2 months, 5-10 hours a week, competitive rate).
Ideal candidate has and can provide proof of experience with T-SQL programming at enterprise scale (millions of rows, complex iteration).