Interview guides · Mohamed Abdulrahman Al-Bahar

Mohamed Abdulrahman Al-Bahar Software Engineer Interview Guide

Mohamed Abdulrahman Al-Bahar Software Engineer interview guide: reported rounds, questions and how candidates describe the process.

The 60-second brief

A Software Engineer at Mohamed Abdulrahman Al-Bahar plays a pivotal role in designing, developing, and maintaining software solutions that drive the company’s operations and enhance its product offerings. This position is essential not only for the technical execution of projects but also for fostering innovation that aligns with the company’s strategic objectives. Software Engineers contribute to a diverse range of products, from internal systems that streamline processes to customer-facing applications that enhance user experience. The impact of this role is significant as it directly influences business performance and customer satisfaction. You will work within cross-functional teams, collaborating with product managers, designers, and other engineers to solve complex problems and deliver high-quality software.

This guide is scoped to a Software Engineer candidate at Mohamed Abdulrahman Al-Bahar.

Focus areas

Communication skills (verbal presentation)
Technical interview preparation
Problem solving (technical Q&A)

The Mohamed Abdulrahman Al-Bahar interview process

Mohamed Abdulrahman Al-Bahar candidates report 4 rounds over 3-5 weeks. The stages below are what candidates describe, not a published process.

Resume Review

Initial screening where your resume and qualifications are reviewed.

What to demonstrate

Initial screening where your resume and qualifications are reviewed
Depth in Communication skills (verbal presentation)

How to prepare

Be able to walk your CV end to end in two minutes, and say why this company specifically.
Have your salary expectations, notice period and location constraints ready, and ask for the rest of the loop in writing.

Multiple Interview Rounds

You will face questions from various stakeholders, including technical managers and team leads.

What to demonstrate

You will face questions from various stakeholders
Including technical managers and team leads

How to prepare

Answer aloud and timed: Describe a challenging technical problem you solved in a past project.
Answer aloud and timed: How do you ensure code quality in your work?

Technical Assessments

Interviews will assess your technical capabilities.

What to demonstrate

Interviews will assess your technical capabilities
Depth in Communication skills (verbal presentation)

How to prepare

Answer aloud and timed: What is your experience with version control systems?
Answer aloud and timed: Describe a time when you faced a conflict in a team setting. How did you handle it?

Behavioral Questions

Expect questions that evaluate your fit within the team and company culture.

What to demonstrate

Expect questions that evaluate your fit within the team and company culture
Depth in Communication skills (verbal presentation)

How to prepare

Prepare three examples from your own work, each with a decision you made and an outcome you can quantify.
Re-read the description of the behavioral questions above and write down what you would ask to confirm before it.

Where candidates lose points

Understand the Company Culture

Familiarize yourself with Mohamed Abdulrahman Al-Bahar's mission and values to communicate your alignment effectively during the interview.

Prepare Real-World Examples

Be ready to discuss specific projects or challenges you have faced, highlighting your role and the outcomes achieved.

Practice Technical Skills

Engage in coding exercises or technical assessments to ensure you are well-prepared for practical evaluations.

Show Enthusiasm for Learning

Emphasize your willingness to learn and adapt, which is crucial in the ever-evolving tech landscape.

Questions & practice

Write a function to reverse a string.

Medium · Coding / Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

How would you implement a binary search algorithm?

Medium · Coding / Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

Can you explain the time complexity of your solution?

Medium · Coding / Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

Stop tag and share joins from fanning out a page

Medium · join fan-out · semi-joins · many-to-many

resource_tag is (resource_id, tag_id) with PK (resource_id, tag_id); resource_share is (resource_id, shared_with_user_id, permission). The tagged-and-shared listing inner-joins resource to both, filters tenant_id, tag_id = ANY($2) and shared_with_user_id = $3, orders by updated_at DESC and takes 50. Pages come back with fewer than 50 distinct resources and the total in the header is far too high. Explain the row multiplication, rewrite both the page query and the count query so each is correct, and name the index each one needs. PostgreSQL 16.

Approach

Do the arithmetic against the predicates that are actually there. An inner join emits one row per matching child row, and both joins are filtered: tag_id = ANY($2) admits only the requested tags, shared_with_user_id = $3 admits one user's share rows. So a resource holding three of the requested tags and shared with $3 once yields three rows, not one — the multiplier is its count of matching tags times its share rows for that single user, and that second factor is 1 unless the table admits duplicate (resource_id, shared_with_user_id) pairs. LIMIT 50 then limits rows rather than resources, and COUNT(*) counts pairs — the header is the product, not the population.
Reject DISTINCT as the fix. It deduplicates after the product has been built, so the planner must materialise and sort the fanned-out set before the LIMIT can apply, and it leaves any SUM or AVG in the same select list wrong.
Rewrite both filters as semi-joins, keeping resource as the only row source: AND EXISTS (SELECT 1 FROM resource_tag rt WHERE rt.resource_id = r.resource_id AND rt.tag_id = ANY($2)) and the same shape against resource_share. A semi-join stops at the first match per resource and preserves the driving index order, so ORDER BY updated_at DESC, resource_id DESC LIMIT 50 still stops after 50 rows.
Count with the same predicates and no join at all: SELECT count(*) FROM resource r WHERE r.tenant_id = $1 AND r.status = 'active' AND EXISTS (...) AND EXISTS (...). Nothing multiplies a resource, so the number is the population.

Follow-up

The filter changes from 'any of these tags' to 'all of these tags'. Rewrite it and state what it costs relative to the ANY form.
A resource can be shared with the same user twice under different permissions. Does your count change, and should it?

Replace offset paging on the resource feed with keyset

Easy · keyset pagination · composite index · sort order

