Lead Software Engineer

Summary

Join Tripadvisor's Site Operations team as a Principal Software Engineer/DBA and become a key player in maintaining and enhancing the core systems powering tripadvisor.com. You will be responsible for optimizing and automating infrastructure and deployment processes around our databases, focusing on migrations between on-premise and AWS environments. This role demands expertise in Postgres, AWS services, and infrastructure automation tools. You will collaborate with cross-functional teams, troubleshoot operational issues, and contribute to the evolution of our infrastructure. Significant leadership and communication skills are essential for success in this business-facing role. The position involves ensuring high availability, reliability, and scalability of data maintenance and delivery.

Requirements

• 10 years of expertise in database operations with a focus on building and maintaining scalable infrastructures around data
• 5 years of working directly with PostgreSQL at a Senior level is essential
• 5 years of experience in leadership and communicating with the business
• Strong programming experience with Python is essential
• Strong problem-solving skills and the ability to work in a fast-paced, agile environment
• Solid understanding of AWS-based data management technologies
• Experience in configuration management using Ansible
• Experience with infrastructure as code using CDK
• Understanding of CI/CD tools like Jenkins, GitLab CI, and GitHub Actions
• Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience)

Responsibilities

• Design, implement, and maintain automated infrastructure provisioning and configuration management using Python, Ansible, and Typescript CDK to ensure consistency and scalability
• Set up monitoring and logging systems to proactively detect and address potential issues, ensuring optimal performance and reliability, in environments like on-prem Prometheus/Thanos, as well as Grafana Cloud and Loki
• Manage hundreds of on-prem PostgreSQL databases, including performance tuning, backups, disaster recovery strategies, and their active/passive counterparts in AWS
• Work closely with cross-functional teams, including developers, system administrators, and technical managers, to improve the overall development and deployment processes, and keep everyone in sync as to deliverables and timelines
• Assist in identifying and resolving operational issues and participate in on-call rotations

Preferred Qualifications

• Understanding of networking concepts such as load balancing and DNS is also a plus
• Knowledge of containerization technologies like Docker and container orchestration tools such as Kubernetes is a plus