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 large-scale digital advertising platform. Responsibilities include administration, performance tuning, troubleshooting, security, and disaster recovery. Requires extensive experience with MS SQL, performance optimization, and OLTP environments. Experience with distributed systems, AWS, and PostgreSQL is a plus. Experience with compliance programs like SOX or PCI is also a plus.

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. Investigate potential problems and issues raised by users
  5. Monitor database events and continuously optimize system performance through troubleshooting and tuning

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
  • 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)
  • Programming experience with C#/.NET
  • AWS database management
  • OLAP experience
  • PostgreSQL experience
  • Experience designing, building, installing, configuring, supporting, and maintaining high‑volume, large‑scale database systems
  • Experience with database design and management for compliance programs such as SOX or PCI