Somya Garg Email & Phone Number

A skilled technologist with extensive experience in querying and optimizing large databases. Proficient in database design, development, implementation, and administration using Microsoft SQL Server 2012-2016. Possesses strong problem-solving abilities, with a knack for diving deep into scenarios and leveraging various tools to craft solutions and methodologies. Enthusiastic about embracing the latest products and technologies.- Over 7 years of experience in business, systems, and data analysis with Microsoft.- Consistently manages and executes projects within budget and timelines.- Experienced in designing and developing large-scale data warehouses and business intelligence solutions, implementing complex logic with data structures and algorithms in SQL and C languages.- Proven track record in developing, optimizing, troubleshooting, and maintaining very large databases (VLDBs) with terabytes of data.- Deep knowledge of MS SQL Server internals, system tables and databases, table partitioning, and data migration.- Expertise in T-SQL, including table creation, data integrity enforcement, data management, index creation and maintenance, functions, stored procedures, joins, subqueries, and XML usage in SQL.- Proficient in creating and maintaining SSIS packages and has in-depth knowledge of various index types and indexing algorithms.- Skilled in creating, monitoring, and maintaining ETL jobs.- Experienced in deploying solutions on servers and maintaining backups.- Managed and contributed to over 6 projects, collaborating with engineers, project managers, and designers across different locations over the past 5+ years.