Principal Software Engineer / DBA (PostgreSQL, Python)

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

Job summary

Join an innovative team at a leading travel platform as a Principal Software Engineer/DBA. This role involves optimizing and automating infrastructure and deployment processes, focusing on PostgreSQL and AWS technologies. You'll lead migrations and enhance data management systems, ensuring high availability and reliability. Collaborate with cross-functional teams to drive improvements in development and deployment, all while working in a dynamic and inclusive environment. If you're passionate about technology and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• 10 years in database operations with scalable infrastructures.
• 5 years of senior-level PostgreSQL experience is essential.
• Strong programming experience with Python is required.

Responsibilities

• Design and maintain automated infrastructure provisioning.
• Manage hundreds of PostgreSQL databases and performance tuning.
• Collaborate with teams to improve development and deployment processes.

Skills

PostgreSQL

Python

AWS DMS

Ansible

Infrastructure as Code

CI/CD

Docker

Kubernetes

Problem-solving

Education

Bachelor's degree in Computer Science

Tools

AWS

Prometheus

Grafana

GitLab CI

GitHub Actions

Job description

Join to apply for the Principal Software Engineer / DBA (PostgreSQL, Python) role at Tripadvisor

2 weeks ago Be among the first 25 applicants

Join to apply for the Principal Software Engineer / DBA (PostgreSQL, Python) role at Tripadvisor

We believe that we are better together, and at Tripadvisor we welcome you for who you are. Our workplace is for everyone, as is our people powered platform. At Tripadvisor, we want you to bring your unique perspective and experiences, so we can collectively revolutionize travel and together find the good out there.

The Site Operations team at Tripadvisor is responsible for maintaining and enhancing the core systems that power and support the tripadvisor.com website. This includes systems in both private data centers and over a hundred accounts in AWS. Our scope of responsibilities is vast and would take an entire page to list here. Suffice it to say that we are the go-to team for questions about the interface boundaries that lie between these two halves of the company, as well as the deep inner workings of the legacy half. Data at Tripadvisor is hugely important, and as a result, we have over 600 on-premise logical databases running on over 100 database hosts serving petabytes of data. As a Principal Software Engineer/DBA on the SiteOps team, you will be a force multiplier for our engineering & operations teams, delivering tooling & infrastructure that not only has a direct impact on day-to-day operations but also helps contribute to the future evolution of Infrastructure & Engineering here at Tripadvisor. You'll be part of a dynamic team responsible for ensuring the high availability, reliability, and scalability of our data maintenance and delivery.

We are looking for passionate engineers with deep experience in Postgres, as well as AWS DMS, RDS, and Aurora, to help us optimize and automate our infrastructure and deployment processes around our databases. We are currently involved in several types of systems migrations, within both the scope of on-prem to AWS/cloud-native migrations, as well as on-prem data centers to alternate AWS-based data center migrations. As a Principal Software Engineer/DBA, you will be involved in designing and implementing how we perform those migrations, testing those migrations, and then performing them with a “no surprises in production” mindset. In addition, you will have a major role in evolving the infrastructure as code and configuration management we use to both keep the lights on for our existing on-prem databases and transition them into the cloud. This is a business-facing role, and as such, significant leadership and communication experience is required.

What You'll Do

• Infrastructure Automation: Design, implement, and maintain automated infrastructure provisioning and configuration management using Python, Ansible, and Typescript CDK to ensure consistency and scalability.
• Strong programming skills in these areas is a must have.
• Monitoring and Alerting: 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.
• Database Management: Manage hundreds of on-prem PostgreSQL databases, including performance tuning, backups, disaster recovery strategies, and their active/passive counterparts in AWS.
• Collaboration: 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.
• Troubleshooting and Incident Management: Assist in identifying and resolving operational issues and participate in on-call rotations.
  
  

Skills & Experience

• 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.
• 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.
• Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience).
  
  

If you need a reasonable accommodation or support during the application or the recruiting process due to a medical condition or disability, please reach out to your individual recruiter or send an email to [e-mail] and let us know the nature of your request. Please include the job requisition number in your message.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Software Development, Technology, Information and Internet, and Travel Arrangements

Referrals increase your chances of interviewing at Tripadvisor by 2x

Get notified about new Principal Software Engineer jobs in Oxford, England, United Kingdom.

Senior Software Engineer - Green Energy - up to £90,000

Oxford, England, United Kingdom 6 days ago

Software Engineering Manager, Python, Bioinformatics, COR7181

Oxford, England, United Kingdom 5 days ago

Oxford, England, United Kingdom 1 month ago

C# Senior Software Engineer (Security Clearance)

Reading, England, United Kingdom 2 weeks ago

Regional Clinical Lead - HCPC / SWE / NMC - Specialist Schools

Reading, England, United Kingdom 1 week ago

Oxford, England, United Kingdom 1 week ago

Senior Software Defined Network Engineer

High Wycombe, England, United Kingdom 3 weeks ago

Business Development Manager - Software Division

Newbury, England, United Kingdom 1 month ago

Reading, England, United Kingdom 1 week ago

Marlow, England, United Kingdom 1 month ago

Oxford, England, United Kingdom 2 weeks ago

Oxford, England, United Kingdom 2 weeks ago

Oxford, England, United Kingdom 2 weeks ago

Senior Software Engineer – UK - Client Applications

Reading, England, United Kingdom 16 hours ago

Oxford, England, United Kingdom 3 weeks ago

Oxford, England, United Kingdom 1 week ago

Oxford, England, United Kingdom 1 day ago

Reading, England, United Kingdom 1 week ago

Oxford, England, United Kingdom 2 weeks ago

Oxford, England, United Kingdom 2 weeks ago

Oxford, England, United Kingdom 2 weeks ago

Bicester, England, United Kingdom 1 week ago

Senior AI Software Engineer (Research and Development)

Culham, England, United Kingdom 2 weeks ago

Reading, England, United Kingdom 3 weeks ago

Oxford, England, United Kingdom 3 weeks ago

Oxfordshire, England, United Kingdom 1 week ago

Reading, England, United Kingdom 2 weeks ago

Oxford, England, United Kingdom 1 week ago

C# Senior Software Engineer (Security Clearance)

Reading, England, United Kingdom 5 hours ago

Senior Robotics Software Engineer (Integration & Validation)

Oxford, England, United Kingdom 1 week ago

Reading, England, United Kingdom 2 days ago

Reading, England, United Kingdom 6 days ago

Oxford, England, United Kingdom 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.