Senior Database Engineer

The Trade Desk The Trade Desk · Media · Sydney, Australia · Database Engineering

Senior Database Engineer to support and maintain Microsoft SQL Server databases for a global technology company in the digital advertising space. Responsibilities include administration, performance tuning, troubleshooting, security, and disaster recovery for high-volume, large-scale systems.

What you'd actually do

  1. Provide day‑to‑day support and maintenance for Microsoft SQL Server 2019/2022 databases for our platform
  2. Perform administration, design, performance analysis, support, proactive monitoring, troubleshooting, recoverability, failover, security, and installation
  3. Troubleshoot challenging performance issues and develop proactive measures and trend analysis
  4. Monitor database events and continuously optimize system performance through troubleshooting and tuning
  5. Work with engineering teams to automate reactive procedures and promote rapid response to database issues

Skills

Required

  • 5+ years of Database Administration experience supporting mission‑critical relational databases
  • Extensive experience and knowledge of MS SQL 2019 or above, along with best practices
  • Proficiency in performance tuning, optimization, and database internals
  • Proficiency working in OLTP database environments
  • Experience configuring and administering MSSQL replication, Availability Groups, and Distributed Availability Groups
  • Full systems lifecycle experience from requirements gathering to delivery of database projects
  • Experience designing, building, installing, configuring, supporting, and maintaining high‑volume, large‑scale database systems
  • Strong troubleshooting and analytical problem‑solving skills
  • Excellent written and verbal communication skills, with the ability to document complex technical issues
  • Ability to work effectively in a team environment across time zones, as well as independently with limited supervision

Nice to have

  • Experience with distributed systems (OLTP/DW MPP) is a plus
  • Programming experience with C#/.NET is a plus
  • AWS database management, OLAP experience, and PostgreSQL experience are pluses
  • Experience with database design and management for compliance programs such as SOX or PCI is a plus

What the JD emphasized

  • mission-critical
  • high-volume, large-scale