I have a very urgent DIRECT CLIENT requirement for *SQL Server DBA* in
*Columbia,
SC*. Please Let Me Know If you have available candidate, please reply with
their word resume, location, rate and contact number.
Please send the resumes at alb...@cncconsulting.com
*Job Titie: SQL Server DBA*
*Location: Columbia, SC*
*Duration: 12 Months*
*Client: State of SC*
*Must have experience upgrading from SQL Server 2008 to SQL Server 2012. *
*Local candidates preferred. Stat gov experience preferred*
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.
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 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 service 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
o Develop Reports using SSRS
o Develop database design, development, and management standards
• Business Intelligence
o Support development of a business intelligence solution for
SCDMV
• Oracle 11/12
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 – 10 YEARS SQL DBA EXPERIENCE
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR SQL SERVER
SQL SERVER 2014, 2016
ORACLE 11/12 BUSINESS INTELLIGENCE MICROSOFT OFFICE
MICROSOFT PROJECT
MICROSOFT VISIO
Database Platformsbackup/recovery Yes 1
AdvancedCurrently Using 6 + Years
Database PlatformsHigh-AvailabilityYes 1
AdvancedWithin 6 Months 6 + Years
Database PlatformsMS SQL Server 2008 enterprise serverYes
1 AdvancedWithin 5 Years 4 - 6 Years
Database PlatformsMS SQL Server 2008 R2 Yes 1
AdvancedWithin 5 Years 6 + Years
Database PlatformsMS SQL Server 2012Yes 1
AdvancedWithin 2 Years 6 + Years
Database PlatformsSchema design including the appropriate
implementation of database access security protocols into reporting program
code. Yes 1 AdvancedCurrently
Using 6 + Years
Database PlatformsSQL Server Analysis Services ( SSAS)Yes
1 Intermediate Within 2 Years 4 - 6 Years
Database PlatformsSQL Server Integration Services (SSIS)Yes
1 Intermediate Within 2 Years 4 - 6 Years
Database PlatformsSQL Server Reporting Services (SSRS