43 Database Engineer jobs in Indonesia

Key Responsibilities

● Database Administration & Operations

○ Administer and support Snowflake and PostgreSQL databases (core requirement).

○ Manage users, security policies, roles, and connectivity.

○ Perform proactive monitoring, capacity planning, and health checks.

● Backup, Recovery & Disaster Preparedness

○ Design and implement backup/restore strategies.

○ Define and meet RTO (Recovery Time Objective) and RPO (Recovery Point Objective).

○ Conduct periodic disaster recovery testing.

● Performance Tuning & Optimization

○ Optimize queries, indexes, and schema design.

○ Troubleshoot bottlenecks and improve workload performance.

○ Implement cost and storage optimization strategies.

● Best Practices & Data Management

○ Enforce database security, auditing, and compliance standards.

○ Apply data compression and storage optimization techniques.

○ Automate recurring DBA tasks for efficiency and consistency.

Required Skills & Qualifications

● Mandatory:

○ Proven expertise in Snowflake and PostgreSQL administration.

○ Strong knowledge of backup/recovery, RTO/RPO, and disaster recovery.

○ Hands-on experience with performance tuning, indexing, and query optimization.

○ Solid understanding of data compression and storage optimization.

● Added Advantage:

○ Experience with Amazon Aurora (PostgreSQL/MySQL).

○ Experience with Azure Database (SQL, PostgreSQL, or MySQL).

● Good to Have:

○ Familiarity with Infrastructure as Code (Terraform/CloudFormation/ARM) for DB provisioning.

○ Python or Shell scripting for automation, backups, and monitoring.

Tanggung Jawab:

• Mendesain, membangun, dan mengelola arsitektur database (RDBMS).

• Optimasi query, indexing, dan tuning performa database.

• Menjamin reliability, backup, recovery, dan high availability sistem database.

• Monitoring, troubleshooting, dan capacity planning database.

• Mengelola security, compliance, dan data governance.

• Bekerja sama dengan tim dev/ops untuk integrasi aplikasi dengan database.

• Melakukan Normalize existing database

Kualifikasi:

• Pengalaman minimal 2–3 tahun sebagai Database Engineer / DBA.

• Menguasai SQL tingkat lanjut (PostgreSQL, MySQL, MSSQL).

• Familiar dengan database NoSQL (Redis).

• Pengalaman dalam replication, clustering, sharding.

• Terbiasa dengan cloud database (GCP Cloud SQL, BigQuery).

• Memahami konsep backup & recovery, security, dan performance tuning.

Plus poin jika :

• Menguasai otomasi dengan scripting (Python, Bash).

Role & Responsibilities:

• Actively involved in PSAK 117 / IFRS 17 project for financial and actuarial data processing
• Design and develop efficient and scalable Database Systems (Oracle ODA)
• Develop Stored Procedures, ETL processes, Data Mapping, and Transformation
• Collaborate with Business Analysts, Actuary, Developers, and Finance for data preparation and reporting needs
• Conduct database performance tuning and query optimization
• Ensure data security, integrity, and compliance with regulatory requirements (OJK, PSAK)

Technical Requirements:

• Proficient in SQL Server (SSMS, SSIS, SSRS) and/or Oracle Database
• Experience in Data Warehouse, Data Mart, Reporting Database design
• Strong in writing Stored Procedures, Views, Functions, Triggers, ETL Pipelines
• Exposure to financial or insurance data (IFRS/PSAK) is a plus
• Knowledge in data security, encryption, and disaster recovery

Non-Technical Requirements:

• Detail-oriented, logical, and independent
• Good teamwork and communication
• Responsive to feedback and issues

Minimum Qualifications:

• Bachelor's Degree in IT/Engineering
• Minimum 3 years of experience as a Database Engineer / Developer / Data Analyst
• Having experience in Insurance core applications would be point plus

Role Description :

