Connecting...

W1sizmyilcivc3j2l3d3dy9vbgl2zxivy3vycmvudc9wdwjsawmvchjvzhvjdglvbi9wzw9wbgvzb2x2zwqvaw1hz2vzl2jhbm5lci1kzwzhdwx0lwe0n2e3ndcxzmfiyzk3mzkwnzywytaxyzazmjc1nzi0otfizjg0yzdiztcxyjlhmzbjyme4ztnlztg0owm0odcuanbnil0swyjwiiwidgh1bwiilciyntywedqwmcmixv0

Developer (4335)

Developer (4335)

Job Title: Developer (4335)
Location: Gauteng
Industry:
Salary: 540000.00
Reference: JN -082016-6397
Job Published: December 06, 2016 09:12

Job Description

The Data Platform Consultant role is focused on the best practice establishment and operation of Microsoft data platform services up to and including the establishment of Microsoft Analytics Services environments.
 
Microsoft SQL Server Data Platform:
Implementation of Microsoft Reporting Services and Reports
Implementation of Microsoft Analytics Services
Ability to fork lift and migrate data from SQL Server to Data Warehouse
TSQL
ETL via SSIS
Creation of TSQL and Reporting in SSRS
Interaction with users to gather and document task and project requirements related to SQL Data Platform
Database development and support in Microsoft SQL Server environments.
Support of BI tools an environments using, SSRS, SSAS, SSIS
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Performance tuning, query optimisation, using performance monitor, SQL profiler and other related monitoring and troubleshooting tools.
bsp;;Detect and troubleshoot SQL server related CPU, memory, I/O, disk space and other resource contention.
Backups, restores, recovery models, database shrink operations, DBCC commands, replication.
PowerShell for SQL
Implementing operational automation.
Indexing, index management, integrity checks, configuration, patching.
Making use of SQL server tools such as Profiler, DTA, SSMS, PerfMon, system stored procedures
SQL development - ability to write and troubleshoot SQL code
Design of stored procedures, functions, tables, views, triggers , indexes , constraints
Documentation of processes and procedures
SQL database operational support to users
SQL Server Integration Services and TSQL for ETL
Creation, Maintenance, Enhancement and troubleshooting of SSIS packages
Creation, Maintenance, Enhancement and troubleshooting of SSAS processes.

Formal Qualifications Required
Relevant graduate qualification
Desirable
Relevant post-graduate qualification or
Desirable
Relevant certification (MCSE Data Platform)
Desirable

 
Job Related Experience Required Time Span

-Microsoft Reporting Design
5+ years
Essential
Microsoft SSAS
5+ years
Desirable
Database development
5+ years
Essential
SSRS report development
5+ years
Essential
Bi development
4+ years
Desirable
Quality testing
5+ years
Desirable
Operational support
5+ years
Desirable
SQL server / database administration
5+ years
Essential

 
Job Related Knowledge Required
Microsoft BI Environment Creation and Support
Desirable
Microsoft Analytics Services
Desirable
Database design and development
Essential
Report design and development
Essential
T-SQL Excellent SQL Skills
Essential
Call resolution and change control experience;
Essential
SQL Server Replication
Desirable
SQL server / database administration
Essential
PowerBI
Desirable
Data warehousing
Desirable
Disaster recovery
Desirable
Microsoft Excel
Desirable
Microsoft Access
Desirable
Visual studio development
Desirable

 
Job Related Skills Required
Relational database / BI schema design
5+ years
Strong T-SQL skills.
5+ years’ Experience in database administration with Microsoft SQL Server 2012 or higher
5+ years’ Experience in performance monitoring with Microsoft SQL Server 2012 or higher.
5+ years
Sound knowledge of integration services, analysis services and reporting services
5+ years

 
Competencies
Adaptability
Building Customer Loyalty
Time Management
Follow & up
Initiative
Innovation
Managing Conflict
Communication
Continuous Learning
Contributing to team success
Customer Focus
Decision Making
Planning and Organising
Quality Orientation
Stress Tolerance

 
PeopleSolved is a leading specialist recruitment firm solving the needs of and for people globally
 
 

Get similar jobs like these by email

By submitting your details you agree to our T&C's