• 4+ years of experience in Database Administration and development for very large and complex databases in MySQL 5x, SQL Server 2012, SQL Server 2008R2, 2008, 2005 and MongoDB. Presently working with Plumslice Lab Pvt Ltd as Database Administrator.
• Experience in Replication set up, database optimization, performance tuning, developing stored procedures, Triggers, Cursors, Joins, Views and T-SQL
• Strong MySQL & SQL Server skills along with significant general system administration skills on
• Experience in Batch processes, Import, Export, and report queries.
• Experience in write complex report query and return that result back to the application dashboard.
• Attached my worked with my portfolio, you can see that how complex report I written in SQL store procedure which gives you almost 90% performance over code written in application.
• I have written that kind of store procedure which get the data from database and generate CSV file of that result data.
• As I know in report query you just have to pass parameters based on that report query will get data and return result. Passing parameters in store procedure.