- Karachi, Sindh, Pakistan +2 more
- On-site
- Full-time · Senior
- Market-leading Salary
- 4+ years
Senior Database Performance Engineer to join the NX R&D team, focusing on analyzing, troubleshooting, and improving the performance of enterprise applications with a strong focus on Microsoft SQL Server.
Locations (3)
- Karachi, Sindh, Pakistan
- Lahore, Punjab, Pakistan
- Islamabad, Pakistan
Responsibilities
- Own and drive database and application performance analysis and optimization initiatives
- Diagnose and resolve SQL Server performance bottlenecks involving complex queries, stored procedures, and database workloads
- Analyze SQL Server execution plans and recommend appropriate indexing and query optimization strategies
- Diagnose issues involving statistics, parameter sniffing, blocking, and deadlocks
- Use Query Store, Extended Events, Dynamic Management Views (DMVs), and wait statistics to identify and troubleshoot database performance problems