Azure Ms-sql + Cosmos

Job Responsibilities DBA Support for Azure MS-SQL Cosmos 8-10 years of experience in MS SQL Server Azure SQL and Azure Cosmos DB NoSQL Database Installing configuring managing monitoring and troubleshooting SQL 2019 both on premises and on Azure cloud Very good knowledge and hands-on experience in IaaS and PaaS systems on Azure cloud Hands-on experience in provisioning VMs in Azure cloud Experience in using Azure cloud monitoring tools Very good knowledge of Database Security Standards and implementation of the same in SQ Server environments Installing Service Packs Cumulative Updates Hotfixes GDR QFE Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers Upgrading Migrating SQL Server Creating and Configuring Databases as per requirement of Application Teams Understanding of Server Role Database Roles and Permissions Handling Orphan Users and working at Impersonate permissions Correlation of Schemas-Users changing schema ownerships giving permissions Setting up contained databases and utilizing them for effective migrations Configuring recovery models and designing backup strategies Fine tuning backups by using Backup Encryption Compression and special parameters like MAXTRANSFERSIZE BUFFERCOUNT BLOCKSIZE CHECKSUM Increasing Backup Buffers Split backups to make backups run faster Restored corrupted databases and recovered them with minimal zero data loss Backup Types Full Differential Log Restore Scenarios Point-in-Time Piecemeal Page Handling Master Model MSDB TEMPDB and Resource database corruptions Handling Suspect Database state and following order of troubleshooting recovering DB s Knowledge on configuring Active Directory and adding VMs Servers to Domain Configuring Replication types Transactional Snapshot Merge Peer-To-Peer Experience in Merge Peer-to-Peer bi-directional replication conflict detection resolution Knowledge on replication topologies Central Distributor Publisher Subscriber Publishing subscriber Background process exploration of Checkpoint Lazy writer Eager writer Log Writer Understanding of SQL Server Indexes and data structure level B-Tree level focus towards Heap Clustered and Non-Clustered indexes Creating Managing Clustered Non-Clustered Indexes including Filtered Column Store Identifying fixing Index fragmentation and resolving page splits using fill factor pad index Strong understanding of ACID Isolation Levels Pessimistic and Optimistic Resolving 100 CPU usage troubleshooting using appropriate Perform Counters and DMVs considering factors like High IO Query load Cost Threshold MAXDOP Identifying resolving Memory high consumption situations like workload memory leaks Out of Memory OOM errors Reporting High IO Utilization and working with storage team to find out reasons behind IOPS performance drop and diagnosing Benchmarking SQL Server IO performance using SQLIO Microsoft s Proprietary tool Using Perform counters for troubleshooting major bottlenecks CPU Memory IO Network Diagnosing Server Application Database slowness performance situations Monitoring and checking top wait types in SQL Server Troubleshooting slow performing long running queries running recommendations Resolving Blockings and Deadlocks using Extended Events and provide recommendations on Isolation Levels Indexes to avoid minimize blockings deadlocks Handling space management issues like Log File Full Data File Full TEMPDB Full Implementing best practices through SQL Server Hardening methods Handling spin locks and understanding of latches AZURE Cosmos DB Job Descripions Basic architecture and understanding of Cosmos DB Working Knowledge on NoSQL Graph and Documentation DB Working knowledge on Azure cloud components Provisioning and configuring Cosmos DB from Azure Marketplace Knowledge on globally distributed multi-model database Elastic scaling concepts Knowledge on REST API JSON Node js and Python