• Develop, and maintain ETL/ELT pipelines using tools such as Airflow and BigQuery.
• Design and implement tables in Data Warehouse based on Business & Technical Requirements.
• Develop and maintain disaster recovery plans and backup strategies for databases to minimize downtime and data loss in the event of failures.
• Maintain version-controlled configurations for database servers, ensuring consistency and repeatability across environments.
• Automate routine tasks such as database backups, schema migrations, and data archiving to improve operational efficiency.
• Develop database high availability and replication solutions to meet the requirements of critical applications.
• Support data extraction and preparation for internal dashboards and regulatory reports.
• Coordinate with reporting team/stakeholders to ensure data definitions are consistent.
• Assist in cleaning, transforming, and validating datasets for use in BI tools such as Looker.
• Provide occasional help with ad-hoc SQL queries or data exports.

Requirement :

• 5+ years of Experience as a Devops Engineer with a focus on database management.
• Hands-on experience with cloud platforms (AWS or GCP).
• Proficiency in scripting languages such as Go, Shell, and Python for automation tasks.
• In-depth knowledge of database systems such as PostgreSQL, Redis, etc., including configuration, optimization, and troubleshooting.
• Strong understanding of CI/CD practices and tools.
• Experience with disaster recovery strategies (including hands-on backup and recovery experience).
• Experience in configuration management tools (eg, Atlas) for database patching and maintenance automation.

Tanggung Jawab Utama

• Penguasaan Oracle Database versi 11g, 12c, 19c atau lebih tinggi.
• Berpengalaman dalam installasi, konfigurasi, patching, dan upgrade Oracle Database.
• Mampu melakukan backup & recovery dengan RMAN.
• Memahami performance tuning (SQL tuning, database tuning, AWR, ASH, ADDM).
• Menguasai Oracle Data Guard (physical dan logical standby).

• Pengalaman dalam implementasi dan administrasi Oracle GoldenGate (OGG), termasuk:

• Konfigurasi capture & replication.

• Setup extract, pump, dan replicat.
• Troubleshooting latency & error OGG.
• Migrasi database dengan OGG (zero downtime migration).
• Familiar dengan high availability & disaster recovery (HA/DR) konsep.
• Mengerti konsep ogg classic,integrated dan ogghub.
• Memahami konsep keamanan database (user privilege, auditing, encryption).
• Pengalaman bekerja di Linux/Unix environment.
• Pengetahuan dasar tentang cloud database (Oracle Cloud, AWS RDS, atau Azure Database) menjadi nilai tambah.

Keterampilan, Kualifikasi, dan Pengalaman yang Dibutuhkan

• Pendidikan minimal S1 di bidang Teknologi Informasi, Sistem Informasi, atau Ilmu Komputer.
• Memiliki pemahaman yang baik tentang konsep database, RDBMS, serta arsitektur Oracle Database.
• Mampu bekerja secara mandiri maupun dalam tim dengan orientasi pada kualitas dan ketepatan waktu.
• Memiliki kemampuan komunikasi yang baik serta problem solving yang kuat.

JOB DESCRIPTION :

• Develop, and maintain ETL/ELT pipelines using tools such as Airflow and BigQuery.
• Design and implement tables in Data Warehouse based on Business & Technical Requirements.
• Develop and maintain disaster recovery plans and backup strategies for databases to minimize downtime and data loss in the event of failures.
• Maintain version-controlled configurations for database servers, ensuring consistency and repeatability across environments.
• Automate routine tasks such as database backups, schema migrations, and data archiving to improve operational efficiency.
• Develop database high availability and replication solutions to meet the requirements of critical applications.
• Support data extraction and preparation for internal dashboards and regulatory reports.
• Coordinate with reporting team/stakeholders to ensure data definitions are consistent.
• Assist in cleaning, transforming, and validating datasets for use in BI tools such as Looker.
• Provide occasional help with ad-hoc SQL queries or data exports.

REQUIREMENT :

