Office Tour Photos
Employer: Wayfair LLC
Title: Senior Database Administrator 3
Location: 100 Huntington Avenue, 4 Copley Place, Boston, MA 02116
Duties: Manage database security and permissions across multiple environments by applying knowledge of database management systems. Serve as technical expert for SQL Server and MySQL relational databases. Drive best practices around use and troubleshooting across the engineering organization. Improve management, deployment, capacity planning, and uptime of customer-facing mission-critical systems through better monitoring tools and self-healing automation. Ensure engineers and other internal users can easily use databases to find the information they need and that the systems perform as expected. Monitor database performance and perform performance-tuning support. Ensure organizational and customer data is secure. Backup and restore data to prevent data loss. Ensure the reliability and integrity of database backups to meet business recovery point objectives. Identify user needs to create and administer databases. Ensure databases operate efficiently and without error. Make and test modifications to database structure when needed. Implement technologies to support master / slave data architecture including transactional replication and change tracking. Review and execute T-SQL code submitted by various engineering team. 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 solution (Availability Groups, Failover Cluster Instances, log shipping). Proactively monitor and resolve database alerts. Triage database health and performance issues and trouble shoot database outages as they occur. Automate routine DBA tasks using scripting such as PowerShell. Participate in a 24x7 on-call rotation approximately one week out of three months.
Requirements: Bachelors degree (or foreign equivalent) in Computer Engineering, Computer Science, Information Systems, or a directly related field plus five (5) years of experience as a hands-on SQL Server Database Administrator or similar role. Experience must include:
Five (5) years of experience with the following (experience may be gained concurrently):
- Data structures, algorithms, programming/scripting languages, or relational database design and concepts
- SQL Server performance tuning methodologies
- Optimizing SQL Server database code
- Working on cross-functional teams on projects including server migrations, version upgrades, or shared development environment refreshers
- Hands-on demonstrable experience using TSQL
- SQL Server troubleshooting
- Microsoft Windows 2012 internals or later
- Collecting, monitoring, and analyzing SQL Server systems performance data
- Implementing HA and DR solutions available within SQL Server using AGs, FCIs, or log shipping.
Three (3) years of experience with the following (experience may be gained concurrently):
- Supporting a SQL Server transactional replication environment
- Microsoft Powershell to automate DBA functions
Two (2) years of experience with the following (experience may be gained concurrently)
- SQL Server in a cloud environment
- EMC storage products
Multiple positions. Submit resumes to Wayfair LLC, 100 Huntington Avenue, 4 Copley Place, Boston, MA 02116 or via https://www.wayfair.com/careers/job/senior-database-administrator--/4398..., Job Code: 23103
Wayfair is one of the worlds 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, were 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 youre looking for rapid growth, constant learning, and dynamic challenges, then youll find that amazing career opportunities are knocking.
No matter who you are, Wayfair is a place you can call home. Were 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. Thats why were 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.
More Jobs From