IT: Staff Database Optimization Engineer
PCS Group
- South Tangerang, IndonesiaSouth Tangerang, Banten, IndonesiaSouth TangerangBantenIndonesiaIndonesia
- Penuh waktuFULL_TIME
Lowongan dipasang 3 days ago dan batas waktu lamaran adalah 21 May
Rekruter terakhir aktif 18 hours ago
2025-08-12T04:16:50.731818+00:002026-05-21T17:00:00+00:00Deskripsi Pekerjaan
- Support developers with a focus on database design, query design, query tuning performance, and indexing strategy.
- Review all new query development before implemented in production, cooperating with the related developers team.
- Maintain and monitor query performance on the production database.
- Enhance the performance of existing database programs and ensure optimized performance.
- Debug database scripts and programs, as well as resolving conflicts.
- Support developers in troubleshooting and tuning problematic queries.
- Create best practice guidance on query design compatible with the company’s existing data to maximize efficiency and performance.
- Conduct regular database best practice workshops / training to developers to increase knowledge on database design and awareness of database flaws and common pitfalls.
- Perform database backup/restore and indexing table (PostgreSQL & MSSQLserver).
- Perform PostgreSQL database parameter tuning and data migration from or into PostgreSQL using ETL tools like SSIS, Apache Airflow, Informatica, etc.
- Familiarity with multi-database environments and data synchronization strategies.
- Experience working with the ELK stack (Elasticsearch, Logstash, Kibana) for log and event data management.
- Support developers with SQL query creation and optimization.
- Contribute to our Business Intelligence efforts, utilizing data to inform strategic decisions.
Kualifikasi Minimum
- Bachelor degree from Computer Science or Informatic Engineering
- Min. 2 years experience as Database Engineer/Optimization or similar role
- Strong proficiency in SQL and No-SQL database
- Experience in query performance optimization
- Hands on with distributed data processing framework (Debezium, Kafka, Flink)
- Solid understanding of ETL/ELT processes to ingest data from various sources (databases, APIs, files, message queues) and data warehouse
- Having basic knowledge of cloud platforms such as AWS or GCP and DevOps practices in database engineering
Ringkasan Perkerjaan
- Tingkat Posisi
- Supervisor / Asisten Manager
- Spesialisasi
- IT and Software
- Persyaratan tingkat pendidikan
- Lulus program Sarjana (S1)
- Respon rekruter ke lamaran
- Sometimes
- Alamat Kantor
- South Tangerang, Banten, Indonesia
Agar merasa aman saat melamar: carilah ikon verifikasi dan selalu lakukan riset terhadap Perusahaan yang Anda lamar. Hindari dan laporkan situasi dimana Perusahaan membutuhkan bayaran dalam proses rekrutmen mereka.
Tentang PCS Group
PCS Indonesia is a company engaged in financial technology products and services. We provide payment solutions with the latest technology and in accordance with the development of the world.