resource holds resource_id, tenant_id, owner_user_id, title, body_ref, version, status ('draft','active','archived','deleted'), created_at, updated_at, deleted_at, with an index on (tenant_id, status, updated_at DESC, resource_id DESC). The listing endpoint returns active resources for one tenant, newest update first, 50 per page, today with LIMIT 50 OFFSET n. Tenants reach page 400 and rows are created while they read. Write the keyset query, define what the cursor carries and how it is encoded, and say which part of the index each predicate uses. Assume PostgreSQL 16.

Approach

Name the two failures separately. OFFSET 20000 makes the server produce and discard 20,000 rows, so page cost grows with depth rather than with page size. Independently, any write that changes how many rows sort above the offset moves the window between two fetches, and the direction decides which anomaly you get: an insert lands at the head of updated_at DESC and pushes already-returned rows down past the boundary, so they are returned a second time; a delete above the offset, or a row whose updated_at is bumped above the cursor, pulls rows up and one is never returned at all. Nothing in the response reveals either.
Write the seek: WHERE tenant_id = $1 AND status = 'active' AND (updated_at, resource_id) < ($2, $3) ORDER BY updated_at DESC, resource_id DESC LIMIT 50. The row-value comparison is one index range rather than a disjunction, and both columns are NOT NULL, which is what makes that comparison well defined.
Map each predicate onto the index: tenant_id and status are equality on the leading columns, (updated_at, resource_id) is the range, and the ORDER BY matches the index order so no Sort node appears and the scan stops after 50 rows. The DESC in the definition only matters for mixed directions — a plain ascending btree on the same columns is read backwards for this query.
Put both sort columns in the cursor and nothing the client can tamper with into another tenant: base64 of (updated_at, resource_id), validated server-side, with tenant_id taken from the principal.

Follow-up

The client asks for 'jump to page 400'. What do you offer instead, and what does the honest version cost?
Sort order becomes user-selectable across four columns. How many indexes is that, and which would you refuse to add?

What programming languages are you proficient in?

Medium · Technical / Domain Questions

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

Can you explain the difference between agile and waterfall methodologies?

Medium · Technical / Domain Questions

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

Describe a challenging technical problem you solved in a past project.

Medium · Technical / Domain Questions

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

How do you ensure code quality in your work?

Medium · Technical / Domain Questions

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

Given a specific problem, how would you architect a solution?

Medium · Problem-Solving / Case Studies

Approach

Fix the scope first: who calls this, how often, and what they do when it fails.
Name the read and write paths separately; they rarely have the same bottleneck.
Choose a partition key and say what query it makes expensive.
State the consistency you need, and where you are willing to be stale.

Follow-up

What breaks first when traffic grows ten times?
How does this behave when that dependency is down for an hour?

Explain how you would optimize a slow-running application.

Medium · Problem-Solving / Case Studies

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

Discuss a past project where you had to adapt your solution based on feedback.

Medium · Problem-Solving / Case Studies

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

How would you approach debugging a production issue?

Medium · Problem-Solving / Case Studies

Approach

Establish what changed and when, before forming any theory.
Pick a bisection that eliminates candidates whichever way it turns out.
Check the instrumentation before believing the symptom.
Separate the trigger from the cause; the deploy is rarely the bug.

Follow-up

What would you look at first, and what would it rule out?
How would you tell a cause from a coincidence here?

Suggested practice checklist

Built from the rounds and topics Mohamed Abdulrahman Al-Bahar candidates report.

Day 1 — Map the Mohamed Abdulrahman Al-Bahar loop

Write out the reported sequence: Resume Review, Multiple Interview Rounds, Technical Assessments, Behavioral Questions.
For each round, write one sentence on what it is judging, from the description above, and mark the one you are least ready for.

Deliverable: A one-page map of the 4 reported rounds, with the weakest marked.

Day 2 — Work Communication skills (verbal presentation)

Spend the session on Communication skills (verbal presentation), which Mohamed Abdulrahman Al-Bahar candidates report being tested on.
Write one worked example in Communication skills (verbal presentation) and time yourself on it.

Deliverable: One timed worked example in Communication skills (verbal presentation).

Day 3 — Work Technical interview preparation

Spend the session on Technical interview preparation, which Mohamed Abdulrahman Al-Bahar candidates report being tested on.
Write one worked example in Technical interview preparation and time yourself on it.

Deliverable: One timed worked example in Technical interview preparation.

Day 4 — Work Problem solving (technical Q&A)

Spend the session on Problem solving (technical Q&A), which Mohamed Abdulrahman Al-Bahar candidates report being tested on.
Write one worked example in Problem solving (technical Q&A) and time yourself on it.

Deliverable: One timed worked example in Problem solving (technical Q&A).

Day 5 — Answer out loud: Technical / Domain Questions

Answer aloud, timed: What programming languages are you proficient in?
Answer aloud, timed: Can you explain the difference between agile and waterfall methodologies?

Deliverable: Spoken answers to 2 reported Technical / Domain Questions question(s), under time.

Day 6 — Answer out loud: Behavioral / Leadership

Answer aloud, timed: Describe a time when you faced a conflict in a team setting. How did you handle it?
Answer aloud, timed: What motivates you to perform well in your job?

Deliverable: Spoken answers to 2 reported Behavioral / Leadership question(s), under time.

Day 7 — Answer out loud: Problem-Solving / Case Studies

Answer aloud, timed: How would you approach debugging a production issue?
Answer aloud, timed: Given a specific problem, how would you architect a solution?

Deliverable: Spoken answers to 2 reported Problem-Solving / Case Studies question(s), under time.

Behavioural preparation

Behavioural rounds judge the decision you made and what it cost.

What is your experience with version control systems?

Medium · Technical / Domain Questions

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?