About the job
At SoSafe, we strive to become the premier human risk management provider in Europe. Our award-winning platform offers innovative training and simulations that empower individuals to combat cybersecurity threats and protect their data effectively. With cybercrime projected to incur global costs of $10.5 trillion by 2025, we invite you to join us in making a difference!
Your Role:
We are on the lookout for a skilled and proactive PostgreSQL Database Engineer who possesses hands-on experience with AWS RDS and Aurora. This role is pivotal in supporting our development teams by managing PostgreSQL infrastructure, optimizing performance, and actively participating in database design and code reviews to create scalable, efficient, and maintainable data solutions.
The ideal candidate will have a blend of operational database administration expertise and the ability to understand application-level needs. Strong communication skills are essential for collaborating with developers to optimize SQL and enhance database usage.
Your Contributions:
Oversee, monitor, and optimize PostgreSQL databases hosted on Amazon RDS and Aurora.
Execute regular database maintenance tasks including backup validation, replication checks, patching, and system upgrades.
Collaborate with developers to refine SQL queries and database objects, maintain PL/pgSQL routines, and contribute to data modeling efforts aimed at performance enhancement.
Establish and fine-tune database performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and additional tools.
Identify opportunities to optimize slow-running queries.
Implement and oversee access control, auditing, and security policies in accordance with organizational standards.
Create and maintain comprehensive database documentation and deployment scripts.
Participate in schema changes, migrations, and version control of database objects, adhering to best practices (GitHub experience is a plus).
Engage in DevOps processes, including database CI/CD and schema deployment automation.

