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 AccessibleRecruiting@Tripadvisor.com 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
#J-18808-Ljbffr