Database Engineer

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.

Skills: PostgreSQL, Sql & Query Optimization, Database Indexing, Database Troubleshooting, airflow, Etl / Data Pipeline, MySQL, Data Automation, Database Monitoring, Big Data / Data Retrieval, Query Optimization, Database Performance Tuning, Indexing & Performance Tuning