Responsibilities

1. Design, develop, and maintain PostgreSQL database objects supporting HR platform applications.

2. Develop tables, views, functions, stored procedures, queries, and database scripts.

3. Translate application and data requirements into optimized database structures.

4. Optimize SQL queries, indexing, database performance, and data access patterns.

5. Support data integrity, transaction management, security, and database standards.

6. Support Backend, ETL, reporting, and integration teams with database requirements.

7. Analyze and resolve database-related performance issues and defects.

8. Support database migration, deployment, and version management activities.

Qualifications

1. Bachelor’s degree in Computer Science, Information Technology, or a related field,



orequivalent experience.

2. Min 2 years of database development experience, preferably with PostgreSQL.

3. Strong knowledge of SQL, relational database design, normalization, and data modeling.

4. Experience developing PostgreSQL functions, procedures, views, indexes, and complex queries.

5. Good understanding of query optimization and database performance tuning.

6. Understanding of transactions, locking, concurrency, and data integrity.

7. Familiarity with database migration/versioning and Git/CI-CD is preferable.

8. Strong analytical, troubleshooting, and collaboration skills.

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