Software developer/architect needed for converting application from Oracle DB to MS SQL Server DB
Within the application OPT, which is a .NET app, we need to upgrade the data layer and switch database provider. We need to move from Oracle DB to MS SQL Server DB and fully review the code for this. We need to remove old DataAccess classes, review NHibernate model, transaction handling and review the frameworks to be used for difficult slow queries.
A tricky item can be materialized tables/views so experience with this in MS SQL Server is certainly an advantage.
- SQL Server
- Transaction handling
- (Oracle experience could be good as well)