Database Administrator

Wayfair.com is a leader in the e-commerce space for all things home. The Data Technologies team is looking for smart, passionate and curious people who are excited to help us scale, support and administer our robust cross-datacenter database infrastructure. With the broad reach of the technologies we are using you will have the opportunity to grow your network and skills by being exposed to new people and ideas who work on a diverse set of cutting-edge technologies. If you are the type of person who loves to shave off milliseconds from query execution plans and is interested in problems like replication, sharding, resiliency and scaling, we should talk. 

What the Data Technologies team does:

  • Technical Experts for SQL Server and MySQL relational databases
  • Drives best practices around use and troubleshooting across the engineering organization
  • Improves the management, deployment, capacity planning and uptime of customer facing mission critical systems through better monitoring tools and self-healing automation

 

What you will do in this role:

  • Ensure the reliability and integrity of database backups to meet business recovery point objectives
  • Implement technologies to support master / slave data architecture (transactional replication, change tracking)
  • Manage database security and permissions across multiple environments
  • Review and execute T-SQL code submitted by various engineering teams
  • Contribute to our internal knowledge base by documenting operational workflows and troubleshooting guides
  • Support an environment with a mix of high availability and disaster recovery solutions (Availability Groups, Failover Cluster Instances, log shipping)
  • Proactively monitor and resolve database alerts
  • Triage database health and performance issues and troubleshoot database outages as they occur
  • Automate routine DBA tasks using scripting such as PowerShell
  • Participate in a 24x7 on call rotation

 About you:

  • 2+ years hands on experience as a SQL Server DBA
  • Solid understanding of relational database design and concepts
  • Familiarity with HA & DR solutions available within SQL Server and experience implementing them (AGs, FCIs, log shipping)
  • Experience working on cross-functional teams on projects such as server migrations, version upgrades, and shared development environment refreshes
  • Experience supporting a transactional replication environment
  • A desire to learn performance tuning methodologies and gain experience optimizing database code
  • Collecting, monitoring and analyzing systems performance data a plus
  • Passion for improving complex geo-distributed systems, people and processes around you


Other traits we look for:

  • Excellent interpersonal skills
  • Self-driven individual looking to challenge and further develop their skills and subject matter expertise
  • An easy-going attitude and strong sense of humor
  • A positive, people-oriented and energetic attitude
  • An analytical, creative, and innovative approach to solving problems
  • An interest in working hard and being challenged in a fast-paced environment, and having fun while doing it
  • Familiar with Linux, .Net and PowerShell


Back to top