Senior Database Performance Engineer

About Contour Contour Software has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years. As a subsidiary of Constellation Software Inc., we are proud to be part of a global enterprise software conglomerate that has grown to become one of the top 10 software companies in the world, with employees and customers in 100+ countries.

With a broad-based and ever-growing portfolio of market-leading, vertical-market enterprise solutions covering more than 100 industry domains in predominantly mature markets, CSI's recipe creates the perfect environment for professionals to build fulfilling, long-term careers.

What started as an R&D & Accounting back-office, has progressed into a full-service Global Centre serving all functions and departments, at the divisional as well as operating group/corporate level. Today Contour employees, located in Karachi, Lahore & Islamabad, are serving CSI divisions located in time zones spanning the globe, from Sydney to Vancouver.

With the global growth of Constellation as the wind in our sails, we are only just getting started! The Division Constellation HomeBuilder Systems is a leading software provider focused exclusively on the homebuilding industry. Its comprehensive suite of software solutions supports production and accounting, new home sales and marketing, home warranty and service, and homebuilder website solutions.

The organization provides integrated information-management solutions designed specifically for homebuilders. NX is a modern enterprise resource planning (ERP) solution for homebuilders, designed to support production and accounting operations while helping customers scale their businesses, integrate systems, and improve business insights.

The Position We are looking for a Senior Database Performance Engineer to join the NX R&D team. The successful candidate will take a hands-on role in analyzing, troubleshooting, and improving the performance of enterprise applications, with a strong focus on Microsoft SQL Server.

The role requires someone who can investigate performance issues across the application stack and identify whether bottlenecks originate within the database, application, IIS, or underlying Windows environment. The ideal candidate will have strong SQL Server performance-engineering expertise and experience taking ownership of performance analysis and optimization initiatives.

The hired candidate will work from the Contour Software Karachi office as an extension of the division-based R&D team, with working-hours availability until 3:00 PM Eastern Time. 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.

Design, develop, and optimize complex T-SQL queries, stored procedures, functions, views, CTEs, and window functions. Investigate IIS and Windows Server performance issues using application pools, worker-process CPU and memory utilization, IIS logs, failed-request tracing, and Performance Monitor. Trace slow requests end-to-end using IIS logs, application logs, and Application Insights.

Determine whether performance bottlenecks originate within the application, database, or infrastructure layer. Collaborate with developers, QA, and other technical team members to identify root causes and implement sustainable performance improvements. Assist teams in establishing appropriate performance baselines and identifying opportunities for proactive optimization.

Document findings, recommendations, and changes resulting from performance investigations. Work closely with both onshore and offshore team members to deliver high-quality solutions within agreed timelines.

Qualifications and Skills Bachelor's degree in Computer Science, Software Engineering, Information Technology, or a related field. 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, including complex queries, stored procedures, functions, views, CTEs, and window functions.

Strong understanding of SQL Server execution plans and query optimization. Strong knowledge of indexing strategies, statistics, and database performance tuning. Practical experience diagnosing parameter sniffing, blocking, and deadlocks. Hands-on experience with Query Store, Extended Events, DMVs, and wait statistics. Working knowledge of IIS and Windows Server diagnostics.

Experience with Application Insights and application-level performance troubleshooting. Ability to trace an application request end-to-end and distinguish database-related bottlenecks from application-related issues. Strong analytical and root-cause-analysis skills. Excellent verbal and written English communication skills. Ability to collaborate effectively with geographically distributed development and QA teams.

Experience working with enterprise ERP or other large transactional systems would be an asset. Homebuilding-domain experience would be an advantage.

Exciting Benefits we offer: Market-leading Salary Medical Coverage – Self & Dependents Parents Medical Coverage Provident Fund Employee Performance-based bonuses Home Internet Subsidy Conveyance Allowance Profit Sharing Plan [Tenured Employees Only] Life Benefit Child Care Facility Company Provided Lunch/Dinner Professional Development Budget Recreational area for in-house games Sporadic On-shore training opportunities Friendly work environment Leave Encashment Disclaimer: At Contour, we attribute our success to the unique contributions of our diverse staff.

We’re committed to fostering a culture of respect that thrives on the varied perspectives and experiences of all individuals we recruit, employ, promote, and compensate. Since day one, we’ve adhered to a policy that champions a work environment honoring the worth and dignity of each person while being free from all forms of employment discrimination.

In our continuous effort to promote inclusivity, we extend our commitment to individuals with special needs by providing reasonable accommodations. We actively encourage qualified individuals with special needs to apply for the various openings within our company.

Should you require assistance in completing the application process or have any inquiries regarding special facilities, please do not hesitate to contact our HR team. Your unique talents and abilities are welcomed and valued here.