Database Engineer - SQL Server

| Greater NYC Area

WHO WE ARE LOOKING FOR:

Raise your hand if you LOVE ads! Yeah, we feel the same… So come be a part of the solution, by joining the team that is changing the face of advertising for the better. Founded by the pioneers of real-time bidding (RTB), The Trade Desk has become the fastest growing demand-side platform (DSP) in the industry by offering agencies and their advertisers a best-in-class technology platform that focuses on delivering meaningful and relevant engagement with consumers.

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 websites combined – 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 hire a Senior Database Administrator 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 2014 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
  • 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
  • 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 2014 or above and best practices
  • Proficiency with OLTP Database Environments
  • Experience configuring and administering MS SQL replication and availability groups
  • AWS Database Management, OLAP experience, and Vertica management experience are a 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
  • Experience managing SQL Server table partitioning
  • 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

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

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.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • ReduxLibraries
    • ASP.NETFrameworks
    • SparkFrameworks
    • CassandraDatabases
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • RedisDatabases
    • VerticaDatabases
    • AerospikeDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • SketchDesign
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement
    • SmartsheetManagement
    • SalesforceCRM
    • MarketoLead Gen

Location

Our NY office is sandwiched between Flatiron and K-Town, close to lots of subway stations.
2 Park Avenue, 5th Floor, New York, NY 10016

Insider's spotlight

How do you collaborate with other teams in the company?

Our most recent Connected TV (CTV) launch was exciting because CTV is a big industry game changer. A lot of people from the London office worked on the project, so I know about the problems we had to solve in order to get us to the point where we could push it live. I’m excited to see how well it takes off.

Kruna

Software Engineer

What makes someone successful on your team?

Unrelenting curiosity. When you’re given a problem or task, you’re so curious that you become obsessive about solving it. I always know that I’ve found great engineers when they refuse to let go of a problem I’ve given them until they figure it out. This quality proves especially useful for a lot of the problems we work on.

Tim

Senior Software Engineer

How do you make yourself accessible to the rest of the team?

During the Engineering Palooza event three years ago, a group of 25 engineers, spent a week in Boulder just brainstorming ideas and talking about our next-gen infrastructure. The sheer brain power in that room was absolutely amazing! Since then, the team has grown, ideas have expanded, and we’re tackling more complex problems than ever before.

Arvind

Principal Lead Software Engineer

What's the biggest problem your team is solving?

Those moments usually involve us looking at vast volumes of data to answer a question or inform a decision. A few examples are investigating how a client uses a certain feature, so we can build a new one to increase efficiency, or helping partners write an attribution model or build a custom report, so they can gain new insights from their data.

André

Solutions Architect

What are The Trade Desk Perks + Benefits

The Trade Desk Benefits Overview

At The Trade Desk we think what you do outside the office is just as important as what you do inside the office, which is why we offer a range of benefits to help our employees lead a healthy and balanced life. We offer competitive benefits ranging from parental leave to savings and investments plan that help you plan for the future. We have offices around the world and they all have something that makes them unique, whether there's a fridge stocked with local craft beer, or daily ping pong tournaments, there's always something fun happening at our TTD offices.

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours

Additional Perks + Benefits

Competitive Salary. Flexible Hours. Meaningful Stock Options. Full health, dental, and vision coverage. Awesome office location with fully stocked fridge, gourmet local coffee, games and breakfast & lunch 2-3X per week.

More Jobs at The Trade Desk36 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Project Mgmt
Sales
Design + UX
new
New York
Sales
new
New York
Sales
new
New York
Sales
new
New York
Operations
new
New York
Developer
new
New York
Developer
new
New York
Data + Analytics
new
New York
Operations
new
New York
Data + Analytics
new
New York
Developer
new
New York
Marketing
new
New York
Operations
new
New York
Developer
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Operations
new
New York
Developer
new
New York
Data + Analytics
new
New York
Marketing
new
New York
Sales
new
New York
Data + Analytics
new
New York
Marketing
new
New York
Developer
new
New York
Developer
new
New York
Marketing
new
New York
Design + UX
new
New York
Design + UX
new
New York