Siphiwo Lumkwana
SQL Developer
Cape Town
Summary
Accomplished SQL Developer specializing in optimizing complex SQL queries to enhance data analysis and improve system performance. Proficient in Oracle SQL and PL/SQL, with a strong ability to provide constructive feedback and facilitate knowledge sharing within teams. Known for exceptional problem-solving abilities and effective collaboration skills, driving project success and efficiency.
Overview
17
17
years of professional experience
Work History
SQL Developer
PBT Group
Cape Town
10.2019 - 06.2024
- Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Provided technical assistance in the form of SQL coding advice to other team members.
- Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
- Conducted unit testing of all database objects before deployment.
- Analyzed business requirements and translated them into logical data models.
- Utilized version control systems to manage changes to SQL scripts and database objects, ensuring consistency across environments.
PLSQL Developer
Metropolitan
Cape Town
07.2018 - 09.2019
- Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
- Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.
- Created scripts to automate daily tasks such as backup jobs and scheduled jobs.
- Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
- Assessed code during testing stage to determine potential glitches and bugs.
- Provide constructive and timely feedback on work progress and problems encountered.
PLSQL Developer
PEPKOR IT
Cape Town
04.2017 - 06.2018
- Developed stored procedures, functions and packages using PLSQL to support the application development needs.
- Optimized SQL queries and stored procedures, reducing execution time by significant percentages.
- Utilized version control systems to manage changes to SQL scripts and database objects, ensuring consistency across environments.
- Conducted peer code reviews to ensure quality and adherence to coding standards.
- Provide constructive and timely feedback on work progress and problems encountered.
- Perform standby duties to ensure services are available.
SQL Developer
Liberty Health
Cape Town
08.2007 - 03.2017
- Developed and optimized complex PL/SQL queries and stored procedures, increasing the efficiency of data retrieval operations while adhering to the defined requirements and within the agreed timeframes.
- Provide constructive and timely feedback on work progress and problems encountered.
- Perform code reviews for colleagues to ensure quality code is promoted to production.
- Perform realistic estimates of effort and size of tasks to be completed.
- Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
Education
ND - Information Technology
Cape Peninsula University of Technology
01.2007
Grade 12 -
01.2002
Skills
- Oracle SQL and PL/SQL
- MSSQL T-SQL
- Database development
- Apex
- Linux
- JavaScript
- PowerShell
- Bash
- Git
- SVN
Telephonenumber
0605294583
Personal Information
Date of Birth: 05/19/84
References
- Ryan Read, Team Leader, PBT, 0849004455, Ryan.read@pbtgroup.co.za
- Mr Vapi Njamela, Analyst Developer, Sanlam, +27 72 879 8719, Vapi.Njamela@sanlam.co.za
Training
- Attended and completed Oracle Database 11g: Introduction to SQL course.
- Attended and completed Oracle Database 11g: Advanced PL/SQL course.
Languages
- English
- Xhosa
Technical Tools
- Software development, 5
- MSSQL TSQL, 5
- Oracle SQL and PL SQL, 5
- Apache Hive, 4
- Impala, 4
- Linux, 3
- JavaScript, 3
- HTML5, 4
- CSS, 4
- Bootstrap, 3
- Windows, 5
Languages
Xhosa
First Language
English
Advanced (C1)
C1
Timeline
SQL Developer
PBT Group
10.2019 - 06.2024
PLSQL Developer
Metropolitan
07.2018 - 09.2019
PLSQL Developer
PEPKOR IT
04.2017 - 06.2018
SQL Developer
Liberty Health
08.2007 - 03.2017
ND - Information Technology
Cape Peninsula University of Technology
Grade 12 -
Similar Profiles
SOMALO SENDERSOMALO SENDER
Travel / Office Administrator at PBT GROUPTravel / Office Administrator at PBT GROUP
Hardeep KaurHardeep Kaur
Administrator at PBT Transport LimitedAdministrator at PBT Transport Limited
Peter MobarakPeter Mobarak
Podcast Producer at PBT PODCASTPodcast Producer at PBT PODCAST