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