PostgreSQL Developer

Insight International (UK) Ltd; Cataluña; Presencial; EUR 50.000 - 70.000; Jornada completa

Descripción de la vacante

A leading company is seeking an experienced software developer with expertise in Databricks and PostgreSQL. The ideal candidate will have a strong background in database management and analytical projects, capable of handling large-scale database solutions and performance tuning.

Formación

• 10+ years in software development, 2-3+ years in Databricks and PostgreSQL.
• Experience with CRM-related projects preferred.

Conocimientos

Software Development

PostgreSQL

Databricks

Database Management

Performance Tuning

Analytical Skills

Descripción del empleo

Job Requirements

1. 10+ years of experience in software development with at least 2 to 3+ years as a Databricks and PostgreSQL developer for large/high-volume projects.
2. Experience with PostgreSQL is essential; candidates with substantial experience in Oracle or other databases, and 2 to 3 years with PostgreSQL, are also considered.
3. Background in analytical projects, with the ability to understand underlying data, its relevance, and its use for hypotheses.
4. Proficiency in writing queries, procedures, and other database scripts to support analytical hypotheses.
5. Awareness of performance considerations and other aspects of database solutions.
6. Experience with CRM-related projects is preferred.
7. Strong fundamentals in database management, including performance tuning, bottleneck identification, ER modeling, and working with PostgreSQL.
8. Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
9. Experience with PostgreSQL architecture and implementation of database objects such as tables, stored procedures, scripts, views, triggers, etc.
10. Ability to measure and troubleshoot database performance issues, including IO bottlenecks.
11. Knowledge of JSON and PostgreSQL's support for JSON.

Process Skills

Familiarity with software development lifecycle and Databricks migration processes.