SQL DBA- Remote role

Overview

On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6 C2H

Skills

Spring Framework
Microsoft SQL Server DBA
Servers
Microsoft SSRS
Microsoft SSIS
Administrative Support
Change Control
Microsoft
SQL Azure
Microsoft Azure
Optimization
Statistics
Scripting
SAP BASIS
Management
Database Administration
Backup Administration
Database
Performance Tuning
Stored Procedures
SQL
High Availability
Disaster Recovery
Failover
Microsoft SQL Server
Replication
Microsoft Operating Systems
Microsoft Windows Server
Active Directory
VMware
SAN Administration

Job Details

- SQL DBA

Project Location Spring, TX-Remote

Project Duration- 6+ month contract, may extend C2H

Job Description-:

The purpose of this position is to perform SQL Server Administration including: install/configure new SQL servers, deploy database change scripts provided by developers, perform all SQL server related IT tickets. The position is also responsible for SSRS, SSIS related administrative support and assist in troubleshooting errors, permission problems and change control.

Tech Stack Requirements:

  • Must have a strong Microsoft Tech stack
  • SQL Server
  • Azure SQL
  • Azure Data Factory

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Database administration for MSSQL Server

2. Performance Tuning and Optimization using native monitoring and troubleshooting tools

3. Index creation, management, statistics

4. Automation, scripting, agent jobs

5. Availability Groups, Backups, and Restores

6. Propose technical solutions to business problems on a proactive basis

7. Other duties as assigned.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or abilities.

  • Microsoft SQL Server 2008 2016
  • Ability to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.
  • Strong working knowledge of query, index and DB I/O performance tuning, and Stored Procedures and SQL coding is required.
  • Prior experience using Microsoft SQL Server DMVs for troubleshooting performance issues.
  • High Availability, Disaster Recovery: - Always on Availability /SQL Server failover Cluster/SQL Server replication.
  • Windows Server, Active Directory, VMWare, SAN Administration.
  • 5+ years' experience.
  • Able to demonstrate impact beyond their own task assignments
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.