Soumitra Mishra

Extensive experience of 17 years in architecting large-scale cloud transformation and migration projects/program; Extensive experience in architecting enterprise Azure cloud solutions; experience of stakeholder management within complex organizations. Proven experience assessing client’s workloads and technology landscape for Cloud suitability, develop business case and Cloud adoption roadmap; deploying & debugging cloud applications; ability to use continuous integration and distribution pipelines to deploy applications; ability to code to implement essential security measures. Excellence in managing large teams right from requirements through design, implementation & deployment; excellent analytical, organizational, planning skills with demonstrated abilities in training & mentoring teams towards achieving organizational goals. Worked on Azure Infrastructure (IaaS & PaaS); Azure Application Services (WebApps and WebJobs); Azure Storage (Blob and File Share); Azure Virtual Machine; Azure Monitor; Azure Log Analytics WorkSpace; Azure SQL PaaS(Azure SQL Database, Managed Instance); Azure MySQL PaaS; Azure Active Directory; Azure AD Connect; Azure Database Migration Services; Azure Database Migration Assistant; Azure Vnet and Subnet; Azure NSG; Azure Load Balancer; Azure Traffic Manager; Azure Gateway; Azure Frontdoor; Azure Key Vault; Azure Recovery Service Vaults etc. MSSQL & MySQL Database Architect & BI/DW Administrator with 15 years of overall experience in MS SQL 2016/2014/2012/2008R2/2008/2005, MySQL 5.6/5.7 and Tableau Server. MCPS: Administering Microsoft SQL Server 2012/2014 Databases MCTS: Microsoft SQL Server 2005 - Implementation and Maintenance ITIL v3.0 TOGAF 9.1 SAFe 4 Scrum Master •Expert in upgrades, migrations , Security Auditing, Patching, hardening and remediation. •Installed, configured and deployed fine-tuned, standardized and secure MSSQL & MySQL databases & servers •Installed and configured PostgreSQL, and migrated several databases from PostgreSQL to MSSQL •Experience with SSIS, SSRS •Develop scripts and procedures using T-SQL and PowerShell for monitoring & automation. •Maintaining the overall integrity of data used in, updated in, and published by one or more applications •Log shipping, Mirroring & AlwaysOn Availability Groups, Disaster Recovery planning and procedures •Assess, Architect, Design and implementation of Active-Active, DR & Reporting solutions using varied replication tools. •Performance Tuning and Troubleshooting