Principal Software Engineer DBA PostgreSQL Python
Principal Software Engineer DBA PostgreSQL Python
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 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 goto 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 onpremise 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 daytoday operations but also helps contribute to the future evolution of Infrastructure & Engineering here at Tripadvisor. Youll 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 onprem to AWS/cloudnative migrations as well as onprem data centers to alternate AWSbased 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 onprem databases and transition them into the cloud. This is a businessfacing role and as such significant leadership and communication experience is required.
What youll 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 onprem Prometheus/Thanos as well as Grafana Cloud and Loki.
- Database Management: Manage hundreds of onprem PostgreSQL databases including performance tuning backups disaster recovery strategies and their active/passive counterparts in AWS.
- Collaboration: Work closely with crossfunctional 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 oncall 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 problemsolving skills and the ability to work in a fastpaced agile environment.
- Solid understanding of AWSbased 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.
- Bachelors 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 and let us know the nature of your request. Please include the job requisition number in your message.
#LIAMCVAY
#LIHybrid
Required Experience:
Staff IC
Employment Type
Full Time
