Souvik Sahoo

Seeking challenging assignments of Database, Azure SQL, MS SQL Server DBA, Cosmos DB in a growth-oriented organization.

• Technically Sophisticated Professional with 9+ Years of experience in the area of Database and Microsoft SQL server Administration.
• Exposure on working and handling issues on US Healthcare IT infrastructure.
• Experienced with deployments, Maintenance and troubleshooting issues on SQL Server and Cloud Azure SQL.
• Exposure in handling the entire production server and understanding client's requirement.
• Excellent Communication and Interpersonal skills with abilities in analyzing and managing all type of Severity cases.
• Worked on decrypting and recovering database server from ransomware attack.

• Planning and Successfully Installing, Upgrading SQL Server 2005/2008/2012/2014/2019 on the Production and Development Servers.
• Strong Experience on patching and Database Refreshment activities . (Backup &Recovery strategy).
• Implementing SQL logins, roles and authentication modes as part of security policies for various categories of user and granting / revoking various authorizations to different Users/Group.
• Experience in performing administrative tasks: Database files management , space management issues on database files and file groups , Backup & Restore, Security and Encryptions.
• Experienced in performance Tuning and optimizing queries.
• Identifying and troubleshooting issue on hosted Web based application from Database end.
• Performed database health checks using SQL profiler and DBCC commands.
• Identifying and Resolving Blocking , locking related issues and monitoring SQL Server Performance and Activity.
• Inspecting SQL Server error logs for unusual events and performance issues.
• Configuring and Managing High Availability ( Mirroring and Always On ).
• Monitoring and troubleshooting SQL server Clustering , Replication related issues.
• Use of Query Store feature for monitoring performance of database systems.

Azure IAAS and PAAS :

• Deploy, Configure, Maintain Azure sources like PAAS and IAAS offerings.
• Create and configure Azure subscription, Resource group, Virtual machine, Managed Instances, Azure SQL DB using different service tier.
• Configuring Provisioned and ServerLess model of Azure SQL Using VCore and DTU model.
• Planning, Assessing and Migrating to Azure from Onprem.
• Automate deployment using Automation runbook, Powershell and ARM template
• Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
• Creating and Managing logins/Access and managed identities.
• Configuring Geo Replication, Data Sync and failover groups.
• Creating azure monitoring, Log analytics workspace for resource health monitoring.
• Suggest Cost optimization solutions in Azure PAAS environment.
• Enabling and Managing data masking and encryption in Azure cloud environment.

COSMOS DB :

• Configure and manage Azure CosmosDB on Azure cloud.
• Planning and implementing sizing and Scaling of Cosmos db container.
• Understanding of Serverless and Provisioned model to use provisioned throughput.
• Configure Partition key for better query operation.
• Use of Point operation vs query operations.
• Understanding Request Units and throughput.
• Taking care of performance issues.
• Using different consistency level, TTL, Container locking features.
• Understanding of backup restore features, Burst Capacity.