Data Engineer & Optimization
PCS Group
- South Tangerang, Indonesia46, Jalan Anggrek Lili, Rawa Buntu Kel., Serpong, South Tangerang, Banten, IndonesiaSouth TangerangBantenIndonesiaIndonesia
- ContractualCONTRACTOR
Posted 21 hours ago and deadline of application is on 20 Jul
Recruiter was hiring 21 hours ago
2025-05-23T05:45:58.864310+00:002025-07-20T17:00:00+00:00Job Description
- Optimize database performance:
Support developers with database design, query tuning, and indexing strategies. Review new query development, and maintain and monitor production query performance. - Enhance database programs:
Debug scripts, resolve conflicts, and continuously improve existing database program execution. - Developer enablement:
Provide hands-on troubleshooting for problematic queries. Create and deliver best practice guidance and training on database design and common pitfalls. - Database operations:
Perform backup/restore, indexing maintenance for PostgreSQL & MSSQL Server, and tune PostgreSQL parameters. - Data integration & synchronization:
Manage data migrations using ETL tools and contribute to multi-database synchronization strategies. - Performance monitoring:
Utilize the ELK for log and event data management to aid performance analysis. - Business Intelligence contribution:
Leverage optimized data to inform strategic business decisions.
Minimum Qualifications
- Expert in SQL & Database Design: Extensive experience with SQL and strong principles of relational database design.
- Database Tuning Pro: Proven proficiency in database performance tuning, including advanced knowledge of query execution analysis, indexing strategies, and optimization techniques.
- Hands-On Database Experience: Solid experience with PostgreSQL and MySQL. Experience with MSSQL Server (including T-SQL and optimization) is preferred.
- ETL & Multi-Database Savvy: Proficient with ETL tools like SSIS, Apache Airflow, and Informatica, and comfortable working in multi-database environments with data synchronization strategies.
- Familiarity with the ELK stack (Elasticsearch, Logstash, Kibana).
- Familiarity with Python, Apache Kafka, DBaaS on Cloud, and Golang is a plus.
- Willing to Work From Office (WFO - BSD CITY)
Personal Attributes:
- Exceptional communication skills, able to explain complex technical details clearly.
- Strong analytical and problem-solving abilities with a keen eye for detail.
- Proactive, self-motivated, and a great team player.
Jobs Summary
- Job Level
- Entry Level / Junior, Apprentice
- Job Category
- IT and Software
- Educational Requirement
- Bachelor's degree graduate
- Office Address
- Blok AA, Jl. Anggrek Loka Jl. Anggrek Lili No.41 Sektor 2.2, Rw. Buntu, Kec. Serpong, Kota Tangerang Selatan, Banten 15310
Feel secure when applying: look for the verified icon and always do your research on a company. Avoid and report situations when employers require payment or work without compensation as part of their application process.
About 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.