Senior Database Engineer
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 1 trillion queries per day, 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?
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.
WHAT YOU WILL BE DOING:
• 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, design, performance analysis, support, proactive monitoring, troubleshooting, recoverability, failover, security and installation.
• Troubleshoot challenging performance issues and develop proactive measures and trend analysis
• Investigate potential problems and issues raised by users
• Monitor database events and continuously optimizing system performance through troubleshooting and tuning• Work with engineering teams to automate reactive procedures and promote rapid response to database issues
• Perform database code reviews and enforce database best practices
• Design and develop proactive tools and measures to optimize performance and take our platform to the next level of scale
• Maintain database configurations in compliance with established best practices
• Design and implement systems, policies, and procedures for backup and disaster recovery
• Monitor ongoing capacity and implement design and architecture changes as needed to improve global availability
• 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 as part of a follow-the-sun team
WHAT YOU BRING TO THE TABLE:• 5+ years of Database Administration experience supporting mission critical relational databases• Considerable experience and knowledge of MS SQL 2019 or above and best practices• Proficiency with performance tuning/optimizations/database internals• 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 MSSQL replication, Availability Groups, and Distributed Availability Groups• AWS Database Management, OLAP experience, and PostgresSQL experience are pluses, but not required• 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• Ability to work effectively in a team environment across different time zones, as well as independently with limited supervision
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 1 trillion queries per day, 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?
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.
WHAT YOU WILL BE DOING:
• 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, design, performance analysis, support, proactive monitoring, troubleshooting, recoverability, failover, security and installation.
• Troubleshoot challenging performance issues and develop proactive measures and trend analysis
• Investigate potential problems and issues raised by users
• Monitor database events and continuously optimizing system performance through troubleshooting and tuning• Work with engineering teams to automate reactive procedures and promote rapid response to database issues
• Perform database code reviews and enforce database best practices
• Design and develop proactive tools and measures to optimize performance and take our platform to the next level of scale
• Maintain database configurations in compliance with established best practices
• Design and implement systems, policies, and procedures for backup and disaster recovery
• Monitor ongoing capacity and implement design and architecture changes as needed to improve global availability
• 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 as part of a follow-the-sun team
WHAT YOU BRING TO THE TABLE:• 5+ years of Database Administration experience supporting mission critical relational databases• Considerable experience and knowledge of MS SQL 2019 or above and best practices• Proficiency with performance tuning/optimizations/database internals• 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 MSSQL replication, Availability Groups, and Distributed Availability Groups• AWS Database Management, OLAP experience, and PostgresSQL experience are pluses, but not required• 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• Ability to work effectively in a team environment across different time zones, as well as independently with limited supervision
As an Equal Opportunity Employer, The Trade Desk is committed to creating an inclusive hiring experience where everyone has the opportunity to thrive.
Please reach out to us at accommodations@thetradedesk.com to request an accommodation or discuss any accessibility needs you may require to access our Company Website or navigate any part of the hiring process.
When you contact us, please include your preferred contact details and specify the nature of your accommodation request or questions. Any information you share will be handled confidentially and will not impact our hiring decisions.