Company Background
Our client is an award-winning travel company that connects travelers with a nationwide network of independent travel advisors. The company combines innovative technology, personalized service, and strong supplier partnerships to deliver customized vacation experiences across cruises, resorts, tours, and more.
Project Description
The project focuses on rebuilding a proprietary agent-facing travel platform from the ground up using a modern, cloud-native architecture on Microsoft Azure. The new platform aims to improve performance, scalability, and usability while enabling faster feature delivery and seamless integrations. A key part of the initiative is migrating data from legacy systems to a new PostgreSQL-based architecture and ensuring high availability, security, and performance of critical data systems.
Technologies
- PostgreSQL
- Microsoft Azure
- SQL
- High Availability (Failover, Replication, Backup/Recovery)
- Database Security & Encryption
- CI/CD & DevOps
What You'll Do
- Administer and maintain Azure-managed PostgreSQL databases across environments
- Design scalable and efficient database schemas and architectures
- Monitor and optimize database performance (queries, indexing, execution plans)
- Implement and maintain backup and disaster recovery strategies
- Ensure database security, access control, and compliance
- Plan and execute data migrations from legacy systems
- Write and optimize complex SQL queries, procedures, and functions
- Collaborate with development teams on database design and query optimization
- Automate routine DBA tasks using scripting tools
- Troubleshoot and resolve database issues
- Maintain documentation (data models, ER diagrams, data dictionaries)
- Participate in on-call rotation
Job Requirements
- 5-8 years of experience as a Database Administrator
- Strong experience with PostgreSQL, including Azure-managed environments
- Expert-level SQL skills and query optimization
- Experience with high availability and disaster recovery solutions
- Strong experience with performance tuning and indexing strategies
- Understanding of database security, encryption, and compliance
- Experience with data migration from legacy systems
- Familiarity with database monitoring and performance tools
- Strong analytical and problem-solving skills
- Excellent communication skills
- Ability to work in a greenfield environment
- Strong experience in schema design
- English level: B1 (Intermediate) or higher
What Do We Offer
The global benefits package includes:
- Technical and non-technical training for professional and personal growth;
- Internal conferences and meetups to learn from industry experts;
- Support and mentorship from an experienced employee to help you professional grow and development;
- Internal startup incubator;
- Health insurance;
- English courses;
- Sports activities to promote a healthy lifestyle;
- Flexible work options, including remote and hybrid opportunities;
- Referral program for bringing in new talent;
- Work anniversary program and additional vacation days.