About the Role
Role details below.
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 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.
Requirements
- 5+ years of hands-on experience operating and scaling PostgreSQL in high-availability production environments.
- 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, with the experience to explain database concepts to both developers and non-technical stakeholders.
- Proactive problem-solving mindset, with a strong sense of ownership and commitment to identifying issues through to resolution.
- Comfortable participating in on-call duty.
Nice to Have
- GitHub experience is a plus.
Benefits
- Flexible hours
- 33 vacation days
- Access to Open Up
- Corporate discounts
- Virtual events
- Collaborative team activities
- Opportunities for local meet-ups
- Tech equipment
- Referral bonuses
- Dog-friendly HQ
Work Arrangement
local-country
