Procurement Advisor job at VVOB Zambia - Education for Development
Website :
21 Days Ago
Linkedid Twitter Share on facebook
Procurement Advisor
2025-04-17T17:39:13+00:00
VVOB Zambia - Education for Development
https://www.greatzambiajobs.com/jsjobsdata/data/employer/comp_6679/logo/VVOB%20Education%20for%20Development.png
FULL_TIME
 
Lusaka
Lusaka
10101
Zambia
Education, and Training
Transportation & Logistics
ZMW
 
MONTH
2025-05-01T17:00:00+00:00
 
Zambia
8

VVOB– Education for development is an international non-profit organisation with over 40 years’ experience in strengthening the quality of education systems in Africa, Asia and South America in close partnership with ministries of education and their institutions. Our head office is based in Brussels, Belgium.

We implement our programmes and projects with one shared passion: to ensure the improvement of quality education.

Do you share our ambition to ensure that learners around the world can enjoy their fundamental human right to quality education, without exception? Are you convinced as well that quality education guarantees equal opportunities for everyone and is the key to a better world?

Are you interested and eager to find out if you are a fit for this position? Then check the specifications outlined in this vacancy. We are looking for a Procurement Advisor who will operate from our office in  Zambia.

Do you want to take on this challenge? Continue reading!

Responsibilities of the Procurement Advisor:

  • As Procurement Advisor you contribute to VVOB’s ambitions and values by overseeing the procurement agenda in Zambia and ensuring high quality and timely implementation of procurement processes in line with donor requirements and VVOB standard operating procedures and policies.
  • The Procurement Advisor will report to the Operations Manager and thus be a part of the operations team.
  • You are the lead on all procurements in VVOB Zambia and will thus coordinate all procurements in country. This includes preparing terms of references, examining, and evaluating tenders, writing awards reports and supporting contract management.

You will:

  • You lead and oversee the procurement agenda for VVOB Zambia, coordinating procurement needs from different departments and translating these into a feasible country procurement plan.
  • You coordinate all procurement related matters based on this plan. You lead the procurement processes in line with donor and VVOB procurement policies and guidelines and ensure a qualitative and timely implementation and execution of all procurements.
  • You ensure qualitative contract management, including framework agreements, ensuring procurement contracts are finalised in a correct way and follow up of existing contracts.
  • You keep abreast with procurement laws and regulations and take the lead in continuous improvement, knowledge building and knowledge sharing on procurement within the team and procurement colleagues in Zambia and globally.
  • You also follow up and execute specific procurement processes, including preparing terms of references, examining, and evaluating tenders, drawing up award decisions and notification letters and supporting contract management including framework agreements.
  • You ensure integrity, fairness, accuracy, and transparency in procurement processes
  • Through market research efforts, you identify and qualify potential suppliers (and products/services). Ensure that beneficial, ethical, and open supplier relationships are created and maintained.

If you’re our Procurement Advisor, your workweek at the office may include the following highlights:

  1. Together with the Operations Manager, you discuss updates, on procurement guidelines, on the Zambian procurement handbook to verify if the updates are fully in line with the VVOB global guidelines.
  2. You have a meeting with the Project Coordinators to understand their upcoming procurement needs and to ensure that they are still in line with the procurement plans to ensure the procurement needs of the projects can be met in a qualitative and timely manner.
  3. You support the programmes team on the qualitative review from a recent call for quotations and finalise on the technical review, bringing it together in an award report for the sign off of the Country Programmes Manager.
  4. Lunch! A perfect time to catch up with your colleagues and get informal feedback of current service providers.
  5. You engage with the Finance Officers to ensure that you are aligned on the vendor balances and upcoming payments.
  6. You meet with vendors that we have framework agreements with to discuss concerns raised by staff and some concerns raised by the provider to ensure a smooth working relationship.

Who are you?

This position is open to Zambian Nationals.

Your expertise and experience :

  • Master’s degree in Purchasing and Supply, Finance/Business management/CIPS (6) or other relevant field or equivalent experience
  • Registered practicing member with the Zambia Institute of Purchasing and Supply.
  • All professional and Academic qualifications must be verified by ZAQA.
  • Profound experience in operations, specifically in coordinating procurement preferably in an INGO
  • Excellent computer skills in MS Office, Excel, Power point, Teams and other operations systems
  • Understanding of donor requirements and experience of compliance is an asset
  • Experience of effectively setting up and implementing framework agreements for goods and services
  • Skilled in vendor selection, negotiation, contracting, performance monitoring and building ethical vendor relationships.
  • Experienced in training and mentoring operations teams and field staff, and in implementing, SOPs, and systems to strengthen procurement capacity across various project locations.
  • Fluent in English.

