![]() Analyzed query plans and implemented improved indexing strategies which reduced instances of slow client application response times. Captured slow running queries using a combination of Profiler and system DMVs.Set up alerting to the DBA group for various performance degrading events such as low space, blocking, deadlocks, low memory error conditions, failed backups and failed transaction log dumps. ![]() Built and deployed SQL Agent jobs used for index maintenance and updating data estimates / statistics. Modified machine configurations in order to optimize available hardware resources. Install SQL Server 2008 R2 and SQL Server 2012 on clustered platforms.SQL Server / MySQL Database Administrator Cache Multidimensional Object Database, CSP and Cache Web services.Post - Relational Object Data Architecture.Database Disaster Recovery and Business Continuity Planning.Relational Database Design, DataEdo ERD, Bulk Loading Strategies, Index Tuning and Relational OLAP.Database and Query Performance Optimizing Techniques.VB.NET, ADO.NET, ASP.NET, C#, Crystal Reports and SQL Reporting Services.Google Cloud SQL, AWS Relational Databases, AWS Glue, AWS Step, AWS Database Replication and Spectral Core.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |