Job Description

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 DBs.
• 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 (Microsofts 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.

• 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.

Ciel HR