• 5+ years of Experience as a Devops Engineer with a focus on database management.
• Hands-on experience with cloud platforms (AWS or GCP).
• Proficiency in scripting languages such as Go, Shell, and Python for automation tasks.
• In-depth knowledge of database systems such as PostgreSQL, Redis, etc., including configuration, optimization, and troubleshooting.
• Strong understanding of CI/CD practices and tools.
• Experience with disaster recovery strategies (including hands-on backup and recovery experience).
• Experience in configuration management tools (eg, Atlas) for database patching and maintenance automation.

Job Brief
Location: Remote

Program Background
The SKALA Program is a significant Australian investment designed to help Indonesia address regional disparities in development. SKALA will contribute to this objective by strengthening selected elements of Indonesia's large and complex decentralised government system responsible for the delivery of basic services (Layanan Dasar). The SKALA Program's core approach is to facilitate better collaboration (Kolaborasi) between Indonesian government stakeholders, at national and subnational levels, to help realise synergies (Sinergi) that will trigger improved service delivery. Moreover, SKALA will build on, and take to scale, the successes and learning from Australia's previous 19 years of support to Indonesia's decentralised government system. The SKALA Program is to be implemented through the following three pillars:

• Pillar 1: Stronger national level enabling environment for sub-national service delivery.
• Pillar 2: Better sub-national governance for service delivery.
• Pillar 3: Greater participation, representation and influence for women, people with disabilities and vulnerable groups.

SKALA is implemented at the national level with an office in Jakarta and at the subnational level with offices in Aceh, Nusa Tenggara Barat, Nusa Tenggara Timur, Maluku, Gorontalo, Kalimantan Utara, Tanah Papua. In addition to the 3 pillars, SKALA works across 4 general themes of Public Financial Management, Minimum Service Standards, Data and Analysis and GEDSI.

About DT Global Asia Pacific
At DT Global Asia Pacific, we aim to positively impact people's lives through delivery excellence. As a leading implementing partner across Asia and the Pacific, we co-create locally led solutions in partnership with governments, communities, and stakeholders. We bring together talented teams and deep regional expertise to deliver initiatives that promote inclusive economic growth, essential services, and resilient, secure communities. With over 1,500 staff, experts in 22+ countries and more than 60 years of development experience, we tackle complex community, national and transnational challenges — from governance and justice systems to climate resilience, infrastructure and social equity — with innovative thinking and a commitment to long-term impact.

For more information, please see

The Role
Junior Database Engineer will assist SKALA and its government counterparts, especially BAPPENAS and Kementerian Keuangan by providing expertise and technical input on building and maintaining data systems that will support SEPAKAT database and application. The Consultant will construct datasets, build infrastructure for extraction, transformation and loading of data from various data sources including national socio-economic data to support SEPAKAT analysis modules and data integration process. The Consultant will support the continuous development of SEPAKAT analytical intervention ready to be linked with other system application such as SIPD, SIKD and SLR Dashboard. In addition, the Consultant will contribute to the development of system mock-ups integrating SEPAKAT and SIKD data, provide input to sea level rise (SLR) analysis, and assist in designing evidence-based intervention frameworks based on spatial and fiscal data insights.

Click on the link or copy paste it to access the full Terms of Reference for this position:

About You
Specific Responsibilities

