Ashok K.

I have 15+ Years’ experience with MS SQL Server Administration, SQL Azure DBA and SQL Database Developer with SSRS Developer and experience in designing, coding, testing and supporting next-generation database solutions in SQL Server environments, • Presently associated with Metro Infrasys Pvt. Ltd. as a Lead SQL Server DBA. • Well versed with the concepts of RDBMS, functionalities with Applications and understanding as well as basic writing various DDL / DML queries, good Command on T-SQL like Creating Stored Procedures, Views, UDF, Triggers, and Tables. • Good Experience with Performance Tuning and Optimization (PTO) & SQL Query Optimization. • Planning and designing databases based on project requirements. • Experience with backups, restores and recovery models. • Patching SQL server instances with Service Pack. • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O and disk space resource contention. • Hands on experience in High Availability & DR Solutions like Replication, database mirroring and Log Shipping, Always On AG(2012/14,2016 ). • Worked on Configuration and Administration Part for SQL BIDS environment in SSIS, SSRS, SSAS including configuration, Deployment, setup, Report migration, Package Migration, working on Cube databases and troubleshoot all Basic core DBA activities in BIDS. • Well versed with Performance tools of Various DMVs, Profiler, Perfmon, Database tuning adviser and Activity monitor. • Data modeling to visualize database structure and Creating table indexes to improve database performance, query optimization techniques and execution plan analysis. • Having Experience on Data center servers and handling 7 TB databases. • Experience in SQL Azure DBA. Configuring and Maintaining Azure AD. • Experience with migrating systems from On-Prem to Cloud Azure. • Azure Storage (Blob Storage, Azure Files, Queue Storage, Table storage) • Excellent knowledge and hands on experience in Migrations from on-premise to Azure IAAS and PAAS servers • Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model • Having good experience into Geo-Replication, Availability Group(s) and Data Sync • Implemented Data Partitioning, Purging and Archiving solutions in the Azure model databases. • Having very good knowledge on saving the cost on Azure models. • Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers • Automate deployment and troubleshoot mechanisms for quick service. • Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud. • Monitor performance and setup alerts to avoid performance issues occurring on Azure databases. • Having hands on experience in Elastic Jobs and Run Books. • Having good knowledge on External tables and Elastic pool Model(s) • Having hands on experience into the Reservations and Azure hybrid benefits