Principal Software Engineer / DBA (PostgreSQL, Python)

Job Description

Tripadvisor is seeking a Principal Software Engineer/DBA to join its Site Operations team. This role is crucial for maintaining and enhancing the core systems that power the Tripadvisor website. The ideal candidate will be a force multiplier for the 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 Principal Software Engineer/DBA will be responsible for ensuring the high availability, reliability, and scalability of data maintenance and delivery. They will be involved in designing, implementing, and testing system migrations, as well as evolving the infrastructure as code and configuration management.

What this role involves:

• Infrastructure Automation: Design, implement, and maintain automated infrastructure provisioning and configuration management.
• Monitoring and Alerting: Set up monitoring and logging systems to proactively detect and address potential issues.
• Database Management: Manage hundreds of on-prem PostgreSQL databases, including performance tuning, backups, and disaster recovery strategies.
• Collaboration: Work closely with cross-functional teams to improve the overall development and deployment processes.
• Troubleshooting and Incident Management: 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.
• 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).

What Tripadvisor offers:

• Opportunity to work on a dynamic team responsible for ensuring the high availability, reliability, and scalability of data maintenance and delivery.
• Involvement in designing and implementing system migrations.
• A role in evolving the infrastructure as code and configuration management.