VVOB core competences:

  • Results and goal oriented
  • Lifelong learning and improvement
  • Cooperation within a team and with other stakeholders

Function specific competencies:

  • Reliability
  • Development Oriented
  • Communication Skills
  • Problem Analysis and Judgement and planning and Organization

What we’re offering:

  • A dynamic working environment in an international context.
  • An exciting job in a growing organisation with varied responsibilities and opportunities for professional development.
  • An opportunity to contribute to exciting, evidence-based projects aimed at ensuring the education sector in Zambia is strengthened, by bringing in innovative solutions for professional development of school leaders and teachers.
  • A complete remuneration package, which includes a base salary and benefits.
  • A national contract to 31/12/2026.
As Procurement Advisor you contribute to VVOB’s ambitions and values by overseeing the procurement agenda in Zambia and ensuring high quality and timely implementation of procurement processes in line with donor requirements and VVOB standard operating procedures and policies. The Procurement Advisor will report to the Operations Manager and thus be a part of the operations team. You are the lead on all procurements in VVOB Zambia and will thus coordinate all procurements in country. This includes preparing terms of references, examining, and evaluating tenders, writing awards reports and supporting contract management. You will: You lead and oversee the procurement agenda for VVOB Zambia, coordinating procurement needs from different departments and translating these into a feasible country procurement plan. You coordinate all procurement related matters based on this plan. You lead the procurement processes in line with donor and VVOB procurement policies and guidelines and ensure a qualitative and timely implementation and execution of all procurements. You ensure qualitative contract management, including framework agreements, ensuring procurement contracts are finalised in a correct way and follow up of existing contracts. You keep abreast with procurement laws and regulations and take the lead in continuous improvement, knowledge building and knowledge sharing on procurement within the team and procurement colleagues in Zambia and globally. You also follow up and execute specific procurement processes, including preparing terms of references, examining, and evaluating tenders, drawing up award decisions and notification letters and supporting contract management including framework agreements. You ensure integrity, fairness, accuracy, and transparency in procurement processes Through market research efforts, you identify and qualify potential suppliers (and products/services). Ensure that beneficial, ethical, and open supplier relationships are created and maintained. If you’re our Procurement Advisor, your workweek at the office may include the following highlights: Together with the Operations Manager, you discuss updates, on procurement guidelines, on the Zambian procurement handbook to verify if the updates are fully in line with the VVOB global guidelines. You have a meeting with the Project Coordinators to understand their upcoming procurement needs and to ensure that they are still in line with the procurement plans to ensure the procurement needs of the projects can be met in a qualitative and timely manner. You support the programmes team on the qualitative review from a recent call for quotations and finalise on the technical review, bringing it together in an award report for the sign off of the Country Programmes Manager. Lunch! A perfect time to catch up with your colleagues and get informal feedback of current service providers. You engage with the Finance Officers to ensure that you are aligned on the vendor balances and upcoming payments. You meet with vendors that we have framework agreements with to discuss concerns raised by staff and some concerns raised by the provider to ensure a smooth working relationship.
Results and goal oriented Lifelong learning and improvement Cooperation within a team and with other stakeholders Function specific competencies: Reliability Development Oriented Communication Skills Problem Analysis and Judgement and planning and Organization
Master’s degree in Purchasing and Supply, Finance/Business management/CIPS (6) or other relevant field or equivalent experience Registered practicing member with the Zambia Institute of Purchasing and Supply. All professional and Academic qualifications must be verified by ZAQA. Profound experience in operations, specifically in coordinating procurement preferably in an INGO Excellent computer skills in MS Office, Excel, Power point, Teams and other operations systems Understanding of donor requirements and experience of compliance is an asset Experience of effectively setting up and implementing framework agreements for goods and services Skilled in vendor selection, negotiation, contracting, performance monitoring and building ethical vendor relationships. Experienced in training and mentoring operations teams and field staff, and in implementing, SOPs, and systems to strengthen procurement capacity across various project locations. Fluent in English.
postgraduate degree
No Requirements
JOB-68013cc19ae9c

Vacancy title:
Procurement Advisor

[Type: FULL_TIME, Industry: Education, and Training, Category: Transportation & Logistics]

