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
