Hari Musham
Redmond
Summary
Dynamic Service Engineer with extensive experience at Microsoft Corporation, specializing in SQL Server and Azure solutions. Proven track record in optimizing database performance, achieving a 20% increase while ensuring compliance with industry standards. Adept at driving automation initiatives and collaborating with cross-functional teams to enhance service reliability and operational efficiency.
Overview
18
18
years of professional experience
Work History
Service Engineer II
Microsoft Corporation
Redmond
08.2022 - Current
- Install and maintain corporate databases, ensuring high availability and performance
- Manage backup and recovery processes, safeguarding data integrity and system storage
- Plan and coordinate data migration between systems while minimizing downtime
- Develop and implement database encryption and security measures to protect confidential data
- Identify and resolve data abnormalities to maintain data consistency
- Research, evaluate, and recommend technology solutions to improve database performance
- Create and enforce data management policies, standards, and best practices
- Investigate and document data collection processes, administration policies, and security controls
- Establish procedures for accessing and using corporate data assets securely
- Write optimized SQL scripts, stored procedures, and triggers to automate database tasks
- Acted as a liaison between the Engineering and Business teams to design an efficient database architecture
- Optimized system performance by implementing database striping, segregating blob data, Index data, and transactional data into separate file groups, resulting in a 20% performance boost and a 10% reduction in database size
- Provisioned and managed Azure subscriptions and resources, ensuring cost-effective cloud solutions
- Deployed and configured Azure Virtual Machines, optimized network protocols, and leveraged VM Scale Sets (VMSS) for automated server patching
- Achieved significant cost savings through server consolidation, reducing infrastructure expenses by thousands of dollars
- Operated in a distributed environment, ensuring seamless system performance and scalability
- Ensured compliance with SOX and GDPR regulations
- Managed a high-volume transactional database exceeding 20TB in size
- Designed, configured, and executed Business Continuity and Disaster Recovery (BCDR) strategies across data centers, ensuring high availability and resilience
- Led multiple large-scale database migrations from SQL Server 2012 to 2016 and from 2016 to 2017, ensuring minimal downtime and data integrity
- Led an 8-member vendor team to oversee operations and ensure the efficient resolution of escalated issues to Tier 3 support
Service Engineer II
Microsoft Corporation
Vancouver
02.2021 - 08.2022
- Identify opportunities and drive the implementation of automation to improve service health, manageability, reliability, and telemetry
- Work with business stakeholders, suppliers, program managers and other engineers to mitigate and resolve production incidents / support tickets and evolve the production system by contributing to effective solutions
- Support the development and operation of applications/services that are complete from a usability, reliability, security, performance, scale, maintainability, extensibility, and built-with ops-as-first class aspects for the different components/services/system(s) in a cloud world
- Build tools to bring visibility to TTE, TTD, TTR and drive towards making them better by learning from the past
- Drive projects that improve robustness of production systems
- Design and implement accurate and actionable internal monitoring and tooling to help maintain business SLAs and system health
- Participate in On Call and Site Reliability rotations to support live site and drive engineered solutions to improve customer experiences
- Provide critical thinking, technical innovation, and attention to detail while serving as a trusted advisor in the organization
- Gain understanding of Microsoft businesses and the varied processes along with their outcomes and collaborate with all stakeholders to contribute to a cohesive set of capabilities built to deliver frictionless experience
Service Engineer II
Microsoft Corporation
Redmond
04.2020 - 02.2021
- Working on product architecture, design, development, testing and enhancement
- Developing Data processing pipeline using Azure Cloud and big data tools
- Working in Cloud computing, Databricks, Spark, Python, Azure App Service, Azure Function App, Azure Key Vault, Azure Security, Azure Data Factory, Azure Database, PowerBI, Azure Storage Account, Azure Service Bus, Azure Data Lake Analytics, Stream Analytics and PowerShell
- Design and develop efficient database T-SQLs, functions, views, and stored procedures
- Worked on Data Migration from On Premise to Azure Data Lake and Azure SQL
- Implemented Disaster Recovery and Failover Servers in Cloud by replicating data across regions
- Supporting 3rd Party Application for Microsoft Partner Payouts
- 8Billion revenue generations per year
- Approximately 700Million USD processing will be done every month
- Provided uninterrupted services for several years
DevOps/Site Reliability Engineer
Microsoft Corporation
Redmond
12.2019 - 04.2020
- Surface, XBOX, HoloLens and various other groups across Microsoft engage with external suppliers and services for a variety or purposes
- The Devices Engineering team offers them a menu of options tailored to suit their timeframes, security concerns, data and specific collaboration needs
- DevOps experience using modern engineering platforms, with Visual Studio Team Services
- Involve in Development of Test automation scripts, update the scripts based on changes
- Working experience with Kubernetes to deploy and manage Micro applications
- Managed Docker orchestration and Docker containerization using Kubernetes
- Used Kubernetes to orchestrate the deployment, scaling and management of Docker Containers
- Utilized Kubernetes for the runtime environment of the CI/CD system to build, test deploy
- Research on design solutions, provides guidance to prevent technical debt
- Develop user stories in front end, middle tier and back-end technology stack
- Build and setup single Page Application with Angular JS, ASP.NET Web API and entity Framework
- Designed and Implemented Token based Authentication Using ADAL.JS and ASP.NET middleware with Azure Active Directory
- Incorporated Azure Application Insights into client side and Server side for telemetry and diagnostics
- Developed custom Angular JS directives for data tables, progress bar and multi selection dropdowns
- Created resource deployment using Azure Resource Manager API and managed continuous build and release using Visual studio online
- Review and approve proposed development releases and manage the release process
Automation Engineer
Microsoft Corporation
Redmond
07.2018 - 12.2019
- End-to-End Development of Windows based application and Deployment through CI/CD Pipeline
- To show various partners reconciliation data on Power BI dashboard by summarizing year wise data
- Stored Procedures were built to fetch the data from source systems and developed a Windows Service to invoke all the stored procs parallelly and at specified schedule
- Used concepts of multi-threading & Dependency Injection
- Provisioned feature for customized scheduling of processes
- Extensive logging in App Insights and creating alerts for failures
- Accessing sensitive data through key vault and configuring values dynamically based on environment
- Followed best coding standards to make it readable and re-usable
- Displaying partners data on Power BI dashboards at a single view
- Enabling the code in Git and deployed the service through release pipeline
- Automated large backup file movements to blob and restoring on demand using PS Scripts
- Automated user removals and adding in servers (windows and SQL)
- Service heath Status check automation was done to report jobs/services last run time
- Through alerts on failures
- Automated the Customized application failovers via Power Shell scripts
- Forced failover across DCs
Database Administrator
Microsoft Corporation
Redmond
07.2014 - 07.2018
- Royalties is an Agile model project in Microsoft with high volume data management project
- Primary goal of the project is to let Microsoft to payout and report accurate and timely royalties to partners through calculation, accrual, and statement services
- As part of Royalty payments Microsoft processes $5 Billion Revenue
- Royalties service delivers outstanding customer service for internal/external teams through rapid onboarding of new programs/contracts, quick resolution of issues, visibility to data for operational processes, and responsiveness to feature requests to better enable the business
- Responsible for on time and accurate data processing to generate royalty statements to all Microsoft major partners in entertainment, enterprise and contentment management sectors
- Responsible for requisition on-time delivery, improved requisition processing time by 50% with process flow monitoring, push notifications and auto healing
- Responsible for providing 24 X 7 critical production support to 100+ Production, development and clustered servers with Always on
- Servers provisioning, managing the Azure storage, monitoring storage needs and fore casting the requirements for Disk spaces
- Performed Data striping activity on Larger databases with 10 TB to align the data and indexes into database files
- Worked on Data archival projects to move the data from On Premise to hive
- Built Windows Clusters, configured Always on with two node and three nodes including across data centers
- Strong skills in configuring Always on and troubleshooting Always on health issues
- Implemented CDC to manage the database changes for Audit purpose
- Implemented database encryption on larger databases as per organization needs and data security purpose
- Data anonymization done for Production databases before moving to Pre prod and while sending External Development teams
- Implemented GDPR compliance across databases and production and pre-production systems
- Executed the SOX controls for 2+ years Extensive Extensively worked with External auditors to prove the SOX scoped applications are never compromised
- Designed and deployed SSIS packages in production environment
- Create, deploy, configure and monitor complex ETL/SSIS packages
- Tested and applied latest service packs and cumulative Hotfix for SQL 2012/2014
- Executed Disaster recovery solutions and published white paper
- Performed Performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards
- Experience with dealing with Hive queries and moving data from on premise to hive and Vice Versa
- Based on Business Requirements developed SSRS reports, used Datasets from SQL and HDInsight’s connections to pull the data to Sub-report and Drill-down reports
- Created reports and automated few resolutions for the maintenance job failures, backup failures to monitor
- Regular Business meetings to talk about the health of systems providing suggestions and fore casting possible data growths and run times for the upcoming FME processing
L4 Service Engineering/Operations
Microsoft Corporation
Hyderabad
06.2007 - 07.2014
- Product and Product Launch (P&PL) portfolio of applications used to create, manage and distribute Microsoft Product Information
- The Applications are used by internal and external customer’s worldwide and central source of Product and Product Launch data within Microsoft and the RSM is a web-based tool that allows vendors access to information needed to manufacture Microsoft Products
- Responsible for providing 24 X 7 critical production support to 50+ Production, development and clustered servers
- Implemented and maintained high availability systems (clustering, database mirroring, log shipping)
- Successfully migrated 20 SQL 2005 databases to SQL 2008
- Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005
- Create, deploy, configure and monitor complex ETL/SSIS packages
- Wrote stored proc to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
- Automated daily backup/restore processes implemented batch jobs to automate DBA maintenance tasks
- SQL Server 2005 clustering on Windows 2008 cluster environment for high availability
- Create and manage database maintenance plans and design and implement backup and disaster recovery plans
- Define and enforce database standards, policies, security and documentation
- Prepare current database structure and configuration for high-performance through analysis and optimization
- Implementation of Database mirroring and transactional replication
- Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues
- Monitor database systems performance, capacity and availability
- Work on data mapping and conversion; manage disk space, change control and bug fixes
- Developed and implemented Disaster Recovery (DR) on production SQL Server 2005
- Manage and resolve trouble tickets (ITSM Tool) for database-related issues submitted by customers
Education
Diploma - Management Information Systems and Computer Applications
Osmania University
Hyderabad, IndiaBachelor of Science - Electronics
Osmania University
Hyderabad, IndiaSkills
- SQL Server 2017
- SQL Server 2016
- SQL Server 2014
- SQL Server 2012
- SQL Azure
- Cosmos dB
- MongoDB
- Encryption
- Access Controls
- Compliance Standards
- Disaster Recovery Planning
- High Availability Solutions
- Query Optimization
- Indexing
- Partitioning
- Azure Synapse Analytics
- Windows Azure
- Azure Web services
- Azure Load Balancer
- Network load balancer (NLB)
- Hardware load balancer (HLB)
- Windows 2022
- Windows 2019
- Windows 2016
- Windows 2012
- Windows 2008
- Pyspark
- C#NET
- VB NET
- Visual Studio
- Visual Studio Code
- Azure Notebooks
- PowerShell
- Azure Monitoring
- ICM
- APP Insights
- SNOW
- Scripting
- Office 365
- Power BI
- Excel Pivot Table
- SPSS
- Service Now
- Microsoft IcM
- IIS 50
- IIS 60
- IIS 70
- IIS 80
- Information Technology (IT)
- Financial Domain expertise
- Microsoft Reporting Services
- Integration Services
- Microsoft Office
- Word
- Excel
- PowerPoint
- Visio
- Project Plan
Skill Summary
SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Azure, Cosmos dB, MongoDB, Encryption, Access Controls, Compliance Standards, Disaster Recovery Planning, High Availability Solutions, Query Optimization, Indexing, Partitioning, Azure Synapse Analytics, Windows Azure, Azure Web services, Azure Load Balancer, Network load balancer (NLB), Hardware load balancer (HLB), F5-BigIP, Windows 2019, Windows 2016, Windows 2012, Windows 2008, Pyspark, C#.NET, VB .NET, Visual Studio, Visual Studio Code, Azure Notebooks, PowerShell, Azure Monitoring, ICM, APP Insights, SNOW, Scripting, Office 365, Power BI, Excel Pivot Table, SPSS, Service Now, Microsoft IcM, IIS 5.0, IIS 6.0, IIS 7.0, IIS 8.0, Information Technology (IT) & Financial Domain expertise, Microsoft Reporting Services, Integration Services, Microsoft Office (Word, Excel, PowerPoint, Visio, Project Plan)
Technical Education
- Diploma in Management Information Systems and Computer Applications, Osmania University, Hyderabad, India
- Bachelor of Science in Electronics, Osmania University, Hyderabad, India
Timeline
Service Engineer II
Microsoft Corporation
08.2022 - Current
Service Engineer II
Microsoft Corporation
02.2021 - 08.2022
Service Engineer II
Microsoft Corporation
04.2020 - 02.2021
DevOps/Site Reliability Engineer
Microsoft Corporation
12.2019 - 04.2020
Automation Engineer
Microsoft Corporation
07.2018 - 12.2019
Database Administrator
Microsoft Corporation
07.2014 - 07.2018
L4 Service Engineering/Operations
Microsoft Corporation
06.2007 - 07.2014
Diploma - Management Information Systems and Computer Applications
Osmania University
Bachelor of Science - Electronics
Osmania University
Similar Profiles
Sumit SampatSumit Sampat
Senior Technical Program Manager at Microsoft CorporationSenior Technical Program Manager at Microsoft Corporation
Jeffrey MutethiaJeffrey Mutethia
Software Engineer at Microsoft CorporationSoftware Engineer at Microsoft Corporation
Sidhartha SunkaraSidhartha Sunkara
Threat Hunter 2 at Microsoft CorporationThreat Hunter 2 at Microsoft Corporation