Senior Database Engineer

The Trade Desk is changing the way global brands and their agencies advertise to audiences around the world. How? With a media buying platform that helps brands deliver a more insightful and relevant ad experience for consumers -- and sets a new standard for global reach, accuracy, and transparency. We are proud of the culture we have built. 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.

So, if you are talented, driven, creative, and eager to join a dynamic, globally-connected team, then we want to talk!

WHO WE ARE LOOKING FOR:

We are looking to hire a Senior Database Engineer who will work with our engineering team to ensure aligned execution of database-related activities. You enjoy investigating database problems, performance troubleshooting, and evaluating best practices to ensure optimal performance on the platform.

• Provide day-to-day support and maintenance for Microsoft SQL Server 2019/2022 databases for our platform
• This includes, but is not limited to: administration, analysis, support, proactive monitoring, troubleshooting, recoverability, failover, security, installation, and design
• Troubleshoot challenging performance issues, develop proactive measures, and trend analysis
• Monitor database events, investigate potential problems and issues raised by users, and continuously optimize system performance through troubleshooting and tuning
• Work with engineering teams to automate processes 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
• Monitor ongoing capacity and implement design and architecture changes as needed to improve global availability
• Maintain database configurations in compliance with established best practices
• Design and implement systems, policies, and procedures for backup and disaster recovery
• Install upgrades and patches to existing database servers
• Design and develop database code as needed
• Review and establish database migration processes
• Participate in on-call rotations (every 2-3 months)

• 5+ years of Database Administration experience supporting mission critical relational databases
• Considerable experience and knowledge of MSSQL 2019 or above and best practices, with extensive experience on DB Infrastructure
• Proficiency with OLTP Database Environments
• Programming experience with PowerShell.
• Programming experience with C#/.NET is a big plus, but not required
• Experience configuring and administering MSSQL replication, Availability Groups, and Distributed Availability Groups, and Failover Clustering.
• AWS Database Management, OLAP experience, and PostgresSQL experience are a plus, but not required.
• Dashboard creation using Grafana is a plus.
• Full systems lifecycle experience (from requirements gathering 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