SQL Server DBA

Infojini Inc

Blythewood (SC)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A technology solutions company located in South Carolina is seeking a skilled SR. DATABASE ADMINISTRATOR to manage and maintain SQL Server databases, including migration from SQL Server 2008 to SQL Server 2012. The position requires 8-10 years of SQL DBA experience, strong troubleshooting skills, and the ability to work on high availability solutions. Excellent communication skills are necessary, and candidates located in SC, GA, or NC will have preferred consideration. This is expected to be a long-term assignment requiring on-site presence.

Qualifications

8-10 years SQL DBA experience required.
Experience with SQL Server Database Administration.
Strong skills in backup, recovery, and automation.

Responsibilities

Manage and maintain all production and non-production databases.
Perform backup and recovery on Database Management Systems.
Troubleshoot SQL Server performance issues as they occur.
Develop and support data warehouse and cubes through SQL Server Analysis Services.

Skills

SQL Server 2008

SQL Server Reporting Services

SQL Server Analysis Services

Reports Designer

Business Intelligence Tools and Design

Education

Bachelor's degree in a related area

Tools

SQL Server 2012

SQL Server 2014

Oracle 11/12

Microsoft Office

Microsoft Project

Microsoft Visio

Job description

POSITION: SR. DATABASE ADMINISTRATOR

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 database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. May require a bachelor's degree in a related area and 3-5 years of experience in the field or in a related area.

SCOPE OF THE PROJECT

SCDMV 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. SCDMV is also facing increasing security concerns around these assets. SCDMV 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 oral and written communications skills are required.

DAILY DUTIES / RESPONSIBILITIES

Setup and maintain data replication and mirroring
Configure maintenance automation
Backup and Recovery
Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends
SQL Server monitoring
Install and configure new SQL Servers
Develop and support data warehouse and cubes through SQL Server Analysis Services
Migrate SQL Server database to SQL Server 2012, 2014
Develop Reports using SSRS
Support SSIS packages
Develop database design, development, and management standards
Consult with developers regarding database design.
Implement 3rd party databases for vendor supplied applications.
Oracle 11/12: Desired - Analyze, develop, and support stored procedures and SQL.
Business Intelligence: Assess business intelligence tools for appropriateness to SCDMV data architecture, SQL and Oracle.
Design and develop and manage the design and development of dashboards and reports through a BI solution
Develop and present end user training for BI solution
Develop and present developer training for BI solution