Postgres Database Administrator

Imagine standing at the top of the Empire State Building, taking in the breathtaking view. From the online booking to the seamless entry, every part of your ticketing experience was designed and supported by Ventrata. An industry-leading SaaS platform that helps attractions, tours, and activities to create memorable experiences.

Backed by a passionate team, headquartered in London and with offices in Brno, Lisbon, and remote teams worldwide, we’re expanding rapidly across multiple markets and verticals. Our mission is to help businesses of all sizes scale and grow while preserving their unique identity and spirit.

Be a part of something extraordinary, where your ideas and contributions truly matter. Let’s shape the future of travel together.

The Challenge:

Ventrata is seeking an experienced PostgreSQL Database Administrator (DBA) to join our growing team. This is our first dedicated database administrator role, and you'll play a key part in shaping our database strategy as we scale. You’ll work closely with two infrastructure engineers and have the opportunity to influence the future architecture of our data systems.
Our current PostgreSQL database is hosted in Google Cloud and was originally designed by developers. While functional, it’s now hitting limitations as our business grows. We need a database expert who can take charge, optimize, and ready it for the next level of scaling. If you’re passionate about problem-solving, love working on complex systems, and have a mastery of PostgreSQL, this is the role for you.

Responsibilities and Duties

• 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

Why Join Us?

• Be the first database expert in the company and shape the future of our data infrastructure.
• Work on complex, large-scale challenges with opportunities to solve performance issues, implement best practices, and build for scale.
• Collaborate with a dedicated team of infrastructure engineers and have a direct impact on our company's growth and success.

• 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.
• Nice to have: Hands-on experience with databases hosted in Google Cloud (GCP), including Cloud SQL and relevant services.

• We are fairly informal about working hours. We want to make sure you like your job and wanna go an extra mile for us.

• Unlimited paid holiday days.
• Start-up working environment.
• WFH or work remotely.
• Team buildings and company remote office. Sounds boring? The whole team met in Spain, South Africa, Italy, Portugal, and France. We also enjoy a spontaneous beer after work or any sports activity.
• Office in Brno and Lisbon. We have two office locations: the core team is located in Brno and we have one newly opened office in Lisbon. How does working for a month from Lisbon sound? :)
• 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.

Did we catch your eye or maybe also your heart and do you want to become part of the Ventrata family? Send us your CV and join us!

About Ventrata

Ventrata is an enterprise ticketing platform designed for high-volume attractions, museums, observatory towers, sightseeing tours, and activity operators. Our all-in-one solution powers online, in-person, and third-party sales, and provides robust functionality for resource management, hardware integrations, and 24/7 live support. 

Leading brands across diverse verticals trust Ventrata's solutions, and our focus on building long-term connections is key to mutual success. Since 2016, we have worked with many City Sightseeing operations and have teamed up with notable companies like Big Bus Tours and Historic Tours of America. Our recent partnerships, including those with English Heritage, Paradoxon, the Empire State Building, Thames Clippers, and many others established over the past two years, show strong potential to evolve into enduring, long-term relationships. These examples represent just a few of our many collaborations driving the innovation behind the 21 million tickets we sold in 2023 — a 60% increase from the previous year.

What truly sets us apart is our independence — we've been profitable since 2018, with no reliance on venture capital. This financial stability allows us to innovate and grow on our own terms.

We value collaboration and freedom ensuring that every team member has the space to take ownership, be heard, and drive real impact.