PostgreSQL Database Engineer (m/f/d) Remote

Overview

SoSafe has the ambition to become the leading human risk management provider in Europe. Our award-winning awareness platform triggers behavioural change by providing effective and engaging training and simulations on cybersecurity and data protection. Cybercrime is predicted to cost the world $10.5 trillion annually by 2025 - we invite you to be part of the solution!

In Short

• Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora.
• Perform regular database maintenance tasks, including backup validation, replication checks, patching, and upgrades.
• Collaborate with developers to optimize SQL and database objects, maintain PL/pgSQL routines, and contribute to data modeling initiatives to enhance performance.
• Set up and fine-tune database performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and other tools.
• Identify and improve slow-running queries.
• Implement and manage access control, auditing, and security policies in line with organizational standards.
• Create and maintain database documentation and deployment scripts.
• Contribute to and follow best practices for schema changes, migrations, and version control of database objects (GitHub experience is a plus).
• Contribute to DevOps processes, including database CI/CD and automation of schema deployment automation.

Requirements

• Hands-on experience with PostgreSQL in production environments.
• Hands-on experience with Amazon RDS for PostgreSQL, including provisioning, parameter groups, backups, and failover.
• Hands-on experience integrating PostgreSQL with other AWS services (e.g., Lambda, S3).
• Hands-on experience in writing and debugging SQL queries, developing and optimizing PL/pgSQL routines, managing views and materialized views, implementing and maintaining partitions.
• Hands-on experience with performance tuning, query planning, and index optimization.
• Familiarity with PostgreSQL monitoring tools such as pg_stat_statements, auto_explain, and others.
• Solid understanding of database design, normalization, and data integrity constraints.
• Experience collaborating with developers to understand application logic and improve data-layer performance.
• Knowledge of CI/CD practices for database development (e.g., Github Actions).

Benefits

• Work/Life balance: Flexible hours, 33 vacation days.
• Wellbeing and financial support: Access to Open Up, corporate discounts.
• Connection & community: Virtual events, collaborative team activities, and opportunities for local meet-ups.
• And the list goes on: Tech equipment, referral bonuses, dog-friendly HQ.