Mabushe Paul Mabidikama

• Managed end-to-end data pipeline construction for seamless integration of disparate data sources.
• Conducted regular audits on existing datasets to maintain integrity and accuracy.
• Migrated legacy databases onto cloud platforms like AWS or Google Cloud Platform, improving scalability and resilience of infrastructure.
• Applied statistical methods for advanced quantitative analyses.
• Enhanced user experience by automating repetitive tasks using Python scripts.
• Implemented real-time monitoring tools to detect anomalies in data streams swiftly.
• Developed complex data models to support business decision-making.
• Troubleshot complex system issues, ensuring minimal disruption to business operations.
• Led team training sessions on best practices in database management and maintenance, enhancing overall staff proficiency.
• Streamlined flow of information by introducing efficient ETL processes.
• Advocated a culture of continuous learning within the team, keeping abreast with latest industry trends in big data technologies.
• Collaborated closely with cross-functional teams to define technical requirements for new initiatives.
• Crafted custom SQL queries to pull relevant subsets of data for specific projects.
• Created interactive dashboards using BI tools such as Tableau, empowering non-technical stakeholders with actionable insights.
• Identified opportunities for process improvement through thorough review of existing systems and procedures.
• Optimised large datasets to improve speed and efficiency in analysis tasks.
• Utilised industry-leading tools to support ETL operations.
• Supported data quality and integrity with secure data storage and retrieval.
• Researched emerging technologies in data engineering, consistently learning new best practices.
• Developed and implemented ETL processes and enforced adherence to established procedures.
• Created and maintained data models to support consistent and secure operations.
• Implemented data partitioning improvements to optimise data processing.
• Maintained internal company knowledge base of data pipelines and processes to increase data accessibility.
• Extracted data and distilled into usable formats for data warehousing.
• Collaborated with cross-functional teams to gather and distil technical project requirements.
• Translated technical jargon into simplified language to effectively convey project details to non-technical personnel.Provisioning SQL Server SQL Database
• Implementing and Managing SQL Server Security and Permissions
• Securing the Server and Data
• Designing SQL Server Tables
• Performance Tuning and Optimizing SQL
• Developing, Deploying and Data Recovery
• Implementing SQL Server High Availability and Disaster Recovery
• Managing and Monitoring SQL Server Databases
• Automating SQL Server Administration
• Develop technique/algorithms/measurement for research and analysis work
• Work with other teams to identify problems in different areas where data mining/statistics can help
• Communicate results; develop and maintain strong relationships with key stakeholders, partners and internal clients
• Development and testing support.
• Performance analysis and tuning
• Diagnosing performance problems
• Optimization of SQL queries
• Creating indexes for improved performance
• Suggesting table design changes to improve performance.
• Creating backups and recovery testing of the backups
• Assist team with investigation, analysis, design and
• Ensure delivery across multiple projects simultaneously.
• Capacity planning for continued data growth
• Use of change logs to keep remote databases in sync.
• Drive business value: prioritize initiatives to ensure delivery of business value while continuing to build out the team’s core competencies.
• Design and maintain data models, schemas, and database structures to support analytical and
• operational use cases.
• Optimize data storage and retrieval mechanisms for performance and scalability.
• Evaluate and implement data storage solutions, including relational databases, NoSQL databases, data lakes, and cloud storage services.
• SSIS or other BI toolset.
• Writing of reports (SSRS), both ad hoc and for the regular production schedule
• Production reports will be sourced from the DataMart which draws data from the outgoing system, and the replacement system
• Management information – strategic and statistical
• Technical support (basic user set-up, configuring user defined screens, reports etc.)
• Database and application tuning and performance monitoring
• Worked with 50+ internal stakeholders, engineers, data scientists, cloud platform engineers, and other technologists across the business.
• Managed development of a robust Cloud platform sitting
• Spearheaded 100% of code repositories in GitHub and set up automated CI/CD pipeline for all product lines
• Defined branching strategy, permissions, and access management for 10+ engineering teams
• Mentored 30+ junior SQL engineers in gaining experience and assuming DevOps responsibilities Shared best practices and guided 5+ engineers while implementing infrastructure as code.
• Troubleshooting and optimizing data systems.
• Analyzing and translating business needs into long-term solution data models.
• Creating logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Working with the development team to create conceptual data models and data flows.
• Collaborated with 3 engineering teams to help with azure Role Management and provisioning azure resources.
• Managed 100% of existing azure Cloud environments,
• automation, monitoring metrics, disaster.
• recovery/backups, and capacity planning
• Ensured 100% of all project documentation was created and updated, including design, development, and deployment documentation
• Create and maintain fully automated CI/CD pipelines for code.

· Built and deployed Docker containers to break up monolithic app into microservices, improving developer workflow, increasing scalability, and optimizing speed

