SoSafe is looking for a proactive PostgreSQL Database Engineer to join our team. You will manage our PostgreSQL infrastructure on AWS, optimize performance, and partner closely with development teams to build scalable, efficient, and maintainable data solutions.
What You'll Do
- 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.
- 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.
- Create and maintain database documentation and deployment scripts.
- Contribute to best practices for schema changes, migrations, and version control.
- Contribute to DevOps processes, including database CI/CD and automation of schema deployment.
What We're Looking For
- 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, and implementing partitions.
- Hands-on experience with performance tuning, query planning, and index optimization.
- Familiarity with PostgreSQL monitoring tools such as pg_stat_statements and auto_explain.
- Solid understanding of database design, normalization, and data integrity constraints.
- Experience collaborating with developers to understand application logic and improve data-layer performance.
- Strong collaboration and communication skills, with the ability to explain database concepts to both technical and non-technical stakeholders.
- Proactive problem-solving mindset and a strong sense of ownership.
- Comfortable participating in code reviews and providing constructive feedback on database interactions.
- Willingness to participate in on-call duty.
Nice to Have
- Knowledge of CI/CD practices for database development (e.g., Github Actions).
- GitHub experience is a plus.
Technical Stack
- PostgreSQL, Amazon RDS, Amazon Aurora, AWS CloudWatch
- pg_stat_statements, AWS Lambda, Amazon S3, PL/pgSQL
- GitHub, GitHub Actions
Benefits & Compensation
- 33 vacation days
- Flexible hours
- Tech equipment
- Access to Open Up (wellbeing support)
- Corporate discounts
- Virtual events and collaborative team activities
- Opportunities for local meet-ups
- Referral bonuses
- Dog-friendly HQ
Work Mode
This is a remote position open to global candidates.
SoSafe is an equal opportunity employer.
