Home Jobs Board Senior Database Administrator, Zillow, August 20

Senior Database Administrator, Zillow, August 20

Zillow-LogoWho: Zillow
Position: Senior Database Administrator
Where: Seattle
What: World class DBA needed to help deliver, design and support Zillow’s database of all homes.Do you desire to work with multi-terabyte datasets or a 30 billion row table? Zillow operates the largest home-related marketplace on mobile and web, backed by large and fast databases. At the core, our data infrastructure is SQL Server, but we have plenty of other data stores including MySQL and MongoDB.

Responsibilities:

  •  Provide 24X7 support for live site and back-end databases in conjunction with on-call rotation.
  •  Performance monitoring and tuning.  This includes daily metric gathering as well as designing new systems, while improving current ones.
  •  Work with Engineering, Test and Operations in 2 week major release cycles and daily minor releases.
  •  Work with Engineering in architecting new product designs and processes.
  •  Writing ETL processes in SSIS to work between SQL Servers as well as to/from external data stores.
  •  Daily/Weekly security audits.
  •  Maintaining and monitoring failover environments.
  • Deep understanding of how the databases are used on the production site and the backend processes.

Requirements:

  • BS/BA in Computer Science, Computer Engineering or Equivalent experience
  • At least three years of SQL Server DBA experience
  • Experienced SQL Server DBA in a 24X7 fast-paced engineering driven organization
  • Deep understanding of the b-tree data structure and how data access paths affect query performance.
  • Ability to write and read complex SQL queries
  • Experience in designing, writing and maintaining SSIS packages for ETL workflows, database optimization routines and other key DBA tasks.
  • Proven knowledge of core SQL server security modeling, and understanding of SOX requirements. Data management of multi-gigabyte/terabyte datasets, to include growth modeling, data flows, compression and partitioning.
  • Thorough understanding of high availability strategies (mirroring, replication, logshipping and multi-node clustering), to include real-time and disaster recovery strategies.
  • Experience working in a cloud environment such as AWS.
  • Strong understanding of performance tools such as Profiler, Query analyzer, Execution Plans and standard T-SQL commands.
  • Architect and develop database-specific monitoring tools.
  • Deep understand of querying and joining SQL Server DMV views.
  • Thorough understanding of database interaction with the OS, including corresponding Windows Performance Monitoring counters/objects.
  • MySQL, MongoDB and SAN technologies a plus.

How: Apply Here