• Assemble large-scale survey datasets by leveraging expertise in managing sources such as Susenas, Sakernas, Podes, and other relevant socio-economic data, including data from sectoral ministries (Satu Sehat, Dapodik). This includes extracting key information, cleaning and transforming data and conducting statistical analysis. Identify, design and implement infrastructure for scalability, optimize data delivery and automating manual processes.
• Build required infrastructure for extraction, transformation and loading of data from various data sources using SQL technologies.
• Develop mock ups on SEPAKAT analytical intervention menu ready to be linked with SIPD and SIKD.
• Develop analytical mock-ups that integrate SEPAKAT and SIKD data to support policy and planning processes.
• Perform analytical skills to interpret data, identify trends, patterns, and correlations, and generate actionable insights for different sets of data including Regsosek/DTSEN, Susenas, Sakernas, Podes, and other relevant socio-economic data. Apply statistical methods to draw meaningful conclusions from these datasets.
• Conduct data quality assurance and quality control in SEPAKAT application regularly to ensure data presented of highly standard and can be utilized fully.
• Provide technical expertise and work closely with SKALA-GEDSI team to identify and interpret pattern and trends on specific GEDSI data to ensure data on women, disabilities and vulnerable individual and their needs are available and accurate.
• Provide technical input to national and sub-national regulatory and policies frameworks ensuring coherence and synergy related to GEDSI data integration and utilization.
• Provide technical facilitation to BAPPENAS on the discussion on dataset analysis for SIPD-SEPAKAT integration.
• Work collaboratively with programmers to identify process improvement opportunities, propose system modifications, and data governance mechanism that will ensure GEDSI data are accessible.
• Other tasks as requested by SKALA.

Other Duties

• Comply with DFAT, DT Global and SKALA policies on gender, disability, fraud and anticorruption, child protection, PSEAH and the environment.
• Ensure compliance and adherence to various operational policies, guidelines and manuals issued by DT Global and SKALA.

Job Requirements

• Work environment involves only infrequent exposure to disagreeable elements and minor physical exertion and/or strain.
• Work may require long, and flexible hours as needed. Travel is based on need.

Deliverables

• Technical analysis report on the infrastructure of database that is used in SEPAKAT and other systems such as SIPD and SIKD.
• Technical input on infrastructure for extraction, transformation and loading of data for SEPAKAT.
• Mock-ups on SEPAKAT analytical intervention feature ready to be linked with SIPD and SIKD.
• Develop analytical mock-ups that integrate SEPAKAT and SIKD data to support policy and planning processes. Technical input on national socio-economic data interoperability mechanism and run various exercises for data matching and data checking.
• Guidelines and documented process of consultation.
• Report on GEDSI regarding data analysis and utilisation in the planning process, i.e. RPJMD, Renstra, RPJMDes, RKPD, etc.
• Improved the integration between SEPAKAT, SIPD and SIKD application.
• Input to SEPAKAT monitoring and updating processes.
• Frequently asked questions and answers for SEPAKAT and SIPD.

Relationship Management
The role will be working closely with the Data and Analytics team and Government counterparts, under close coordination and reporting to the Data and Analytic Lead.

Selection Criteria
Essential

• Bachelor degree in Information System, Statistics, with a minimum of 6 years' experience in database, data analysis, information system, research, data science, machine learning including for its utilization in local planning and budgeting processes.
• Proficient in data processing tools: Demonstrate fluency in various data processing tools such as Microsoft Excel, Stata, SAS, R, or Python. Leverage these tools to manipulate and transform data, conduct exploratory data analysis, and implement statistical models.
• Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
• Proficiency in statistics and statistical packages like Excel, STATA, SPSS to be used for dataset analysis
• Adept at using data processing platforms.
• Excellent interpersonal skills and written and verbal communication skills.
• Excellent problem-solving skills.
• Ability to work both independently and as part of a team to achieve goals.

Preferred

• Experienced working with Government of Indonesia.
• Experienced working on community development projects involving government and development partners, especially related to social protection for people with disabilities.

Why join SKALA?
By joining the SKALA, you will be part of an environment where you can collaborate with leading experts from diverse backgrounds, access development programs to achieve your career goals, and be challenged to take a global outlook.
How To Apply
Click the 'Apply Now' button.

Please submit

• Your CV
• A cover letter addressing the selection criteria

