JOB DESCRIPTION

POSITION DETAILS:

JOB TITLE: Database Administrator

LOCATION: Blythewood, SC 29016

DURATION:12+ months (Strong possibility for an extension)

JOB DESCRIPTION:

* Manages and maintains all production and non-production databases.
* Responsible for standards and design of physical data storage, maintenance, access and security administration.
* Performs backup and recovery on Database Management Systems, configures data

SCOPE OF THE PROJECT:

* Client supports in the neighborhood of 100 plus SQL server databases and are in the process of migrating those databases from SQL server 2008 to SQL server 2012.
* In addition DMV is implementing high availability solutions on a number of the systems supported by these databases and increasing our use of reporting services and analysis services implemented in a number of support systems such as SharePoint, ms system center, team foundation server, and others.
* Client is also facing increasing security concerns around these assets.
* Client is also investigating business intelligence solutions for all of its data assets including Oracle and Sql Server data.
* This engineer will be expected to provide support for this initiative.
* In addition, this position will supplement our current SQL DBA force with production support activities such as os updates, security updates, etc. and will require beyond normal hours activities.
* This is expected to be a long term, ongoing assignment. on-site presence is required therefore regional candidates (SC, GA, NC) will be given preferred priority.
* Candidate will be working in a team environment consisting of 5 database engineers and administrators and working directly with application developers and server support team.
* Excellent communications skills are required.

DAILY DUTIES / RESPONSIBILITIES:

* SQL Server

o Setup and maintain data replication and mirroring

o Configure maintenance automation

o Backup and Recovery

o Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends

o SQL Server monitoring

o Install and configure new SQL Servers

o Develop and support data warehouse and cubes through SQL Server Analysis Services

o Migrate SQL Server database to SQL Server 2012, 2014

o Develop Reports using SSRS

o Develop database design, development, and management standards

o Consult with developers regarding database design.

o Implement 3rd party databases for vendor supplied applications

* Business Intelligence

o Support development of a business intelligence solution for CLIENT

* Oracle11/12: Desired

o Develop Dashboard and reports using through BI solution

o Develop and present end user training for BI solution

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):

* SQL Server 2008, 2012

* SQL Server Reporting Services

* SQL Server Analysis Services

* Reports Designer

* Business Intelligence Tools and Design.

* 8 - 10Years SQL DBA Experience

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):

* SQL Server 2014,2016

* DD Boost to Support Backup AND Restore Operations for SQL Server

* Oracle11/12 Business Intelligence Microsoft Office

* Microsoft Project

* Microsoft Visio