Hemanta Khanal

• About 6 years of IT experience in installing, upgrading, configuring, administering, monitoring, troubleshooting and securing production, test, development, replication, and cluster servers for MS SQL Server 2016/2017/2019/2022. • Detail oriented, analytical, and troubleshooting experience in different aspect of SQL Server including installation and configurations of SQL Server, Database High Availability Solutions, SQL Server Reporting Services SSRS, data modelling, DR Disaster Recovery Solution, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints etc. • Strong knowledge of all Windows 8/ 7/ Vista/ XP and Windows Server platform including familiarity with virtualization techniques like VMware, Microsoft Virtual PC, Hyper-V, Oracle Virtual Box Operating System • Knowledge of development software like Microsoft Visual Studio 2015/2017/2019/2022, Java, MS Visio for database design and modelling, Adobe Dreamweaver, Flash, Photoshop, SAS Data Mining. • Knowledge of SSIS, SSRS, Power BI, Microsoft Fabric, SSAS, TSQL, PowerShell, MS Access, MS Office Suite, MySQL, Oracle, MongoDB, Hadoop, SharePoint, Microsoft IIS 6.0/7.0, DNS server, DHCP server, WINS, Java Scripts, HTML, XML. • Experience in database backup/restore, data import/export, Point-in-Time recovery, High Availability and Disaster Recovery procedures and applying service packs and hot fixes to all SQL servers. • Knowledge of handling database migration in MS SQL Server 2016/2017/2019/2022. • Expertise in Capacity planning and Storage management, implementing MS SQL server security and database permissions like SQL Logins, Roles, and Authentication Modes as a part of security policies. • Experience with Performance Monitor/Profiler to solve Dead Locks/Long running queries. • Experience in writing TSQL queries and hands on experience with performance tuning, stored procedures, query optimization, fine tuning, managing indexes and tables. • Good exposure on creating and deploying SSIS packages, SSAS deploying cube, calculator and KPI along with experience in generating reports using SSRS, Crystal Reports. • Worked with various RDBMS tools including SQL Server, Oracle, and MySQL. • Ensuring data consistency in the database through DBCC commands. • Worked on different types of Replication models like Snapshot and Transactional. • Knowledge of 2 nodes active passive and active clustering in SQL Server. • Expertise in administering large and complex databases, Always On availability Groups, Failover clustering, Log shipping, Database Mirroring and Security Management. • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages. • Experience in recommending and executing modifications to server environment in order to improve efficiency, reliability, and performance. • Conducted research on server hardware, software, and protocols in support of procurement and development efforts.