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.
Qualifications:
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 providers.
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.
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.
#J-18808-Ljbffr