PCS Group
PCS Group

IT: Staff Database Optimization Engineer  

PCS Group

  • South Tangerang, Indonesia
    PT Pasifik Cipta Solusi L.50 , Kav. 13-15 Jalan Jendral Sudirman , South Tangerang, Banten, Indonesia
    South Tangerang
  • Rp 6.500.000,00 - Rp 9.500.000,00 / bulan
  • Penuh waktuFULL_TIME

Lowongan dipasang 5 days ago dan batas waktu lamaran adalah 30 May

Rekruter terakhir aktif 3 hours ago


Deskripsi 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

  • Great knowledge in Structured Query Language (SQL) and database design.
  • Proficiency in MySQL and MongoDB.
  • Good knowledge and experience in tuning query and database indexing.
  • Advance knowledge of PL/pgSQL/MSSQL Server, SQL, execution analysis & optimization, indexing strategies, etc.
  • Familiar with PostgreSQL procedure, function, view, materialized view, trigger & scheduler agent.
  • Advance working SQL knowledge and experience working with a variety of databases.
  • Familiarity with Python and Apache Kafka is a plus.
  • Knowledge of DBaaS on Cloud is a plus.
  • Willing to Work From Office (Not Hybrid)

Personal Attributes

  • Strong communication skills; ability to deliver detailed information between team members and to other teams; ability to glean knowledge from received information.
  • Proficient in English, both verbally and in writing.
  • Plus points for experience in programming and/or familiarity with Go programming language (Golang).

Ringkasan Perkerjaan

Tingkat Posisi
Supervisor / Asisten Manager
IT and Software
Persyaratan tingkat pendidikan
Lulus program Sarjana (S1)
Respon rekruter ke lamaran
Alamat Kantor
Jl. Anggrek Loka Jl. Anggrek Lili No.41, Rw. Buntu, Kec. Serpong, Kota Tangerang Selatan, Banten 15310
Information Technology / IT
1 lowongan dibuka

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.

Kandidat juga melamar untuk

  1. Home

Other Recommended Jobs

Apply jobs in

Job Categories:

Related to your search: