Consultant as Database Management System (DBMS) Developer for Social Forestry

Information Technology Palembang, Indonesia

Program Overview

WRI Indonesia has strong commitment to provide supports to the Social Forestry (SF) initiative of Government of Indonesia that exists as an approach to overcome poverty problem in villages inside and around forest area, while also ensuring that the forests will be managed sustainably. WRI Indonesia supports particularly in understanding the indicators or success criteria for SF schemes, assessing the challenges and enabling factors of SF initiative, and examining the effectiveness of SF implementation at regional level. During the process of supporting SF initiative, WRI Indonesia understands that local government, forest management units (KPHs), SF working group (POKJA PPS), SF assistants, farmer groups, and other relevant SF stakeholders require valid and updated SF related-data to implement and accelerate its SF initiative.


Considering the importance of SF database for SF stakeholders, WRI Indonesia initiates the development of Social Forestry Database Management System (SF-DBMS) of South Sumatra to provide online-platform for collecting and analyzing SF related-data, as well as disseminating the information of social forestry implementation in South Sumatra. The SF-DBMS of South Sumatera has also been one of main activities planned by the POKJA PPS of South Sumatra to support the SF program of Forestry Service (Dinas Kehutanan) and KPHs.


To accelerate the SF-DBMS development in South Sumatra, WRI Indonesia will require IT/IMS professional as DBMS Developer to develop informative and user-friendly SF-DBMS of South Sumatra. The DBMS Developer will be based in Palembang, and responsible to provide technical and operational expertise to examine the SF-DBMS system requirements, design and develop the system, produce technical guidelines, and involve in SF-DBMS related trainings and workshop. Reporting to the South Sumatra Senior Program Lead of WRI Indonesia, he/she will be working in collaboration with a SF Data Analyst of WRI Indonesia and Database Specialist of POKJA PPS. He/she should also coordinate with the regional team and other key personnel of the projects, and will liaise with the partners implementing similar programs as well as relevant agencies of the Government, local authorities, and civil society.


Job Responsibilities

The main areas of responsibility will include the following:

Technical Works and Research

  • Develop object-oriented analysis and design (OOAD) document of SF-DBMS, which includes activity diagram, functional and non-functional requirements, system architecture, data flow diagram, use case diagram, database design (table, form, query, etc), and other elements.
  • Design user interface and user experience (UI/UX) that accommodates four levels of users (i.e. super administrator, administrator, data entry users, and public users).
  • Develop prototype of SF-DBMS of South Sumatra as planned in the OOAD Document and UI/UX design.
  • Design and conduct survey on user-admin response to prototype of SF-DBMS.
  • Install and configure the SF-DBMS into designated server and integrate its system into existing website.
  • Develop user-admin technical guidelines or manual book of SF-DBMS.

Project Management and Communications

  • Collaborate closely with SF Data Analyst in designing the SF-DBMS.
  • Liaise closely with Senior GIS/IMS Analyst for technical and operational aspects of SF-DBMS development.
  • Participate in meetings and trainings with prospective users, admin and other SF stakeholders, and present the progress (if needed).
  • Develop minutes of meeting, activity report, and other relevant documents to support SF-DBMS development.
  • Other duties that may be assigned.





Document / Output


Portion of Work

Develop object-oriented analysis and design (OOAD) document of SF-DBMS

Object-oriented analysis and design (OOAD) document of SF-DBMS

Week 2 of November 2020

50 %

Design user interface and user experience (UI/UX) of SF-DBMS

UI/UX Design of SF-DBMS

Week 2 of November 2020

Develop prototype of SF-DBMS

-    Database design (table, form, query, etc)

-    Prototype of SF-DBMS of South Sumatra

Week 4 of December 2020

Design and conduct survey on user-admin response to prototype of SF-DBMS

Report on user-admin's response survey

Week 1 of December 2020

Install and configure the SF-DBMS (including bug-fixing as user-admin response)

SF-DBMS installed in the designated server and integrated in SF Website

Week 3 of December 2020

50 %

Develop user-admin technical guidelines or manual book of SF-DBMS

User-admin manual book of SF-DBMS

Week 4 of December 2020


Job Qualifications

