· Exporting and Importing the Databases from CRMNEXT Extraction tool and take the regular Database backup.
· Creating database Tables, Procedures and Functions as according to the requirement.
· Providing the Database slowness solutions by checking the SQL queries, Execution plans and by checking the Profiler Trace.
· Provide the Database suggestions by checking the Missing Index, Stats update, worst queries.
· Provide the Deadlock suggestions by checking the deadlock trace.
· Provide the suggestions by checking the IIS Logs, Event Viewer, Dot Trace.
· Fix any issues related to database performance and provide corrective measures.
· Reading load testing reports and providing suggestions to make application efficient.