Junior PostgreSQL Developer
Posted Updated
Description
PT Astra Graphia Information Technology is seeking a database developer to design, build, and optimize PostgreSQL data structures for HR platform applications. You will implement tables, views, functions, and scripts, translating requirements into robust database designs.
The role requires strong SQL, data modeling, and performance tuning skills, plus hands-on experience with migrations and Git/CI-CD. Collaboration with Backend, ETL, and reporting teams is essential.
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. Bachelor’s degree in Computer Science, Information Technology, or a related field. 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.Skills
Sign in to read and join the discussion.