Jobs at:
VVOB Zambia - Education for Development

Deadline of this Job:
Thursday, May 1 2025

Duty Station:
Lusaka | Lusaka | Zambia

Summary
Date Posted: Thursday, April 17 2025, Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about VVOB Zambia - Education for Development
VVOB Zambia - Education for Development jobs in Zambia

JOB DETAILS:

VVOB– Education for development is an international non-profit organisation with over 40 years’ experience in strengthening the quality of education systems in Africa, Asia and South America in close partnership with ministries of education and their institutions. Our head office is based in Brussels, Belgium.

We implement our programmes and projects with one shared passion: to ensure the improvement of quality education.

Do you share our ambition to ensure that learners around the world can enjoy their fundamental human right to quality education, without exception? Are you convinced as well that quality education guarantees equal opportunities for everyone and is the key to a better world?

Are you interested and eager to find out if you are a fit for this position? Then check the specifications outlined in this vacancy. We are looking for a Procurement Advisor who will operate from our office in  Zambia.

Do you want to take on this challenge? Continue reading!

Responsibilities of the Procurement Advisor:

  • As Procurement Advisor you contribute to VVOB’s ambitions and values by overseeing the procurement agenda in Zambia and ensuring high quality and timely implementation of procurement processes in line with donor requirements and VVOB standard operating procedures and policies.
  • The Procurement Advisor will report to the Operations Manager and thus be a part of the operations team.
  • You are the lead on all procurements in VVOB Zambia and will thus coordinate all procurements in country. This includes preparing terms of references, examining, and evaluating tenders, writing awards reports and supporting contract management.

You will:

  • You lead and oversee the procurement agenda for VVOB Zambia, coordinating procurement needs from different departments and translating these into a feasible country procurement plan.
  • You coordinate all procurement related matters based on this plan. You lead the procurement processes in line with donor and VVOB procurement policies and guidelines and ensure a qualitative and timely implementation and execution of all procurements.
  • You ensure qualitative contract management, including framework agreements, ensuring procurement contracts are finalised in a correct way and follow up of existing contracts.
  • You keep abreast with procurement laws and regulations and take the lead in continuous improvement, knowledge building and knowledge sharing on procurement within the team and procurement colleagues in Zambia and globally.
  • You also follow up and execute specific procurement processes, including preparing terms of references, examining, and evaluating tenders, drawing up award decisions and notification letters and supporting contract management including framework agreements.
  • You ensure integrity, fairness, accuracy, and transparency in procurement processes
  • Through market research efforts, you identify and qualify potential suppliers (and products/services). Ensure that beneficial, ethical, and open supplier relationships are created and maintained.

If you’re our Procurement Advisor, your workweek at the office may include the following highlights:

  1. Together with the Operations Manager, you discuss updates, on procurement guidelines, on the Zambian procurement handbook to verify if the updates are fully in line with the VVOB global guidelines.
  2. You have a meeting with the Project Coordinators to understand their upcoming procurement needs and to ensure that they are still in line with the procurement plans to ensure the procurement needs of the projects can be met in a qualitative and timely manner.
  3. You support the programmes team on the qualitative review from a recent call for quotations and finalise on the technical review, bringing it together in an award report for the sign off of the Country Programmes Manager.
  4. Lunch! A perfect time to catch up with your colleagues and get informal feedback of current service providers.
  5. You engage with the Finance Officers to ensure that you are aligned on the vendor balances and upcoming payments.
  6. You meet with vendors that we have framework agreements with to discuss concerns raised by staff and some concerns raised by the provider to ensure a smooth working relationship.

Who are you?

This position is open to Zambian Nationals.

Your expertise and experience :

  • Master’s degree in Purchasing and Supply, Finance/Business management/CIPS (6) or other relevant field or equivalent experience
  • Registered practicing member with the Zambia Institute of Purchasing and Supply.
  • All professional and Academic qualifications must be verified by ZAQA.
  • Profound experience in operations, specifically in coordinating procurement preferably in an INGO
  • Excellent computer skills in MS Office, Excel, Power point, Teams and other operations systems
  • Understanding of donor requirements and experience of compliance is an asset
  • Experience of effectively setting up and implementing framework agreements for goods and services
  • Skilled in vendor selection, negotiation, contracting, performance monitoring and building ethical vendor relationships.
  • Experienced in training and mentoring operations teams and field staff, and in implementing, SOPs, and systems to strengthen procurement capacity across various project locations.
  • Fluent in English.

