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, more than 100X the query volume of search globally, operating at unprecedented scale. Our award‐winning culture is built on trust, empathy, collaboration, and ownership. Working together across typical dividing lines makes us a stronger team.
WHO WE ARE LOOKING FOR
We are looking to hire a Senior Database Engineer focused on database administration.
WHAT YOU WILL BE DOING
* Infrastructure tasks: automate daily tasks, performance test SQL Server updates, set up alerting and log extraction for monitoring.
* Work with engineering to investigate database issues, maintain databases, evaluate best practices, and automate tooling for high availability and optimal performance.
* Automation of tasks using T‐SQL, PowerShell, Ansible, Chef and other tools.
* Bring a DevOps perspective to the role.
* Provide day‐to‐day support and maintenance for Microsoft SQL Server 2019/2022 databases, including administration, analysis, support, proactive monitoring, troubleshooting, recoverability, failover, security, installation, and design.
* Investigate potential problems and issues raised by users.
* Troubleshoot challenging performance issues and develop proactive measures and trend analysis.
* Monitor database events and continuously optimize system performance through troubleshooting and tuning.
* Work with engineering teams to automate reactive procedures and promote rapid response to database issues.
* Design and develop proactive tools and measures to optimize performance and scale the platform.
* 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 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 MSSQL 2019 or above and best practices, with extensive experience on DB infrastructure.
* Proficiency with OLTP database environments.
* Proficiency with T‐SQL, PowerShell (Python is a plus).
* 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 PostgreSQL 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.
Equal Opportunity Employer
As an equal opportunity employer, The Trade Desk is committed to creating an inclusive hiring experience where everyone has the opportunity to thrive. If you require an accommodation or accessibility assistance, please contact accommodations@thetradedesk.com. Any information you provide will be confidential and will not affect your hiring decisions.
#J-18808-Ljbffr