Job description for Database Engineer at PT Neural Technologies Indonesia (Official)
Requirements
- Minimum 20–35 years old
- Minimum Diploma (D3) / Bachelor’s Degree (D4/S1) in a relevant field
- Strong knowledge and hands-on experience in ETL / Data Pipelining
- Strong proficiency in SQL Query and database query optimization
- Proficient in PostgreSQL, SQL Server, MongoDB, and MySQL
- 0–1 year of relevant work experience, with a strong interest in database management and performance optimization
Job Description
- Design database structures, create procedures, and perform database tuning.
- Support developers in service/application development, particularly in database design, query design, query performance tuning, and indexing strategy.
- Review new queries before production implementation and collaborate with relevant development teams.
- Maintain and monitor query performance in production databases.
- Maintain and enhance the performance of existing database programs.
- Monitor databases and related systems to ensure optimized performance.
- Perform debugging on database scripts and programs, as well as resolve related conflicts.
- Support developers in identifying problematic queries and assist with troubleshooting and query tuning.
- Develop best practice guidelines for query design that are compatible with existing company data to maximize efficiency and performance.
- Perform database indexing for PostgreSQL, ClickHouse, and MSSQL Server.
- Schedule and maintain Data Automation Jobs for Data Application Monitoring.
- Develop queries to retrieve data from SQL Server, PostgreSQL, ClickHouse, and Hadoop Big Data.
