Identityo Having a total of six years of IT Experience
o Application development using c#.net, Asp.net
o SQL Development
o Having three years of experience of taking corporate Training on MIS, SQL Server, Advance Excel
o Reviewing query performance and optimising code
o Writing queries used for front-end applications
o Backup, recovery
o Provide server level and database level roles
o Designing and coding database tables to store the application data
o Data modelling to visualise database structure
o Working with application developers to create optimised queries
o Creating table indexes to improve database performance
o Programming views, stored procedures, and functions
o Performance Tuning
o Involved in apply Service packs, Security packs, CU and hotfixes.
o Experience in scheduling Backups, Restore and Maintenance plans.
o Experience in Creating Jobs and Sending Alerts using Database Mail.
o Experience in performing administrative tasks: database files
o Maintained Database Authentication modes, Creation of user, configuring permissions and assigning roles to users.
o Regularly monitor and identify blocking issues and notifies long running queries/transactions.
o Troubleshooting the log file full, data file full and tempdb full issues
o Identifying long-running questions when 100% CPU/High Memory situation arises.
o Scheduling/Troubleshooting of maintenance jobs.
