Database: Design, Development & Maintenance

Tshimoloho Business Consultants has a capable team of qualified database specialists proficient in Microsoft SQL Server,
Microsoft Access, as well as open source databases like MySQL and PostgreSQL.
Our database developers and administrators are very adept in developing and maintaining complex data structures and high volume, high availability databases

Database Development

  • Database design and planning
  •  Database scalability and architecture
  •  Database Implementation
  •  Performance analysis and improvement
  •  Database security
  •  Maintenance plans and backup scheduling

Business Intelligence

  • SSIS-Sql Server Integration Services
  •  Data Integration and Management
  •  ETL including multi-source complex transformation
  •  Data filtering and cleansing including manual and semiautomated processing
  •  Data Analytics
  •  Mobile Business Analytics Solutions (iPad, Android)
  •  Cloud-based Business Intelligence Solutions
  •  Business Activity Monitoring and Reporting
  •  Business Analytics Dashboard

Database Maintenance

  • Monitoring database health and usage
  •  Optimising SQL queries and database performance
  •  Monitoring storage and archiving
  •  Setting up maintenance plans
  •  Monitoring scheduled jobs
  •  Setting up and monitoring database replication and mirroring

Reporting & Analysis Service

  • SSRS-Sql Server Reporting Services
  •  Enterprise Reporting
  •  Management Scorecards / Portal analysis and architecture
  •  Online Analytical Processing Reporting / OLAP Solutions
  •  Data Mining
  •  Report Migration
  •  BI reporting on ERP Packages
  •  Business Activity Monitoring and Reporting
  •  Customized reporting and analytics

Business Suites 24 | Preller Square
Dan Pienaar | Bloemfontein, 9301
info@tshimoloho.co.za
+27(0) 76 289 9837
+27 (0) 86 525 7555

Our Offices

Search