I am production support database Administrator/Architect with 15+ years of experience .
I have worked year long implementation plus 24 x 7 production support projects in MSSQL / Oracle from scratch, with RAID / SAN (dell/emc), replication / cluster for terabytes of data etc
environments with advanced cluster configurations hosting multi-terabyte VLDBs.
Worked with utlis like Perfmon, Profiler monitored wait stats, memory usages.
Worked on sql tuning by reading and chaining execution plan for better resource utilisation with creating indexes etc
Worked on Log shipping, replication, mirroring and AlwaysOn Availability Groups
Worked on cluster installation and administration
I have written various SQL Server monitoring scripts
Worked on ETL projects having SSIS data being coming and going from various sources
I have written T-SQL scripts / codes
Setting up Log Shipping with custom backup & onsite/offsite/ftp restore schedule
Setting up SQL Replication (transactional, merge, snapshot, Peer to Peer transactional)
Experienced in designing SQL Resource Governor for limiting & managing system workload, prioritizing users/groups
Administer large number of SQL Servers by using Policy-Based Management, designed & applied custom policies
Experienced in creating instance/Database level SQL Auditing and Change Data Capture
Created custom DBA script using DMVs, system tables for database management
Using SQL Server dashboard reports, DMVs and Profiler to identify slow or