We are seeking a qualified and proactive PostgreSQL Database Engineer with hands-on experience in AWS RDS and Aurora to manage PostgreSQL infrastructure, tune performance, and contribute to database design and code reviews to ensure scalable, efficient, and maintainable data solutions.
Requirements
- 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.
Benefits
- Flexible hours
- 33 vacation days
- Access to Open Up
- Corporate discounts
- Tech equipment
- Referral bonuses
- Dog-friendly HQ