Deano Diergaardt

Experience

• 

  Hortgro

  Apr 2010 - Aug 2011

  Data Analyst

  • I was responsible for processing and distributing market information over a wide spectrum of industry activities.• Updating information and adaptations of crop estimates to and from the industry and its members.• Weekly updating and processing of South African and competing countries data.• Database administration and processing of data.• Provide support with regards to updating of the price model information on the website and distribution of information.• Processing and supplying information for newsletters, information pamphlets and articles for market forums and other industry groups.• Preparation of information and presentations for meetings.• Basic website updating Show less

• 

  Spier

  Jan 2012 - Mar 2012

  ERP Systems Analyst (Contract)

  • Maintaining ERP systems and planning systems stock reference data.• Automate and maintain regular reports.• Compiling and running scheduled ad hoc reports on Cognos.

• 

  Oursource

  Apr 2012 - Aug 2015

  Database Administrator

  • Keeping databases up to date• Helping with database design and development• Designing maintenance procedures and putting them into use• Managing database security/integrity and backup procedures• Writing reports, documentation and operating manuals• Testing and modifying databases to ensure that they operate reliably• Providing user training, support and feedback• SSIS and SSRS tasks• VBA

• 

  Capitec Bank

  Aug 2015 - Jan 2024

  Establishing the needs of users and monitoring user access and security.Monitoring performance and managing parameters to provide fast responses to front-end users;Installing and testing new versions of the DBMS;Maintaining data standards, including adherence to the Data Protection Act;Controlling access permissions and privileges;Developing, managing and testing back-up and recovery plans;Ensuring that storage and archiving procedures are functioning correctly;Capacity planning;Working closely with IT project managers, database programmers and multimedia programmers;Communicating regularly with technical, applications and operational staff to ensure database integrity and security;Commissioning and installing new applications and customising existing applications in order to make them fit for purpose.Database Operations: - SQL Server - AWS RDS - Automation via Powershell - Ansible - Azure Show less Establishing the needs of users and monitoring user access and security.Monitoring performance and managing parameters to provide fast responses to front-end users;Installing and testing new versions of the DBMS;Maintaining data standards, including adherence to the Data Protection Act;Controlling access permissions and privileges;Developing, managing and testing back-up and recovery plans;Ensuring that storage and archiving procedures are functioning correctly;Capacity planning;Working closely with IT project managers, database programmers and multimedia programmers;Communicating regularly with technical, applications and operational staff to ensure database integrity and security;Commissioning and installing new applications and customising existing applications in order to make them fit for purpose. Show less

  • Senior Database Administrator

    Oct 2018 - Jan 2024

  • Database Administrator

    Aug 2015 - Oct 2018
• 

  Absa Group

  Jan 2024 - now

  Senior MSSQL DBA

  DBA in the Enablement and Shared Service team, responsible for the delivery of DevOps capabilities