Requirements:
-Have a great knowledge in Structured Query Language (SQL) dan database design.
-Have a 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 relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
-Familiar with Python is a plus.
-Experienced with Apache Kafka is a plus.
-Plus point will be given, if candidate have experience in programming and/or familiar with Go programming language (Golang) or .NET Programming Language
Job Describtion :
1. Support developers in service/apps development that focus on database design, query design, query tuning performance, and indexing strategy.
2. Review all new query development before implemented in production cooperate with related developers team.
3. Maintain and monitor query performance on production database.
4. Maintain and enhance the performance of existing database programs.
5. Monitor database and related systems to ensure optimized performance.
6. Perform debugging procedures on database scripts and programs, as well as resolving conflicts.
7. Support developers in finding problematic query and help them to troubleshoot and tune the query.
8. Create best practice guidance on query design which compatible with the company’s existing data that can maximize the efficiency and performance.
9. Conduct regular database best practice workshop / training to developers to increase knowledge on database design and awareness of database flaw and common pitfall.
10. Perform database backup/restore and indexing table (PostgreSQL & MSSQLserver)
11. Perform PostgreSQL database parameter tuning
12. Perform data migration from or into postgreSQL using ETL tools : SSIS, Apache Airflow, Informatica, etc