Overview
Remote
120000
Full Time
No Travel Required
Unable to Provide Sponsorship
Skills
.NET
ASP.NET
Application Servers
Microsoft SQL Server
SQL
Microsoft IIS
Microsoft Azure
Test Suites
SQL Tuning
Job Details
- 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.
- 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.
- 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.
- 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).
- 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: o For .NET: Refactor code, enhance caching, adjust threading/asynchronous processes, recommend config changes. o For SQL Server: Tune queries, rewrite stored procedures, index optimization, review execution plans, recommend partitioning or schema changes.
- 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.
- 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. Skills: Oracle LoadRunner Scripting SQL Optimization .NET Core Application and Azure Infrastructure Monitoring and Tuning
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.