Sql Server Database Solution Architect
CurrentPoint of contact for technical escalations & business-related projects. Experience in Windows Azure, migrating database to Azure Scheduling review meetings with client to understand the pain areas & future upcoming project requirements, Conducting Weekly progress report call with location managers for operations & project related activities Ensure timely delivery of the deliverables as per the MSA / SLA / SOW, Recruitment of skilled consultants as per new projects requirements, Training the consultants in-house or through principal partner for upcoming project requirements, Sharing the daily competency report as a part of SLA. Setting the KRA & goals with the team, continuous discussion on improvement areas, Preparing service review presentations, highlighting project status & achievement details, Scheduling monthly technical sessions for sales team for technical pre-sales activities,Good knowledge in SQL programming & query optimization. Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues. Good knowledge in SQL Server Database level and query level tuning optimization for various applications. Improve the performance of SQL Queries and stored procedures to optimize the queries. Good knowledge in Database level maintenances on daily, weekly and monthly basis. Automation of gathering performance counters of servers and generating daily performance reports. Monitored and modified Performance using execution plans, Index tuning and implement missing index.