Job description

Required Skills: • Oracle LoadRunner Scripting • SQL Optimization • .NET Core Application and Azure Infrastructure Monitoring and Tuning 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: • 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. 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. Benefits at IntelliBee • Long-Term Stability: Join us on a multi-year opportunities with room to grow. • Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well. • Future Planning: Enroll in our 401(k) program and invest in your financial security. • GC Assistance: We support immediate Green Card processing, if required.

Requirements