Required Qualifications:

  • Bachelor’s degree computer science, information technology, software engineering, or a related field required;
  • A minimum three years of work experience in database development and programming;
  • Experience in designing UI/UX and developing DBMS.
  • Strong inter-personal skills, working with people from a variety of backgrounds;
  • High attention to details, well organized, and strong analytical skills;
  • Self-motivated and able to work independently and as a team player; and
  • Excellent oral and written communication skills.


Preferred Qualifications:

  • Having experience on building information system on forestry or environment sector.
  • Experience in using one of the HTML5, web technologies, JavaScript, Bootstrap, jQuery and creating web services;
  • Experience in using PHP web framework such as CodeIgniter, Laravel, Zend, FuelPHP, etc;
  • Experience in using database server POSTGRESQL and MYSQL;
  • Preferably those with experience in Linux environment;
  • Has knowledge of .NET, SQL, and C #;
  • Always keep abreast of the latest technology and web trends; and
  • Fluency in Bahasa Indonesia and English.


Period of Work

The duration of the service is 2 months (1 November 2020 – 31 December 2020). Detailed work plan will be discussed with WRI Indonesia team following signing of the engagement contract.


Terms of Payment

This work is a consultant scheme where the consultant will receive payment in 2 terms. The first term will be paid after 50% of the work is accomplished. The remaining will be paid in the second term after all work is accomplished.



Must have authorization to work in Indonesia to be eligible for this position.


Final candidates might be required to take a writing test and to produce two writing samples when needed.


Consultant rate: Consultant rate is commensurate with experience and skills.


Qualified applicants should apply online through WRI career portal in order to be formally considered. 


Application close: 1700 (Jakarta Time), 3 November 2020. We will close the advert earlier when the best candidates are identified at earlier dates. 


This is a locally engaged position; Indonesian nationals are encouraged to apply.



WRI Overview

World Resources Institute (WRI) is an independent, nonprofit global research organization that turns big ideas into action at the nexus of environment, economic opportunity and human well-being. We are working to address seven critical challenges that the world must overcome this decade in order to secure a sustainable future for people and the planet: climate change, energy, food, forests, water, sustainable cities, and the ocean. We are passionate. We value our diversity of interests, skills and backgrounds. We have a flexible work environment. And we share a common goal to catalyze change that will improve the lives of people. Our shared ideals are at the core of our approach. They include: integrity, innovation, urgency, independence and respect. The foundation of our work is delivering high-quality research, data, maps and analysis to solve the world’s greatest environment and international development challenges, and improve people’s lives. We work with leaders in government, business and civil society to drive ambitious action and create change on the ground. Equally important, we bring together partners to develop breakthrough ideas and scale-up solutions for far-reaching, enduring impact.


We have been growing rapidly: our staff has doubled in size over the past 5 years and our operating budget is now $100 million. Founded in 1982, WRI has a global staff of 800+ people with work spanning 60 countries. We have offices in Africa, Brazil, China, Europe, India, Indonesia, Mexico and the United States as well as a growing presence in other countries and regions. 


WRI is committed to advancing gender and social equity for human well-being in our mission and applies this principle to our organizational and programmatic practices.


WRI Indonesia is national entity (Yayasan) associated with the World Resources Institute (WRI), a global environmental research organization that turns big ideas into action at the nexus of environment, economic opportunity, and human well-being. WRI work with various stakeholders in the natural resources sector to support policy and management that are both profitable and sustainable. WRI work with leaders in more than 50 countries for more than 30 years, with offices in Brazil, China, Europe, India, Indonesia, Mexico, and the United States.


Launched in early 2014, WRI Indonesia builds on WRI’s 10-year history in the country and strengthens our impact on the ground. In the short-to-medium term, WRI Indonesia aims to expand its presence and portfolio to include projects in the climate, energy, as well as city and transportation programs.


The World Resources Institute ( is an environmental and development research and policy organization that creates solutions to protect the Earth and improve people’s lives. As an Equal Opportunity Employer, it is WRI’s policy to recruit, hire, and provide opportunities for advancement in all job classifications without regard to race, color, religion, sex, national origin, age, citizenship, marital status, sexual orientation, gender identity, parental status, protected veteran status, or disability. WRI’s global agenda requires a staff that is diverse – with respect to race, gender, cultural, and international background. Diverse perspectives and experience enhance the way WRI selects and approaches issues, as well as the creativity and applicability of WRI's policy research and analysis. WRI, therefore, encourages applications from U.S. minorities, persons from other countries (especially developing nations), and from women of all backgrounds.