Hello There!!
This is Dheeraj from India.
I have more than 8 Years of experience in Database Development, Data Visualization and Administration
Experienced in working on Different big products like Yardi Voyager, WMS. TaskTrack
My Skillset includes but not limited to:
Writing Stored Procedures, Views, Functions and Queries for the product development and customization
Writing complex queries for report/product development
SSIS. SSRS, SSAS, ETL
Managing the entire database
Monitoring SQL Server Performance and troubleshooting
Power BI | DAX | Excel | Power Query
Installing, Configuring and Administering SQL server 2005\2008\R2.
Performing Database maintenance activities like Backups, Restoring.
As a part of the DBA team providing 24x7 production support to the clients.
Monitoring Scheduled jobs.
Configured log-shipping between the servers.
Monitoring the Disk spaces on all the servers.
Checking the general Health of the servers for identifying Bottlenecks.
Analysing, Identifying and Resolving performance issues of the server.
Database performance tuning for optimal results.
Ensuring High Availability using Technologies like DB mirroring, Log shipping.
Backing and Restoring of Databases.
Scheduling and scripting Jobs.
Looking forward to working with you and achieve mutual benefits.