Experience of implementation of the projects based on MS SQL

Versions of MS SQL Server: 7.0 - 2008

Design of DB model and business-processes:

• Design tools: EMS SQL Manager for SQL Server, Sybase PowerDesigner, Erwin, Rational Rose.
• Modeling languages: BPEL, UML.
• Design experience: DB application can contain more than 200 tables and more than 500 stored procedures.

DB-side design of business logic:

• Usage of stored procedures, triggers, indexes, materialized views and other tools for implementation of business logic. Vast experience in SQL-queries optimization.
• Technologies:
  • SQL Server Database Engine;
  • CLR integration;
  • SQL Server Analysis Services;
  • SQL Server Integration Services (SSIS);
  • SQL Server Replication;
  • SQL Server Reporting Services;
  • SQL Server Notification Services;
  • SQL Server Service Broker Overview;
  • Full-Text Search.
• Administering:
  • Installation of DB MSSqlServer and other components to Windows platforms;
  • Initial data filling, using export/import, data pump utilities;
  • DB monitoring. Settings and recommendations for improving of its performance;
  • DB cloning;
  • DB backup and restoring;
  • Server hardware settings;
  • Data privacy and security-related issues.
• Additional info:
  • Experience in DB remote installation and maintenance;
  • Experience in managing of large data bulks;
  • Experience in adjusting and applying systems to various business areas.