Very urgent DIRECT CLIENT Opening. Please send the resumes at
su...@cncconsulting.com
Job Tite: SQL Server DBA
Location: Columbia, SC
Duration: 12 Months
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
Setup and maintain data replication and mirroring
Configure maintenance automation
Backup and Recovery
Troubleshoot SQL Server service 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
Develop Reports using SSRS
Develop database design, development, and management standards
Business Intelligence
Support development of a business intelligence solution for SCDMV
Oracle 11/12
Develop Dashboard and reports using through BI solution
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 Platforms backup/recovery Yes 1
Advanced Currently Using 6 + Years
Database Platforms High-Availability Yes 1
Advanced Within 6 Months 6 + Years
Database Platforms MS SQL Server 2008 enterprise server Yes
1 Advanced Within 5 Years 4 - 6 Years
Database Platforms MS SQL Server 2008 R2 Yes 1
Advanced Within 5 Years 6 + Years
Database Platforms MS SQL Server 2012 Yes 1
Advanced Within 2 Years 6 + Years
Database Platforms Schema design including the appropriate
implementation of database access security protocols into reporting program
code. Yes 1 Advanced Currently
Using 6 + Years
Database Platforms SQL Server Analysis Services ( SSAS) Yes
1 Intermediate Within 2 Years 4 - 6 Years
Database Platforms SQL Server Integration Services (SSIS) Yes
1 Intermediate Within 2 Years 4 - 6 Years
Database Platforms SQL Server Reporting Services (SSRS) Yes
1 Advanced Currently Using 6 + Years
Database Platforms SQL Server tools: PerfMon Yes 1
Advanced Currently Using 6 + Years
Database Platforms SQL Tuning Yes 1
Advanced Currently Using 6 + Years
Database Platforms Strong background in database planning, scaling,
and capacity planning activities Yes 1
Advanced Currently Using 6 + Years
Database Platforms Oracle RDBMS No 3
Intermediate Within 5 Years 1 - 2 Years
ERP ORACLE BUSINESS INTELLIGENCE REPORTS DESIGNER (OBIRD) No
3 Intermediate Within 2 Years 1 - 2 Years
Miscellaneous Business Intelligence (BI) Yes 2
Advanced Within 2 Years 4 - 6 Years
Miscellaneous DESIGN OF COMPLEX WEB INTELLIGENCE REPORTS AND DASHBOARDS
Yes 2 Advanced Within 2 Years 4 - 6
Years
Additional Skills: DD BOOST database backup and restore
tools. Preferred.
Microsoft SQL Server 2014, 2016
Thanks,
Sunny Roy
su...@cncconsulting.com
--
You received this message because you are subscribed to the Google Groups "SAP
BASIS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-basis+unsubscr...@googlegroups.com.
To post to this group, send email to sap-basis@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-basis.
For more options, visit https://groups.google.com/d/optout.
