SQL Server design and optimization
Healthcare Technology
Design, query, and tune SQL Server data workflows that keep business applications responsive and dependable.
What this bullet means
The employer is looking for practical database skill: thoughtful tables, understandable queries, useful indexes, and the ability to improve a slow report or screen.
Sample app idea
Care Program Operations Dashboard with SQL Server-style tables for requests, participants, approvals, activity history, and reporting periods.
Main build outline
- Create relational tables for requests, approvals, status history, participants, and reporting periods.
- Write queries for open work, completed work, turnaround time, and activity trends.
- Record one query review with the slow behavior, likely cause, and improvement made.
Portfolio proof
- Database diagram and saved query examples for the operational dashboard.
- Query-performance note that explains one improvement in plain language.
Minimal documentation
- README with the business problem, screenshots, setup notes, and technology stack.
- One requirements note that maps the job bullet to the sample feature.
- One test plan note with happy path, validation, and edge case checks.
- One honest portfolio note that says this is self-directed practice, not employer work.
Modern .NET stack
- Blazor Server or ASP.NET Core Razor Pages.
- C# services with validation and dependency injection.
- SQL Server locally, then SmarterASP SQL Server or Azure SQL.
- Optional Azure App Service, GitHub Actions, Docker, and AI helper feature.