Overview
Skills
Job Details
LoadRunner Performance Engineer – .NET & SQL Server Optimization
1. Requirements Gathering & Test Planning
Collaborate with stakeholders (architects, developers, DBAs, business analysts) to determine performance test objectives for .NET and SQL Server environments.
Define key metrics and SLAs such as transaction response time, throughput, database latency, and resource utilization.
Scope test conditions that assess end-to-end application and database performance under varying loads.
2. Test Design, Scripting, and Automation
Create and parameterize LoadRunner scripts simulating typical user actions across .NET web applications, APIs, and database-intensive workflows.
Design database-specific test cases: Include SQL Server heavy-load scenarios like complex queries, batch jobs, and data ingestion.
Automate performance tests: Integrate scripts into CI/CD pipelines and schedule regular test executions.
3. Test Environment Setup & Management
Coordinate with infrastructure teams to configure and provision test environments for both application (IIS, .NET versions) and database (SQL Server instances) tiers.
Implement monitoring tools for real-time insights, including Windows PerfMon, LoadRunner’s monitors, SQL Server Profiler, Extended Events, and .NET profilers.
4. Execution & Real-Time Monitoring
Run load/stress/soak tests using LoadRunner Controller, monitoring application servers (.NET) and SQL Server simultaneously for resource bottlenecks.
Utilize diagnostic tools: Monitor ASP.NET performance (threading, garbage collection, memory leaks) and SQL Server health (lock waits, deadlocks, slow queries, indexes).
5. Analysis, Diagnosis & Optimization
Analyze test results and pinpoint performance issues across all layers: client, .NET app, database, and infrastructure.
Perform in-depth root cause analysis: Leverage LoadRunner Analysis, .NET performance tools (dotTrace, Visual Studio Profiler), and SQL Server Profiler or Query Store to trace slowdowns to application code or database operations.
Develop and recommend optimizations:
For .NET: Refactor code, enhance caching, adjust threading/asynchronous processes, recommend config changes.
For SQL Server: Tune queries, rewrite stored procedures, index optimization, review execution plans, recommend partitioning or schema changes.
6. Reporting & Stakeholder Communication
Document findings, bottlenecks, and recommendations: Generate clear test summary reports, charts, and presentations.
Communicate actionable insights: Ensure technical and business stakeholders understand performance risks and solutions.
7. Continuous Improvement & Best Practices
Stay updated on latest LoadRunner, .NET, and SQL Server tools/features; share best practices with teams.
Maintain and enhance test suites: Update scripts as applications evolve, include database-intensive scenarios in regular performance hygiene.
Key Skill Requirements
Performance Testing: Advanced LoadRunner (VuGen scripting, Controller, Analysis)
.NET Troubleshooting: Visual Studio Profiler, dotTrace, PerfMon, IIS monitoring
SQL Server Expertise: SQL Server Profiler, Query Store, Execution Plan analysis, T-SQL tuning, index optimization, Extended Events
Monitoring Tools: AppDynamics, Dynatrace, New Relic (optional), SQL Server DMVs, Windows diagnostic utilities
Collaboration: Strong communication with both developers and DBAs