Good Experience in maintaining the production servers of multiple environments.
Creating new users on SQL server and Managing SQL Server Security.
Experience in Database backup and disaster recovery procedures.
Test backups to ensure we can meet the business Recovery Time Objectives (RTO)Experience in Replication (Mandatory)
Having knowledge of Bulk Data Merging using SQL Server Import or Export.
Wizard or writing queries on SQL Server query window
Creating and maintaining databases.
Monitoring, troubleshooting, and optimizing SQL Server performance.
Having knowledge of SQL Profiler to check the Execution Plan, Performance Monitor.
Monitored server performance, database, and transaction log growth, and error logs.
Help the database query developers on technical issues, i.e., writing queries like join or subquery, triggers, cursors, store procedures.
Have Experience of indexes.
Review and optimize SQL queries, store procedures, views, and triggers to help developers to achieve maximum efficiency and scalability.
Auditing of DML commands on SQL servers and individual database/s.
Troubleshoot SQL Server service outages as they occur, including after- hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
Creating the configuration Document for the database environment
Candidate should have good hands-on experience in SQL Data analysis using queries as well as using Microsoft Excel.
AWS RDS (database services)
All High availability concepts like log shipping, Replication, Mirroring, Always ON, Clustering.
Strong knowledge on Performance tuning
Knowledge on .net application projects and connection strings
Profiler and DTA usage and importance
Carry out Defragmentation, Memory management, data migration, server upgrades
Applying patches on existing or new SQL servers
Work from home