Responsibilities
- Design, develop, and maintain PostgreSQL database objects supporting HR platform applications.
- Develop tables, views, functions, stored procedures, queries, and database scripts.
- Translate application and data requirements into optimized database structures.
- Optimize SQL queries, indexing, database performance, and data access patterns.
- Support data integrity, transaction management, security, and database standards.
- Support Backend, ETL, reporting, and integration teams with database requirements.
- Analyze and resolve database-related performance issues and defects.
- Support database migration, deployment, and version management activities.

Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related field, orequivalent experience.




- Min 2 years of database development experience, preferably with PostgreSQL.
- Strong knowledge of SQL, relational database design, normalization, and data modeling.
- Experience developing PostgreSQL functions, procedures, views, indexes, and complex queries.
- Good understanding of query optimization and database performance tuning.
- Understanding of transactions, locking, concurrency, and data integrity.
- Familiarity with database migration/versioning and Git/CI-CD is preferable.
- Strong analytical, troubleshooting, and collaboration skills.

📌 Junior PostgreSQL Developer (Asia)
🏢 PT Astra Graphia Information Technology
📍 Asia