Over 15 years of IT experience in SQL Database Administration, System Analysis, Design Development, & Support of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, 2000, 7.0 in Production, QA, and Development environments. Managing SQL Servers in Clustering, Replication, AlwaysOn, Mirroring and Log-Shipping Environments. Experience in Server Specification, Installation, Configuration, Maintenance, Troubleshooting of MS SQL Server version 7.0, 2000, 2005, 2008-R2, 2012, 2014, 2016, 2017 and 2019. Experience with SQL Server online / offline Indexing & Recovery features, Maintenance Plans for Index de-fragmentation . Experience with implementing DR solution, High Availability of database servers using AlwaysOn, SQL Clustering, Database mirroring. Experience in Managing SQL Server Security and Object permissions. Experience in SQL Jobs, Alerts, Notifications, SQL Mail Agent and scheduling task, SSIS packages. Experience in performing integrity checks, troubleshooting issues by using SQL Tools, execution plans, Trace, Performance Monitor, SQL Profiler, SQL Data Collector, Extended Events, third party monitoring tools (App Dynamics, RedGate, SquaredUp etc). Experience in MS SQL BI Stack administration SSRS, SSAS, SSIS. Experience in data virtualisation SQL Server PolyBase, Hadoop HDFS, Azure Blob Storage.
Worked as a production SQL DBA with VLDB’s (2 to 5 TB) on high volume of transactional and mission critical, Financial Services, ISP's, Government and Insurance Systems. Manage issues and incidents with a strong sense of urgency and thrives in a fast-paced and pressurised environment. Experience in SQL Development, SSIS, and SSRS, using BIDS, SSDT, and Visual Studio.
Core competencies Include: Performance Analysis & Tuning, T-SQL, Query Optimisation, Indexing, Data Migration., Upgrading, Backups & Restores, Database High Availability & Disaster Recovery, Capacity Planning, Automation Monitoring, and Database Documentation.