Need help developing DB interface - running web services - queries - procedures and triggers.
DB will be hosted at an ISP (MS Azure) - data is posted into the DB directly from field machines and compared against data received from a third party gateway - reports and alerts are then auto generated to inform staff of potential issues.
1- Experience with Microsoft SQL Server 2005/2008
2- Good experience writing T-SQL Stored procedures, and triggers
3- Experience with Automated Database Replication between two SQL Servers