Database Engineer

12 hours 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

  • Lahore, Punjab, Pakistan beBee Careers Full time

    Job Description:Azgard9-denim seeks an experienced Oracle Database Engineer to develop and maintain databases in different environments, including multi-node setups.Responsibilities:Tune and optimize Oracle databases for maximum performanceDevelop and implement shell scripting and automation scriptsMaintain and upgrade databases using RMAN and patching...


  • Lahore, Punjab, Pakistan Ravi Autos Sundar Pvt. Limited Full time

    As a Database Software Engineer at Ravi Autos Sundar Pvt. Limited, you will play a key role in designing and implementing efficient database solutions.Job SpecificationKey Responsibilities:Design and implement database solutions using Oracle Forms and Reports 10g.Develop and maintain software applications using SQL / PLSQL.Collaborate with cross-functional...


  • Lahore, Punjab, Pakistan Prima Systems Full time

    Job Overview: We are seeking a Data Engineer to join our team at Prima Systems. As a key member of our technical staff, you will be responsible for designing, developing, and maintaining robust database solutions to support our business applications and reporting needs.Responsibilities and Deliverables:Designing and developing efficient SQL queries, stored...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    About the Role:We are seeking a skilled Database Developer to join our team. As a Database Developer, you will be responsible for designing, implementing, and maintaining complex database systems.Key Responsibilities:Create complex functions and scripts to cleanse, transform, load, and validate large datasets in a time-sensitive manner.Work with relational...

  • Software Engineer

    2 weeks ago


    Lahore, Punjab, Pakistan Abeer Integrated Solutions Pvt. Ltd Full time

    Abeer Integrated Solutions Pvt. Ltd is hiring a skilled Software Engineer - Access Database to drive innovation in our organization.Primary Responsibilities:Design, develop, and test database applications using Microsoft Access.Implement VBA scripts to automate tasks and improve productivity.Collaborate with stakeholders to gather requirements and develop...

  • Database Engineer

    2 days ago


    Lahore, Punjab, Pakistan beBee Careers Full time

    Job Description:">Design, implement, and maintain Oracle database environments ensuring optimal performance, scalability, and security.Utilize Ansible for automating infrastructure provisioning, configuration management, and deployment pipelines.Provide expert-level Linux administration to ensure system stability, performance, and security across the...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Job Overview:We are seeking a skilled professional with extensive experience in database management, web development, and software engineering to fill a challenging role.About the Position:The ideal candidate will have 4-5 years of experience configuring and optimizing Microsoft SQL databases for optimal performance, designing and implementing RESTful web...


  • Lahore, Punjab, Pakistan TheHiringl Full time

    TheHiringl is seeking a highly skilled and detail-oriented Database Administrator to oversee the performance, integrity, and security of its databases.Key Responsibilities:Install, configure, and upgrade database servers and tools to ensure optimal performance and data security.Maintain the integrity and availability of all database resources, ensuring data...


  • Lahore, Punjab, Pakistan CureMD Corporation Full time

    At CureMD Corporation, we are looking for a highly skilled Associate Database Administrator to support the maintenance and administration of our database systems. As an Associate Database Administrator, you will play a key role in ensuring database performance, security, and availability.Responsibilities:Support the maintenance and administration of...


  • Lahore, Punjab, Pakistan Programmers Force Full time

    Job Description:We are seeking a seasoned Senior Database Administrator to join our team at Programmers Force. In this role, you will be responsible for managing and optimizing databases for our SaaS-based web application in the fintech domain.About the Role:This position involves ensuring the availability, scalability, and performance of our databases that...