• Working on AWS cloud/services like firehose, AWS Glue ETL, crawlers via Spectrum• Creating and analyzing funnel/sankey reports via tableau for data visualization• Designed and Established DataLake for reporting/analytics• Working on data warehouse solutions in Redshift• SQL Server DB optimization via Query Store/In Memory Tables/MaxDop/Index Tuning• Created Glue Jobs to set up data pipelines• As a lead, Coordinating the DB projects, Gathering requirements from end users, Delegating/ Managing and supervising DB team and projectso Hiring/performance appraisals and trainingo Develop and track project schedules/roadmaps and feedback to team and management

• Setup and manage SQL Server 2008/2014 Transactional Replication to offload work from OLTP servers• Work extensively on fine tuning stored procedures • Add Indexes to the most expensive queries by analyzing the execution plan to eliminate database time outs• Partitioning and archiving heavy tables for fast data retrieval• Use BCP to import and export data among servers• Use SSIS to build packages for miscellaneous operations• Use SSRS to create reports

• Developed stored procedures and ad hoc queries in SQL Server 2005/2008 for applications• Optimized existing dynamic stored procedures after analyzing the execution plan• Used both SQL Server Profiler and Activity Monitor (SQL 2008) to capture poor performing queries, analyze SP recompilations and view deadlocks • Established Synchronous Transaction Replication between servers• Performed Data Migration (via SQL queries, SSIS package, native DTS package) among different databases involving importing data from different sources and integrating them into one authoritative source• Resolved Database Fragmentationo By using and creating Maintenance Plans to Rebuild Indexes o By taking databases offline and using Transfer Database Task (SSIS) to transfer database objects that help in compacting unallocated space• Used Database Engine Tuning Advisor to create optimal set of indexes and tune database queries

Designed and developed relational databases by keeping in mind the scalability and performance issuesDesigned/Created financial reports for the firm using SSRS and customizing them by writing functions in Visual Basic within SSRS Developed stored procedures using appropriate schemas in SQL Server 2005 for front end web applicationsPerformed troubleshooting and fixed bugs in SQL code by using Try Catch (Sql Server 2008), @@Error and RaiseError handling methodsCreated triggers on tables to set efficient workflowsCreated both full and transaction log backups both natively and via Red-Gate's SQL Backup Established Log Shipping between the primary and secondary server via Red-GateUsed Red-Gate's Log Rescue to recover accidentally modified dataCreated read-only database snapshots in SQL 2005Established Asynchronous database mirroring with forced failoverUsed SQL Profiler for monitoring SQL Server and debugging stored proceduresUsed Idera's SQL diagnostic manager to diagnose and monitor SQL Server instancesEstablished linked servers for remote server access and managing user logins and rolesUpgraded all the databases from SQL Server 2000 to 2005 and from 2005 to 2008 by detaching and attaching all the data and log filesSet up SQL Agent jobs to automate daily tasks

Created efficient and optimized existing Stored Procedures in SQL Server 2000Created ad-hoc queries in T-SQL to accomplish routine tasksUsed SQL Common Language Runtime (CLR) to implement complex tasksImplemented Data Integrity (entity, domain and referential) while developing new databases Performed Data Transformation/Data Integration/Data ModelingPerformed native Database Back-ups and Restores Created Documentation (Data Dictionary, Data Flow, Entity Relationship Diagrams etc)

Designed and developed Web Applications for college of education in ASP.net (C#)Designed data models (entity relationship diagrams) for various databasesDeveloped/Maintained databases in SQL Server 2000Created several stored procedures & triggers to support various applicationsProvided application training and technical support to faculty

• Developed and maintained Web Applications using ASP • Ran Load and Stress Tests for testing application performance using Load Runner• Supervised technical projects (ASP applications) to interns and coordinated activities effectively in teams • Interviewed and hired applicants for 3M projects