This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking a skilled and experienced PostgreSQL Developer (Level 2) with 4–5 years of hands-on experience in database development and optimization. The ideal candidate will be responsible for developing, maintaining, and improving PostgreSQL-based database solutions, supporting high-performance applications, and assisting with architecture and automation initiatives.
Job Responsibility:
Design, develop, and optimize complex SQL queries, stored procedures, triggers, and PL/pgSQL functions
Collaborate with architects and application developers to define efficient schema designs and data models
Perform advanced performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, and indexing strategies
Implement and maintain ETL processes for structured and semi-structured data
Manage large-scale data migrations and version-controlled schema deployments
Conduct capacity planning and monitoring to maintain database health and scalability
Implement and manage backup/restore policies, disaster recovery testing, and high availability configurations
Work with DevOps teams to integrate database changes into CI/CD pipelines
Mentor junior developers and participate in peer code reviews
Requirements:
Strong expertise in PostgreSQL SQL and PL/pgSQL programming
In-depth understanding of PostgreSQL internals: query planner, indexing, vacuum/analyze, and WAL
Experience with partitioning, parallel queries, table inheritance, and advanced types (JSONB, ARRAY)
Proficient with performance tuning, database normalization/denormalization, and query optimization
Experience with replication mechanisms: streaming replication, logical replication, or BDR
Good knowledge of PostgreSQL backup and recovery strategies using pg_basebackup, pgBackRest, or Barman
Experience with monitoring tools like pg_stat_activity, pgBadger, Prometheus + Grafana, or Zabbix
Bachelor’s degree in Computer Science, Information Technology, or related discipline
Nice to have:
Scripting experience (Bash, Python, or Shell) for automation tasks