Junior PostgreSQL Developer

PT Astra Graphia Information Technology

Asia

On-site

PEN 119,000 - 238,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

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.

Qualifications

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

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.

Skills

SQL
PostgreSQL
Data modeling
Performance tuning
Troubleshooting
Collaboration

Education

Bachelor’s degree in Computer Science/Information Technology

Tools

Git
CI/CD

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Engineer
Database Engineer

Alpha Philindo Solution Inc. • Asia

On-site
PEN 60,000 - 100,000
Junior ETL Developer
Junior ETL Developer

PT Astra Graphia Information Technology • Asia

On-site
PEN 60,000 - 90,000
Database Administrator (DBA) - Lima
Database Administrator (DBA) - Lima

Yeah! Global • Lima Metropolitana

On-site
PEN 100,033 - 166,722
Senior Site Reliability Engineer - APAC
Senior Site Reliability Engineer - APAC

Alpaca • Peru

Remote
PEN 484,000 - 795,000
Competitive Salary & Stock Options
Health Benefits
New Hire Home-Office Setup: USD $500
+1
DevSecOps Engineer
DevSecOps Engineer

Plan A Technologies, Inc. • Junín

Remote
PEN 409,000 - 613,000
Vacation, Brand New Laptop, and More
Senior DBA: Performance, Security & Cloud DBs
Senior DBA: Performance, Security & Cloud DBs

Yeah! Global • Lima Metropolitana

On-site
PEN 100,033 - 166,722
Database Engineer & Analyst
Database Engineer & Analyst

Usobi • Asia

On-site
PEN 29,000 - 48,000
Holiday bonus
Annual bonus
Relocation visa
+4
Junior Oracle HCM Functional Analyst
Junior Oracle HCM Functional Analyst

TotalTECH Corporation • Asia

On-site
PEN 104,000 - 156,000
DevSecOps Engineer Latin America
DevSecOps Engineer Latin America

Plan A Technologies, Inc. • Junín

Hybrid
PEN 306,000 - 408,000
Vacation
Brand new laptop
Junior Golang Developer
Junior Golang Developer

PT Astra Graphia Information Technology • Asia

On-site
PEN 42,000 - 66,000