APPLICATIONS CLOSE Friday, 5 th September 2025. Max 5 PM Jakarta Time
Encouraging Applications From People With Disabilities
As part of our commitment to inclusion, we actively encourage applications from people with disabilities (PWDs). We are also committed to providing reasonable accommodation throughout the recruitment process and in the workplace to support the success and well-being of employees with disabilities. Candidates requiring any adjustments to participate equitably, may contact SKALA People & Culture unit at and we will work with the candidate to find the right solution. This information is strictly confidential; used solely to strengthen our inclusive hiring efforts and ensure we provide any support needed. Your disclosure will not impact on recruitment decisions.

Should this role be of interest, we encourage you to apply as soon as possible. Kindly note only shortlisted applicants will be contacted.
DT Global is committed to child protection and safeguarding the welfare of children in the delivery of our international development programs. We are committed to Safety and the Prevention of Sexual Abuse and Harassment (PSEAH), and bribery prevention. DT Global is an equal opportunity employer and we encourage women, men, people with diverse backgrounds and people living with disabilities to apply. This program is funded by the Australian Government and Managed by DT Global.

Requirements:

• Memiliki gelar S1 Ilmu Komputer, Teknik Komputer, Teknik Informatika, Statistika atau yang sejenisnya.
• Mendapatkan sertifikasi Data Engineer dari Associate Big Data Engineer, Cloudera Certified Professional Data Engineer, IBM Certified Data Engineer, atau Google Cloud Certified Professional Data Engineer.
• Mengembangkan keterampilan dalam bahasa pemrograman (SQL, NoSQL, Python, Java, R, dan Scala), relational dan non-relational database, sistem ETL (Xplenty, Stitch, Alooma, dan Talend), data storage, automation dan scripting, machine learning, big data tools, data security, serta platform cloud computing (Amazon Web Services, Google Cloud Platform, dan Microsoft Azure).
• Membuat portofolio proyek data engineering di Wix, Squarespace, atau GitHub untuk semakin menambah kesempatan diterima.
• Penempatan: Cengkareng, Jakarta Barat.

Job Descriptions:

• Mengelola, memelihara, dan mengamankan sistem database untuk memastikan data aman, cepat diakses, dan stabil.
• Bertanggung Jawab atas penggunaan database dalam aplikasi. Merancang arsitektur data, model data, dan menunjang penggunaan database untuk kebutuhan aplikasi spesifik.
• Membuat API terintegrasi sistem.
• Membuat perangkat lunak integrasi sistem AI dengan pengolahan dan analisis big data serta bertanggungjawab dalam membangun validasi model data.

JOB DESCRIPTION :

• Design and implement new idea for existing system.
• Analyze existing system and find which part need to optimize.
• Develop, and maintain ETL/ELT pipelines using tools such as Airflow and BigQuery.
• Design and implement tables in Data Warehouse based on Business & Technical Requirements.
• Develop and maintain disaster recovery plans and backup strategies for databases to minimize downtime and data loss in the event of failures.
• Maintain version-controlled configurations for database servers, ensuring consistency and repeatability across environments.
• Automate routine tasks such as database backups, schema migrations, and data archiving to improve operational efficiency.
• Develop database high availability and replication solutions to meet the requirements of critical applications.
• Support data extraction and preparation for internal dashboards and regulatory reports.
• Coordinate with reporting team/stakeholders to ensure data definitions are consistent.
• Assist in cleaning, transforming, and validating datasets for use in BI tools such as Looker.
• Provide occasional help with ad-hoc SQL queries or data exports.

REQUIREMENT :

• 5+ years of Experience as a Software Engineer with a focus on database management, experience as a devops engineer is a plus
• Hands-on experience with cloud platforms (AWS or GCP).
• Proficiency in scripting languages such as Go, Shell, and Python for automation tasks.
• In-depth knowledge of database systems such as PostgreSQL, Redis, etc., including configuration, optimization, and troubleshooting.
• Strong understanding of CI/CD practices and tools.
• Experience with disaster recovery strategies (including hands-on backup and recovery experience).
• Experience in configuration management tools (eg, Atlas) for database patching and maintenance automation.