Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
CloudSmithsSenior Database Administrator
Aug. 2023Nelson Mandela Bay, Eastern Cape, South AfricaI am currently placed at a client of Cloudsmiths called Dentsu. We are working to build out a media solution called Audience Builder. This gives their clients the ability to do targeted marketing for audiences generated by survey questionnaires that are completed. Some of the techology that I work with daily include - Azure SQL Managed Instance - Azure SQL Database - Snowflake - Databricks - Azure VM's (created a development SQL VM for the project) - SQL Server (2019, 2022) The data sets I work with daily are very large (billions of records). I love doing performance tuning on the data, and really enjoy seeing this move more efficient.
Inzalo EMSSenior Database Administrator
Aug. 2018 - Aug. 2023Nelson Mandela Bay Municipality, Port ElizabethProduction DBA role with the following key responsibilities: > Migration of SQL 2019 production environment to Azure SQL Managed Instance (10 SQL Servers) > Optimize queries on production systems, to make them run more efficient > Analyze SQL server wait types, and apply the appropriate remedies > Using Query Store to find our most resource-intensive queries for optimization. > Index optimization and tuning > Using BrentOZar's SP_Blitz stack to troubleshoot our SQL servers, reducing CPU, Memory and IO requirements, and saving my company money in the process. Our workload runs on less compute because of these efforts. > Building and maintaining Apache Kafka data pipes to sync our data from one SQL server to the next. Distributed and Single broker setups, with load balancing checks. > JDBC Source and Sink connectors, Debezuim connectors to manage our Change Data Capture data flows. > Custom WMI events to detect changes to SQL or Domain user accounts on SQL > Change Data Capture implementation to track data as an audit solution > SQL Replication implementation > User and System database backup to ensure the server can be rebuilt if necessary in case of a disaster > DR planning and testing > Troubleshoot servers that are running slow and improve query speeds > Analyze dead locks, and apply remedies so that they do not happen anymore by working closely with developers to solve the issue > Proper SQL server installation and configuration, so that you get the best possible server that you are paying for > SSRS, SSMS, SSIS workable knowledge > Azure SQL Managed Instance, Azure SQL Database, SQL 2005, 2008, 2012, 2016, 2017, and 2019 expert > Implementation of best practice scripts i.e. SQL Master BrentOZar's SP_Blitz, Ola Hallengren, Pinal Dave and many more
Sebata Municipal SolutionsData Migration Manager and Information Technology Stream Lead
Jan. 2016 - Aug. 2018Nelson Mandela Bay Municipality, Port ElizabethTo facilitate the data migration efforts for the mSCOA ERP implementation project at Nelson Mandela Bay Municipality Our ERP implementation includes seven work streams, namely, Billing, Finance, Supply Chain Management, Assets, Inventor, Planning and HR/Payroll. I am accountable for all data migration activities on the project. Our data size to be taken on across from 37 legacy systems into one ERP system is around 30Tb large! Enjoying this project so much!
Sebata Municipal SolutionsIT Manager
Aug. 2015 - Jan. 2016Port Elizabeth Area, South AfricaTo assess and advise on Municipal readiness from an IT Infrastructure perspective for the mSCOA ERP Implementation project.
Blue LimitedGroup IT Manager
Sep. 2014 - Jun. 2015Pretoria Area, South AfricaOverview • Blue Financial Services is the market leader in Micro Loans throughout Africa with 25 instances of the micro-finance product FAME. • BLUE has a market capital of over R4 Billion. • All IT related development, email migration, server migration, Loan book data migration etc. projects in Blue were driven and overseen to completion by Mr Gustav Mulder and his team. Responsibilities • Enabling our teams to be productive • Enabling our teams to achieve • Creating and communicating a technological vision and strategy for the company • Top Management and Executive level engagement (presentations and advice) • Server Virtualization project (40 production servers) • Email Migration project (Exchange to Microsoft Office 365 Cloud Based) • Data Migration Project – transfer loan data to new loan system • Business requirement analysis • Project manage system delivery activities • Systems delivery – implementation and support • Change management • System configuration • System roll-out • System Customization • Business continuity • Business change impact and communication to stakeholders • Managing and guiding multiple software development teams • Career development of my team • Project items are met in budget, and on time. • ETL process monitoring, troubleshooting etc. Technology • Microsoft Projects • Microsoft Visio • Microsoft Office PowerPoint / Word / Excel / Outlook (2007, Office 365) • Webex (Virtual Meetings) • Windows Server 2003/2008/2012 • VMWare • Pastel • RDP • Microsoft SQL 2005, 2008 R2 • Visual Studio 2008 / 2010, 2013 • Microsoft .Net 3.5 / 4.0 / 4.5 • FAME Micro Lending System • SAS EDW Achievements • Managed a migration project to virtualize our production servers from owned to hosted in the cloud (40 servers) • Managed an email migration project from multiple versions of Exchange to a cloud based Office 365 solution from Microsoft
Blue Financial ServicesSystems Development Manager / Data Analyst
Sep. 2011 - Sep. 2014Pretoria Area, South AfricaOverview • Blue Financial Services is the market leader in Micro Loans throughout Africa with 25 instances of the micro lending platform FAME. • BLUE has a market capitalization of R4 Billion. • All software products in Blue were administered from a solutions development perspective by Mr Gustav Mulder and his team Responsibilities • Business requirement analysis • Project manage system delivery activities • Systems architecture and design • Systems development • Systems presentation and testing • Systems delivery – implementation and support • Change management • System configuration • Business change impact and communication • Managing and guiding a software development team consisting of 3 Developers, 1 Data Analysts, 1 Database Administrator, 1 Software Tester and 1 Business Analyst throughout the software development life cycle (SDLC). • Career development of my team • Project items are met in budget, and on time. • Looking after +- 115 databases on Microsoft SQL 2005 and Microsoft SQL 2008 R2 • Data integrity checks • SQL Scripting • SQL Stored Procedures • Data interrogation and manipulation • Backup and Restore of database • Report Creation using SQL Reports and Visual Studio 2008 / 2010 Technology • Microsoft SQL 2005, 2008 R2 • Visual Studio 2008 / 2010, 2013 • Microsoft .Net 3.5 / 4.0 • Microsoft Projects • Microsoft Excel Achievements • BLUE’s product FAME requires that the financial books for each instance has to be manually taken over to the next financial day. Mr Mulder managed to implement an automated solution that utilizes SQL instead of the Windows Forms Application to accomplish this. • Established a Service Desk within BLUE to accommodate 1st, 2nd and 3rd line supporting and escalation structures servicing 10 countries throughout Africa.
Infinity Technology (PTY) LtdManaging Partner
Oct. 2002 - Jul. 2011
Bulmers LtdHelpdesk Analyst
May. 2002 - Aug. 2002a Helpdesk Analyst and the later as a Support Engineer on a Novell Network.
AST GijimaSupport Engineer [Systems Administrator]
Sep. 1997 - Mar. 2001. Work entailed the following: Administration of NT4.0 and Novell Netware accounts, NDPS. Backup of file servers NT4.0 , Novell Netware and SAP System registry editing, troubleshooting and diagnostics on NT4.0, Win95/98, Windows 2000; Building and repair to PCs and network servers on first line support level Hardware and Software installation and maintenance Training of Junior network support engineers Handling of 3rd party vendors Recommendation and approval of above mentioned: Ian du Plessis Support Manager (Mining Hq & Aff.)
Intch is a Professional Networking App for the Future of WorkSee more people like Gustav on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1026939 people
15
Data Analyst @ BK IT Technologies
26
SAP FICO CONSULTANT @ SARs
38
Entrepreneur / 3x Tech Startup / Marketing and Growth @ Morlean Trading Group
78589 people
15
Data Analyst @ BK IT Technologies
17
CTO / Solutions Architect
32
Financial/Business Manager @ Automotive group