Database Administrator III

Company: Wayfair LLC
Location: Boston, MA
Posted on: January 18, 2018

Job Description:

Database Administrator III (Data Technologies/Operations)

Duties: manage and grow infrastructure supporting our large-scale

internet e-commerce platform and big data analytics environment. Perform

administration of Microsoft SQL Server with exposure to a broad range of

database technologies including Memcache, Redis, and MariaDB. Provide

support of database infrastructure and operations including: high

availability engineering; monitoring, troubleshooting and on call

support; SQL query tuning and optimizations; facilitating data

replication for DR, and BI analytics and development environment

refreshes; researching, prototyping and developing new database

technology service offerings; and researching, evaluating, testing and

installing updates and patches. Work with Application Engineering teams

developing new business initiatives and algorithms. Analyze performance,

capacity and availability KPI instrumentation and trending analysis.

Requirements: Master's degree in Computer Science, Information Systems,

Engineering, Information Technology or related field (willing to accept

foreign education equivalent) plus two (2) years of experience

performing SQL database management, administration and performance

tuning. or, alternatively, a Bachelor's degree and five years of

experience as noted above. One year of experience must include:

performing database and schema design for new/existing databases, and

setting up backup and recovery plans for SQL databases; reviewing code

written by developers and recommending changes for optimization and

performing design, debugging, implantation, and maintenance of stored

procedures, triggers, and user-defined functions that are stored in the

DBMS; upgrading, migrating SQL databases, and instances to more recent

versions of SQL server; implementing security, authentication and

authorization for SQL databases to regulate access; scripting and

automating SQL server maintenance and administration using powershell

and VBScript, and creating and troubleshooting SQL server alerts in

powershell; performing capacity planning for new and existing SQL

servers and databases, and monitoring growth of database objects over

time; performing query optimization and performance tuning using third

party tools like SolarWinds Database Performance Analyzer, SQL Sentry;

and installing and configuring SQL and MySQL instances on newly

provisioned servers.

Submit resume to Wayfair LLC, S. Lisanti, 100 Huntington Avenue, 4

Copley Place, Boston, Massachusetts 02116 or via

https://jobs.wayfaircareers.com/jobs/oLWK6fwh

Keywords: Wayfair LLC, Boston , Database Administrator III, Retail , Boston, MA, Massachusetts