Information for Applicants – Locally Engaged Staff
Information for Applicants – Locally Engaged Staff (KOMPAK)
Position Title:
Onsite Consultant for Database Engineer for SIKD Development
Position Location:
Jakarta , Indonesia
Position Type:
STA
Contract Duration
7 Months
Estimated Start Date:
15 June 2016
Application Closing Date:
15 May 2016
Overview Thank you for your interest in the position of Onsite Consultant for Database Engineer for SIKD Development with the KOMPAK Program, as managed by Abt JTA on behalf of the Australian Government. This document includes information on the following:
Program Overview;
Introduction to Abt JTA;
Application process;
Terms of Reference; and
Key Selection Criteria.
Please read this document carefully as applications that vary from the specified requirements may not be accepted. Program Overview KOMPAK is a large and complex program that is uniquely placed to add value to the Government of Indonesia’s own efforts to improve the social and economic conditions of its citizens; it is aimed at economic expansion and poverty reduction in Indonesia. Abt JTA is supporting frontline services—including health and education—while identifying governance constraints. The work accompanies implementation of Village Law, new national rules that empower local communities and increase the direct flow of money to village governments and services. KOMPAK seeks to strengthen the capacity of all levels of government to improve services, respond to citizen needs and contribute to stable prosperity. Abt JTA – Who We Are Abt JTA is a global development consulting firm with over 10 years’ experience operating within the health and social sectors in the Australian and Asia-Pacific region. We are a company that has a personal commitment to its staff and as such we value the long-term
Page 1 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
relationships that we build with the people who work with us. For more information about our company and what we do visit our website at www.abtjta.com.au. Our Values Mission-Driven. We are united by our mission to improve the lives of people worldwide. Global. We are a global community, bringing diverse knowledge, expertise, and perspectives to the many challenges faced by today's world. Committed to Excellence. We strive to meet and exceed the highest professional standards. Collaborative. We know that working collaboratively produces excellence. Accountable. We take responsibility for what we do and how we do it. Balanced. We sustain the energy and commitment we bring to our roles by promoting a healthy balance between our personal and professional lives. Preparing Your Application Please read the following information carefully as incomplete applications may not be accepted. To submit an application: 1.
Visit the Abt JTA website (www.abtjta.com.au) and navigate to the ‘Careers’ section.
2.
Locate the position you are applying for and select ‘Job Details’.
3.
Click on the ‘Apply Online’ button and follow the prompts.
It should take between 10-20 minutes for you to complete the online application. Before submitting your application it is recommended that you have the following documentation prepared so that these can be readily uploaded during the application process: 1.
An electronic version of your CV in MS Word or PDF format (less than 3MB);
2.
A statement addressing the key selection criteria (maximum 3 pages). This document should clearly describe how your skills, experience and qualifications will enable you to meet the requirements of the position; and
3.
Details of at least 3 professional referees (preferably your current supervisor and 2 previous supervisors).
Other Points to Consider:
Page 2 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
1.
You will need to submit a separate application for each position that you apply for.
2.
If you are successful in being short-listed or are selected for this position you may be required to undertake a police check, psychometric test and/or a medical examination.
3.
Only short-listed candidates will be contacted.
4.
Women are encouraged to apply.
Lodging Your Application: All applications should be submitted online through our website at: www.abtjta.com.au. Should you experience any difficulties with the submission process, or have any questions about this role then please contact: Contact Name:
KOMPAK HR Team
Email:
[email protected]
Closing Date:
13 May 2016
Page 3 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
Terms of Reference The Services that the successful candidate is to provide include, but are not limited to, fulfilling the following Terms of Reference: Position Title: Onsite Consultant for Database Engineer for SIKD Development
Nama Jabatan: Konsultan onsite Database Engineer Sistem Informasi Keuangan Daerah (SIKD)
Location: Jakarta, Indonesia
Lokasi: Jakarta, Indonesia
Reporting To: Melapor Kepada: 1. Head of Sub Directorate of Technical 1. Kasubdit Informasi dan Dukungan Support and Information of Directorate Teknis Direktorat Jenderal General of Fiscal Balance Ministry of Perimbangan Keuangan Finance 2. Responsive Government Lead 2. Responsive Government LEAD KOMPAK KOMPAK Abt JTA Values The incumbent must demonstrate a high level of commitment to following values of Abt JTA: Mission-Driven We are united by our mission to improve the lives of people worldwide. Global We are a global community, bringing diverse knowledge, expertise, and perspectives to the many challenges faced by today's world.
Committed to Excellence We strive to meet and exceed the highest professional standards. Collaborative We know that working produces excellence.
Global Kami merupakan masyarakat global, yang menghadirkan pengetahuan, keahlian dan perspektif yang beragam guna mengatasi berbagai tantangan yang dihadapi dunia saat ini. Komitmen pada Keunggulan Kami berupaya untuk mencapai dan melampaui standar profesional yang tertinggi.
collaboratively
Accountable. We take responsibility for what we do and how we do it. Balanced. We sustain the energy and commitment we
Page 4 Version 1.5_13/11/2015
Nilai-nilai Abt JTA Pihak yang menjabat harus memperlihatkan tingkat komitmen yang tinggi terhadap nilainilai Abt JTA berikut ini: Didorong oleh Misi Kami dipersatukan oleh misi yang sama untuk meningkatkan kehidupan manusia di seluruh dunia.
Kolaboratif Kami tahu bekerja secara kolaboratif akan menghasilkan keunggulan. Akuntabel Kami bertanggungjawab atas apa yang kami lakukan dan bagaimana kami melakukannya.
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
bring to our roles by promoting a healthy balance between our personal and professional lives.
Seimbang Kami menjaga energi dan komitmen yang kami bawa dalam peran kami masingmasing dengan mempromosikan keseimbangan yang sehat antara kehidupan personal dan professional kami.
Project Summary:
Ringkasan Proyek:
KOMPAK (Governance for Growth) is a large and complex program that is uniquely placed to add value to the Government of Indonesia’s own efforts to improve the social and economic conditions of its citizens; it is aimed at economic expansion and poverty reduction in Indonesia. Abt JTA is supporting frontline services—including health and education—while identifying governance constraints. The work accompanies implementation of Village Law, new national rules that empower local communities and increase the direct flow of money to village governments and services. KOMPAK seeks to strengthen the capacity of all levels of government to improve services, respond to citizen needs and contribute to stable prosperity.
KOMPAK (Kolaborasi Masyarakat dan Pelayanan untuk Kesejahteraan) merupakan sebuah program yang besar dan sangat kompleks dan ditempatkan sedemikian uniknya sehingga menjadikan nilai tambah terhadap usaha-usaha Pemerintah Indonesia sendiri dalam meningkatkan kondisi sosial dan ekonomi dari warga negaranya; yang ditujukan pada perluasan ekonomi dan penanggulangan kemiskinan di Indonesia. Abt JTA mendukung penyelenggaraan pelayanan dasar – termasuk kesehatan dan pendidikan – sambil mengidentifikasi hambatan dan kendala yang ada dalam tata kelola. Pekerjaan ini akan mendampingi implementasi Undang-Undang Desa, peraturan nasional baru yang memberdayakan masyarakat lokal dan meningkatkan pengarusan uang langsung ke pemerintahan dan pelayanan desa. KOMPAK berusaha untuk memperkuat kapasitas di semua tingkat pemerintahan guna meningkatkan pelayanan, memberikan tanggapan akan kebutuhan-kebutuhan warganya serta memberikan kontribusi demi stabilitas kemakmuran.
Purpose
Tujuan
The key purpose of this position is to support the Ministry of Finance - Directorate General of Fiscal Balance in enhancing database performance and building the database report needed for decision making for executive in Ministry of Finance
Tujuan utama dari rekruitmen ini adalah untuk mendapatkan konsultan yang dapat membantu Kementerian Keuangan (c.q. Direktorat Jenderal Perimbangan Keuangan/DJPK) dalam meningkatkan performa database SIKD dan membantu pengembangan database pelaporan sesuai dengan informasi atau laporan yang dibutuhkan pimpinan Kementerian Keuangan untuk kebutuhan pengambilan
The consultant will work with DJPK staff in developing procedures and databases (joint development). This collaboration is necessary condition to provide relevant
Page 5 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
information for consultant to identify critical SIKD reporting requirement in a comprehensive manner. Consultant’s output will contribute to development of SIKD with enterprise architect. During the SIKD improvement process, KOMPAK and DJPK will conduct evaluation on an ongoing basis to ensure quality of output that has been developed, and meet the requirements.
keputusan dalam perumusan desentralisasi fiscal.
kebijakan
Konsultan akan melakukan peningkatan performa database dan pengembangan database pelaporan bersama pegawai DJPK dengan mekanisme Joint Development. Kolaborasi diperlukan agar Konsultan mampu mengidentifikasi critical requirement pelaporan SIKD secara komprehensif. Output dari konsultan akan berkontribusi pada pengembangan SIKD berbasis enterprise architect. Selama proses penyempurnaan SIKD, DJPK dan KOMPAK akan melakukan evaluasi secara berkesinambungan untuk memastikan kualitas output yang telah dikembangkan serta mampu memenuhi kebutuhan.
Job Specification / Responsibilities
Spesifikasi Tugas / Tanggungjawab
Will be responsible for the following duties:
Konsultan bertanggung jawab untuk melakukan tugas sebagai berikut: 1. Melakukan identifikasi, review performance dan review konfigurasi atas database yang ada dan database yang akan digunakan untuk pelaporan SIKD; 2. Melakukan tuning, balancing dan enhancing untuk peningkatan performance database SIKD; 3. Menyiapkan mekanisme failover dan high-availability database SIKD; 4. Mengembangkan mekanisme backuprestore database SIKD; 5. Merancang dan membangun Database Staging yang dibutuhkan untuk kebutuhan pelaporan; 6. Merancang dan mengimplementasikan mekanisme Extract Transform Load (ETL) dari database sumber ke database tujuan 7. Merancang dan membangun Database OLAP dan database Pelaporan 8. Melakukan transfer knowledge dan know how terkait pembangunan, penggunaan, pemeliharaan, serta pengembangan Pelaporan Data SIKD; 9. memberikan solusi dan rekomendasi terhadap masalah yang relevan yang dikelola sehari-hari oleh client
1. Identify, review performance and review configuration of existing SIKD databases; 2. Perform tuning, balancing and enhancing for increasing performance SIKD databases; 3. Preparing failover mechanism and highavailability database SIKD; 4. Design database backup-restore mechanism; 5. Design and implementing database staging needed for reporting; 6. Design and implementing Extract Transform Load (ETL) mechanism; 7. Design and implementing database OLAP and database reporting; 8. Delivering transfer of knowledge and transfer of know-how from SIKD Core application that had been developed; 9. Recommend solution for any daily problem found in client 10. Maintain nondisclosure for any data and information confidentiality for all work activity 11. Undertake any other tasks assigned by the Project Manager.
Page 6 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
10. Menjaga kerahasiaan data dan informasi atas semua aspek pekerjaan; 11. Melakukan tugas-tugas lain yang diberikan oleh Project Manager. Deliverables
Capaian
The following deliverables will be submitted refer to work plan prepared by consultant at least after 2 weeks from mobilization and approved by DJPK and KOMPAK. These are deliverables:
Capaian berikut disampaikan oleh konsultan mengacu pada rencana kerja yang disusun oleh konsultan setidaknya dua minggu dari mobilisasi dan disetujui oleh DJPK dan KOMPAK. Capaian yang harus dihasilkan oleh konsultan:
1. Work plan 2. Identification, performance and configuration review 3. Enhancing database performance review 4. ERD for database staging and database reporting 5. SIKD Data Reporting Requirement Reports; 6. Detailed documentation for each phase of work; 7. Standard/Baseline for Future Database Development
1. Rencana kerja 2. Laporan Identifikasi, Review Performa dan Review Konfigurasi database SIKD 3. Laporan DBA untuk Peringkatan Performa Database SIKD 4. ERD untuk rancangan database staging dan database pelaporan SIKD 5. Laporan Kebutuhan Pelaporan Data SIKD; 6. Dokumentasi Rinci Untuk Setiap Tahapan pekerjaan dalam Spesifikasi Tugas/ Tanggungjawab yang dilakukan; 7. Dokumen Standar Pengembangan Database;
Core Competencies
Kompetensi Utama
1. Delivers Results
1. Memberikan Hasil
2. Builds Internal and External Customer Satisfaction and Loyalty
2. Membangun Loyalitas dan Kepuasan Pelanggan Internal dan Eksternal
3. Develops People
3. Mengembangkan Orang
4. Communicates
4. Melakukan komunikasi
5. Sets Vision and Direction
5. Menetapkan Visi dan Arah
6. Demonstrates Sound Financial and Business-Related Practices
6. Menunjukkan Praktek Keuangan dan Praktek Terkait Bisnis yang Baik
7. Builds Teams and Cooperation
7. Membangun Tim dan Kerjasama
8. Promotes Technical Excellence and Quality
8. Mempromosikan Mutu dan Keunggulan Teknis
9. Promotes Diversity
9. Mempromosikan Keragaman
10. Acts as a Role Model
10. Bertindak sebagai Panutan
Page 7 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
Information for Applicants – Locally Engaged Staff
Key Selection Criteria For your application to be considered by the panel, interested applicants must submit a response to each of the following Key Selection Criteria: KSC 1. Educational background of informatics system, informatics technology, statistics, or mathematics with three years relevant working experiences or have proof of the capability to complete any relevant task given with five years experiences KSC 2. Have experience of working as a Database Administrator at least 5 years with various RDBMS database platform such as PostgreSQL, MSSQL and MySQL in Windows or Linux Environment KSC 3. Have experience design the database, build ERD, and implementing database design to database engine in many RDBS platform KSC 4. Have experience design and implementing database staging and OLAP database KSC 5. Mastering concepts and practical process of database backup-restore, database tuning performance, database clustering for high-availability, database replication or database mirroring KSC 6. Recommend solution for any daily problem found in client KSC 7. Have experience for working in many operating system environments such as Windows and Linux (especially Redhat/Centos)
If no response to the above Key Selection Criteria is made, applications will not be considered further.
Page 8 Version 1.5_13/11/2015
Commercial in Confidence © Abt JTA
