SQL Server DBA SSIS/SSRS T-SQL - Voorschoten - Holland

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

Keywords

Description

SQL Server DBA SSIS/SSRS T-SQL - Voorschoten - Holland

Essential technical skills & experience relevant to the role
*College or University Bachelor degree and at least three years relevant experience.
*Thorough Microsoft SQL Server knowledge.
*SQL Server Clustering/Mirroring/Replication.
*SQL Server Integration Services (SSIS).
*SQL Server Reporting Services (SSRS).
*SQL Server Analysis Services (SSAS).
*ANSI SQL/Transact-SQL (TSQL) Developer skills.
*Database diagnostic and tuning.
*Fluent Business English.
*European Driver's license.

Job summary
Installs, configures, maintains and administers MS SQL Server software and databases. Evaluates MS SQL Server database design. May troubleshoot network connectivity and recommend improvements to database network connectivity. Provides documentation, project tracking and management reporting.
May provide tactical input on overall network connectivity planning and related projects.

Working Conditions
*Can be called upon for urgent advice and decision making during out-of- office hours.
*Participate in after-duty-hours on-call rotation in order to assure consistent high availability of all databases.
*Participate in periodic database maintenance in order to facilitate efficient database/application operations - these maintenance periods may occur after office hours (ie evenings/weekends).
*Participate in periodic Disaster Recovery exercises to verify integrity of database operations/backups/restores.
*Short visits abroad may occur.
2 Key objectives & responsibilities of the role

ObjectivesResponsibilities
*Develop and maintain an optimal performing, secure and stable database environment
*Develop and maintain sound backup and recovery strategies together with the Technical Services Department.
*Maintain close relationships with BSM, and applications owners to stay informed regarding business processes and business rules.
*Provide advice to application owners/BSMs in the areas of database development and design (R&D) and emerging database technologies.
*Stay updated with latest technology & vendor updates.
*Maintain close and active relationship with Technical Services Department & Support Services department.
*Maintain documentation regarding the databases.
*Create plans- and implementation of additions, deletions and major modifications to database company-wide.
*Manage and perform necessary software maintenance, which may include security patches, database upgrades, bug fix application, etc.
*Implement and maintain security to conform to established SOX controls.
*Perform general technical troubleshooting and provide consultation to application and development teams as appropriate.
*Planning and performing periodic maintenance periods of databases in order to facilitate efficient operations.
*Maintain and track software distribution.
*Database performance diagnostic and tuning .
*Tune, develop, provide and analyze metrics on the performance and growth levels.
*Complies with and enforces standard XXXXXX policies and procedures.
*Perform risk analysis when updating hardware and software and provide change control documentation.
*Assist application owners/support staff with vendor management.
*Application support and development liaison.
*Database training assessment and coordination.
*Solid and updated administration.
*IT Change Management process.
*Participates in all programs relating to performance evaluations and career development planning.
*Develop, maintain and react to SQL Server alerting.
*Develop, maintain SQL Server jobs.
*Solve problems/issues proactive.
3bDesirable technical skills & experience relevant to the role
*Oracle RDMBS 10g/11g knowledge
*Oracle Enterprise Manager.
*Data WareHousing Design & Modeling.
*SAN and VMware systems knowledge.
*ETL experience, Informatica Powercenter 9.1.
4aEssential competencies relevant to the role
*Planning, project management.
*Pursues excellence in all aspects of business.
*Effective, integer and tactful communication.
*Strong Consumer and Customer focus.
*Possesses the expert knowledge to identify opportunities for change and the ability to convey the need for change.
*Analytical skills to translate functional requirements into technical solutions.
*Strong problem resolution and analytical skills required.
*Managing change.
*Financial awareness & reporting skills.
*Administrative skills.
*Creative and innovative thinking.
*Teamwork.
*Documentation.
4bDesirable competencies relevant to the role
*Commercial and Business awareness
*Willingness to adapt to rapidly changing conditions (at times) under pressure
*Ability to respond to crisis situations with composure and self-assurance
*Financial awareness
*Learn quickly with minimal supervision
5Key performance indicators
6Main relationships
*Database & Integration Environment Manager
*Works closely with Technical Services Manager
*Works closely with Application (Support) Managers

*You will be on 12 month renewable contract with the client but paid on a per annum than a per day - this includes holidays etc.Cognitive Group are trusted and exclusively retained to fill senior AX, CRM and SharePoint positions for the top 40% MS Dynamics partners, the world's largest software vendors and hundreds of end user organisations.

Cognitive Group have unparalleled experience in Dynamics recruitment. We are well networked through personal contacts within the Microsoft Dynamics recruitment arena and hold a sustained track record of helping Microsoft centric companies identify, attract and retain the best Dynamics professionals in the industry. As a consequence we can offer the widest variety of Dynamics jobs based on a detailed understanding of what you specifically want, not just what's available at that time.

A Unique Candidate Experience
The Cognitive Groups approach is different from most Dynamics recruitment consultancies in that we're interested in you for the long term. We focus on your motivations, aspirations and personal goals with the aim to match your skills, knowledge and aspirations to the optimum permanent or contract role for you.

Start date
n.a
Duration
12 months renew
From
Cognitive Group
Published at
24.01.2014
Project ID:
655317
Contract type
Freelance
To apply to this project you must log in.
Register