Database Administrator (DBA)

About TripStack

We are travel tech entrepreneurs, changing the way millions of people travel. Our proprietary virtual interlining technology provides access to billions of travel itineraries by combining flights from different airline carriers that don't traditionally work together. We take our customers from point A to B via C, including land transportation, at the lowest possible price. We are impacting the way people travel and provide higher margin opportunities to our partners that are some of the largest online travel agencies in the world.

We pride ourselves on the performance-driven environment we have created for our teams to prosper and excel in. We come to work ready, to challenge and be challenged. We are big enough to give our teams support but small enough that every person makes a difference. There are still plenty of challenges to champion.

The Role:

Our Database Administrator will play a crucial part in maintaining the operational integrity of our PostgreSQL databases, ensuring seamless performance and reliability for our mission-critical systems. The Database Administrator will spearhead tasks such as capacity planning, performance optimization, and implementing robust backup and recovery solutions, ultimately facilitating the smooth functioning of our innovative virtual interlining technology and enhancing the overall travel experience for millions of users.

Requirements

Responsibilities:

• Operational Management: Oversee operational tasks encompassing hardware, architecture, configuration, integration, and the maintenance of mission-critical Production PostgreSQL databases.
• User Management: Manage users and permissions, including the addition of new users and removal of inactive accounts.
• Capacity Planning: Estimate PostgreSQL database capacities and develop methods for monitoring database capacity and usage.
• Backup and Recovery: Implement backup, restoration, and point-in-time database recovery procedures.
• Replication Setup: Configure streaming replication and logical replication solutions.
• Problem Resolution: Analyze database-related issues and implement effective solutions. Undertake database upgrades, migrations, and other administrative projects.
• Performance Optimization: Conduct database performance reviews to ensure optimized and efficiently performing queries before production release.
• Query Tuning: Fine-tune queries and perform preventative maintenance to enhance database performance.
• Maintenance Activities: Execute regular scheduled maintenance on the database server, such as vacuum analysis on large tables to eliminate obsolete data.
• Performance Monitoring: Continuously monitor database performance to identify slowdowns or potential issues proactively.
• 
  

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field; or equivalent practical experience.
• Proven experience as a Database Administrator or similar role, specifically with PostgreSQL databases.
• In-depth understanding of database management systems, with a focus on PostgreSQL.
• Utilize experience in PostgreSQL administration on Linux platforms.
• Demonstrate proficiency in Linux shell scripting to automate database management tasks.
• Strong analytical and problem-solving skills, with keen attention to detail.
• Ability to manage multiple tasks and prioritize effectively in a fast-paced environment.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively across teams.
• Proactive approach to identifying and addressing database performance issues.
• Experience with database backup, recovery, and replication techniques.
• Knowledge of database optimization and tuning strategies.
• Familiarity with monitoring tools for database performance evaluation.

Benefits

What it takes to succeed here

Ambition and dedication to make a difference and change the way people travel; Where we always play to each other's strength in a high performing team reaching for our common goal. We hold ourselves to the highest expectations, and move with a sense of urgency and hold ourselves accountable and win by staying true to what we believe in.

Learn more about our values here at www.tripstack.com

Benefits and Perks

• Luxmed benefits coverage
• Flexible hybrid environment (1-2 days from the office - lunch provided)
• IATA and other discounts
• Pet friendly office

What we offer

We offer an opportunity to work with a dynamic and growing team composed of high caliber professionals. We value professionalism and promote a culture where individuals are encouraged to do more and be more. If you feel you share our passion for excellence, and growth, then look no further. We have an ambitious mission, and we need a world-class team to make it a reality. Upgrade to a First Class team!

At TripStack, we proudly believe in embracing diversity. This is true for our team, clients, communities and stakeholders. We are an equal opportunity employer and committed to creating a safe, healthy and accessible environment. We encourage applications regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or any other grounds protected by law. Please let us know if you need any accommodations during any part of the recruitment process.

TripStack thanks all applicants for their interest, however only those selected to continue in the process will be contacted.