Sumit Agarwal Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Paris, France, Fr

• Placed the appropriate governance and decommissioning process on cloud infrastructure (AWS and Azure) that resulted in significant cost saving. Placed governance by leveraging server-less and event driven components as AWS Lambda functions for appropriate use of cloud infrastructure. • Expertise in automation, automated end to end windows server and SQL Server build with Powershell DSC (Desired state configuration). • Established strong governance on SQL Databases using policy based mechanism around security, best practices and monitoring.• Designed AWS Hybrid cloud platform for on premise database and infrastructure.• Expertise in SQL Server license auditing, e.g. Designed Technology Governance by using data analytics and visualization tools; which led to reduce the cost of SQL Server Licenses significantly• Provided solutions to modernise Database, creating technology roadmap for database & cloud, decommissioning and migration to cloud.• Designed solution to migrate the databases handling customer facing critical applications with direct revenue impact. Designed new server architecture enforcing SQL Server & Security best practices. Also provided end to end migration plan with various phases and milestones and optimized the database by 40% . This migration included Microsoft SQL Server 2016 based on failover cluster, SQL AlwaysOn and Tivoli.• Documented the process and successfully migrated the databases from Microsoft SQL Server (on premise) to Aurora Database (AWS) to reduce the licensing/operational cost.• Optimized UK's one of the most highly transactional database performance to ensure database can cater high concurrent load without any operational impact.

Paris, France, Fr

• Created an enterprise level monitoring and alerting solution to proactively monitor different database engines (such as Microsoft SQL Server, PostgreSQL and MySQL) using Powershell to capture monitoring data on a centralised server with PowerBI on top for reporting and trend forecasting. This avoids expensive third party monitoring tools and also ensures we are monitoring different database engines consistently. • Designed a solution of a complex migration. This migration involved complex infrastructure using an implementation of multiple nodes in multi-subnet cluster.• Designed a solution to migrate on premise databases to Microsoft Azure cloud.• Led Commercial Datawarehouse Migration from legacy SQL Server.• Maintained SLAs more than 97% without any escalation in the service• Led Disaster recovery rehearsals to ensure database is highly available and resilient.

Paris, France, Fr

Key Responsibilities:• Administrating more than 100 + Database servers.• Installation and Configuration of SQL Server 2000/2005/2008/2008R2• Maintaining Production Database (up to 1 TB) • Database Tuning • Using performance counter to monitor Disk I/O, processor, Memory, Network and user connection.• Using SQL server profiler & SQL query analyser for performance related issues in MS SQL database / MS SQL based applications• Space Management in all the servers• Backup and Restoration of Database • Disaster recovery Management• Configuring and Troubleshooting of Log shipping.• Change Management Process involvement• Working closely with project/dev team to analyze & resolve the issues.• Assist in resolving all problems with development and Production SQL Server Databases.• Troubleshooting the problem and providing the root cause analysis • Database MAIL (SQL Server 2005 / 2008) Configuration and Management• Database Object related minimal to higher level Security configuration and maintenance.• To proactive monitoring of database servers (using SCOM tool) and manual checks.• Logshipping configuration using Litespeed (Quest Software) tool

Newark, California, Us

Key projects:» ExposureSource: Data Models as product used by U.S. Insurance companies for risk assessment.The objective of developing the data Models was to evaluate the value/risk factor of buildings in US cities. I designed and developed a complex process to merge Terabytes of data from multiple data sources, extract information from consolidated data and create a new data warehouse with the most accurate information. These different data sources contain every US address/building so it was a challenging job to manage and optimise the processes due to the amount of data we were dealing with.» ExposureSource Quality Management System (EQMS): EQMS was an online Quality Management System for ExposureSource database team with the objective to make Production, QC and QA processes structured and traceable. I developed application and its backend database in Oracle which I migrated to SQL Server later.» Photo Interpretation Application. This Application automated the process of capturing building information based upon the raw data gathered in the form of images. This process used to capture the every image according city and state wise. The whole project was implemented on Abstract factory design pattern at that time.