Case Studies

EDM Americas

Amzur is currently providing software development services in various technologies/platforms including but not limited to Microsoft Development Platform (.NET technologies, Crystal Reporting) Web Development and Relational Database Development/Administration Services.


Key Services support of Microsoft SQL Server 2005 :

  • Analyzing the client requirement/specs with the team.
  • Involving in the design sessions on the databases to include new tables/update existing tables based on the requirement.
  • Identifying the database objects that are involved in the requirement and understanding the concept behind and then creating the database queries accordingly.
  • Creating complex queries involving many tables from different servers.
  • Creating Temp Tables, Views, Stored Procedures, Functions wherever required.
  • Performance Tuning of SQL queries once created both in test and production databases.
  • Closely monitoring the SQL Server performance using Server –Side tracing to find performance issues in production database with real data.
  • Involved in writing special procedures for the process scheduler so that the database objects are scheduled in hourly/weekly/monthly builds.
  • Communicating with the database admin team to create indexes for better performance of the procedures wherever required. .
  • Suggesting new fields/changing existing fields with new field length/datatype based on the requirement in the database tables.
  • Identifying the bugs in the already existing procedures/views and fixing accordingly.