It: Staff Database

4 weeks ago

Tangerang, Indonesia PCS Group Full time

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.
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.
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.

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).

  • Database Administrator

    3 weeks ago

    Tangerang, Indonesia Professional Outsourcing Solutions Full time

    PT Indodev Niaga Internet Staff - 3 Months Probation - Responsible for the administration and support of various database system used by the company. - Installation and management of the MS SQL running on Linux and Windows servers **Job Requirement** - Education: Bachelor Degree, Diploma, Master Degree - Minimum GPA: 3.5 - Major: Computer Engineering,...

  • Marketing Database Support

    2 weeks ago

    Tangerang, Indonesia PT. Sukses Mulia Seimbang Full time

    PT. SUKSES MULIA SEIMBANG adalah perusahaan importir barang teknik berlokasi di tangerang. Kami mencari karyawan/staff Admin Sales yang terbiasa berbicara dengan customer dan juga menelpon untuk penawaran barang. Pelamar akan bekerja untuk PT. SMS bukan untuk perusahaan lain dan tidak ada biaya apapun untuk melamar. Silahkan melamar apabila bersedia di...

  • Database & Payroll Staff

    1 week ago

    Tangerang, Indonesia PT Bina Talenta Full time

    **Informasi Lowongan** **Tipe Pekerjaan** **Remote/On-site** **Fungsi Pekerjaan** Administrasi **Jenjang Karir** Pemula / Staf **Job Deskripsi** - Mengumpulkan dan memverifikasi data kehadiran, absensi, dan informasi lain yang diperlukan untuk menghitung gaji karyawan. - Menghitung dan memproses gaji karyawan sesuai dengan peraturan perusahaan dan...

  • Database Administrator

    4 weeks ago

    Tangerang, Indonesia Professional Outsourcing Solutions Full time

    PT Indodev Niaga Internet Staff - 3 Months Probation **Benefit** - Overtime: No - Free Lunch: Free Lunch - Pension Fund : Pension Fund - Medical Allowance: Medical Allowance

  • Staff It

    2 weeks ago

    Tangerang, Indonesia PT Indoseiki Metalutama Full time

    Staff IT - Pria/Wanita, usia maksimal 35 tahun - Pendidikan mínimal S1 Teknik Komputer/Teknik Informatika, Min. IPK 3.00 Skala 4.00 - Memiliki pengalaman mínimal 1 tahun dibidang yang sama. Fresh Graduate dipersilahkan - Menguasai Query Database (MySQL/PostgreSQL/SQLServer) - Menguasai Maintenance Database (Indexing, Archiving, Shrinking dan Tuning) -...

  • Lease Staff

    1 week ago

    Tangerang, Indonesia Sinarmas Land Full time

    **Job Descriptions**: - Canvass potential tenants and collecting database. - Attend location survey with potential tenants. - Prepare and secure lease agreement documents w/ tenants and monitor its effective period. - Prepare reports related with lease activities, occupancy rate, tenant database, potential tenant database, vacancies, etc. **Job...

  • Software Maintenance Staff

    3 weeks ago

    Tangerang, Indonesia PT Indodev Niaga Internet Full time

    Join Us! Software Maintenance Staff is responsible for dealing with relevant customer complaints, queries and requests for information from the start to the end of the process. Software Maintenance Staff also provides solutions to customer problems with the assistance of development and/or implementation teams. **Education**: Diploma, Bachelor Degree, Master...

  • Software Maintenance Staff

    3 weeks ago

    Tangerang, Indonesia Professional Outsourcing Solutions Full time

    PT Indodev Niaga Internet Staff - 3 Months Probation Software Maintenance Staff is responsible for ?for the dealing with relevant customer complaints, queries and requests for information from the start to the end of the process. Software Maintenance Staff also provides solutions to customer problems with the assistance of development and/or implementation...

  • Lease Staff

    4 weeks ago

    Tangerang, Indonesia Sinarmas Land Full time

    **Job Descriptions**: - Gather potential tenants and collecting database - Accompany potential tenants for site surveys and coordinate with related teams regarding operations - Control master data and tenant rental status, as well as coordinate with related departments - Collect data on units that have not been rented - Support the Dept. Head to meet the...

  • HR Staff

    4 days ago

    Tangerang, Indonesia PT Recruit First Indonesia Full time

    **Lokasi : Karawaci, Tangerang** **Jam Kerja : Senin-Sabtu** **Kualifikasi**: - Pendidikan min. D3 - Pengalaman min. 1 tahun dalam bidang yang sama - Menguasai sistem **HRIS **(diutamakan Talenta) - Menguasai Microsoft Office (Excel, Word) - Dapat bergabung segera **Deskripsi**: - Melakukan proses payroll - Merekap absensi karyawan - Melakukan arsip...

  • HR Operations Staff

    5 days ago

    Tangerang, Indonesia Siloam Hospitals Group Full time

    Responsible for operational aspects of the Hospital's human resources department in accordance with established Group HR standards, policies, procedures and regulations and applicable accreditation requirements. - Work on all operational aspects of the Hospital's human resources department (including recruitment processes, staff contracts & onboarding,...

  • Lease Staff

    3 weeks ago

    Tangerang, Indonesia Sinarmas Land Full time

    **Job Descriptions**: - Implement administration related to leasing and promotional media with tenants according to the applicable SOPs. - Distribute documents and letters according to the specified deadlines and to the correct recipients. - Create a tenant database. - Input employee overtime data and attendance for outsourced personnel. - Compile a summary...

  • Product Staff for IT Specialist

    3 weeks ago

    Tangerang, Indonesia PT Sariling Aneka Energi Full time

    Product Staff for IT Specialist - Memillki Database Vendor IT - Mampu menjalin komunikesi yang baik dengan seluruh distributor, vendor dan principal. - Mampu me-monitor pricing, stocking dan inventory control. - Mampu merekomendasikan produk berdasarkan spesifikasi dari customer. - Bersedia full WFO di Karawaci - Tangerang. "Waspada terhadap Modus Penipuan...

  • Marketing Staff

    1 week ago

    Tangerang, Indonesia PT. Kwadran Lima Mitra Kaya Solusi Full time

    **Kualifikasi**: - Usia maksimal 35 tahun - Pendidikan mínimal D3, semua jurusan - Memiliki pengalaman sebagai **Marketing Staff min 2 tahun di perusahaan IT Consultant**: - Memiliki pengetahuan mengenai Teknologi Informasi yang baik - Memiliki customer database yang luas - Memiliki integritas dan mau bekerja keras dalam mencapai target - Mampu melakukan...

  • Purchasing Tender Staff

    3 weeks ago

    Tangerang, Indonesia PT Sariling Aneka Energi Full time

    Purchasing Tender Staff - Memiliki pengalaman sebagai purchasing Alat Berat / Alat Kesehatan / Alat Lab / IT / Furniture I ME. dll. - Mampu membuat evaluasl terhadap project tender. - Memiliki Database Vendor yang banyak. - Familiar dan mampu melengkapi seluruh dokumen kebutuhan tender seperti surat dukungan. dll. - Bersedia full WFO di Karawaci -...

  • Homepass Management Staff

    1 week ago

    Tangerang, Indonesia MyRepublic Full time

    MyRepublic merupakan salah satu perusahaan penyedia layanan internet (ISP) dan salah satu anak perusahaan dan Sinarmas group. Saat ini kami sedang membuka kesempatan berkarir sebagai ; Homepass Management Staff Uraian Tugas: 1. Memperbarui data homepass dari penjualan regional dan permintaan VIP. 2. Unggah RFS Cluster ke sistem. 3. Meninjau basemap / As...

  • Marketing Staff

    4 weeks ago

    Tangerang, Indonesia PT. Kwadran Lima Mitra Kaya Solusi Full time

    **Kualifikasi**: - Usia maksimal 35 tahun - Pria / Wanita - Pendidikan mínimal D3, semua jurusan - Memiliki pengalaman sebagai Marketing Staff di perusahaan IT lebih di sukai - Memiliki pengetahuan mengenai Teknologi Informasi yang baik - Memiliki customer database yang luas - Memiliki integritas dan mau bekerja keras dalam mencapai target - Mampu...

  • Marketing Staff

    3 weeks ago

    Tangerang, Indonesia PT. Kwadran Lima Mitra Kaya Solusi Full time

    **Kualifikasi**: - Usia maksimal 35 tahun - Pria / Wanita - Pendidikan mínimal D3, semua jurusan - Memiliki pengalaman sebagai Marketing Staff di perusahaan IT lebih di sukai - Memiliki pengetahuan mengenai Teknologi Informasi yang baik - Memiliki customer database yang luas - Memiliki integritas dan mau bekerja keras dalam mencapai target - Mampu...

  • Marketing Staff

    4 days ago

    Tangerang, Indonesia PT. Kwadran Lima Mitra Kaya Solusi Full time

    **Kualifikasi**: - Usia maksimal 35 tahun - Pria / Wanita - Pendidikan mínimal D3, semua jurusan - Memiliki pengalaman sebagai Marketing Staff di perusahaan IT lebih di sukai - Memiliki pengetahuan mengenai Teknologi Informasi yang baik - Memiliki customer database yang luas - Memiliki integritas dan mau bekerja keras dalam mencapai target - Mampu...

  • Purchasing Staff

    3 weeks ago

    Tangerang, Indonesia Intan Safety Glass PT Full time

    We are looking for a generalist **Purchasing Staff** that are able to work under pressure - willing to go on-field and understand the production processes, and has relatively high interest in understanding the mechanics and electrical complexity of machine parts. **General Responsibility**: - Conduct purchasing: searching for items, price comparison &...