Dewald Rautenbach
About Dewald Rautenbach
Dewald Rautenbach is a Senior SQL Developer at BrightRockZA in Johannesburg, South Africa, with a strong background in data science and extensive experience in SQL programming and database management. He has a proven track record in automating deployments, optimizing stored procedures, and developing integration solutions.
Work at BrightRock
Dewald Rautenbach has been employed at BrightRockZA as a Senior SQL Developer since 2019. In this role, he focuses on database development and management, contributing to various projects within the organization. His responsibilities include optimizing SQL queries and ensuring the integrity and performance of database systems. Rautenbach collaborates with system and business architects to align development practices with industry standards, particularly in relation to IFRS 17 implementation.
Previous Experience at COFESA Labour Law Specialists
Before joining BrightRock, Dewald Rautenbach worked at COFESA Labour Law Specialists as a Senior SQL Programmer from 2003 to 2015. During his 12 years in this position, he developed and maintained SQL databases, focusing on enhancing data management processes. His experience at COFESA laid the foundation for his expertise in SQL programming and database optimization.
Education and Expertise
Dewald Rautenbach completed his secondary education at Noordheuwel High, where he achieved a Senior Certificate from 1998 to 2002. He furthered his education at the University of London, earning a BSc in Computer Science with a focus on Data Science from 2019 to 2023. His academic background supports his technical skills in SQL development and data integration.
Technical Skills and Projects
Rautenbach has demonstrated proficiency in various technical areas, including the automation and configuration of Octopus for SSIS package and database object deployments. He developed business-to-business integration solutions using SSIS and integrated a REST API with PowerShell. His work includes optimizing stored procedures, achieving a 500% reduction in execution time, and leading the development of a reinsurance warehouse utilizing SQL Server 2019, SSIS, and C# scripting.
Contributions to Development Standards
In his current role, Dewald Rautenbach works closely with system and business architects to ensure compliance with development standards, particularly for IFRS 17 implementation. He creates complex T-SQL programs that generate JSON outputs for web display, significantly reducing manual labor by eliminating 100 man hours of work each month.