Middle PostgreSQL Developer

PT Astra Graphia Information Technology; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PT Astra Graphia Information Technology is seeking a skilled Database Developer to design, implement, and optimize PostgreSQL database objects for our applications.

You will collaborate with Backend, ETL, and reporting teams to ensure data integrity, performance, and secure transaction management while aligning with CI/CD practices.

This role offers growth in a dynamic tech environment and exposure to enterprise data challenges.

Qualifications

• Bachelor's degree in CS/IT or equivalent experience.
• 3-5 years of PostgreSQL database development experience.
• Strong SQL, relational design and data modeling skills.
• Experience with PostgreSQL functions, views, indexes, and queries.
• Knowledge of query optimization, performance tuning, transactions and concurrency.
• Familiarity with database migration, version control and Git/CI-CD.
• Experience supporting backend development or ETL.
• Strong analytical, troubleshooting, and collaboration abilities.
• Good command of English, both written and spoken.

Responsibilities

• Develop and maintain PostgreSQL database objects such as tables, views, functions, and queries.
• Design and optimize database structures based on application needs.
• Perform SQL query optimization and performance tuning.
• Ensure data integrity, security, and proper transaction management.
• Collaborate with Backend, ETL, reporting, and integration teams.
• Troubleshoot database issues and support migrations and deployments.

Skills

PostgreSQL experience

SQL proficiency

Data modeling

Analytical thinking

English proficiency

Education

Bachelor's degree in Computer Science or Information Technology

Tools

Git

CI/CD

Job description

Job Descriptions

1. Develop and maintain PostgreSQL database objects, including tables, views, functions, stored procedures, and queries.

2. Design and optimize database structures based on application and data requirements.

3. Perform SQL query optimization, indexing, and database performance tuning.

4. Ensure data integrity, security, and proper transaction management.

5. Collaborate with Backend, ETL, reporting, and integration teams on database requirements.

6. Troubleshoot database issues and support database migration, deployment, and version management.

Qualifications

1. Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience.

2. Min 3-5 years of experience in database development, preferably using PostgreSQL.

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

4. Hands-on experience developing PostgreSQL functions, stored procedures, views, indexes, and complex queries.

5. Good understanding of query optimization, performance tuning, transactions, locking, concurrency, and data integrity.

6. Familiarity with database migration, version control, and Git/CI-CD is a plus.

7. Experience supporting backend development, application integration, or ETL processes is a plus.

8. Strong analytical, troubleshooting, and collaboration skills.

9. Good command of English, both written and spoken.