SQL Database Engineer / Senior DBA

Boston, MA | Perm

Post Date: 04/03/2018 Job ID: 225617 Industry: IT

SQL Database Engineer / Senior DBA 

Boston, MA

Full Time / Salaried Position 

Key Responsibilities:


Responsible for configuring, troubleshooting and maintaining the company’ s Production and Development environment databases.

Responsible for owning, tracking and resolving all database related incidents and requests to meet SLA requirements.

Ensure a stable and performant SQL service in support of our Software as a Service platform.

Serve as a subject matter expert in support of the development team, especially concerning (but not limited to) database structures, database performance, data security and query optimization.

 

Required Experience:

Excellent SQL Server Skills

Production support types of skills and experience with performance tuning. (Environment consists of 75 server’ s high throughput database transactions with a focus on low latency and performance tuning)

8-15 years of experience as a database administrator required.

A Bachelor's degree in Computer Science or equivalent experience. 

Expert knowledge of database systems with a focus on Microsoft SQL Server and T-SQL required. 

Familiarity with current development support tools including: GIT, JIRA, Confluence required. 

Familiarity with common tools and techniques needed to develop, troubleshoot and maintain database systems are required.

Strong operational background, but also within development.

Strong DBA development background with experience in Windows clustering and SQL Server at scale.

Need someone who is very performance oriented with a focus on low transaction time and needs someone who can tune-this is critical.

Powershell scripting on the Linux side is of strong interest.

Database Design

Continuous improvement of database schema in conjunction with development

Recommendations and best practices for table structures, indexing, database sharding to ensure scalability of the platform as the business grows

SQL Server Maintenance

Backups, restores and defining recovery models

Responsible for database clustering

Proactively monitor SQL platform to ensure stability and uptime against SLA

Understand SQL Server use of underlying operating system platform and communicate requirements and standards to the system and network administrators

Evaluate, test and deploy new releases, patches and upgrades of the Microsoft SQL Server Platform

Reporting:

Define and implement performance monitoring in a continuous improvement cycle

Define and implement capacity monitoring in a continuous improvement cycle

Produce regularly scheduled and ad hoc reports as needed

Performance Tuning:

Performance tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Index creation and management

SQL Automation:

Work with Process Engineering and IT Operations team to tune automated SQL server deployment within pre-production environments

Implement operational automation using scripts and scheduling

Work with Process Engineering to automate frequently performed tasks in non-production environments for ad hoc development use (restores, etc…)

SQL Security:

Table, field and database encryption per industry best practices

Server permissions model and monitoring of exceptions

Documentation creation and maintenance

Annotated schema layouts

Server configuration

 

 

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: