SQL Server Database Administrator (Microsoft MVP)
Last active: 1 day ago
--Experience in Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005 to 2008 R2
--Experience in SQL version migration.
--Experience in Extracting, Transformation and Load from CSV, Raw Files and almost all RDBS vendors.
--Perform database optimization, administration and maintenance (partitioning tables, partitioning indexes, indexing, normalization, synchronization, job monitoring, etc
--Establish best practices for T-SQL scripting and encouraging development teams to follow these practices via mentorship and training.
--Establish and enforce database change management standards including pushes from development to QA, on to production, etc;
--Expertise in Troubleshooting and performance monitoring SQL Server Database server (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc
--Expertise in T-SQL and writing efficient and highly performing SQL Statements.
--Expertise in SQL Server Internals , wait events, profiler, windows events etc
--System administration fundamentals including Installation, Configuration & Security setups.