• Updated server software regularly to ensure compatibility with new applications.
• Implemented security measures to protect sensitive information, enhancing data safety.
• Reduced redundancy in the database using normalisation techniques, optimising storage usage.
• Troubleshot technical issues promptly, minimising downtime, maintaining business continuity.
• Coordinated with application development teams to improve software integration with databases.
• Provided technical support for SQL Server databases, improving operational efficiency.
• Achieved streamlined data flow with regular monitoring and updating of database systems.
• Assisted junior DBAs in resolving complex technical issues, fostering team collaboration.
• Implemented partitioning schemes for large tables to increase query performance.
• Improved data quality through the implementation of validation rules and triggers.
• Managed disaster recovery protocols with efficient backup strategies, reducing potential downtime.
• Conducted performance tuning activities for enhanced system responsiveness and speed.
• Enhanced system performance by implementing database maintenance plans.
• Extracted and transformed data, accurately loading into data warehouse.
• Monitored database performance and identified areas for improvement.
• Installed software system updates, processed backup upgrades and created instructional materials for users to boost efficiency.
• Created and maintained data models that depicted relationships between data elements.
• Built databases and table structures using database tools for web applications.
• Monitored alert log, memory, disk I/O and CPU usage as part of DBA daily activities.
• Provisioned and managed database instances, setting up replication and high availability.
• Resolved performance issues quickly through accurate root cause identification.
• Authored multiple scripts to automate backup and recovery processes.
• Tracked storage and CPU usage and general usage trends to keep enough compute available to meet service levels.
• Wrote queries using SQL to retrieve, build, delete or update information in database.
• Kept database balanced and performing optimally with regular maintenance.
• Enforced security and integrity controls to prevent breaches, loss and damage.
• Established database access and usage policies and procedures for managing each.
• Maintained legacy databases and assisted with migrations to new systems.
• Set naming conventions to define and standardise databases.
• Gathered and defined technical requirements for database designs and updates.
• Diagrammed database designs and wrote descriptive documentation.
• Organised planning, connection and deployment for data warehouse systems.
• Executed tests at different stages of design and production to validate, debug and improve code.
• Improved system functionality with regular updates and bug fixes.
• Resolved complex technical issues, ensured smooth operations.
• Executed successful migration of all BI systems to new platform.
• Coordinated cross-functional teams for effective project implementation and completion.
• Identified trends for strategic planning using advanced SQL queries.
• Utilised Python for predictive modelling, improving future business strategies.
• Conducted regular audits on database performance; ensured optimised operation at all times.
• Streamlined data processing to increase efficiency and accuracy in reporting.
• Managed large-scale data integrations, resulting in a more unified system view.
• Achieved company objectives with the creation of customised BI dashboards.
• Improved data access for stakeholders by designing and building data models.
• Performance-tuned and troubleshooted reporting and BI tools, systems and software.
• Translated legislative requirements into technical specifications and functional regulations.

• Managed disaster recovery protocols with efficient backup strategies, reducing potential downtime.
• Enhanced system performance by implementing database maintenance plans.
• Coordinated with application development teams to improve software integration with databases.
• Data Warehousing experience utilizing SSAS or other OLAP toolset
• Advanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks
• SQL Server Clustering Installation and Configurations (FCI and AG)
• Interact with report owners to establish/clarify their requirements and develop report specifications.
• Work with all levels of development from analysis through implementation and support.
• ETL experience, including SSIS or other BI toolset.
• These are quality documents for client consumption and need to enhance the Our client brand
• Writing of reports, both ad hoc and for the regular production schedule
• Production reports will be sourced from the DatatMart which draws data from the outgoing system, and the replacement system
• Management information – strategic and statistical
• Either on request or on a regular basis
• MS SQL Server back-up and restore
• Performance tuning
• SQL analysis server
• Technical support (basic user set-up, configuring user defined screens, reports etc.)
• Design and create
• Install, configure, maintain and troubleshoot
• Implement and maintain backup and recovery of the databases
• Database and application tuning and performance monitoring
• Financial reports and statistics
• Compiling technical documentation
• Server-side web technologies including: ASP.NET C#, AJAX
• Web Designers and Developers research, design, develop and produce internet and intranet sites.

• Collaborated closely with IT project managers to deliver projects timely and efficiently.
• Managed disaster recovery protocols with efficient backup strategies, reducing potential downtime.
• Implemented security measures to protect sensitive information, enhancing data safety.
• Check daily backups
• User support
• Maintain the Geology Warehouse
• The Geology Warehouse involves importing test results of rock samples that are analysed by different laboratories
• The results are mailed to a "Geology" mailbox
• Using VB and VB Script, read the mailbox and stripped the files (attachments) out and imported these into a database
• Use SQL to clean and manipulate the data in order to gather it all into a single format to be reported to the Geologists
• Analyse and maintain the project - from the importing stage of the project to the presentation stage
• Create DTS packages from the SQL Server
• Report using Crystal Reports
• Enhance the SQL code
• Streamlined database migration processes for seamless transition between platforms.
• Implemented partitioning schemes for large tables to increase query performance.
• Conducted performance tuning activities for enhanced system responsiveness and speed.
• Enhanced system performance by implementing database maintenance plans.

