Database administrator (Microsoft SQL Server 2000/2005)

If your DBA team is overworked or you want to save money by outsourcing DBA positions, Vilesse can provide you with a dedicated DBA. Our DBA will understand your business, database architecture and infrastructure, and will provide you with the best solutions possible. Our DBA experts have vast experience in the field and are always applying the best practices.

Here is the list of what a dedicated DBA can do:

  • Install / reinstall Microsoft SQL Server reattaching it to existing databases

  • Move databases and DTS-packages to another server

  • Migrate from Microsoft SQL Server 2000 to Microsoft SQL Server 2005

  • Set up transactional or merge replication

  • Set up SQL Mail

  • Develop and implement backup and maintenance plans

  • Analyze effectiveness of current indices and develop new effective indices structure

  • Develop database structure for handling large amounts of data (Distributed Partitioned Views / split database into several files / etc)

  • Data recovery (includes recovery of corrupted data)

  • Identify potential issues and limitations

  • Improve database architecture, infrastructure and design

  • Apply the latest patches and version upgrades

  • Benchmark, stress-test, and optimize critical SQL queries and stored procedures

  • Control database files' size, analyze log files