ensure that all technology components, including hardware, software, networks, and databases, are operating comprehensive and reflect current software and hardware assets.
responsible for implementing optimizing methods to store, analyse, utilize, and organize data associated Responsible for designing and optimizing methods to store, analyze, utilize, and organize data associated backed up data. o Collaborate with Team Leader: Hardware to ensure that backups conform to best practice patching. How statistics work, how indexes are stored, how they can be created and managed effectively Leads / Participates in systems software and/or hardware projects. · Manages projects of limited scope
when needed. Creating ad-hoc queries or SQL Server stored procedures, views and jobs based on user requests Design and maintain Excel and SSRS reports using stored procedures and views. Maintain or improve existing knowledge of the T-SQL language including use of stored procedures, triggers, views, data types, keys indexes years. Experience optimising SQL Server queries and stored procs and the use of query analyzer for tuning