Database Engineer at Stewart Pakistan Private Limited

Job Description:

Latest job information from Stewart Pakistan Private Limited for the position of Database Engineer. If the Database Engineer vacancy in Pakistan matches your qualifications, please submit your latest application or CV directly through the updated Jobkos job portal.

Please note that applying for a job may not always be easy, as new candidates must meet certain qualifications and requirements set by the company. We hope the career opportunity at Stewart Pakistan Private Limited for the position of Database Engineer below matches your qualifications.

We are seeking a highly skilledDatabase Engineerwith deep expertise inMS SQL Serverto focus onquery optimization, performance tuning, and database design. The ideal candidate should have astrong grasp of complex queries, indexing strategies, and fine-tuning database performance. This role involves working closely with developers and architects to ensureefficient data storage, retrieval, and optimizationin our complex, high-transactional environment.

Key Responsibilities:

1. Query Writing & Optimization

• Write and optimize complex SQL queries, stored procedures, functions, and triggers .
• Analyze and fine-tune query execution plans to improve database performance.
• Work closely with development teams to optimize database interactions .

2. Performance Tuning & Table Optimization

• Identify and resolve slow-performing queries and indexing issues .
• Implement best practices for indexing, partitioning, and table design .
• Optimize transaction handling and concurrency control .
• Monitor query performance and recommend improvements.

3. Database Design & Collaboration

• Design and improve database schemas for scalability and efficiency.
• Ensure data integrity, consistency, and normalization .
• Collaborate with developers and architects to enhance data processing efficiency.
• Conduct query and schema reviews to enforce best practices.

4. Collaboration & Best Practices

• Work closely with software engineers to integrate optimized queries into applications.
• Define and enforce SQL development standards and best practices .
• Conduct code reviews and training sessions on SQL performance tuning.

Qualifications & Skills

Must-Have:

• 10+ years of experience in MS SQL Server query optimization .
• Expertise in writing, analyzing, and tuning complex SQL queries .
• Strong understanding of indexing strategies, execution plans, and partitioning .
• Experience in table design, normalization, and performance tuning .
• Hands-on experience with stored procedures, triggers, and query profiling .

Nice-to-Have:

• Exposure to Azure SQL and cloud-based database solutions .
• Experience with SSIS, SSRS, and ETL optimization .
• Familiarity with NoSQL databases and alternative data storage models.
• Scripting knowledge ( PowerShell, Python, or T-SQL automation ).

Job Info:

• Company: Stewart Pakistan Private Limited
• Position: Database Engineer
• Work Location: Pakistan
• Country: PK

How to Submit an Application:

After reading and understanding the criteria and minimum qualification requirements explained in the job information Database Engineer at the office Pakistan above, immediately complete the job application files such as a job application letter, CV, photocopy of diploma, transcript, and other supplements as explained above. Submit via the Next Page link below.