URGENT REQUIREMENT
Role : Performance Engineer & Optimization Specialist
Location : Remote
Duration : Long term contract W2 contract
and Optimization Specialist 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