From making models to serving thousands of concurrent users, database performance optimization is one of the most challenging aspects of information systems. We offer a complete range of services for optimizing performance, implementation, administration and database security. We are available for individual projects or as a source of continual support.​

Implementation

  • Infrastructure design and capacity planning
  • Database model design
  • Database model design consulting
  • Defining the physical design of the database in order to match your needs with data storage capabilities
  • Model analysis in accordance with best practices
  • Ensuring data consistency and data relations
  • Archiving data while maintaining transparent access to data
  • Identifying the risk of data loss and creating a mitigation plan
  • Defining and testing recovery plans
  • Pre-design solutions for recovery consulting
  • Designing and implementing federated databases
  • Project management on the implementation of database solutions
  • Data migration on the same or different platforms​

Performance Optimization


  • Performance monitoring configuration
  • Analyzing performance data
  • Analyzing models, data and code
  • Analyzing index usage statistics
  • Analyzing query statistics
  • Baseline performance creation
  • Index and statistic optimization
  • Execution plans  configuration
  • Limits configuration
  • Code optimization
  • Temporary chart system optimization
  • Fine-tuning the configuration of DBMS servers
  • Performance monitoring

Administration

  • Backup plan definition and implementation
  • Replication system definition and implementation
  • Services installation and configuration
  • Ensuring concurrent access to objects
  • Configuration and maintenance of backup solutions
  • Configuration and maintenance of replication solutions
  • Backup testing
  • Replication testing
  • Backup and replications maintenance
  • Migration testing on new versions of database services
  • Notifications for important events configuration
  • System accuracy monitoring
  • Capacities planning
  • Log shipping, mirroring, always-on​

Security

  • Logical and physical securities design and implementation
  • Security analysis in accordance with best practices
  • Defining privileges and user access monitoring
  • Backup protection
  • Backup recovery systems protection
  • Monitoring and alerts
  • Data masking
  • Data anonymization of key objects​​