Overview

Director Database Engineering Jobs in Seattle, WA at Avalara



Title: Director Database Engineering

Company: Avalara

Location: Seattle, WA

Salary: $200K – $250K*

Category: Enterprise Technology

Job Summary

The Director Database Engineering is responsible for the maintenance of the system databases in MS SQL and other environments in a manner that ensures services are accessible on a 24 x 7 basis.

Job Duties:

Administer all aspects of the production databases including applying patches, upgrading or migrating the RDBMS, and planning for appropriate storage capacity

Troubleshoot performance issues

Recommend changes to improve application performance

Develop and implement disaster recovery plans

Implement industry standard best practices for ongoing database administration

Develop and maintain expert-level knowledge in database design architecture and physical data modeling, including debugging, profiling, and problem solving

Work with business personnel to develop logical data models and service level agreements for capacity, performance, and reliability requirements for new and existing applications

Assist the business in deciding which database platform to utilize for a given application

Work with the Development team to migrate applications from one platform to another as needed

Design, implement, function test, load test packages, stored procedures, triggers and other database objects to support new and existing applications

Develop, enforce, and maintain appropriate database change control procedures for the database objects

Exercise appropriate control and oversight of all data to keep all taxpayer, employee and financial data secure

Review existing processes and recommend changes or institute new processes as necessary, including the areas of monitoring, upgrades, and tuning

Generate high-quality project documentation, such as architecture designs, implementation plans, design documents, test plans, etc.

Provide technical escalation and be on call during designated periods

Mentor other members of the technical team database administration practices and procedures

Stay abreast of industry best practices regarding new methods and technologies and adopt these new methods and technologies as appropriate

Manage a distributed team of DBAs across the US, India, Brazil and EU

Other job duties as assigned

Qualifications

This role should have significant experience in both MS SQL server and opensource Mongo / Atlas and AWS SaaS Databases.

Atlas architecture and best practices in experience migrating from SQL server to Mongo.

Experience designing, implementing, and maintaining high-availability SQL databases in a SaaS environment – preferably an MS SQL Cluster environment in AWS

Deep expertise in MS SQL Server 2008/2012/2014/2017, including SQL server operations and SQL query optimization

SQL Server upgrades moving to 2017/2019

Hands-on SSRS and SSIS experience

Thorough knowledge of configuration and tuning, backup and recovery, transaction log management, replication, cluster configuration, maintenance, performance tuning, and indexes

Solid understanding of security concepts, principles and practices, including fundamental knowledge of OSI model

OLTP and OLAP support and design experience

7 to 10 years of experience implementing, maintaining and architecting database solutions using Microsoft SQL Server including experience using Procedural SQL constructs

Exceptional written and verbal communication skills

Desirable Skills:

Exposure to RDS, Aurora, and Redshift databases

Required Education:

Bachelor of Science degree in Computer Science, Computer Engineering or…

 

About Avalara



Avalara, Inc. is a privately held company with headquarters in Seattle, WA. Avalara helps businesses of all sizes achieve compliance with transactional taxes, including VAT, sales tax, excise tax, communications tax, and other tax types. Founded in 2004, Avalara is one of six Certified Service Provider available to retailers. Avalara was founded in 2004. In 2011 Avalara raised $7 million in venture capital from Sageview Capital. In 2012 Avalara raised $20 million in additional venture capital from Battery Ventures.