Essbase/SQL Server DBA ( 4957WS )

Lausanne  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Reference #:
4957WS
Industry:
FMCG
Location:
Lausanne und Region
Start:
ASAP
Duration:
Until March 2015
Role:
Essbase and SQLServer DBA for Dynamic Forecasts
Provide Essbase and SQLServer (2005, 2008R2 and above) database expertise, to ensure quality of the delivery, availability and performances for Dynamic Forecasts Program worldwide. Ensure the respect of the client standards and guidelines and ITIL processes.
Main responsibilities:
Mainly support of Dynamic Forecast solution.
Installation and configuration of Essbase according to my client standard.
Monitoring and performance troubleshooting on Essbase
Knowledge on Essbase backup solution
Manage the delivery process regarding Essbase component for the current architecture
Installation of SQLServer 2008R2 & 2012 new instances, according to the standard, on standalone or clustered servers.
Troubleshooting and incident management for data services, Integration services and Analysis Services.
Management of connections to database servers.
Management of users and privileges.
Ensure availability and performances by proactive monitoring of databases, and tuning on demand.
Plan and follow-up worldwide deployment of Essbase and SQLServer Service Packs and hot fixes.
Follow-up and report on progress of the projects. Commit on deadlines and ensure delivery according to the agreed planning.
Write and maintain runbook, to be used by offshore team.
Provide L3 support to offshore team.
Skills:
At least 5 years of experience with Essbase and Microsoft SQLServer (Data Services, Integration Services, Analysis Services, Reporting Services).
ESSBASE
SQLServer Enterprise Edition
MS Integration Services
MS Analysis Services
MS Reporting Services
T/SQL
Oracle Database
MS Office tools
ITIL methodology
The knowledge of Oracle Database is an advantage.
Language(s):
Must speak fluent English and French.
Please note that only the applications from EU Citizen will be considered.
Start date
10/2014
Duration
Till 31/12/2015
From
ITech Consult AG
Published at
17.10.2014
Project ID:
792691
Contract type
Freelance
To apply to this project you must log in.
Register