Lead Software Engineer (PostgreSQL)

Job Description

Tripadvisor is seeking a Lead Software Engineer (PostgreSQL) to join their Site Operations team. This role is crucial for maintaining and enhancing the core systems that power the Tripadvisor website. The engineer will be a force multiplier for engineering and operations teams, delivering tooling and infrastructure that impacts day-to-day operations and contributes to the future evolution of infrastructure and engineering.

The Lead Software Engineer will be involved in designing, implementing, and testing system migrations, both from on-premise to AWS/cloud-native environments and between on-premise data centers. They will also play a major role in evolving the infrastructure as code and configuration management used to maintain existing on-premise databases and transition them to the cloud. Strong leadership and communication skills are required for this business-facing role.

Responsibilities:

• Design, implement, and maintain automated infrastructure provisioning and configuration management.
• Set up monitoring and logging systems to proactively detect and address potential issues.
• Manage hundreds of on-prem PostgreSQL databases, including performance tuning and disaster recovery.
• Collaborate with cross-functional teams to improve development and deployment processes.
• Assist in identifying and resolving operational issues and participate in on-call rotations.

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.

The role offers:

• Opportunity to work on a large scale database environment.
• Chance to contribute to the evolution of infrastructure and engineering at Tripadvisor.
• Involvement in designing and implementing system migrations.