MS Dynamics & SQL DB Developer
Budget: $15 – $25 USD
I need a seasoned database developer who can jump straight into our Microsoft stack. The work centres on three pillars:
• Database design – architect new tables, relationships, and indexes that align with our current Microsoft Dynamics workflows while remaining compatible with long-standing Access front-ends and SQL Server reporting.
• Data migration – extract and cleanse data sitting in several internal legacy databases, then import it cleanly into the new schemas. You’ll have direct access to the existing SQL Server instances plus a handful of Access files; SSIS or your preferred migration tool is fine as long as the result is reliable and auditable.
• SQL query optimisation – review the most heavily used stored procedures and ad-hoc queries. I want tangible speed gains, so expect to use execution plans, indexing strategies, and T-SQL refactoring.
All work happens on Microsoft Dynamics, Access, and SQL Server, so practical experience with each platform’s quirks is essential. I’ll supply database diagrams, sample data sets, and VPN credentials on day one; you’ll return updated schemas, migration scripts, and optimisation reports ready for QA.
If this toolkit and workflow sound familiar, let’s get moving.
• Database design – architect new tables, relationships, and indexes that align with our current Microsoft Dynamics workflows while remaining compatible with long-standing Access front-ends and SQL Server reporting.
• Data migration – extract and cleanse data sitting in several internal legacy databases, then import it cleanly into the new schemas. You’ll have direct access to the existing SQL Server instances plus a handful of Access files; SSIS or your preferred migration tool is fine as long as the result is reliable and auditable.
• SQL query optimisation – review the most heavily used stored procedures and ad-hoc queries. I want tangible speed gains, so expect to use execution plans, indexing strategies, and T-SQL refactoring.
All work happens on Microsoft Dynamics, Access, and SQL Server, so practical experience with each platform’s quirks is essential. I’ll supply database diagrams, sample data sets, and VPN credentials on day one; you’ll return updated schemas, migration scripts, and optimisation reports ready for QA.
If this toolkit and workflow sound familiar, let’s get moving.