Database Engineer

3 weeks ago


Lahore, Punjab, Pakistan Stewart Pakistan Private Limited Full time

Get AI-powered advice on this job and more exclusive features.

We are seeking a highly skilled Database Engineer with deep expertise in MS SQL Server to focus on query optimization, performance tuning, and database design. The ideal candidate should have a strong grasp of complex queries, indexing strategies, and fine-tuning database performance. This role involves working closely with developers and architects to ensure efficient data storage, retrieval, and optimization in 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.
  • 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.
  • 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).
Seniority level
  • Seniority levelMid-Senior level
Employment type
  • Employment typeFull-time
Job function
  • Job functionInformation Technology
  • IndustriesInsurance

Referrals increase your chances of interviewing at Stewart Pakistan Private Limited by 2x

Get notified about new Database Engineer jobs in Lahore, Punjab, Pakistan.

Associate Software Engineer- Data EngineerAssociate Software Engineer - Data Science

Lahore District, Punjab, Pakistan 13 hours ago

Data Platforms Solutions Engineer - Data EngineeringSoftware Engineer - Supplier/Data ExperienceCloud Migration Engineer (Oracle to Azure Workloads)

We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr
  • Database Engineer

    3 days ago


    Lahore, Punjab, Pakistan Stewart Pakistan Private Limited Full time

    Get AI-powered advice on this job and more exclusive features.We are seeking a highly skilled Database Engineer with deep expertise in MS SQL Server to focus on query optimization, performance tuning, and database design. The ideal candidate should have a strong grasp of complex queries, indexing strategies, and fine-tuning database performance. This role...


  • Lahore, Punjab, Pakistan Cloudelligent Full time

    Position Title: AWS Database EngineerJob Timings: 8:00 AM – 5:00 PM CST (6:00 PM- 3:00 AM PKT)Location:LahoreAbout CloudelligentCloudelligent is Cloud-native consultancy and AWS Advanced consulting partner We specialize in providing bespoke cloud solutions to Startups & SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses to make...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    **Job Title:** AWS Database EngineerWe are seeking an experienced AWS Database Engineer to join our team. The successful candidate will possess a strong background in database administration and optimization in cloud environments, particularly on AWS.**Key Responsibilities:**Design, implement, and manage cloud-based relational database systems using Amazon...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Database Systems EngineerJob Description: As a Senior Database Administrator, you will be responsible for ensuring the reliability and performance of our database systems.Main Responsibilities:Safeguard database systems against failures and outages.Enhance database performance through optimization and troubleshooting.Promote secure data handling...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Job Title: Database AdministratorAbout the Role:We are seeking a skilled Database Administrator to join our team. In this role, you will be responsible for managing and maintaining database systems to ensure their performance, integrity, and security.Key Responsibilities:Manage and maintain database systems to ensure their performance, integrity, and...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    We are seeking a seasoned Database Administrator with 3–5 years of experience in managing and optimizing databases, ensuring performance, security, and high availability. The ideal candidate will have strong expertise in MongoDB, relational databases such as SQL Server and Oracle, and exposure to PostgreSQL.Responsibilities:Database Administration:...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Data Management ProfessionalThis position requires a skilled Data Management Professional to oversee database performance, integrity, and security. The key responsibilities include installing, configuring, and upgrading database servers, maintaining database resources, monitoring performance, implementing security measures, backing up databases, designing...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Database And Api Development ExpertWe are looking for a highly skilled database and API development expert to join our team. The ideal candidate will have extensive experience with MySQL databases and RESTful APIs, as well as strong analytical and problem-solving skills.Main Responsibilities:Design and implement scalable MySQL databases.Develop and maintain...


  • Lahore, Punjab, Pakistan Cinnova Technologies, LLC Full time

    We are looking for highly skilled Cloud Infrastructure and Database Operations Engineer. The purpose of the Cloud Infrastructure and Database Operations Engineer is to deliver a sustainable, high-quality, end-to-end cloud infrastructure hosting service that supports the Company's products and the Inspire platform. This role is responsible for continuously...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Database Solutions EngineerWe are looking for highly motivated individuals with 3-7 years of hands-on experience in designing, implementing, and optimizing database solutions that support healthcare software products.