VVOB core competences:

  • Results and goal oriented
  • Lifelong learning and improvement
  • Cooperation within a team and with other stakeholders

Function specific competencies:

  • Reliability
  • Development Oriented
  • Communication Skills
  • Problem Analysis and Judgement and planning and Organization

What we’re offering:

  • A dynamic working environment in an international context.
  • An exciting job in a growing organisation with varied responsibilities and opportunities for professional development.
  • An opportunity to contribute to exciting, evidence-based projects aimed at ensuring the education sector in Zambia is strengthened, by bringing in innovative solutions for professional development of school leaders and teachers.
  • A complete remuneration package, which includes a base salary and benefits.
  • A national contract to 31/12/2026.

 

Work Hours: 8

Experience: No Requirements

Level of Education: postgraduate degree

Job application procedure
Interested in applying for this job? Click here to submit your application now.

  • Send your motivation letter detailing your match with the profile as well as your motivation behind applying for the vacancy along with your CV by e-mail no later than 1st May 2025  Don’t forget to refer to the job title in the subject line of your e-mail.
  • Before a job offer, shortlisted candidates can expect:
  • 1. A written test
    2. An interview process
  • VVOB firmly believes that quality education can only be achieved if equity is ensured. Qualities of people prevail, regardless of age, gender, ethnicity or disability.

 

All Jobs | QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Logistics/ Transportation/ Procurement jobs in Zambia
Job Type: Full-time
Deadline of this Job: Thursday, May 1 2025
Duty Station: Lusaka | Lusaka | Zambia
Posted: 17-04-2025
No of Jobs: 1
Start Publishing: 17-04-2025
Stop Publishing (Put date of 2030): 17-04-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.348MBMemory Usage719msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "3db05958eac3ae199cd2435da99eee0e" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 4 "timer" => array:3 [ "start" => 1746773071 "last" => 1746773073...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (31.03ms)
  • afterInitialise (11.13MB) (114ms)
  • afterRoute (5.06MB) (40.49ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (294μs)
  • afterRenderComponent com_jsjobs (3.18MB) (74.48ms)
  • Before Access::preloadComponents (all components) (255.64KB) (8.31ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.35ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (25μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (417μs)
  • afterDispatch (2.35MB) (138ms)
  • afterRender (31.56MB) (309ms)
  • 1 x afterRender (31.56MB) (43.05%)
    309.39ms
    1 x afterDispatch (2.35MB) (19.2%)
    137.99ms
    1 x afterInitialise (11.13MB) (15.86%)
    113.96ms
    1 x afterRenderComponent com_jsjobs (3.18MB) (10.36%)
    74.48ms
    1 x afterRoute (5.06MB) (5.63%)
    40.49ms
    1 x afterLoad (4.12MB) (4.32%)
    31.03ms
    1 x Before Access::preloadComponents (all components) (255.64KB) (1.16%)
    8.31ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.19%)
    1.35ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    417μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    294μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    25μs
89 statements were executed, 23 of which were duplicates, 66 unique57.64ms350.25KB
  • SELECT @@SESSION.sql_mode;81μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?207μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1130μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id119μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`112μs1.55KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest151μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'149μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`89μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'172μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config148μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'127μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'79μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'80μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'83μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC277μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC301μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id204μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'352μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'272μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'237μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'341μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'97μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'94μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'263μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 756355.2ms92.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'328μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 7563528.09ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'309μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering389μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'269μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering288μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'253μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'296μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'86μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'72μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'269μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'254μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'82μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'87μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2181μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2166μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'694μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'722μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2185μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2164μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2168μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'263μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'316μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'266μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering230μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)804μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0149μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22154μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24138μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28114μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 383.89ms73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40140μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0199μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft467μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft363μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft529μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635' AND `published` = 1201μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635'105μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration392μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'235μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field214μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'147μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1220μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'247μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`405μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'153μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc274μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`441μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid145μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid145μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Procurement-Advisor-job-at-VVOB-Zambia-Education-for-Development-75635'153μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 183μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"458μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.18ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin197μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin144μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`153μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'123μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'300μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 667978μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?96μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?121μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy