Junior PostgreSQL Developer

PT Astra Graphia Information Technology; Asia; Presencial; PEN 119.000 - 238.000; Jornada completa

Descripción de la vacante

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.

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

SQL

PostgreSQL

Data modeling

Performance tuning

Troubleshooting

Collaboration

Educación

Bachelor’s degree in Computer Science/Information Technology

Herramientas

Git

CI/CD

Descripción del empleo

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.