Database Admin (Postgres+AWS)
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!
Location:
UK, Ireland, or Portugal (remote). Candidates must have work authorization in one of these countries. Office access available in London, Dublin, and Lisbon.
YOUR MISSION:
We are seeking a qualified and proactive PostgreSQL Database Engineer with hands-on experience in AWS RDS and Aurora, and a collaborative mindset for assisting development teams. In this role, you will manage PostgreSQL infrastructure, tune performance, and contribute to database design and code reviews to ensure scalable, efficient, and maintainable data solutions.
The ideal candidate combines hands-on operational database administration experience with the knowledge to understand application-level requirements, effective communication to facilitate dialogue with developers, and the capacity to actively assist them in optimizing SQL and database usage.
HERE'S HOW YOU'LL MAKE A DIFFERENCE:
- 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.
- Collaborated 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...