The Trade Desk

Senior / Staff Software Engineer - Vertica DBA

Posted 08 May 2023
LocationChina
Job type Permanent
ReferenceREQ-5344

Company's Benefits

  • Flexible Working Arrangements

    Flexible Working Arrangements

  • Mentorship Program

    Mentorship Program

  • Leadership Development Program

    Leadership Development Program

  • Paid Parental Leave

    Paid Parental Leave

  • Return to Work Policy

    Return to Work Policy

  • Breastfeeding Rooms

    Breastfeeding Rooms

  • Sponsorship Program

    Sponsorship Program

  • Coaching Program

    Coaching Program

  • Raise Numbers Of Women In Leadership

    Raise Numbers Of Women In Leadership

Job Description

​The Trade Desk is a global technology company with a mission to create a better, more open internet for everyone through principled, intelligent advertising. Handling over 1 trillion queries per day, our platform operates at an unprecedented scale. We have also built something even stronger and more valuable: an award-winning culture based on trust, ownership, empathy, and collaboration. We value the unique experiences and perspectives that each person brings to The Trade Desk, and we are committed to fostering inclusive spaces where everyone can bring their authentic selves to work every day.

Do you have a passion for solving hard problems at scale? Are you eager to join a dynamic, globally-connected team where your contributions will make a meaningful difference in building a better media ecosystem? Come and see why Fortune magazine consistently ranks The Trade Desk among the best small-medium-sized workplaces globally.

ABOUT THE ROLE:

We are looking to hire a Big Data Database Engineer to join our engineering team to build out our data-driven platform and support database related activities. You enjoy investigating database problems, performance issues, and evaluating/influencing MPP database use cases to ensure optimal performance on the platform.

WHAT YOU WILL DO:

  • Designing, developing, and supporting features and functionality that leverage our MPP databases.

  • Provide day-to-day support and maintenance for the MPP databases that are part of our platform. This includes, but is not limited to: administration, analysis, support, proactive monitoring, troubleshooting, recoverability, security, installation, and design.

  • Investigating potential problems and issues raised by users

  • Monitoring database events and continuously optimizing system performance through troubleshooting and tuning

  • Automate reactive procedures and promote rapid response to database issues

  • Maintaining database configurations in compliance with established best practices

  • Designing and implementing systems, policies, and procedures for backup and disaster recovery

  • Monitoring ongoing capacity and implement design and architecture changes as needed to improve global availability

  • Installing upgrades and patches to existing database servers

  • Designing and developing database code as needed

  • Reviewing and establishing database migration patterns and weekly release scripts

  • Participating in on-call rotations

WHO YOU ARE:

  • 5+ years of Database Administration experience supporting mission critical relational databases

  • Considerable experience and knowledge of on-premise MPP databases, like Vertica, Teradata, or Netezza.  Vertica experience is a huge plus. Equivalent experience with other SQL technologies like Redshift or Snowflake, or even open source may be acceptable alternatives for the right candidate.

  • Proficiency with OLAP Database Environments running on Linux

  • Full systems lifecycle experience (from requirements to delivery) of database projects

  • Experience designing, building, installing, configuring, supporting, and maintaining high-volume, large database systems

  • Top-notch troubleshooting and analytical problem-solving skills

  • Experience with database design and management aspects for various compliance programs, such as Sarbanes-Oxley or PCI, is a big plus

  • Excellent written and verbal communication skills, with a demonstrated ability to document complex technical problems

  • Ability to work effectively in a team environment, as well as independently with limited supervision