IT: Staff Database Optimization Engineer

PCS Payment


Tanggal: 2 minggu yang lalu
Kota: South Tangerang, Banten
Jenis kontrak: Penuh waktu
  • 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.

Minimum Qualifications

  • 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

Cara melamar

Untuk melamar pekerjaan ini, Anda perlu otorisasi di situs web kami. Jika Anda belum memiliki akun, silakan daftar.

Posting CV

Pekerjaan serupa

Senior Software Engineer

PT Adicipta Inovasi Teknologi, South Tangerang, Banten
1 minggu yang lalu
Develop and maintain onboarding backend services using Java Spring Boot or Golang. Design and implement secure, scalable APIs and microservices. Collaborate with cross-functional teams to deliver seamless onboarding flows. Review code, ensure best practices, and support junior engineers. Review code, ensure best practices, and support junior engineers. Optimize system performance and resolve production issues.Minimum Qualifications Bachelor’s Degree of Computer Science/Informatics...

IT: Technical Writer

PCS Payment, South Tangerang, Banten
2 minggu yang lalu
OverviewWe are seeking a skilled Technical Writer to join our team. The ideal candidate will have a strong background in technical communication, a keen eye for detail, and the ability to transform complex information into clear and concise documentation. As a Technical Writer, you will play a crucial role in creating user manuals, technical guides, API documentation, and other materials...

Tech Recruiter

PCS Payment, South Tangerang, Banten
2 minggu yang lalu
Source potential IT candidatesParse specialized skills and qualifications to screen IT resumesPerform pre-screening calls to analyze applicants’ abilitiesInterview candidates combining various methods (structured interviews, technical assessments and behavioral questions)Coordinate with Recruiter Lead to forecast department goals and hiring needsCraft and send personalized recruiting emails with current job openings to passive candidatesParticipate in tech conferences and meetups to network with IT...