Siyabonga Cindi
SQL Developer
Cape Town
Summary
Seasoned professional with a robust foundation in database management, business intelligence, and cloud engineering. Specializes in designing, implementing, and optimizing advanced database solutions using Microsoft SQL Server, AWS, and various reporting tools. Seeks an engaging and challenging role that leverages a broad range of technical expertise. Committed to continuous professional growth and excellence in the areas of DBA, BI, and cloud engineering.
Overview
11
11
years of professional experience
1
1
Certification
Work History
SQL Developer
Digioutsource
7 2022 - Current
- Collaborate with stakeholders to gather, understand, and prioritize database requirements for new and existing projects.
- Design, develop, and implement SQL database solutions to meet the dynamic needs of the business, ensuring scalability and maintainability.
- Write, test, and optimize complex SQL queries, stored procedures, and functions for various applications and data retrieval processes.
- Perform database tuning and optimization to enhance performance, including indexing, query optimization, and storage management.
- Conduct code reviews and enforce best practices to maintain coding standards, consistency, and code quality across the team.
- Troubleshoot and resolve database-related issues promptly and effectively, minimizing downtime and ensuring smooth operations.
- Create and maintain comprehensive database documentation, including data models, schema designs, and metadata, to facilitate future maintenance and development.
- Work closely with cross-functional teams, including application developers, system administrators, and data analysts, to ensure seamless integration and collaboration.
- Generate SSRS and Power BI reports and dashboards tailored to the specific needs of stakeholders, providing actionable insights and data visualizations.
- Manage data security and integrity, implementing access controls, encryption, and data masking as needed to protect sensitive information.
- Support data migration and transformation efforts, ensuring data accuracy, consistency, and compatibility across systems and platforms.
- Stay current with industry trends and best practices in SQL development, database technologies, and related tools, and apply this knowledge to continuously improve processes and solutions.
- Provide training and mentorship to junior team members, sharing expertise and fostering growth within the team.
- Contribute to planning and architecture discussions, offering insights and recommendations for database-related decisions and strategies.
- Participate in disaster recovery planning and testing to ensure business continuity and data availability in case of system failures.
SQL DBA
Digioutsource
04.2019 - 07.2022
- Install, configure, and maintain SQL Server instances across multiple environments, ensuring optimal performance and reliability.
- Perform regular database maintenance tasks, including backups, restores, data recovery, and integrity checks to safeguard data and maintain continuity.
- Monitor and optimize database performance, ensuring efficient query execution, optimal response times, and minimal downtime through proactive monitoring and tuning.
- Collaborate with development and infrastructure teams to design and implement database solutions that align with business goals and requirements.
- Troubleshoot and resolve database-related issues, including performance bottlenecks, connectivity problems, and data integrity challenges.
- Implement and maintain robust database security measures such as access controls, encryption, and auditing to protect sensitive data and comply with regulations.
- Plan, schedule, and execute database upgrades and migrations with minimal disruption, ensuring seamless transitions and data integrity.
- Create and maintain detailed documentation related to database configurations, processes, performance metrics, and best practices for reference and knowledge sharing.
- Set up and manage SQL transactional replication environments, configuring publishers, distributors, and subscribers for data synchronization across systems.
- Monitor SQL transactional replication to ensure data consistency, reliability, and performance, proactively identifying and resolving issues that may arise.
- Set up and manage SQL replication and Always On environments to ensure high availability, data redundancy, and disaster recovery capabilities.
- Assist developers with troubleshooting and optimizing SQL code issues to improve application performance and database interactions.
- Provide support and guidance to DevOps and infrastructure teams, particularly in managing and maintaining RabbitMQ and other message queuing systems that interface with SQL replication.
- Analyze and report on database usage patterns, identifying opportunities for optimization and cost savings in licensing, storage, and resource allocation.
- Ensure compliance with data governance and regulatory requirements, maintaining a clear understanding of applicable standards and implementing necessary controls.
- Participate in capacity planning and forecasting, assessing future database needs and recommending hardware or infrastructure upgrades as required.
- Stay current with emerging database technologies and trends, continuously seeking ways to improve existing systems and exploring new tools and solutions.
- Provide training and mentorship to junior DBAs, fostering growth and knowledge sharing within the team.
Cloud support engineer
Amazon Web Services
12.2017 - 04.2019
- Help customers troubleshoot connectivity issues to RDS instances, including analyzing security group settings, subnets, network ACLs, and other networking aspects for potential problems.
- Assist customers in troubleshooting database performance issues, including query optimization, indexing, and resource management, to ensure smooth and efficient database operations.
- Provide guidance on instance and storage limits for RDS to customers, helping them understand and manage their resource usage and planning upgrades or changes as needed.
- Collaborate with cross-functional teams to understand data migration requirements and objectives, including working with service teams, developers, and customers to gather and prioritize needs.
- Plan and execute end-to-end data migration processes, ensuring data integrity, security, and optimal performance throughout all stages of the migration.
- Design and implement AWS-based solutions for data migration, utilizing services such as AWS Database Migration Service (DMS), AWS Snowball, Amazon S3, and other AWS services to meet customer needs.
- Perform data profiling, validation, and cleansing activities to ensure data quality during migration, addressing data anomalies and inaccuracies as they arise.
- Troubleshoot and resolve issues related to data migration, working closely with technical support, development teams, and customers to identify and address problems.
- Optimize and tune migration processes for efficiency and performance, continuously evaluating and adjusting configurations to enhance the overall migration experience.
- Develop and maintain comprehensive documentation for data migration processes, configurations, and best practices, providing clear guidelines for future reference and support.
- Assist customers in architecting cloud environments that are optimized for their specific use cases, including selecting appropriate AWS services and configurations.
- Stay up to date with the latest AWS tools and services for data migration, performance optimization, and cloud infrastructure, continuously seeking opportunities for improvement.
- Advise customers on data security best practices, including data encryption, access controls, and auditing, to ensure compliance with industry regulations and standards.
- Offer proactive recommendations and solutions for data migration and database management, aiming to enhance the overall customer experience and satisfaction.
- Provide training and guidance to customers and internal teams, sharing best practices and helping others understand AWS services and their application in data migration and database management.
- Support disaster recovery planning and testing, ensuring customers have robust backup and restoration plans in place for their cloud databases.
- Participate in capacity planning and forecasting, helping customers prepare for future data growth and recommending appropriate scaling options.
SQL DBA
EOH
12.2016 - 11.2017
- Migrate SQL servers, SSIS packages and SSRS reports to latest versions
- Rebuild and monitor indexes at regular intervals for better performance
- Recover databases from backup in disasters
- Implementing Point-In-Time Recovery solutions
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
- Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)
- Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning
- Proactively monitor the database systems to ensure secure services with minimum downtime
- Troubleshooting and problem solving of SQL development deployment and making sure all applications follow the development cycle through to production deployment
- Responsible for improvement and maintenance of the databases to include rollout and upgrades
- Installing SQL Server with minimum access privileges service account to improve security
- Responsible for implementation and release of database changes according to agreed timescales and costs
- Administration of the SQL Integration Services (SSIS) environment
- Administration of the SQL Reporting Services (SSRS) environment
- Creating SSRS reports as per user specifications
- Creating SSIS packages as per User specification
- Weekly 24/7 Stand by.
Intermediate SQL DBA
Alexander Forbes
11.2015 - 11.2016
- Migrate SQL servers, SSIS packages and SSRS reports to latest versions
- Rebuild and monitor indexes at regular intervals for better performance
- Recover databases from backup in disasters
- Implementing Point-In-Time Recovery solutions
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
- Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)
- Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning
- Proactively monitor the database systems to ensure secure services with minimum downtime
- Troubleshooting and problem solving of SQL development deployment and making sure all applications follow the development cycle through to production deployment
- Responsible for improvement and maintenance of the databases to include rollout and upgrades
- Installing SQL Server with minimum access privileges service account to improve security
- Responsible for implementation and release of database changes according to agreed timescales and costs
- Administration of the SQL Integration Services (SSIS) environment
- Administration of the SQL Reporting Services (SSRS) environment
- Creating SSRS reports as per user specifications
- Creating SSIS packages as per User specification
- Weekly 24/7 Stand by.
Junior SQL DBA
Alexander Forbes
01.2013 - 10.2015
- Assisting front end users with any problems
- Trouble shooting SQL Server and database problems
- Creating new databases, tables and users as per client’s specifications
- Attending to incidents, requests and changes on the Service Now call logging system and making sure all incidents are resolved within SLA
- Making sure backups go through at all times and correcting backups that are failing
- Following up on any changes done on databases that were not approved by the database administrators
- Checking and making sure all SQL Servers are patched to the correct level
- Documenting SQL procedures
- Logging changes via change administrators
- Performing changes on SQL Servers during maintenance window
- Performing regular restores
- Taking part in disaster recovery tests.
Education
System Administration -
CTU
Enterprise Database Administrator Specialization - undefined
CTU
Skills
Team Collaboration
undefinedKey Technologies
- Microsoft SQL Server 2000
- Microsoft SQL Server 2016
- Microsoft SQL Server 2005
- Microsoft Visual Studio
- Microsoft SQL Server 2008
- SQL Server Integration Services
- Microsoft SQL Server 2008 R2
- SQL Server Reporting Services
- Microsoft SQL Server 2012
- AWS RDS (MySQL, SQL Server, PostgreSQL)
- Microsoft SQL Server 2014
- AWS DMS (Data migration Service)
- Microsoft PowerBI
- Microsoft SQL Server 2017
- Microsoft SQL Server 2019
References Available
True
Driving License
Code 8
Health
Excellent; non-smoker
Professional Development
- Implementing Microsoft SQL Server Databases 2008
- Administrating Microsoft SQL Server Databases 2008
- Amazon Web Services Solutions Architect
Certification
AWS Solutions Architect
Timeline
AWS Solutions Architect
08-2019
SQL DBA
Digioutsource
04.2019 - 07.2022
Cloud support engineer
Amazon Web Services
12.2017 - 04.2019
SQL DBA
EOH
12.2016 - 11.2017
Intermediate SQL DBA
Alexander Forbes
11.2015 - 11.2016
Junior SQL DBA
Alexander Forbes
01.2013 - 10.2015
SQL Developer
Digioutsource
7 2022 - Current
System Administration -
CTU
Enterprise Database Administrator Specialization - undefined
CTU
Similar Profiles
Brendon Marchelles SavoyBrendon Marchelles Savoy
Audit, Accounting and Tax Specialist at DigiOutsourceAudit, Accounting and Tax Specialist at DigiOutsource
Sabrina ALVAREZ VELASCOSabrina ALVAREZ VELASCO
Responsible Gambling Specialist at DigiOutsourceResponsible Gambling Specialist at DigiOutsource
Ian RimmerIan Rimmer
Divisional Manager at DigioutsourceDivisional Manager at Digioutsource