Environment & Tools: MS SQL Server 2017/2019, SQL Server Integration Services (2012/2015), Python (3.7+).Responsibilities:• Created Partitioned Tables, Files and filegroups, views, constraint, store procedures, complex and dynamic queries, indexing (clustered/non-clustered/column store) to serve various interfaces.• Database Administration, Design and T-SQL Development for Large scale databases typically having data of the order of several hundreds of Gigabytes with billions of rows.• Performance tuning of table Indexes and T- SQL Stored procedures of complex data transformation and reporting environments.• Worked with project teams for migration/ upgrading from older versions.• Scripting of stats processing and data calculation for use in reports.• Using Transactional Replication solution for Server/ Data Redundancy and data propagation.• Using SQL server table partitioning for fast ETL transformations (using partition switch) as well as Implementation of data management and storage solutions using partition schemes, development of partition functions and Partitioned Tables.

• Participated in a Banking System Project, developing web pages using HTML5, CSS3, JavaScript, and PHP.• Designed an interface for banking operations.• Implemented PHP for secure database management, ensuring the safe handling of user data.

Worked as a Web Developer for LetsGrowMore. Amazing projects and a lot of experience gained as an intern.