Tando Bonga

Experience

• 

  NMA Computer Solutions

  Jan 1997 - Dec 1997

  PowerBuilder & Sybase SQL Server Analyst Programmer

  Maintaining software applications (All in PowerBuilder & Sybase SQL Server).Developing new applications using Object Oriented techniques.Led a team whose main duty was to develop & maintain new applications. Report writing using Sybase SQL Server.Involved in analysis, design, developing/coding, testing, code reviewing (quality assurance) and rolling out maintenance and new releases of the applications under my domain.

• 

  Snyman & Partners

  Jan 1998 - Sept 1998

  PowerBuilder & Sybase Adaptive Server Programmer

  Developing new system as the company was moving from CLIPPER to PowerBuilder & Sybase SQL Server and later Sybase Adaptive Server.Involved in analysis, design, developing/programming and testing.

• 

  Nestle South Africa

  Sept 1998 - Jan 2007

  Database administration, maintenance, development and monitoring in Microsoft SQL Server 2000 & 2005. Client server software development and maintenance using Sybase PowerBuilder. Project management for the software and database migration projects.Business Applications Support using SAP software.Detail the business process for mapping Nestlé business solutions against the SAP environment. Undertake assigned SAP configuration tasks according to standards and guidelines currently in use, while ensuring all documentation requirements have been performed. Provide business process expertise on a specific business area (Materials Handling/Supply Chain).Collaborate with application specialists to develop functional specifications for any custom application developments required to complement the standard GLOBE Application Template in meeting market business requirements, following approved localisation requests.Understand specifications, business impact and processes of specifications provided by business analyst or senior systems analyst. Analyse/investigate specific issues/problems within existing systems. Perform maintenance on PowerBuilder programs in accordance with accepted user requests. Show less Maintaining software applications (all in PowerBuilder 6.0 & Microsoft SQL Server 7 & 2000). Migrating PowerBuilder applications from PB5 to PB6 and PB7. Responsible for setting up and implementing development standards.Database Administration, maintenance and development in Microsoft SQL Server 6.5, 7 & 2000. Report writing using Microsoft SQL Server 7 & 2000.Drafted and implemented the Disaster Recovery Plan for SQL Server 7 & 2000.Responsible for the consolidation of Head Office MS SQL Server 7 databases from different servers into one MS SQL Server 2000.Migrating database from MS SQL Server 6.5 to 7 and 2000. Responsible for the maintenance & administration of the COGNOS Business Intelligence environment.Project ManagementPreparing Project Definition, Project Charter and Project Plan for the Applications Migration & Testing Project. Managing the Applications Migration & Testing Project.Managed the MS SQL Server \ Cognos Pilot Project.Managed the MS SQL Server 2000 Consolidation project.System Analyst - SAP Technical & Production TeamResponsible for identification of relevant master data objects with the help of business master-data owners, development of data gathering plans with master data owners. I completed loading sheet mapping. I designed and developed legacy data extraction programs in MS SQL Server and Webfocus ETL Manager. Show less

  • Business Application Support Specialist - SAP Materials Handling Team & SQL DBA

    Dec 2004 - Jan 2007

  • Software Developer and SQL Database Administrator

    Sept 1998 - Nov 2004
• 

  ETyhume Database Solutions

  Feb 2007 - Sept 2007

  Independent Consultant

  Database design and implementation.Database objects creation.Database integrity and consistency checking using DBCC.Designing and implementing database server consolidation.Database administration, maintenance and monitoring.Database backups and restores.Creating and monitoring scheduled jobs.Managing and creating user logins and database access.Performance tuning (including query and index tuning).Database development and testing (writing queries, stored procedures, views, triggers, cursors, etc.)Report writing.Data transfer (import/export) using DTS & BCP.Planning and implementing database migrationPlanning & implementing disaster recovery.Database error log monitoring. Show less

• 

  Ascent Technology (Pty) Ltd.

  Sept 2007 - now

  Principal Database Consultant

  From 2017 - 2021, I was based at SBV as the Lead Database Engineer. From 2021 February - 2022 February, Lead DBA at OUTsurance for Ascent.From 2022 March - Current, Lead DBA at Tracker for Ascent.Database design and implementation.Data management.Database objects creation.Database integrity and consistency checking.Designing and implementing MS SQL Server database server consolidation.Database administration, maintenance, and monitoring.Database code tuning and optimisations.Performance tuning.Monitoring and troubleshooting database activity.Database performance auditing, database tuning and stabilization.Designing backup strategies.Database backups and restores.Creating and monitoring scheduled jobs.Configuring database mail and notifications.Managing and creating user logins, database access and database security.Database development and integration.Data transfer/exchange (import/export) using DTS, BCP & Integration Services.Planning and implementing database migration and upgrades.Planning & implementing disaster recovery.Database high availability (log shipping, replication, mirroring, clustering, AlwaysOn).Undertaking AlwaysOn failovers and monitoring.Project management for the software and database migration projects.Detail the business process for data modelling and mapping.DBA team management.Mentoring and training of DBA interns. Work well under pressure.Problem-solving ability.Excellent organising skills.Good verbal, written communications skills.Work well in a team and good team leader.Taking initiatives. Show less