I have 10 years of experience in a professional environment doing SQL Server configuration and maintenance. I have built many databases, configured clustered indexes, file groups, primary and foreign keys, in normalized configuration. I have performed extensive performance baselines, optimizing, monitoring and tuning tables, indexes, indexed views, heaps, stats and transaction log physical architecture for three-tier operation; successfully resolved problems w/ isolation and analysis, including in-depth analyses with DMVs, Profiler, and tracing and sp_who. I have done extensive t-sql configurations, built and managed select and update queries for hundreds of customers of our databases. I have set up and performed replication. I have set up and configured mirroring in a high safety configuration, architecting endpoints over a firewall. I reviewed, analyzed and managed solutions to many issues relating to information content, data integrity, and database performance for over 9 years with IT staff, e.g. buffer management, dynamic management views (optimizing query plans, viewing fragmentation, missing indexes), clustered/non-clustered indexes, page splits/fill factor optimization, rebuilding indexes. I have developed and implemented all DB maintenance plans and ensured redundancy.
Reviews For This Service