SQL DBA - Permanent

Location: Burlington
Posted on: November 4, 2024

Job Description:

Roles & Responsibilities

Work with Engineering team to develop an optimum configuration and improving database performance as well as developing accurate documentation

Work with Implementation teams on data management, backups and education

Work with Infrastructure team on environment planning, capabilities management, reporting and security

Improve infrastructure for automation of regression testing and static code analysis

Qualifications

BS, Computer Science, or equivalent experience administering database applications

Strong communication skills and the ability to work independently

3-5 years experience in:

o Database Administration in SQL Server 2008 - 2012

o Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

o Experience in Performance Tuning, Query Optimization, using Windows perfmon, MSSQL Profiler and other related monitoring and troubleshooting tools(SSMS, MVS10)

o Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

o Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.

o Implementing operational automation (SSIS).

o Database Security (encryptions/decryptions)

Keywords: , Portland , SQL DBA - Permanent, IT / Software / Systems , Burlington, Maine