We have over 10 years experience with Microsoft SQL Server databases and have knowledge of Oracle and MySQL databases at our disposal. We have worked with almost all versions of Microsoft SQL Server from version 7 to 2016 and with all editions including Express to Enterprise.
Throughout our careers we have experienced many challenges in maintaining and upgrading database performance and have gained know-how in analyzing data and program codes that use data, how to monitor performance and how to approach changes, all with the objective of maintaining and improving database performance.​

We have utilized and improved our know-how through numerous projects, with emphasis on the following:

Performance Optimization
  • Performance Optimization of multi-tenant systems with a large number of users - our role: analysis, to generate a status report and to create an action plan, to implement the agreed-upon optimization solutions and to create a performance monitoring system
  • Performance Optimization of a SQL Server database with over 10TB of active data and over 30,000 active users - our role: analysis, measure performances, implement optimization solutions and monitor performance using alerts in cases where indicators appear, signaling a drop in performance levels, performance tuning.

Backup Technologies
  • Custom log shipping for all Microsoft SQL Server editions - our role: complete design, implementation, testing and production, as well as maintenance
  • Microsoft SQL Server database backup and retention management solution - our role: complete design, implementation, testing and production, as well as maintenance​

Data Migration
  • Migration from Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2012 production environment with EMC VMAX database storage – our role: Complete migration planning, documentation, testing and implementation
  • Data migration from MySQL database to Microsoft SQL Server - our role: testing and migration implementation​

Tools
  • Custom alerting and monitoring system for Microsoft SQL Server (the objective being to adapt to the needs of the environment) – our role: complete design, implementation, testing and production, as well as maintenance
  • Custom solutions for maintaining an SQL Server, which includes a system for re-indexing according to available resources, updating statistics and monitoring consistency in the database with reporting - our role: complete design, implementation, testing and production, as well as maintenance
  • Audit approach to data on an SQL Server with an IBM InfoSphere Guardium solution – our role: testing solutions and possible monitoring approaches, implementing policies and reports, configuration, maintenance and documentation​