Database Admin (Postgres+AWS)

TL;DR

Database Admin (Postgres+AWS): Administer and optimize PostgreSQL databases on AWS RDS and Aurora with an accent on performance tuning, SQL optimization, and security policies. Focus on monitoring metrics, collaborating with developers on data modeling, and automating DevOps processes for schema deployments.

Location: Remote from UK, Ireland, or Portugal. Candidates must have work authorization in one of these countries. Office access available in London, Dublin, and Lisbon.

Company

Leading human risk management provider in Europe with an award-winning awareness platform for cybersecurity and data protection, backed by top VCs and rapidly expanding globally.

What you will do

• Administer, monitor, and optimize PostgreSQL databases on Amazon RDS and Aurora, including maintenance, backups, replication, patching, and upgrades.
• Collaborate with developers to optimize SQL queries, PL/pgSQL routines, data modeling, views, partitions, and performance.
• Set up performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and other tools; identify and improve slow queries.
• Implement access control, auditing, security policies, documentation, and deployment scripts.
• Contribute to schema changes, migrations, version control, and DevOps processes including CI/CD automation.

Requirements

• Hands-on experience with PostgreSQL in production environments.
• Hands-on with Amazon RDS for PostgreSQL (provisioning, parameter groups, backups, failover) and integration with AWS services like Lambda, S3.
• Experience writing/debugging SQL queries, PL/pgSQL routines, views, materialized views, partitions, performance tuning, query planning, index optimization.
• Familiarity with PostgreSQL monitoring tools (pg_stat_statements, auto_explain).
• Understanding of database design, normalization, data integrity; collaboration with developers on application logic and data performance.
• Knowledge of CI/CD for databases (e.g., GitHub Actions); strong communication, proactive problem-solving, code review participation, on-call willingness.

Culture & Benefits

• Work/life balance with flexible hours and 33 vacation days.
• Wellbeing support via Open Up access and corporate discounts.
• Connection through virtual events, team activities, local meet-ups.
• Tech equipment, referral bonuses, dog-friendly HQ (perks may vary by location).