Sign in

SQL DBA

Company:
DatamanUSA LLC
Location:
Arlington, Virginia, 22209, United States
Posted:
December 10, 2018

Description:

Position: SQL Server Database Administrator

Duration: 6 Months

Location: Rosslyn, VA

Section I: Position Description

*) Microsoft SQL Server Development DBA able to establish standards for readability, reliability, and performance

*) Design, install, administer, and maintain all MS SQL Server database servers

*) Perform backup and restores of MS SQL Server database servers

*) Maintain database replication

*) Install and configure SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services

*) Collaborate with both development staff and production DBAs

*) Able to work independently as well as collaboratively within a team

*) Can contribute proposed solutions as well as execute on assigned tasks.

Primary Requirements:

*) Responsible for all aspects of SQL database high availability, including Windows clustering, SQL always on, and SQL mirroring configurations

*) Perform version upgrades and regular maintenance of all SQL environments

*) Responsible for designing and maintaining SQL disaster recover strategy

*) Responsible for the daily management and maintenance of all SQL instances

*) Perform regular database performance tuning

*) Maintain database security, service level agreements, and standard operating procedures related to SQL servers and databases

*) Author and promote process management

*) Perform troubleshooting and root cause analysis

*) Adhere to Information Security policies

*) Knowledge of relational database configurations

*) Understanding of database security best practices

Secondary Requirements:

*) Experience using NoSQL databases a plus

*) Communication skills to work with application owners on database requirements and troubleshooting

Section III: Experience

*) At least 10 years working as a database administrator of MS SQL Server in a high availability environment

*) SQL and database performance tuning

*) Session, Role, and Group Management Excellent T SQL programming skills

*) Excellent understanding of database design, data modeling concepts, and experience with data migrations

*) Experience in performance tuning, query optimization, using Performance Monitor, SQL Profiler and other monitoring and troubleshooting tools

*) Able to design indexes, adding and removing as performance dictates

*) Experience using Microsoft Visual Studio 2014, Team Foundation Server

*) Experience with data management and data flowcharting techniques

Thanks & Warm Regards

James Smith

Account Coordinator DatamanUSA, LLC