About

Shantanu Gupta is a highly experienced Data Architect and SQL Server Development Expert with more than 14 years of experience in the field. He has a strong expertise in Microsoft .NET technology stack, including C#.NET 4.0, Web-API 2.0, EF, Win-form, window services, WPF, multi-threading, AngularJS, and JavaScript. He has designed multi-platform applications involving RFID HF/UHF devices and has hands-on experience in performance tuning, data modeling, SQL Profiler, Query optimization, DMV, T-SQL, replication, SQL Jobs, SSIS, SSRS, BCP, CDC, Partitioning, etc. Shantanu has worked on multi-terabyte database servers with table sizes ranging from a few million records to billion records. He has single-handedly set up one-click transactional replication using PowerShell and upgraded the data type of the primary key column with a downstream dependency with zero downtime. He has also worked on AWS, Azure, and Python, including Cloudformation, lambda, VPC, IAM, KMS, AWS CLI, S3, EC2, Cloudwatch, Server migration from OnPrem to AWS, and more. Apart from his technical skills, Shantanu is a self-starter and an active member of the online community StackOverflow, with a rating of 19000+, 390+ Questions, and 140+ Answers covering a wide range of technologies like SQL Server, .NET, AngularJS, ReactJS, jQuery, JavaScript. He has also worked on MongoDB administration, shell scripting, Docker, MQTT, and has a conceptual understanding of Hadoop architecture and other NoSQL based products. Shantanu is currently working as a Senior Software Engineer at Microsoft and has previously worked as an Engineering Manager - DBA at OYO and a Database Developer III at Expedia. He has a B.Tech degree in Computer Science Engineering from Krishna Engineering College, Ghaziabad. Programming is his passion, and he enjoys reading, writing, and listening to programming languages and technologies. Adopting new technology is his energy drink.