Mohakkumar R.

ABOUT ME

I have expertise in below area as a database professional :
1.Performed day to day DBA activities such as monitoring SQL server health, job status, addressing user requirements
2.Ensure SQL data assets are available for use by applications, recoverable in the advent of system failure and secure from possible breaches
3.Mentor other DBA’s & Developers in best practice and automation of tasks whenever and wherever possible
4.Monitor DB with tools like Performance Monitor, SQL Trace, Data collection in Production time, SQL Profiler et and taking pro-active actions
5.Monitoring indexes, Managing heap tables, Managing and Gathering Statistics on Table thru DMVs.
6.Various Auditing Database and Managing compliance needs
7.Overall SQL Server Performance & Query Performance Tuning
8.Implement backup and recovery strategy of Database
9.Implement database security on various level
10.Implement HA and DR solution (i.e. Always on, Replication etc)
11.Manage Data Warehouse & Data Marts
12.Manage transaction logs & database files
13.Create and manage complex queries & SQL blocks (Stored Procedures, UDFs, Triggers etc.)
14.Create and manage SSIS packages & ETL Processes For Business Intelligence
15.Setting up alerts for poor performing queries, wait stats & other workloads
16.Create SQL Scripts for Data & Structure Migration
17.Creating Reports for business insight through SSRS & Power BI
18.Client Communication and Team Management

SKILLS