Data Warehouse Specialist

Urgently looking for a Data Warehouse Specialist who can operate at a Function Level.The primary responsibility of the Data Warehouse Specialist is to advise on the development of medium to high complexity management information systems that will ensure the promotion of operational efficiency and effectiveness for the Internal IT Function. Successful candidate must be able to :

Develop and optimise SQL tables, views, procedures, and query statements
Develop acquisition solutions, which will include SQL/SSIS, Replications, ESB technologies, and bespoke API solutions
Develop and maintain optimal SQL Indexing strategies
Ensure performance, security, and availability of databases and associated services
Handle common database procedures like upgrades, backups, recovery, migration, etc.
Profile server resource usage, and optimise and tweak as necessary
Create, manage and optimise SQL server jobs
Evaluate new technologies and be able to build Proofs of Concepts
Prepare design specifications, and detailed solution documentation
Collaborate with other team members and stakeholders
Participate in Agile ceremonies like feature/story development, backlog grooming, and daily scrums