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

Sign in to set job alerts for "Database Engineer" roles.Associate Software Engineer - Data ScienceData Engineer (Onsite, Lahore, Remittance Salary)

Lahore District, Punjab, Pakistan 2 days ago

Software 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

  • AWS Database Engineer

    4 weeks ago

    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...

  • Database Systems Engineer

    2 weeks ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Data Processing Expert Wanted:We are looking for a qualified Software Engineer who can design and develop database modules, write complex stored procedures and functions, and provide expertise in SQL Server and NoSQL technologies.

  • Database Development Engineer

    2 weeks ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Job Summary">We are looking for a skilled data engineer to join our team. The ideal candidate will have hands-on experience in building data pipelines, managing databases, and supporting data operations.">Key Responsibilities">">Build reliable and scalable data pipelines using industry-standard tools and techniques.">Clean, validate, and transform data from...

  • Database System Engineer

    2 weeks ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Oracle Database Administrator Job SummaryThe successful candidate will be responsible for maintaining and upgrading large-scale Oracle databases to meet changing business requirements. They will also analyze and resolve database performance issues, implement data security measures, and ensure the overall efficiency of database systems.Consult for optimal...

  • Database Systems Engineer

    3 days ago

    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...

  • Cloud Database Specialist

    2 weeks ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Cloud Database Engineer PositionThis role involves designing, implementing, and managing cloud-based relational database systems using Amazon RDS, Aurora, and EC2-hosted databases.

  • Database Systems Engineer

    3 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    We are seeking a highly skilled and motivated professional to manage and optimize databases, ensuring performance, security, and high availability.The ideal candidate will have 3–5 years of hands-on experience in administering, supporting, and maintaining MongoDB environments, including installation, configuration, upgrades, performance tuning, and...

  • Cloud Database Specialist

    3 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    AWS Database Engineer RoleWe are seeking a skilled AWS Database Engineer to join our team. As a key member of our engineering department, you will be responsible for designing, implementing, and managing cloud-based relational database systems using Amazon RDS, Aurora, and EC2-hosted databases.The ideal candidate will have strong experience with database...

  • AWS Database Engineer

    2 weeks ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Job Title: Cloud Database SpecialistWe are seeking an experienced Cloud Database Specialist to join our team.

  • Cloud Database Specialist

    6 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    AWS Database EngineerDesign and implement cloud-based relational database systems using Amazon RDS, Aurora, and EC2-hosted databases.Administer and optimize PostgreSQL, MySQL, and Oracle databases, including performance tuning, backup & recovery, high availability, and disaster recovery.Perform database migrations using AWS Database Migration Service (DMS)...