We are a fast-growing leading Computer Gaming Company

We need highly competent candidates to join the existing team to develop the latest game software

We will provide a High Salary according to the ability in their respective fields

Job Description :

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

MUST HAVE :

13. Have a great knowledge in Structured Query Language (SQL) dan database design.

14. Have a good knowledge and experience in tuning query and database indexing.

15. Advance knowledge of PL/pgSQL/MSSQL Server, SQL, execution analysis & optimization, indexing strategies, etc

16. Familiar with PostgreSQL procedure, function, view, materialized view, trigger & scheduler agent

17. Advance working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

18. Familiar with Python is a plus.

19. Experienced with Apache Kafka is a plus.

NICE TO HAVE :

20. Have good communication skill; able to deliver detailed information between team member and also to another team; able to take the knowledge (essence) from received information.

21. Able to communicate using English both verbally and in writing.

22. Plus point will be given, if candidate have experience in programming and/or familiar with Go programming language (Golang) or .NET Programming Language.

23. Point plus if having knowledge on DBaaS on Cloud