DBA > Jobs

US-MA-Marlborough: SQL Database Administrator

Date: 28-Aug-2018
To see other DBA job opportunities, please visit http://dba.fyicenter.com/

SQL Database Administrator


Create and manage multiple databases and assist in capacity planning.

Monitor, maintain database systems and troubleshoot problems that may arise.

Maintain data integrity and security (manage roles and permissions of database users).

Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks and resolve them.

Develop strategies and implement solutions for managing backup and recovery, restoration and replication.

Create and manage constraints and indexes.

Support software developers with database design and operations including the development of complex SQL,

tuning of DML and the creation of stored procedures.

Proactive housekeeping/archiving and shrinking of databases.

Manage production, Dev, and QA database environments.

Create detailed documentation including diagrams of database infrastructure.

Learn relevant business processes and understand the data flow, criticality and dependencies.

Effectively coordinate and communicate with all stakeholders.

Set up and maintain database infrastructure for company’s BI needs.


Bachelors in Computer Science, Engineering, or equivalent education and experience.

5+ years of hands-on experience in administering Microsoft SQL Server databases (SQL 2008, 2012, 2016)

Extensive experience writing T-SQL, stored procedures, and functions, and query tuning on high-transaction


Experience with Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services


Experience with ETL (Extract-Transform-Load) development and data integration.

Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.

Proficient with SQL Server profiler for monitoring and troubleshooting database activity and performance.

Experience with SQL Server Clustering including mirroring, log shipping, failover cluster and various replication


Ability to develop procedure documents and maintain detailed databased related documents.

Innovative approach to work, constantly looking for upgrading the system to more efficient and effective


Ability to work independently as well as work in a team environment

Outstanding verbal and written communication skills

Preferred Skills

Experience with Solarwinds Database Performance Analyzer

Experience with BI, reporting, and analytical tools (Power BI, Tableau)

Experience with MS Dynamics NAV ERP

Experience working in an Agile SDLC environment, JIRA software

To apply for this position, please visit this Website.

Thank you,
DBA FYI Center