Lead Software Engineer (PostgreSQL)

Tripadvisor; Oxford; On-site; GBP 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Lead Software Engineer with deep PostgreSQL expertise to enhance their data systems. This role involves designing automated infrastructure, managing hundreds of databases, and leading migration projects. You will collaborate with cross-functional teams to optimize processes and ensure high availability and scalability. If you are passionate about technology and looking to make a significant impact in a dynamic environment, this opportunity is perfect for you.

Qualifications

• 10 years in database operations with a focus on scalable infrastructure.
• 5 years of PostgreSQL experience at a senior level.

Responsibilities

• Design and maintain automated infrastructure provisioning using Python and Ansible.
• Manage PostgreSQL databases, including performance tuning and backups.

Skills

PostgreSQL

Python

AWS DMS

Ansible

CI/CD tools

Problem-solving

Leadership

Docker

Kubernetes

Education

Bachelor's degree in Computer Science

Tools

AWS RDS

Grafana

Prometheus

GitLab CI

GitHub Actions

Job description

Join to apply for the Lead Software Engineer (PostgreSQL) role at Tripadvisor.

2 weeks ago Be among the first 25 applicants.

About Tripadvisor

At Tripadvisor, we believe that we are better together and welcome you for who you are. Our workplace is inclusive, and we value your unique perspectives and experiences. We aim to revolutionize travel by harnessing our people-powered platform.

The Site Operations team maintains and enhances the core systems that support tripadvisor.com, including systems in private data centers and AWS accounts. We manage over 600 on-premise databases across 100 hosts, supporting petabytes of data.

As a Principal Software Engineer/DBA, you will enhance our engineering and operations teams by delivering tooling and infrastructure that impact daily operations and future infrastructure evolution. You will ensure high availability, reliability, and scalability of our data systems.

We seek passionate engineers with deep PostgreSQL expertise and experience with AWS DMS, RDS, and Aurora to optimize and automate our database infrastructure. You will lead migration projects, design and implement migration strategies, and evolve our infrastructure as code and configuration management practices. This is a business-facing role requiring leadership and communication skills.

What You'll Do

1. Infrastructure Automation: Design, implement, and maintain automated infrastructure provisioning using Python, Ansible, and Typescript CDK.
2. Monitoring and Alerting: Set up systems to detect and address issues proactively, using tools like Prometheus/Thanos, Grafana Cloud, and Loki.
3. Database Management: Manage hundreds of PostgreSQL databases, including performance tuning, backups, and disaster recovery, both on-premise and in AWS.
4. Collaboration: Work with cross-functional teams to improve development and deployment processes.
5. Troubleshooting and Incident Management: Assist in operational issue resolution and participate in on-call rotations.

Skills & Experience

1. 10 years in database operations, focusing on scalable data infrastructure.
2. 5 years of direct PostgreSQL experience at a senior level.
3. 5 years in leadership and business communication.
4. Strong Python programming skills.
5. Problem-solving skills and ability to work in a fast-paced environment.
6. Solid understanding of AWS data management technologies.
7. Experience with Ansible and infrastructure as code using CDK.
8. Knowledge of CI/CD tools like Jenkins, GitLab CI, and GitHub Actions.
9. Networking concepts, load balancing, DNS knowledge are a plus.
10. Containerization (Docker) and orchestration (Kubernetes) experience are a plus.
11. Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience).

If you need accommodations during the application process, contact your recruiter or email [e-mail] with your request, including the job requisition number.

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Engineering and Information Technology
• Industries: Software Development, Technology, Internet, Travel