Senior Database Engineer

Company: The Trade Desk
Location: Irvine
Posted on: February 23, 2021

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 600 billion--queries--per day (more than 100X--the query volume of search--globally), our platform operates at unprecedented scale. We have--also--built something even stronger and more valuable: an award-winning culture based on trust, empathy, collaboration, and ownership. By working together across typical dividing lines, we are--better--as a team than any of us could be apart. Do you have a passion for solving--hard--problems at scale? Are you eager to join a trust-based, globally-connected team, where your contributions will make a meaningful difference?-- Come and see why Fortune Magazine consistently ranks The Trade Desk among best small-medium sized workplaces globally. WHO WE ARE: The Trade Desk is a global technology company with a mission to create a better Internet for everyone through principled, intelligent advertising. We handle over 600 billion queries per day (more than 100X the query volume of search globally), our platform operates at unprecedented scale. We have also built something even stronger and more valuable: an award-winning culture based on trust, empathy, collaboration, and ownership. By working together across typical dividing lines, we are better as a team than any of us could be apart. Do you have a passion for solving challenging problems at scale? Are you eager to join a trust-based, globally-connected team, where your contributions will make a meaningful difference? Come and see why Fortune Magazine recently named The Trade Desk among the best small-to-medium-sized work places in the US. WHO WE ARE LOOKING FOR: We are looking to hire a Senior Database Engineer who will work in collaboration with our engineering team to ensure aligned execution of database related activities. You enjoy investigating database problems, performance issues, and evaluating best practices to ensure optimal performance on the platform. Recently named one of the top 10 most promising companies in America by Forbes Magazine and one of the "Best Places To Work" in the nation by Outdoor Magazine, The Trade Desk offers a culture of "relaxed intensity" - one that comes from working alongside one of the most talented teams in our industry, and leading in a race that is ours to lose. WHAT YOU WILL BE DOING:

• Provide day-to-day support and maintenance for Microsoft SQL Server 2016/2019 databases for our platform.
• This includes, but is not limited to: administration, analysis, support, proactive monitoring, troubleshooting, recoverability, failover, security, installation, and design.
• Investigating potential problems and issues raised by users
• Troubleshooting challenging performance issues and developing proactive measures and trend analysis
• Monitoring database events and continuously optimizing system performance through troubleshooting and tuning
• Work with engineering team to automate reactive procedures and promote rapid response to database issues
• Design and develop proactive tools and measures to optimize performance and take our platform to the next level of scale
• 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 YOU BRING TO THE TABLE:
  • 5+ years of Database Administration experience supporting mission critical relational databases
  • Considerable experience and knowledge of MS SQL 2016 or above and best practices
  • Proficiency with OLTP Database Environments
  • Experience with distributed systems OLTP/DW MPP is a big plus, but not required
  • Programming experience with C#/.NET is a big plus, but not required
  • Experience configuring and administering MS SQL replication and availability groups
  • AWS Database Management, OLAP experience, and Vertica management experience area bonus, but not required
  • 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 (SOX) 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 a contract 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. 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. Posted 3 Days Ago Full time REQ-902 About Us Our media-buying platform helps deliver a more insightful and relevant ad experience for consumers - and sets a new standard for global reach, accuracy, and transparency. For the past 10 years, we've been transforming media for the benefit of humankind. We're passionate about keeping the internet free and open to everyone, because when content creators thrive, the internet as a whole prospers - free of the restrictions from a few big companies. So if you're talented, driven, creative, and hungry to bring something entirely new and wildly ambitious into the world (and have some fun doing it), then we want to talk.

Keywords: The Trade Desk, Irvine , Senior Database Engineer, IT / Software / Systems , Irvine, California