Ofertes d'ocupació a SoSafe

• Flexibilitat horàriaSi
• Nivell d'experiència---
• Tipus de contracteA temps complert
• PublicadaNova

Teletreball TSQL AWS DevOps PostgreSQL Office

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!

Your Mission:

We are seeking a skilled and proactive PostgreSQL Database Engineer with hands-on experience in AWS RDS and Aurora, and a collaborative mindset for supporting 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 skills with the ability to understand application-level requirements, effective communication skills 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.
• 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.
  
  

• 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)
• Strong collaboration and communication skills, with the ability to explain database concepts to both developers and non-technical stakeholders.
• Proactive problem-solving mindset, with a strong sense of ownership and commitment to seeing issues through to resolution.
• Comfortable participating in code reviews and providing constructive suggestions to improve database interactions.
• Willingness to participate in on-call duty.
  
  

• 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
• Perks and benefits listed above are for full-time employees and may vary slightly by office location. These are just a sample — you'll learn more during the interview process.