Backup/Recovery SQL Server Reporting Services SSRS Business Intelligence Failover C

Requirement id 152549

Job title Administrator

Job location in Blythewood, SC

Skills required Backup/Recovery, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services SSRS Busin

Open Date 21-Mar-2025

Close Date

Job type Contract

Duration 12 Months

Compensation DOE

Status requirement ---

Job interview type ---

Email Recruiter:coolsoft

Job Description Administrator: Backup/Recovery, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services SSRS Busin

Start date : APRIL 15TH 2025

Submission deadline : 3/28/2025

Client Info : Department of Motor Vehicles

Note:

This person will be providing production support and may be asked to work some overtime.Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) Interviews will use MS Teams (video enabled).

Interviewers will be: Darl Neiswonger: IT Director I – Application Systems Development and

Lynn McGilvery, Data Manager

Q) SCHEDULE INTERVIEW: How soon can you schedule an interview (date / times)?

A) INTERVIEWS WILL START THE WEEK OF MARCH 31ST.

Description :

SCOPE OF PROJECT:

SCDMV SUPPORTS IN THE NEIGHBORHOOD OF 300 PLUS SQL SERVER DATABASES AND ARE IN THE PROCESS OF MIGRATING THOSE DATABASES FROM SQL SERVER 2012 TO SQL SERVER 2019. 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.

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:

• 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 databases to SQL Server 2019

o Develop Reports using SSRS

o Support SSIS packages

o Develop database design, development, and management standards

o Consult with developers regarding database design.

o Implement and support 3rd party databases for vendor supplied applications

• Oracle 19: Desired

o Analyze, develop, and support stored procedures and SQL.

• Business Intelligence

o Design, develop, and manage dashboards and reports through a BI solution

o Develop and present end user training for BI solution

o Develop and present developer training for BI solution

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):

SQL SERVER 2012, 2014, 2016, 2019

SQL SERVER REPORTING SERVICES

SQL SERVER ANALYSIS SERVICES

REPORTS DESIGNER

BUSINESS INTELLIGENCE TOOLS AND DESIGN.

8 – 10 YEARS SQL DBA EXPERIENCE

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):

SQL SERVER 2012, 2014, 2016, 2019

DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR SQL SERVER

ORACLE 19

BUSINESS INTELLIGENCE

MICROSOFT OFFICE

MICROSOFT VISIO

Call502-379-4456 Ext 100for more details. Please provide Requirement id: 152549 while calling.