JOB SEEKERS
EMPLOYERS
JOBS QUICK-SEARCH
.net
.net developer
a+
abap
account manager
accountant
admin
administrator
analyst
architect
bookkeeper
business analyst
business intelligence
c#
call centre
ccna
cisco
cloud
cobol
consultant
delphi
desktop
desktop support
developer
engineer
finance
graduate
graduates
helpdesk
internship
it manager
it support
it technician
java
java developer
junior developer
legal
linux
manager
marketing
mcse
network
network administrator
oracle
personal assistant
php
php developer
programmer
project
project administrator
project manager
receptionist
sales
sap
secretary
security
sql
support
technical support
technician
test analyst
tester
web developer
NEWSLETTER
FOLLOW US
SQL BI DBA Architect (Illovo)
Job Ref
278637
Job Type
Permanent
Employer Type
Recruitment Agency
Date Added
8 May 2018
Expiry Date 5 Jun 2018
Expiry Date 5 Jun 2018
* There have been 2 applications to this job.
* This job has been viewed 3261 times.
Employer:
ICT Recruit
Location:
Gauteng
Salary:
ZAR45000 - ZAR50000 PM
Benefits:
Medical Aid Pension fund
Role details:
Overall, this person will be responsible for leading data architecture, database administration, data integration and data services platforms for Data Services, Business Intelligence and Data Governance. The Data Services Manager is hands on technical expert who will ensure that the data integration platforms and architecture are maintained and services delivered meets the business demand
- - - - - - - - - - - - - -
Education:• BSc degree in IT or higher
Skills:
• Designing and the review of data processes and meta data; and providing solutions regarding data (together with the IT Architect) to ensure that the business requirements are met.
• Maintaining and upgrading the database and data integration platforms, to an error free and optimum performance state.
Technical:
• Knowledge of logical and physical database modeling concepts and techniques
• Ability to express complex technical concepts effectively, both verbally and in writing
• Knowledge of database performance factors, monitoring tools and tuning procedures
• Knowledge of relational database design and implementation
• Microsoft SQL Server experience (SQL 2008/2012/2014) with Transact-SQL, writing of stored procedures, views, triggers, common table expressions, windowing functions, creating indexes and constraints
• Thorough knowledge of SQL Server 2008/2012/2014 features including Service Broker, Change Data Capture, Table Partitioning, Replication, and Data Compression
• Knowledge of SQL Server Integration Services (SSIS)
• BI/DW systems design and development
• Crystal Reports and SQL Reports (SSRS) experience
Tasks:
• To perform database administration.
• To provide leadership over business intelligence (BI) /data warehouse (DW) and operational data store implementations and solutions.
• To work in conjunction with end-user and other relevant stakeholders to define data business needs.
• To be responsible for Extract Transform Load (ETL) design, and implementation of data loading processes.
• To manage delivery of DW/BI solutions (portals, dashboards, standard and ad-hoc reporting) with a specific focus on data governance, operational data store and DW architecture.
• To support, maintain, and monitor current ETL processes.
• To conduct root cause analysis and resolve production problems and data issues.
• To lead efforts to develop and improve procedures for database performance monitoring and proactive intervention using appropriate tools.
• To oversee technical support of all database technologies including monitoring, reporting, patching, troubleshooting and code deployment.
• To be responsible for defining and enforcing policies, processes, standards and best practices for development, integration services, and database administration.
• To assist with the design of redundant systems, policies, and procedures for disaster recovery to ensure effective availability, protection, and integrity of data assets.
• To ensure that the company IT maintains a highly available and secure database environment.
• To work with the Architect, Project Managers, and Business Analysts to communicate the impact of technical decisions on:
o Scope;
o Resourcing needs;
o Requirements needs; and
o The impact of the changes.
Reference for this position is SQL BI Architect which is a permanent position based in Sandton Illovo offering a salary of R 50 000 per month with Pension fund and Medical Aid (11%).
ICT Recruit are specialist IT recruiters with a wide range of tech positions available. Should you not hear from us within 14 working days please consider your application unsuccessful, however we do keep CV’s on our Database for future use or other positions you qualify for.
Email your CV today – lea @ ictrecruit. co. za
Check out our website www.ictrecruit.co.za for more positions that might be right for you!
Follow us on Instagram https://www.instagram.com/leaictrecruit/