Senior Database Performance Engineer
Contour Software23 hours ago
Karachi, PakistanSenior
Responsibilities
- Own database and application performance analysis and optimization initiatives.
- Diagnose and resolve SQL Server bottlenecks involving complex queries, stored procedures, and database workloads.
- Analyze execution plans and recommend indexing and query optimization strategies.
- Troubleshoot statistics, parameter sniffing, blocking, and deadlocks.
- Use Query Store, Extended Events, Dynamic Management Views, and wait statistics to investigate database performance problems.
- Design, develop, and optimize complex T-SQL queries, stored procedures, functions, views, CTEs, and window functions.
- Investigate IIS and Windows Server performance using application pools, worker-process resource utilization, IIS logs, failed-request tracing, and Performance Monitor.
- Trace slow requests end to end using IIS logs, application logs, and Application Insights.
- Distinguish bottlenecks across application, database, and infrastructure layers.
- Collaborate with developers, QA, and distributed technical teams on root-cause analysis and sustainable improvements.
- Establish performance baselines, document findings and recommendations, and deliver solutions within agreed timelines.
Requirements
- Bachelor's degree in Computer Science, Software Engineering, Information Technology, or a related field.
- At least 4 years of hands-on Microsoft SQL Server development, performance engineering, or DBA experience.
- Hands-on experience with SQL Server 2022 or later.
- Expert-level T-SQL skills, including complex queries, stored procedures, functions, views, CTEs, and window functions.
- Strong knowledge of SQL Server execution plans, query optimization, indexing strategies, statistics, and database performance tuning.
- Practical experience diagnosing parameter sniffing, blocking, and deadlocks.
- Hands-on experience with Query Store, Extended Events, Dynamic Management Views, and wait statistics.
- Working knowledge of IIS and Windows Server diagnostics, plus Application Insights and application-level performance troubleshooting.
- Ability to trace application requests end to end and distinguish database-related from application-related bottlenecks.
- Strong analytical, root-cause-analysis, communication, and collaboration skills.
- Enterprise ERP or other large transactional systems experience is an asset; homebuilding-domain experience is advantageous.
Benefits
- Market-leading salary, medical coverage for employees and dependents, parents medical coverage, provident fund, and performance-based bonuses.
- Home internet subsidy, conveyance allowance, and profit-sharing plan for tenured employees.
- Life benefit, child care facility, and company-provided lunch and dinner.
- Professional development budget, recreational area, and occasional on-shore training opportunities.
- Friendly work environment and leave encashment.
- Work from the Contour Software Karachi office with availability until 3:00 PM Eastern Time.
Tech Stack
Microsoft SQL Server
Categories
About Contour Software
Contour Software provides R&D, QA, customer support, and professional services for vertical‑market enterprise applications across Constellation Software Inc.’s global portfolio. It builds, maintains, and supports mission‑critical software used by public- and private‑sector organizations via CSI’s operating companies, functioning as an internal service provider rather than a direct vendor. Headquartered in Karachi with offices in Lahore and Islamabad, it is a wholly owned subsidiary of Toronto‑based Constellation Software.