Jabu Mabena

With an interest and passion in IT, I started my career by obtaining an internship at Barloworld Logistics and was taken on for a further year in a SQL DBA. I worked most of my career through a Labour Broker and although the projects have allowed me to work in various environments and different technologies, I am very keen to secure a role in a company where I can grow and develop My SQL DBA\BI experience. Quietly spoken and shy, however Jabu seems to be hungry for a challenge.

Notice Period: Available immediately for long contract or perm role.

SQL Database Administrator - E4 Strategies

(2020-10)

Database Administration and SQL Server management across multiple versions (2000, 2005, 2008, 2012, 2014, 2016).

• Backup And Restore Backups, confirm backups have been made and successfully saved to a secure location
• Check OS Event Logs and SQL Server Logs for unusual events
• Verify that all scheduled jobs have run successfully
• Create SQL Server alerts to notify you of potential problems, and have them e-mailed
• Take action as needed
• Creating Maintenance job and maintaining MSSQL database
• Documentation of database of all tables and fields, working with SQL Server 2000, 2005, 2008.,2012,2014 ,2016
• Daily checks and Performance Turning
• For best performance and monitoring SQL Server
• Throughout the day, periodically monitor performance using both System Monitor and Profiler/SQL Trace
• Check CPU using Task Manager
• Systems Analysis, Impact Analysis and Design of Database Solutions
• Code Reviews
• Check for active job processes running on Job activity
• Check for more information in SQL server error logs and event viewer
• Check if the AWE setting is enabled
• Regularly monitor and identify blocking issues
• Maintaining high availability
• Database mirroring
• Maintaining high availability, we use this technology for high availability and high performance solutions for database redundancy
• Log shipping-is a low cost method of creating a standby server by using standard hardware
• Replication copying data from one server to another and compiling of monthly reports
• Creating Table, Database, writing views, select statement, Indexes, Triggers using TSQL
• Security to make sure that the database is Protected from security attack and malicious code
• Produce and maintain database design documentation
• Assist with maintenance of the production systems
• Ensure data quality, data profiling, metadata management and master data management on all systems
• To configure DBMail in SQL Server using SQL Server Management studio as well as using T-SQL
• Create Linked Server in SQL Server
• Create an Application Role in a Database of SQL Server
• Install Service Packs, Hot Fixes and Windows Patches in Cluster
• Setup AlwaysOn Availability group when SQL Server instances are installed in Cluster Mode
• Plan Backups with AlwaysOn Availability Groups in SQL Server
• Upgrade of SQL Server 2008 R2 to SQL Server
• Moving databases to destination strategy
• Upgrade SQL Server 2008 R2 to SQL Server 2012 checklist (Side by Side)
• Checklist covers almost all items that are important in Migration
• How to identify databases that can be migrated to SQL Server
• High Availability (HA) and Disaster Recovery (DR) options for SQL Serve

SQL Database Administrator - Department of Justice

(2020-04 - 2020-06)

• Database Administration
• Backup And Restore Backups, confirm backups have been made and successfully saved to a secure location
• Check OS Event Logs and SQL Server Logs for unusual events
• Verify that all scheduled jobs have run successfully
• Create SQL Server alerts to notify you of potential problems, and have them e-mailed
• Take action as needed
• Maintenance job, creating and maintaining MSSQL database
• Documentation of database of all tables and fields, working with SQL Server 2000, 2005, 2008.,2012
• Daily checks and Performance Turning
• For best performance and monitoring SQL Server
• Throughout the day, periodically monitor performance using both System Monitor and Profiler/SQL Trace
• Check CPU using Task Manager
• Systems Analysis, Impact Analysis and Design of Database Solutions
• Code Reviews
• Check for active job processes running on Job activity
• Check for more information in SQL server error logs and event viewer
• Check if the AWE setting is enabled
• Regularly monitor and identify blocking issues
• Maintaining high availability
• Database mirroring
• Maintaining high availability we use this technology for high availability and high performance solutions for database redundancy
• Log shipping-is a low cost method of creating a standby server by using standard hardware
• Replication copying data from one server to another and compiling of monthly reports
• Transferring of data using the following tools – SSIS (SQL Server Integration service), XML, BCP (Bulk copy Program), SSRS, and DTS
• Designing and developing ETL processes
• Creating Table, Database, writing views, select statement, Indexes, Triggers using TSQL
• Security to make sure that the database is Protected from security attack and malicious code
• Design and develop OLAP and OLTP database models
• Develop SQL Server Reporting Models Using SSRS
• Develop data marts and data warehousing
• Produce and maintain database design documentation
• Enforce database standards
• Assist with maintenance of the production systems
• Understanding of common ETL design techniques such as change data capture, key generation and optimization
• Ensure data quality, data profiling, metadata management and master data management on all systems

SQL Database Administrator - BCX

(2016-12 - 2020-04)

• Database Administration
• Backup And Restore Backups, confirm backups have been made and successfully saved to a secure location
• Check OS Event Logs and SQL Server Logs for unusual events
• Verify that all scheduled jobs have run successfully
• Create SQL Server alerts to notify you of potential problems, and have them e-mailed
• Take action as needed
• Creating Maintenance job and maintaining MSSQL database
• Documentation of database of all tables and fields, working with SQL Server 2000, 2005, 2008.,2012,2014 ,2016
• Daily checks and Performance Turning
• For best performance and monitoring SQL Server
• Throughout the day, periodically monitor performance using both System Monitor and Profiler/SQL Trace
• Check CPU using Task Manager
• Systems Analysis, Impact Analysis and Design of Database Solutions
• Code Reviews
• Check for active job processes running on Job activity
• Check for more information in SQL server error logs and event viewer
• Check if the AWE setting is enabled
• Regularly monitor and identify blocking issues
• Maintaining high availability
• Database mirroring
• Maintaining high availability, we use this technology for high availability and high performance solutions for database redundancy
• Log shipping-is a low cost method of creating a standby server by using standard hardware
• Replication copying data from one server to another and compiling of monthly reports
• Creating Table, Database, writing views, select statement, Indexes, Triggers using TSQL
• Security to make sure that the database is Protected from security attack and malicious code
• Produce and maintain database design documentation
• Assist with maintenance of the production systems
• Ensure data quality, data profiling, metadata management and master data management on all systems
• To configure DBMail in SQL Server using SQL Server Management st

Matric - Vukuzenzele High School (2001)

SQL Server 2005 Database Administration - Database Administration - Torque IT (2011)

SQL Server 2012\2014 Database Administration - Database Administration - Torque IT (2017)