• Delivered impactful training sessions to increase staff technical proficiency.
• Developed software solutions for improved productivity.
• Utilised cloud technologies improving remote access capabilities.
• Conducted comprehensive system analyses to identify potential improvements.
• Import stage to the presentation stage of the project
• Responsible for working with databases
• MS SQL Server 2000, VBA, VBScript, VB, SQL and VB .Net, C# ,ASP
• Database administrator (writing: T- SQL and Stored Procedure, designing, creating and Data Transformation Services)
• Information System Administrator (writing: Crystal report)
• Software development lifecycle (SDLC) - understanding
• Install, configure, maintain and troubleshoot SQL Server databases
• Implement and maintain backup and recovery of the databases
• Database and application tuning and performance monitoring
• Development support/debugging procedures (including stored process)
• MS Terminal Server knowledge (load balancing, User set-up, problem solving)
• MS SQL Server back-up and restore
• Technical support (basic User set-up, configure User defined screens, reports etc)
• Proficiency in one of the popular report writing tools (Crystal reports 10)
• SQL Analysis Server
• ERP System implementation
• Cognos Modeller and Cubes
• Cognos user support
• Cognos : Report Author
• Travel Nigeria ;Zambia and Lesotho for system Implement
• Support 17 Countries e.g. Nigeria, Kenya, Ghana
• Intro Java

• Collaborated closely with IT project managers to deliver projects timely and efficiently.
• Achieved streamlined data flow with regular monitoring and updating of database systems.
• Streamlined database migration processes for seamless transition between platforms.
• Improved data quality through the implementation of validation rules and triggers.
• Involve in the project as an Analyst/Developer (writing and maintaining) from the importing stage to the presentation stage of the project
• Responsible for administrating the MS SQL 2000 database which includes:-
• Writing: T- SQL and stored procedures
• Design and create
• Data transformation services
• Install, configure, maintain and troubleshoot
• Implement and maintain backup and recovery of the databases
• Database and application tuning and performance monitoring
• MS SQL Server back-up and restore
• Performance tuning
• SQL analysis server
• Write Crystal Reports 10 as Information System Administrator
• Solid understanding of the software development lifecycle (SDLC)
• Development support/debugging procedures (including stored process)
• MS Terminal Server knowledge (load balancing, user set-up, problem solving)
• Technical support (basic user set-up, configuring user defined screens, reports etc.)
• ERP System implementation
• Oracle 10g implementation.

• Conducted performance tuning activities for enhanced system responsiveness and speed.
• Developed and maintained complex stored procedures, resulting in faster data retrieval.
• Provided technical support for SQL Server databases, improving operational efficiency.
• Streamlined database migration processes for seamless transition between platforms.
• Deliver Services to Client
• Comply With Policies and Standards
• Financial Management.
• Configuration Management
• Change Management
• Capacity Management
• Availability Management
• Continuity Management
• Security Management
• Request, Incident & Problem Manager
• Release Management
• Responsible for working with databases
• MS SQL Server 2000, VBA, VBScript, VB, SQL and VB .Net
• Database administrator (writing: T- SQL and Stored Procedure, designing, creating and Data Transformation Services)
• Oracle 10g implementation and Management.
• Information System Administrator (writing: Crystal report)
• Software development lifecycle (SDLC) - understanding
• Install, configure, maintain and troubleshoot SQL Server databases
• Implement and maintain backup and recovery of the databases
• Database and application tuning and performance monitoring
• Development support/debugging procedures (including stored process)
• MS Terminal Server knowledge (load balancing, User set-up, problem solving)
• MS SQL Server back-up and restore
• Technical support (basic User set-up, configure User defined screens, reports etc)
• SQL Analysis Server

• Carried out day-to-day duties accurately and efficiently.
• Quickly learned and applied new skills to daily tasks, improving efficiency and productivity.
• Successfully delivered on tasks within tight deadlines.
• Demonstrated respect, friendliness and willingness to help wherever needed.
• Part of a team that develops the Sales Strategy System that automated the following process:
• The Sales Representative will source potential customers and contact them
• Each sales cycle will represent a project, which is controlled by a sales representative
• The project will have one or multiple targets
• For each target main activities will be generated with various sub activities
• The main activities will be predefined for that project and the sales representative will have to unselect the activities that does not form part of the sales cycle
• The sub activities will be displayed allowing the User to re-select or unselect specific sub-activities