Request ID:IN-8694-1 (99790326)
SQL Server DBA with SSRS, SSAS, SSRS, Reports Designer, BI, DD Boost, Oracle BI/OBI, MS Project/Visio/SharePoint, MS System Center and DMV experience
Location:BLYTHEWOOD, SC
Duration:12+ Months
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
SQL SERVER 2008,2012, 2014
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 2016
DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR SQL SERVER
ORACLE 11/12 BUSINESS INTELLIGENCE MICROSOFT OFFICE
MICROSOFT PROJECT
MICROSOFT VISIO
Experience
Database Platformsbackup/recoveryYes1AdvancedWithin 2 Years6 + Years
Database Platformsfailover clustersYes1AdvancedWithin 2 Years6 + Years
Database PlatformsHigh-AvailabilityYes1AdvancedWithin 2 Years6 + Years
Database PlatformsMS SQL Server 2008Yes1AdvancedWithin 2 Years6 + Years
Database PlatformsMS SQL Server 2012Yes1AdvancedWithin 2 Years4 – 6 Years
Database PlatformsMS SQL Server 2014Yes1AdvancedWithin 2 Years2 – 4 Years
Database PlatformsSchema design including the appropriate implementation of database access security protocols into reporting program code.Yes1AdvancedWithin 2 Years6 + Years
Database PlatformsSQL Server Analysis Services ( SSAS)Yes1AdvancedWithin 2 Years4 – 6 Years
Database PlatformsSQL Server Integration Services (SSIS)Yes1AdvancedWithin 2 Years4 – 6 Years
Database PlatformsSQL Server Reporting Services (SSRS)Yes1AdvancedWithin 2 Years4 – 6 Years
Database PlatformsStrong background in database planning, scaling, and capacity planning activitiesYes1AdvancedWithin 2 Years4 – 6 Years
Database PlatformsOracle 11GNo3IntermediateWithin 5 Years4 – 6 Years
Database PlatformsOracle 12No3IntermediateWithin 2 Years2 – 4 Years
MiscellaneousBusiness Intelligence (BI)Yes2AdvancedWithin 2 Years6 + Years
MiscellaneousDESIGN OF COMPLEX WEB INTELLIGENCE REPORTS AND DASHBOARDSYes2AdvancedWithin 2 Years6 + Years
Additional Skills:Additional skills that would be helpful:
SharePoint 2010, 2013
MS System Center
DDBoost
Unstructured Data Management
Visio, MS Project
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 2016. 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 ORAL AND WRITTEN COMMUNICATIONS SKILLS ARE REQUIRED.
DAILY DUTIES / RESPONSIBILITIES:
•SQL Server
oSetup and maintain data replication and mirroring
oConfigure maintenance automation
oBackup and Recovery
oTroubleshoot SQL Server performance issues as they occur, including after-hours and weekends
oSQL Server monitoring
oInstall and configure new SQL Servers
oDevelop and support data warehouse and cubes through SQL Server Analysis Services
oMigrate SQL Server database to SQL Server 2012, 2014
oDevelop Reports using SSRS
oSupport SSIS packages
oDevelop database design, development, and management standards
oConsult with developers regarding database design.
oImplement 3rd party databases for vendor supplied applications
•Oracle 11/12: Desired
oAnalyze, develop, and support stored procedures and SQL.
•Business Intelligence
oAssess business intelligence tools for appropriateness to Client data architecture, SQL and Oracle.
oDesign and develop and manage the design and development of dashboards and reports through a BI solution
oDevelop and present end user training for BI solution
oDevelop and present developer training for BI solution