SoSafe Madrid, Community of Madrid, Spain
PostgreSQL Database Admin (m/f/d)
Location: Madrid, Community of Madrid, Spain
SoSafe is seeking a qualified PostgreSQL Database Administrator with hands-on experience in AWS RDS and Aurora to join our team. The role focuses on managing PostgreSQL infrastructure, tuning performance, and collaborating with development teams to ensure scalable, efficient, and maintainable data solutions.
Responsibilities
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 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.
Qualifications
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 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).
Strong collaboration and communication, with the ability to explain database concepts to both developers and non-technical stakeholders.
Proactive problem-solving mindset with ownership and commitment to issue resolution.
Willingness to participate in on-call duty.
What we offer
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
Tech equipment, referral bonuses, dog-friendly HQ
Perks and benefits listed above are for full-time employees and may vary by office location. Further details will be provided during the interview process.
About Us
At SoSafe, we're on a mission to make the digital world safer by addressing the human factor in cybersecurity. We're a fast-growing security awareness scale-up leveraging behavioural science and data-driven learning to empower people against cyber threats. Our Human Risk Management approach helps organisations turn employees into their strongest line of defence.
Backed by leading VCs and rapidly expanding globally, we're looking for team players who want to drive meaningful change in cybersecurity, take ownership of their work, and grow with us. If you thrive in a purpose-driven environment that values innovation, diversity, and collaboration, this is the place for you!
Seniority level: Entry level
Employment type: Full-time
Job function: Information Technology
Industry: IT Services and IT Consulting
Note: Referrals increase your chances of interviewing at SoSafe.
#J-18808-Ljbffr