Experience - Databases
We have over 25 years of experience with Microsoft SQL Server databases and also have knowledge of Oracle and MySQL databases. We have worked with all versions of Microsoft SQL Server from version 7 to 2025 and all editions from express to enterprise.
Throughout our career, we've faced a lot of challenges in maintaining and improving database performance, and we've gained experience in analyzing data and the code that uses the data, monitoring performance, and approaching changes—all with the goal of keeping 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 – Improving the performance of an SQL Server database with over 300TB of active data and more than 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 | – Log shipping for all editions of Microsoft SQL Server – 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 of Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2019 production environment with EMC VMAX data storage – our role: complete planning, documenting, testing, and carrying out the migration – Data migration from a MySQL database to a Microsoft SQL Server database - our role: testing and carrying out the migration |
| Tools | – Alerting and monitoring system for Microsoft SQL Server (with the goal of maximum customization to the environment's needs) – our role: complete design, implementation, testing and production, as well as maintenance – A custom solution for maintaining SQL Server, which includes a system for reindexing based on available resources, updating statistics, and checking database consistency 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 |