Remote Postgres Database Administrator

Summary

Join Ventrata as an experienced PostgreSQL Database Administrator (DBA) to shape the future of our data infrastructure. As a key part of our growing team, you'll optimize existing database architecture, resolve bottlenecks, and design strategies for scaling the database.

Requirements

• Previous experience as (PostgreSQL) Database Administrator, including experience with large-scale databases (2TB+)
• Expert-level knowledge of PostgreSQL architecture, including performance tuning, query optimization, and replication
• Hands-on experience with databases hosted in major cloud provider
• Proven track record of designing scalable, highly available database architectures
• Strong understanding of security best practices and regulatory compliance (GDPR, SOC2, etc.)
• Experience with performance monitoring tools like pganalyze and query analysis
• Familiarity with database versioning and DevOps principles
• Experience collaborating with engineering and infrastructure teams to improve database design and performance
• Exceptional problem-solving skills, with the ability to work independently in a fast-paced environment

Responsibilities

• Take ownership of our PostgreSQL databases, focusing on performance, scaling, and future-proofing
• Optimize existing database architecture and queries, resolving bottlenecks and improving overall efficiency
• Understand the specificities of running PostgreSQL in Google Cloud Platform along with its limitations
• Collaborate with infrastructure engineers to ensure smooth integration with the company’s infrastructure as code (IaC) environment
• Design and implement database data export automations for various use cases - automated PR deployments, client data backups, etc
• Develop strategies to scale the database as the company and data needs to grow including sharding and partitioning
• Suggest and implement efficient strategies for connection pooling in code or tools such as PgBouncer
• Work with engineering teams to provide guidance on database design, indexing strategies, and SQL query optimization
• Create tooling for archiving old data

Benefits

• Unlimited paid holiday days
• Start-up working environment
• WFH or work remotely
• Team buildings and company remote office
• Office in Brno and Lisbon
• Young and passionate team
• Refreshments and delicious coffee in the office area
• Hardware/ remote setup package
• Competitive salary and regular salary revaluation
• Bonuses based on company performance