Database Administrator

Engineering - Infrastructure Boston, Massachusetts

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

About Us:

Wayfair is one of the world’s largest online destinations for the home. Whether you work in our global headquarters in Boston or Berlin, or in our warehouses or offices throughout the world, we’re reinventing the way people shop for their homes. Through our commitment to industry-leading technology and creative problem-solving, we are confident that Wayfair will be home to the most rewarding work of your career. If you’re looking for rapid growth, constant learning, and dynamic challenges, then you’ll find that amazing career opportunities are knocking.

No matter who you are, Wayfair is a place you can call home. We’re a community of innovators, risk-takers, and trailblazers who celebrate our differences, and know that our unique perspectives make us stronger, smarter, and well-positioned for success. We value and rely on the collective voices of our employees, customers, community, and suppliers to help guide us as we build a better Wayfair – and world – for all. Every voice, every perspective matters. That’s why we’re proud to be an equal opportunity employer. We do not discriminate on the basis of race, color, ethnicity, ancestry, religion, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, veteran status, or genetic information.