Database Engineer - Vertica

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 600 billion queries per day (more than 100 times the query volume of search globally), 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:


With integrations into every major advertising exchange, we handle well over
4 trillion requests every month
and growing that's more page views and queries than Facebook, Google Search, and Google's entire network of websitescombined all serviced in single-digit-ms response times. Are you interested in working with big data? Do you want to push the edges of scale and responsiveness?
It doesn't get much bigger or faster than this
!
We are looking to hirea 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
(link removed)>

WHAT YOU'LL 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


WHAT MUST YOU HAVE:


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

Considerable experience and knowledge of on-premise MPP databases, like Vertica (Must have experience)

Teradata, or Netezza is a plus technical skill-set

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

The Trade Desk does not accept unsolicited resumes from search firm recruiters. Fees will not be paid in the event a candidate submitted by a recruiter without an agreement in place is hired; such resumes will be deemed the sole property of The Trade Desk. The Trade Desk is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.

#LI-AD1


Our Compensation and Benefits (for Colorado residents only)
Base Compensation Range: $154,300 - $308,600

In accordance with Colorado law, the range provided is The Trade Desks reasonable estimate of the base compensation for this role. The actual amount may be higher or lower, based on non-discriminatory factors such as experience, knowledge, skills and abilities. The Trade Desk also offers a competitive benefits package. Clickhere to learn more.

The Trade Desk does not accept unsolicited resumes from search firm recruiters. Fees will not be paid in the event a candidate submitted by a recruiter without an agreement in place is hired; such resumes will be deemed the sole property of The Trade Desk. The Trade Desk is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.